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.

[[email protected] 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.
[[email protected] 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>

[[email protected] 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
[[email protected] bin]$ 

Now check it again. it is solved.

[[email protected] ~]$ srvctl status database -d MSDB
Instance MSDB1 is running on node msdbadm01
Instance MSDB2 is running on node msdbadm02
[[email protected] ~]$

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

 1,838 views last month,  5 views today