000032812 - Could not determine the AVDB SPFILE from "srvctl config database -d AVDB"  when running modifyhostname.sh in RSA Via Lifecycle and Governance

Document created by RSA Customer Support Employee on Jul 25, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032812
Applies ToRSA Product Set: RSA Via Lifecycle and Governance with local database
IssueWhen trying to execute the modifyhostname.sh script to change the hostname, the script fails with following error.
Could not determine the AVDB SPFILE from "srvctl config database -d AVDB" 
You may need to start oracle

Restarting Oracle does not resolve the issue. 
CauseThis happens when the SPFILE is not properly configured in the Oracle configuration. You can check the Oracle configuration by running command below.
srvctl config database -d AVDB

The output will look similar to this.
Database unique name: AVDB
Database name: AVDB
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DG01/AVDB/spfileAVDB.ora
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: AVDB
Disk Groups: DG01

If the SPFILE parameter is not configured correctly or if it is blank, you will run into this issue while running modify hostname script.
ResolutionThis issue has been resolved in 6.9.1 P13 and 7.0 P4.
  1. Login to Oracle as sysdba using SQL*Plus or a similar client.
  2. Run the following command:
show parameter spfile;

The output will look like the sample below. The value may be different depending on the Oracle configuration.

NAME   TYPE   VALUE                                                  
------ ------ ------------------------------------------------------
spfile string /u01/app/oracle/product/12.1.0/db_1/dbs/spfileAVDB.ora

  1. SSH in to the RSA Via L&G server and run the following:
srvctl modify database -d AVDB -p <enter the string value received from Step 2>

  1. In this case, we would have to run the following command:
srvctl modify database -d AVDB -p /u01/app/oracle/product/11.2.0/db_1/dbs/spfileAVDB.ora

  1. Verify that the SPFILE is properly set by running this command:
srvctl config database -d AVDB

  1. Run modifyhostname.sh again.