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>
Comments