Sunday, February 19, 2012

dvca fails with PRKO-2007: Invalid instance name while registering database vault

Problem Description
In Oracle database 10g to 11.1g while setting up Database Vault on a RAC database a PRKO-2007 error will be encountered if the "racnode" parameter is used and the database name is not the same as the prefix of instance name.
$ dvca -action option -oh /u01/app/oracle/product/10.2.0 -s_path /tmp -logfile dvca_run.log -owner_account dvowner -owner_passwd dvtest_1 
-acctmgr_account DVACCTMGR -acctmgr_passwd dvtest_1 -jdbc_str jdbc:oracle:oci:@orcl1 -sys_passwd sys -languages {en} -nodecrypt 
-racnode rac1 -lockout

DVCA started 
Executing task LOCKOUT_OFF 
Executing task RESTART_SERVICES_PATCH 
MANAGE_INSTANCE stop isqlplus 
MANAGE_INSTANCE stop OC4J 
MANAGE_LISTENER start listener 
MANAGE_INSTANCE start RDBMS 
MANAGE_INSTANCE start RDBMS 
result=/u01/app/oracle/product/10.2.0/bin/dvca_start_rdbms.sh,1, 
MANAGE_INSTANCE start RDBMS log=PRKO-2007 : Invalid instance name: orcl1 
Executing task SQLPLUS_CATOLS 

Cause of the Problem
This issue has been identified as Oracle bug 8208579.

Running DVCA in a RAC environment will invoke "srvctl -d dbname". Currently, service name is passed as dbname, which might be wrong, especially in RAC environment and hence the error invalid instance name is appeared.

Solution of the Problem
Install the patch 8208579 if it is available for your version. If patch is not available to you you can avoid using the "racnode" parameter.

No comments: