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

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.

What is the SRVCTL and Useful SRVCTL Commands in Oracle RAC