[EXACC Gen-1 ] DB Home directory path changed after an expected in place patch with exadbcpatchmulti (Doc ID 2760174.1)

Last updated on DECEMBER 12, 2022

Applies to:

Symptoms

Customer patched first home without issues

[root@exacc01vm01 ~]# nohup /var/opt/oracle/exapatch/exadbcpatchmulti -apply_async 32226491 sshkey=/home/opc/.ssh/id_rsa -instance1=exacc01vm01:/u02/app/oracle/product/12.2.0/dbhome_3 -run_datasql=0 &

and can see the following from dbhome info

e.g.

# dbaascli dbhome info

...

6.HOME_NAME=SHARED02_12201_dbbp210119_0 <<<<
  HOME_LOC=/u02/app/oracle/product/12.2.0/dbhome_3
  PATCH_LEVEL=12201_dbru210119
  DBs installed= DB1 <<====
  OH Backup = NOT Configured

...

10.HOME_NAME=SHARED02_12201_dbbp190115_0
 HOME_LOC=/u02/app/oracle/product/12.2.0/dbhome_8
 PATCH_LEVEL=12201_dbru190115
 DBs installed= DB2
 OH Backup = NOT Configured

...

Then customer patched a second home without issues but much faster on both -precheck_async and -apply_async

and then noticed DB was moved to the first home where the patch is already applied.

e.g.

# dbaascli dbhome info

...

6.HOME_NAME=SHARED02_12201_dbbp210119_0 <<<<
  HOME_LOC=/u02/app/oracle/product/12.2.0/dbhome_3
  PATCH_LEVEL=12201_dbru210119
  DBs installed= DB1 DB2
  OH Backup = NOT Configured

...

10.HOME_NAME=SHARED02_12201_dbbp190115_0
 HOME_LOC=/u02/app/oracle/product/12.2.0/dbhome_8
 PATCH_LEVEL=12201_dbru190115
 DBs installed=
 OH Backup = NOT Configured

...

When trying to run the patch precheck against Oracle Home /u02/app/oracle/product/12.2.0/dbhome_8,

the following errors will now occur because there is no more DBs installed for this Oracle Home directory:

[root@exacc01vm01 ~]# /var/opt/oracle/exapatch/exadbcpatchmulti -precheck_async 32226491 sshkey=/home/opc/.ssh/id_rsa -instance1=exacc01vm01:/u02/app/oracle/product/12.2.0/dbhome_8 -run_datasql=0
Use of uninitialized value $instance_dbnames in substitution (s///) at /var/opt/oracle/exapatch/exadbcpatchmulti line 516.
Use of uninitialized value $patch_dbnames in string ne at /var/opt/oracle/exapatch/exadbcpatchmulti line 521.
Use of uninitialized value $patch_dbnames in substitution (s///) at /var/opt/oracle/exapatch/exadbcpatchmulti line 930.
Use of uninitialized value $patch_dbnames in split at /var/opt/oracle/exapatch/exadbcpatchmulti line 931.
Use of uninitialized value $patch_dbs[0] in concatenation (.) or string at /var/opt/oracle/exapatch/exadbcpatchmulti line 932.
INFO: Master transaction id is : 104
104
Use of uninitialized value $dbnames in substitution (s///) at /var/opt/oracle/perl_lib/DBAAS/dbaas_lock.pm line 1226.
Use of uninitialized value $dbnames in concatenation (.) or string at /var/opt/oracle/perl_lib/DBAAS/dbaas_lock.pm line 1227.
Use of uninitialized value $dbs in split at /var/opt/oracle/perl_lib/DBAAS/dbaas_lock.pm line 1113.
INFO: Acquired ohome lock for /u02/app/oracle/product/12.2.0/dbhome_8. Proceeding to acquire local provisioning lock
INFO: Acquired local provisioning lock in exadbcpatchmulti
INFO: sshkey being used is /home/opc/.ssh/id_rsa for exacc01vm01
INFO: cmd being run is: sudo /var/opt/oracle/exapatch/exadbcpatchsm -precheck_async 32226491 sshkey=/home/opc/.ssh/id_rsa -run_datasql=0 -dbname= -alldbs -firstnode -lastnode -patch_homes=/u02/app/oracle/product/12.2.0/dbhome_8 -txn_fl=/home/opc/txnid_fl.294264
INFO: running on the node exacc01vm01
INFO: host and txn id given : exacc01vm01 and 105
INFO: status seen is: Precheck async failed
INFO: status of slave txn###: Precheck async failed on exacc01vm01
Use of uninitializ

Changes

After chasing the history customer confirmed that patched some databases in the past using -dbnames option

for an individual DB patch requirement and this resulted in some DBs under the same "HOME NAME" prefix

having different Oracle Home directory path.

Cause

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