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

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

ORA-15073: Diskgroup Mounted By Another Instance

We know that in the database each and every  “Error “has its own reasons. Let’s have look on Error ORA-15073: Diskgroup Mounted By Another Instance. This article explains the cause and action for this error. Cause: An attempt was made to drop a diskgroup that is still mounted somewhere in the cluster by another instance. Action: dismount the […]

Read More

ORA-06512: At “SYSMAN.EM_SELF_UPDATE” While Installation 12c Cloud Control

Let’s have look on Oracle error ORA-06512 in 12c Cloud. Below we have mentioned the steps which are used to solve this issue. We got below error while installing OEM 12c Cloud control.     Error:

Solution: Login to repository database and execute below commands.

Now retry the installation, It should complete successfully. Please read […]

Read More

Agent Clone Failed Exit Code:1 in Oracle OEM

When we talk about cloud we face issues. In this article we are going have a look at issue during deploying agent in one of the target server for OEM 12c cloud control, got error like Agent Clone Failed Exit Code:1. Solution: Get the inventory location

Go to inventory location, check the permissions on the […]

Read More