While connecting to catalog database using RMAN you may get below error like . PL/SQL package DBMS_RCVMAN version 12.01.00.01 in RCVCAT database is not current. Problem:   oracle@TEST:~/RMAN/TEST$ rman Recovery Manager: Release 12.1.0.2.0 – Production on Tue Feb 23 09:27:33 2016 Copyright (c) 1982, 2014, Oracle and/or its […]

             While running datapatch tool in Oracle 12c, as part of post patching got ORA-20013 error. Use below steps to solve the issue. Problem: cd /oracle/app/oracle/product/12.1.0.2/dbhome_1/OPatch ./datapatch -verbose SQL Patching tool version 12.2.0.0.0 on Thu Feb 25 11:02:17 2016 Copyright (c) 2014, Oracle. All rights reserved. Connecting to database…OK catcon: […]

     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 […]

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. […]

 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 […]

  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 […]

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 […]

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. […]

      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 […]

                    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: […]