PRCD-1229 : An attempt to access configuration of database xxxxxx was rejected
PRCD-1027 : Failed to retrieve database xxxxxx
PRCD-1229 : An attempt to access configuration of database xxxxxx was rejected because its version 220.127.116.11.0 differs from the program version 18.104.22.168.0. Instead run the program from /u01/app/oracle/product/22.214.171.124/db_1
After manual upgrade or downgrade, we might have seen this above error. This can be resolved as below. This is happening because of the cluster configuration is still pointing to older oracle home where Database is running from new OH. Such situations we have to update the cluster configuration using below command, it can be either upgrade or downgrade.
srvctl downgrade database -d -o -t [126.96.36.199]
srvctl downgrade database -d xxxxx -o /u01/app/oracle/product/188.8.131.52/db_1 -t 184.108.40.206.0
This command will downgrade the cluster configuration to 220.127.116.11 and will point to 18.104.22.168 Home.
$ srvctl config database -d xxxxx
Database unique name: xxxxx
Oracle home: /u01/app/oracle/product/22.214.171.124/db_1
Oracle user: oracle
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,FLASH
Mount point paths:
OSDBA group: dba
OSOPER group: dba
Database instances: xxxxx1,xxxxx2
Configured nodes: xxxxx111,xxxxx112
Database is administrator managed
The same is applicable for upgrade also.