ADRCI is an command line oracle utility for managing diagnostic data. We can create incident packages and provide it to oracle support team for analysis. Follow below steps to create incident package. View the incidents: $ adrci ADRCI: Release 12.1.0.2.0 – Production on Tue Dec 15 18:52:47 2015 Copyright (c) 1982, 2014, Oracle […]
TROUBLESHOOTING
ORA-29548: Java system class reported
You might have faced below error. SQL> select dbms_java.get_jdk_version() from dual; select dbms_java.get_jdk_version() from dual * ERROR at line 1: ORA-29548: Java system class reported: release of classes.bin in the database does not match that of the oracle executable. Solution: This error usually comes, if you haven’t completed the post patching activities for JVM patch. […]
PRVF-5424 : Clock time offset check failed
While installing oracle rdbms home on Oracle Grid, you may get error as below. ERROR: Clock Synchronization – This test checks the Oracle Cluster Time Synchronization Services across the cluster nodes. Error: – PRVG-1015 : Time server “.GPS.” has time offsets that are not within permissible limit “1000.0” on nodes “wmcpredb2,wmcpredb1”. – Cause: Offsets […]
RMAN-20001: target database not found in recovery catalog
While taking backup by connecting to catalog database, Got RMAN-20001 : target database not found error. Below is the exact error; released channel: t1 released channel: t2 released channel: t3 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of crosscheck command at 11/24/2015 15:40:53 RMAN-06004: ORACLE error from […]
ORA-02304: invalid object identifier literal while doing impdp
While doing import, got below error. CREATE TYPE “TEST_CVGCM02”.”TEST_TEST2″ OID ‘BE4C0AFD318A07CBE0443C4A923B4794’ AS OBJECT ( NAME varchar2(40), AGE number(4), ID number(5) ) ORA-39083: Object type TYPE failed to create with error: ORA-02304: invalid object identifier literal Failing sql is: Login to database, Check whether that OID “BE4C0AFD318A07CBE0443C4A923B4794″ exists or not. SQL> select owner,TYPE_NAME,TYPE_OID from dba_types where […]
ORA-31637 ORA-06512 ORA-39062 error while doing impdp
While doing import got the below error : With the Partitioning, OLAP, Advanced Analytics and Real Application Testing ORA-31626: job does not exist ORA-31637: cannot create job SYS_IMPORT_SCHEMA_02 for user SYS ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95 ORA-06512: at “SYS.KUPV$FT”, line 1580 ORA-39062: error creating master process DM00 ORA-31613: Master process DM00 failed during startup. […]
ORA-02030: can only select from fixed tables/views
While providing select privilege on a v$ view , you may get below error. ORA-02030: can only select from fixed tables/views Problem: SQL> grant select on v$session to test; grant select on v$session to test * ERROR at line 1: ORA-02030: can only select from fixed tables/views Solution: You need […]
ORA-04063: view “SYS.KU$_RADM_FPTM_VIEW” has errors
While taking export dump using expdp , if are getting below error. Error: Processing object type DATABASE_EXPORT/SYS_USER/USER Processing object type DATABASE_EXPORT/SCHEMA/USER Processing object type DATABASE_EXPORT/ROLE ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ROLE:”APEX_GRANTS_FOR_NEW_USERS_ROLE”] ORA-04063: view “SYS.KU$_RADM_FPTM_VIEW” has errors ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95 ORA-06512: […]
ORA-06512: at “SYSMAN.EM_SELF_UPDATE” while installation 12c cloud control
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 not map to any partition INFO: oracle.sysman.top.oms:ORA-06512: at “SYSMAN.EM_SELF_UPDATE”, line 1547 INFO: oracle.sysman.top.oms:ORA-06512: at line 1 INFO: […]
Agent Clone Failed Exit Code:1
While 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 (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/12.1.0 Central Inventory : […]