My Oracle Support Banner

datapatch fails against 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 to [Release 12.1 to 12.2]
Information in this document applies to any platform.


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


SQL Patching tool version 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

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
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 +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.' 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


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





Running datapatch after applying DB PSU or Proactive DB BP.


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.