Hi,
Sometimes You can get ” PRCD-1229 : An attempt to access configuration of database was rejected because its version 18.0.0.0.0 differs from the program version 11.2.0.4.0. Instead run the program from 18c Home with PRCD-1027 : Failed to retrieve database MSDB ” error.
Details of error are as follows.
[oracle@msdbadm01 bin]$ srvctl status database -d MSDB PRCD-1027 : Failed to retrieve database MSDB PRCD-1229 : An attempt to access configuration of database MSDB was rejected because its version 18.0.0.0.0 differs from the program version 11.2.0.4.0. Instead run the program from /u01/app/oracle/product/18.0.0.0/dbhome. [oracle@msdbadm01 bin]$
This error is related with Oracle Clusterware keys for the database still refer to the old ORACLE_HOME.
To solve this error, you should Upgrade the Oracle Clusterware keys for the database by running the “srvctl upgrade database” command.
Run srvctl from the new release $ORACLE_HOME to upgrade the database keys as follows.
<new_home>/bin/srvctl upgrade database -d <DB_NAME> -o <ORACLE_DB_HOME>
[oracle@msdbadm01 bin]$ ./srvctl upgrade database -d MSDB -o /u01/app/oracle/product/18.0.0.0/dbhome PRCD-1180 : Configuration of database MSDB has been upgraded to version 18.0.0.0.0 [oracle@msdbadm01 bin]$
Now check it again. it is solved.
[oracle@msdbadm01 ~]$ srvctl status database -d MSDB Instance MSDB1 is running on node msdbadm01 Instance MSDB2 is running on node msdbadm02 [oracle@msdbadm01 ~]$
Do you want to learn more details about SRVCTL Utility, then read the following articles.