ORA-30032: The Suspended (Resumable) Statement Has Timed Out

PROBLEM: While doing a transaction, it was hung for few seconds and got the below error. SQL> create TABLE TEST_3 as select * from dba_objects; create TABLE TEST_3 as select * from dba_objects * ERROR at line 1: ORA-30032: the suspended (resumable) statement has timed out   CAUSE & SOLUTION: Let’s check the alert log: […]

Read More

Generic error(Failed Jdk Version Is Incompatible.Please Use A Jdk Version With Opatchauto)

While running the opatchauto command in oracle grid you may face the jdk version error as below. We are going to learn about the steps which we use to solve this issue. root # /crsapp/app/oracle/product/grid12c/OPatch/opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -analyze -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp  OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI […]

Read More

ASM (Sector Size Validations)

From the technical background, we have an idea of Validations. I talk about normal life we notice that we have lots of Validations in our life. Let’s have look at today about ASM (Sector Size Validations). First few lines will explain the technical definition of  Validations. Validation is the name given to the process whereby the information entered […]

Read More

ASM -(Sector Disk Drives)

This post is about ASM’s attribute deep knowledge. Before going ahead we must have an idea about the topic. Let’s some line must explain about  ASM -(Sector Disk Drives). The database and Oracle’s Automatic Storage Management (ASM) volume manager explicitly understood 4k devices. In this and subsequent versions of ASM, disk groups created on native mode […]

Read More

How To Convert A Non ASM Instance To ASM Instance

Let’s have fun with instance today. Being an Oracle DBA we are well known for Instance. DBA’s life starts from Instance. In early days of DBA training, we introduced with Instance. When we enter to the new part of Oracle. we notice new teams. Now I am going to focus on ASM instance. Some starting lines remind the […]

Read More

How To Move Voting Disk To Another ASM Disk

This article explains the steps which we use to move  VOTING DISK to another ASM DISK. In first few lines remind us about the definition of VOTING DISK and ASM DISK.  After complete, we have mentioned the way to add a voting disk to another ASM.  What is VOTING DISK? The Voting Disk File is a […]

Read More

How To Find The Cluster Name In Oracle RAC

This article is short and simple. It explains the ways to find the cluster name in Oracle RAC. First few lines explain about the cluster. A cluster comprises multiple co-ordinated computers or servers that appear as if they are one server to end users and applications. Oracle RAC enables you to cluster Oracle databases. Oracle RAC uses […]

Read More

PRVF-5424 : Clock Time Offset Check Failed

We are going to have look on the steps which use to solve  RAC database installation INFO: PRVF-9652 : Cluster Time Synchronization Services check failed. While installing Oracle RDBMS home on Oracle Grid, you may get an error as below. ERROR: Clock Synchronization – This test checks the Oracle Cluster Time Synchronization Services across the cluster nodes. Error: […]

Read More

Enable Archive Log Mode In Oracle RAC

Today we are going to have look on the steps which we use for “Enable Archive Log Mode In Oracle RAC”. Being Oracle DBA we all know the importance of Archive Log Mode. This few line explains the technical definition for the quick review of Archive Log Mode. Most of the High Availability features of Oracle require you to […]

Read More

Applying PSU Patch On 12c RAC In Solaris

Patching plays an important role in Oracle Database. In any level of DBA’s interview, they definitely as about Patching. This article explains about the types of patches and steps which use for Applying PSU Patch On 12c RAC In Solaris.   Critical Patch Updates (CPU) was started in January 2005. Then Patch Set Updates (PSU) were […]

Read More