My Oracle Support Banner

datapatch fails against 12.1.0.2 container database with ORA-00942 error for v_$instance (Doc ID 2368483.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

While running datapatch against 12.1.0.2 container database, it fails with below error:

 

SQL Patching tool version 12.1.0.2.0 Production on Fri Jan 12 05:56:57 2018
Copyright (c) 2012, 2017, Oracle. All rights reserved.

Log file for this invocation: /oracle/CDB_MIPS1/cfgtoollogs/sqlpatch/sqlpatch_22307_2018_01_12_05_56_57/sqlpatch_invocation.log

SQL Patching arguments:
verbose: 1
force: 0
prereq: 0
upgrade_mode_only:
oh:
bundle_series:
ignorable_errors:
bootstrap:
skip_upgrade_check:
userid:
pdbs:
noqi:

Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
catcon: ALL catcon-related output will be written to /oracle/CDB_MIPS1/cfgtoollogs/sqlpatch/sqlpatch_22307_2018_01_12_05_56_57/sqlpatch_catcon__catcon_22307.lst
catcon: See /oracle/CDB_MIPS1/cfgtoollogs/sqlpatch/sqlpatch_22307_2018_01_12_05_56_57/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See /oracle/CDB_MIPS1/cfgtoollogs/sqlpatch/sqlpatch_22307_2018_01_12_05_56_57/sqlpatch_catcon__*.lst files for spool files, if any
Bootstrapping registry and package to current versions...done
Error in bootstrap log /oracle/CDB_MIPS1/cfgtoollogs/sqlpatch/sqlpatch_22307_2018_01_12_05_56_57/bootstrap1_CMIPS1_PMIPS1.log:
Error at line 13: ORA-06550: line 21, column 35:
Error at line 15: ORA-06550: line 15, column 7:
Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
/oracle/CDB_MIPS1/cfgtoollogs/sqlpatch/sqlpatch_22307_2018_01_12_05_56_57/sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Fri Jan 12 05:57:08 2018

 

 

In bootstrap log for PDB, it shows below error:

 

Starting bootstrap driver on 12-JAN-18 05.57.04.954357 +00:00

PL/SQL procedure successfully completed.

old 9: IF &full_bootstrap OR &attempt > 1 THEN
new 9: IF FALSE OR 1 > 1 THEN
old 26: --IF database_label != '&datapatch_build_label' THEN
new 26: --IF database_label != 'RDBMS_12.1.0.2.0DBBP_LINUX.X64_170106' THEN
FROM sys.v_$instance);
*
ERROR at line 21:
ORA-06550: line 21, column 35:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 15, column 7:
PL/SQL: SQL Statement ignored

BBB
--------------------------------------------------------------------------------
?/rdbms/admin/nothing.sql

Finished bootstrap driver on 12-JAN-18 05.57.05.063485 +00:00

 

 

 

Changes

Running datapatch after applying DB PSU or Proactive DB BP.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.