After client performed a manual upgrade of a DB from 12c to 19c, we noticed we could not update configuration at cluster level and we faced these errors:

DB1@[servename]oracle> srvctl modify database -db DB1 -oraclehome /u10/app/oracle/product/19.0.0/dbhome_1
PRCD-1229 : An attempt to access configuration of database DB1 was rejected because its version 12.1.0.2.0 differs from the program version 19.0.0.0.0. Instead run the program from /u01/app/oracle/product/12.1.0/dbhome_1/.
DB1@[servename]oracle>


DB1@[servename]oracle> /u01/app/oracle/product/12.1.0/dbhome_1/bin/srvctl modify database -db DB1 -oraclehome /u10/app/oracle/product/19.0.0/dbhome_1
PRCT-1402 : Attempt to retrieve version of SRVCTL from Oracle Home /u10/app/oracle/product/19.0.0/dbhome_1/bin failed. Detailed error:
 PRKC-1137 : Unable to find Version object with string value 19.0.0.0.0
DB1@[servename]oracle>

This is what we did to fix it:

1:- Took current config using old home:


	DB1@[servename]oracle>  /u01/app/oracle/product/12.1.0/dbhome_1/bin/srvctl config db -d DB1
	Database unique name: DB1
	Database name:
	Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1/
	Oracle user: oracle
	Spfile:
	Password file:
	Domain:
	Start options: open
	Stop options: immediate
	Database role: PRIMARY
	Management policy: AUTOMATIC
	Disk Groups: DATA,FRA
	Services:
	OSDBA group:
	OSOPER group:
	Database instance: DB1
	DB1@[servename]oracle> 

2:- Remove from Cluster using old home:

	DB1@[servename]oracle> /u01/app/oracle/product/12.1.0/dbhome_1/bin/srvctl remove database -d DB1
	Remove the database DB1? (y/[n]) y
	DB1@[servename]oracle>



3:- Add to cluster config:

	DB1@[servename]oracle> echo $ORACLE_HOME
	/u10/app/oracle/product/19.0.0/dbhome_1
	DB1@[servename]oracle> srvctl add database -d DB1 -o /u10/app/oracle/product/19.0.0/dbhome_1 -diskgroup DATA,FRA
	DB1@[servename]oracle>


4:- Check 
	DB1@[servename]oracle> srvctl config db -d DB1
	Database unique name: DB1
	Database name:
	Oracle home: /u10/app/oracle/product/19.0.0/dbhome_1
	Oracle user: oracle
	Spfile:
	Password file:
	Domain:
	Start options: open
	Stop options: immediate
	Database role: PRIMARY
	Management policy: AUTOMATIC
	Disk Groups: DATA,FRA
	Services:
	OSDBA group:
	OSOPER group:
	Database instance: DB1
	DB1@[servename]oracle>
Last modified: 15 October 2022

Author

Comments

Write a Reply or Comment

Your email address will not be published.