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: […]
Articles Tagged: Troubleshooting
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: […]
Failed Jdk Version Is Incompatible.Please Use A Jdk Version With Opatchauto
Today, we are going to take a tour on “JDK Version“. This article explains about the issue which comes regarding JDK. Before start article let’s have look on the deep meaning of JDK. This few line gives an introduction of JDK The Java Development Kit (JDK) is a software development environment used for developing Java applications […]
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 […]
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 […]
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 […]