Header

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 :-

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.

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.