My Oracle Support Banner

opatchauto fails during datapatch execution phase with Error - "ORA-65110: Invalid instance name specified" (Doc ID 2889724.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.15.0.0.0 and later
Information in this document applies to any platform.

Symptoms

During execution of opatchauto, below errors are seen in opatchauto log when datapatch is called-

Executing command as oracle:
/bin/sh -c 'cd <19c OH>;ORACLE_HOME=<19c OH> ORACLE_SID=test1 <19c OH>/OPatch/datapatch -verbose'
2022-07-05 10:19:53,063 INFO [523] com.oracle.glcm.patch.auto.db.integration.controller.action.ExecutionThread - Starting command execution...
/bin/sh -c 'cd <19c OH>;ORACLE_HOME=<19c OH> ORACLE_SID=test1 <19c OH>/OPatch/datapatch -verbose'

2022-07-05 10:19:59,168 INFO [523] com.oracle.glcm.patch.auto.db.product.executor.GISystemCall - Is retry required=false
2022-07-05 10:19:59,168 INFO [523] com.oracle.glcm.patch.auto.db.integration.controller.action.ExecutionThread - status: 255
2022-07-05 10:19:59,169 INFO [523] com.oracle.glcm.patch.auto.db.integration.controller.action.ExecutionThread - Failed in executing the command:
/bin/sh -c 'cd <19c OH>;ORACLE_HOME=<19c OH> ORACLE_SID=test1 <19c OH>/OPatch/datapatch -verbose'

2022-07-05 10:19:59,169 INFO [523] com.oracle.glcm.patch.auto.db.integration.controller.action.ExecutionThread -
COMMAND EXECUTION FAILURE :
SQL Patching tool version 19.15.0.0.0 Production on Tue Jul 5 10:19:53 2022
Copyright (c) 2012, 2022, Oracle. All rights reserved.

Log file for this invocation: <ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_20532_2022_07_05_10_19_53/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...Error: prereq checks failed!
catconExec failed with 1

Please refer to MOS Note 1609718.1 and/or the invocation log
<ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_20532_2022_07_05_10_19_53/sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Tue Jul 5 10:19:57 2022

ERROR:
catcon::exec_DB_script: <ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_20532_2022_07_05_10_19_53/sqlpatch_catcon__catcon_20532_exec_DB_script.done did not need to be deleted before running a script

catcon::sureunlink: confirmed that <ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_20532_2022_07_05_10_19_53/sqlpatch_catcon__catcon_20532_revertPdbModes_seed_pdb_close_mult_pdb_stmts_exec_DB_script.done no longer exists after 1 attempts

catcon::exec_DB_script: deleted <ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_20532_2022_07_05_10_19_53/sqlpatch_catcon__catcon_20532_revertPdbModes_seed_pdb_close_mult_pdb_stmts_exec_DB_script.done after running a script

catcon::exec_DB_script: closed Reader
catcon::print_exec_DB_script_output: exec_reset_pdb_mode_stmts:
catcon::print_exec_DB_script_output: output produced in exec_DB_script [
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output: SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 5 10:19:58 2022
catcon::print_exec_DB_script_output: Version 19.15.0.0.0
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output: Copyright (c) 1982, 2022, Oracle. All rights reserved.
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output: set newpage 1#LF#
catcon::print_exec_DB_script_output: set pagesize 14#LF#
catcon::print_exec_DB_script_output: connect / AS SYSDBA#LF#
catcon::print_exec_DB_script_output: Connected.
catcon::print_exec_DB_script_output: alter session set "_oracle_script"=TRUE#LF#/#LF#
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output: Session altered.
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output: alter pluggable database "PDB$SEED" close immediate force instances=('test1')#LF#/#LF#
catcon::print_exec_DB_script_output: alter pluggable database "PDB$SEED" close immediate force instances=('test1')
catcon::print_exec_DB_script_output: *
catcon::print_exec_DB_script_output: ERROR at line 1:
catcon::print_exec_DB_script_output: ORA-65110: Invalid instance name specified
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output: alter pluggable database "PDB$SEED" close immediate force instances=('test2')#LF#/#LF#
catcon::print_exec_DB_script_output: alter pluggable database "PDB$SEED" close immediate force instances=('test2')
catcon::print_exec_DB_script_output: *
catcon::print_exec_DB_script_output: ERROR at line 1:
catcon::print_exec_DB_script_output: ORA-65110: Invalid instance name specified
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output: #LF#host echo > <ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_20532_2022_07_05_10_19_53/sqlpatch_catcon__catcon_20532_revertPdbModes_seed_pdb_close_mult_pdb_stmts_exec_DB_script.done#LF#
catcon::print_exec_DB_script_output:
catcon::print_exec_DB_script_output: exit#LF#
catcon::print_exec_DB_script_output: Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
catcon::print_exec_DB_script_output: Version 19.15.0.0.0
catcon::print_exec_DB_script_output: ] end of output produced in exec_DB_script
catcon::exec_reset_pdb_mode_stmts: restored SIGINT handler

 As can be seen, commands to close PDB$SEED across all RAC Nodes are failing.

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!

In this Document
Symptoms
Cause
Solution


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