Month: July 2018

Oracle PSU July 2018 error – ORA-20001: Latest xml inventory is not loaded into table

arcsdegeo2 Comments

while applying latest Oracle PSU released in July 2018 for 12.1.0.2 release i have faced the following when i reached the “data patch” level:

myhostt1:orax1> ./datapatch -verbose

SQL Patching tool version 12.1.0.2.0 Production on Thu Jul 19 10:53:37 2018

Copyright (c) 2012, 2016, Oracle.  All rights reserved.

Log file for this invocation: /oracle/orax1/cfgtoollogs/sqlpatch/sqlpatch_109246_2018_07_19_10_53_37/sqlpatch_invocation.log

Connecting to database…OK

Bootstrapping registry and package to current versions…done

Queryable inventory could not determine the current opatch status.

Execute ‘select dbms_sqlpatch.verify_queryable_inventory from dual’

and/or check the invocation log

/oracle/orax1/cfgtoollogs/sqlpatch/sqlpatch_109246_2018_07_19_10_53_37/sqlpatch_invocation.log

for the complete error.

Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log

/oraclex/oradbt14/cfgtoollogs/sqlpatch/sqlpatch_109246_2018_07_19_10_53_37/sqlpatch_invocation.log

for information on how to resolve the above errors.

SQL Patching tool complete on Thu Jul 19 10:53:41 2018

if you try to execute the following query:

SQL> select * from OPATCH_XML_INV ;

ERROR:

ORA-29913: error in executing ODCIEXTTABLEFETCH callout

ORA-29400: data cartridge error

KUP-04004: error while reading file

/oracle/orax1/product/12.1.0.2/QOpatch/qopiprep.bat

 

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
——————————————————————————–
ORA-20001: Latest xml inventory is not loaded into table

 

SOLUTION:

first, you need to download the latest OPatch utility 12.2.0.1.14

second, the error i have faced due to that i am invoking the opatch utility outside ORACLE_HOME…… now you need copy it in your oracle home directory ( its a must ! )

cd $ORACLE_HOME
mv $ORACLE_HOME/OPatch.orig
mkdir OPatch
cd OPatch
scp -r /newopatch/OPatch/* .

a good reference is Doc ID 1602089.1

impdp oracle error ORA-01000: maximum open cursors exceeded

arcsdegeoLeave a comment

my current environment were the problem was faced in:

Oracle 12cR1 (12.1.0.2.180417)

Linux Red Hat 7.4

The following errors were thrown in the import (impdp) log file :

ORA-39014: One or more workers have prematurely exited.

ORA-39029: worker 1 with process name “DW00” prematurely terminated

ORA-31671: Worker process DW00 had an unhandled exception.

ORA-01000: maximum open cursors exceeded

ORA-06512: at “SYS.KUPC$QUEUE_INT”, line 254

ORA-06512: at “SYS.KUPW$WORKER”, line 2157

ORA-01000: maximum open cursors exceeded

ORA-06512: at “SYS.KUPW$WORKER”, line 4700

ORA-01000: maximum open cursors exceeded

ORA-06512: at “SYS.KUPW$WORKER”, line 23341

To resolve this problem …you have three options:

Apply ORACLE DATABASE Patch for Bug# 23278750 for Linux-x86-64 Platforms 

OR

Upgrade to 12.2.0.1 🙂

OR

 Set the OPEN_CURSORS parameter to a value equal to or greater than the total number of indexes being imported

 

 

ORA-29548: Java system class reported: release of Java system classes in the database

arcsdegeoLeave a comment

In one of the oracle databases a daily export backup (expdp) is running every night, one day i was checking the log file and found the following errors:

ORA-06512: at “SYS.DBMS_METADATA”, line 10763

ORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EXPORT(:2, :3, :4, :5, :6, :7, :8, :9 ,:10); END;

ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.0 1.6) does not match that of the oracle executable (12.1.0.2.170718 1.6)

ORA-06512: at “SYS.DBMS_JAVA”, line 520

my database environment is:

Oracle 12cR1 (12.1.0.2)

IBM AIX 7.1

and database java component is installed.

i ran the following query for testing:

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 Java system classes in the

database (12.1.0.2.0 1.6) does not match that of the oracle executable

(12.1.0.2.170718 1.6)

SOLUTION:

shutdown the database and listener

cd $ORACLE_HOME/rdbms/lib

If you have already applied OCT 2016 OJVMPSU, then relink using below command.

make -f ins_rdbms.mk javavm_refresh patchset_opt_all ioracle

if you didn’t apply OCT 2016 OJVMPSU then:

make -f ins_rdbms.mk javavm_refresh ioracle

startup the database and then try re-executing the query again:

SQL> select dbms_java.get_jdk_version() from dual;

image00000000000000000001