Symptom:
$ /opt/oracle/product/ora12101b/OPatch]:./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Thu Feb 20 13:17:57 2014
Copyright (c) 2013, Oracle. All rights reserved.
Connecting to database...OK
Determining current state...
Currently installed SQL Patches: 17027533
DBD::Oracle::st execute failed: ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 1011
ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute) [for Statement "DECLARE
x XMLType;
BEGIN
x := dbms_qopatch.get_pending_activity;
? := x.getStringVal();
END;" with ParamValues: :p1=undef] at /opt/oracle/product/ora12101b/sqlpatch/sqlpatch.pm line 962.
|
Solution:
Re-create your OPATCH_LOG_DIR and OPATCH_SCRIPT_DIR directories. And make sure that they point to $ORACLE_HOME\QOpatch
SQL> create or replace directory OPATCH_LOG_DIR as '/opt/oracle/product/ora12101b/QOpatch';
Directory created.
SQL> create or replace directory OPATCH_SCRIPT_DIR as '/opt/oracle/product/ora12101b/QOpatch';
Directory created.
$ /opt/oracle/product/ora12101b/OPatch]:./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Tue Feb 25 10:34:19 2014
Copyright (c) 2013, Oracle. All rights reserved.
Connecting to database...OK
Determining current state...
Currently installed SQL Patches: 17027533
Currently installed C Patches: 17552800
The following patches will be rolled back: 17027533
The following patches will be applied: 17552800
Adding patches to installation queue...
Installing patches...
Validating logfiles...
Patch 17027533 rollback: SUCCESS
logfile: /opt/oracle/product/ora12101b/sqlpatch/17027533/17027533_rollback_TESTDB_testdb_2014Feb25_10_34_28.log (no errors)
catbundle generate logfile: /opt/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTDB_testdb_GENERATE_2014Feb25_10_34_30.log (no errors)
catbundle rollback logfile: /opt/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTDB_testdb_ROLLBACK_2014Feb25_10_34_29.log (no errors)
Patch 17552800 apply: SUCCESS
logfile: /opt/oracle/product/ora12101b/sqlpatch/17552800/17552800_apply_TESTDB_testdb_2014Feb25_10_34_30.log (no errors)
catbundle generate logfile: /opt/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTDB_testdb_GENERATE_2014Feb25_10_34_30.log (no errors)
catbundle apply logfile: /opt/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTDB_testdb_APPLY_2014Feb25_10_34_31.log (no errors)
SQL Patching tool complete on Tue Feb 25 10:34:32 2014
|
No comments:
Post a Comment