[OCI] Database Patching Fails When The DB Cannot Be Started Using srvctl. (Doc ID 2831377.1)

Last updated on JANUARY 15, 2022

Applies to:

Symptoms

DB home patching failed.

DCS log shows:

[2021-11-30 19:35:59,715] FINE [DB: Applying DBHome patch[xxxxxx] : JobId=af04cbfa-d840-4386-9a29-4edfcf1c71a6] com.oracle.dcs.commons.utils.command.CommandExecutor: Return code: 1
[2021-11-30 19:35:59,716] FINE [DB: Applying DBHome patch[xxxxx] : JobId=af04cbfa-d840-4386-9a29-4edfcf1c71a6] com.oracle.dcs.commons.utils.CommonsUtils: Output :
PRCH-1001 : Failed to start resources in Oracle home /u01/app/oracle/product/12.1.0.2/dbhome_1
PRCR-1094 : Failed to start resources on node xxxxxx: ((NAME == xxxxxxx.db) AND (TYPE != application))
CRS-5017: The resource action "ora.xxxxxx.db start" encountered the following error:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00604: error occurred at recursive SQL level 1
ORA-28365: wallet is not open
Process ID: 91579
Session ID: 908 Serial number: 63003
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/xxxx/crs/trace/crsd_oraagent_oracle.trc".

....

Alert lof from same time:

...
Tue Nov 30 19:36:24 2021
Failed to find timezone data file # 31 (DST_4)
Tue Nov 30 19:36:24 2021
Daylight Saving Time feature is disabled
Tue Nov 30 19:36:24 2021
ORA-28365 encountered when generating server alert SMG-4120
Tue Nov 30 19:36:25 2021
FCP operation started for CONTAINER ID: 2
FCP: skipping this PDB as _fix_control is inherited from ROOT
Opening pdb PDB$SEED (2) with no Resource Manager plan active
Tue Nov 30 19:36:25 2021
Errors in file /u01/app/oracle/diag/rdbms/xxxxx/xxxx/trace/xxxx_ora_93078.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-28365: wallet is not open
Tue Nov 30 19:36:25 2021
Errors in file /u01/app/oracle/diag/rdbms/xxxxx/xxxxx/trace/xxxx_ora_93078.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-28365: wallet is not open
Error 604 happened during db open, shutting down database
USER (ospid: 93078): terminating the instance due to error 604
Tue Nov 30 19:36:26 2021
Instance terminated by USER, pid = 93078
ORA-1092 signalled during: ALTER DATABASE OPEN /* db agent *//* {1:58780:1227} */...
opiodr aborting process unknown ospid (93078) as a result of ORA-1092
Tue Nov 30 19:36:26 2021
ORA-1092 : opitsk aborting process
Tue Nov 30 19:52:50 2021
Starting ORACLE instance (normal) (OS id: 20226)
Tue Nov 30 19:52:50 2021
CLI notifier numLatches:53 maxDescs:5315

This shows the wallet could not be found to be opened.
If we try to start the DB from Sqlplus it cold be open.

Cause

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