Sunday, April 30, 2017

PRCD-1229 : An attempt to access configuration of database xxxxxx was rejected

PRCD-1229 : An attempt to access configuration of database xxxxxx was rejected because its version 11.2.0.4 differs from the program version 12.1.0.2.0 Instead run the program from /u01/app/oracle/product/11.2.0.4/db_1

After database upgrade from 11.2.0.4 to 12.1.0.2,I was trying to modify configuration of database and encountered below error :-


[oracle@poc~] srvctl modify database -d orcl -o /u01/app/oracle/product/12.1.0.2/db_1

PRCD-1229 : An attempt to access configuration of database orcl was rejected because its version 11.2.0.4 differs from the program version 12.1.0.2.0 Instead run the program from /u01/app/oracle/product/11.2.0.4/db_1


Cause:-
After manual upgrade or downgrade, we might have seen this error.This is happening because of the cluster configuration is still pointing to older oracle home however database is running from new OH. To tackle such situations we have to update the cluster configuration using below command, it can be either upgrade or downgrade.

Solution :-
We are using Oracle Clusterware, we must upgrade oracle clusterware keys for database.


[oracle@poc~] cd /u01/app/oracle/product/12.1.0.2/db_1/bin

[oracle@poc~] srvctl upgrade database -db orcl -o /u01/app/oracle/product/12.1.0.2/db_1


Same rule applies when you downgrade your database.

Note :-
The "srvctl upgrade database" command is considered part of the database upgrade process, hence the old ORACLE_HOME must still exist for this command to succeed.  If the old ORACLE_HOME has already been removed, then "srvctl upgrade database" will fail with an error similar to "PRKH-1013 : The oracle home <old_home> does not exist."  To work around this issue, perform the following steps:

1. Manually create a directory with the same name as the old ORACLE_HOME and create a dummy oracle executable.
% mkdir -p <old_home>/bin
% touch <old_home>/bin/oracle

2. Re-run the "srvctl upgrade database" command
% <new_home>/bin/srvctl upgrade database -d <name> -o <new_home>





No comments:

Post a Comment