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: INFO: oracle.sysman.top.oms:ORA-06512: at “SYSMAN.EM_SELF_UPDATE”, line 1547 INFO: oracle.sysman.top.oms:ORA-06512: at “SYSMAN.EM_SELF_UPDATE”, line 1547 INFO: oracle.sysman.top.oms:Caused by: oracle.sysman.emInternalSDK.core.selfupdate.integration.OperationFailedException: ORA-14400: inserted partition key does […]

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 [oracle@bt-tstdev-1]/export/home/oracle/bsstdba# opatch lsinventory Oracle Interim Patch Installer version 12.1.0.1.0 Copyright […]

Read More