Could not determine the AVDB SPFILE from "srvctl config database -d AVDB" when running modifyhostname.sh in RSA Via Lifecycle and Governance
Originally Published: 2016-03-23
Article Number
Applies To
Issue
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. Cause
srvctl config database -d AVDBThe 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 Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Database instance: AVDB Disk Groups: DG01 Services:If the SPFILE parameter is not configured correctly or if it is blank, you will run into this issue while running modifyhostname script.
Resolution
Workaround
- Login to Oracle as sysdba using SQL*Plus or a similar client.
- 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
- 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>
- 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
- Verify that the SPFILE is properly set by running this command:
srvctl config database -d AVDB You will see that SPFILE value is now correctly updated as follows: Database unique name: AVDB Database name: AVDB Oracle home: /u01/app/oracle/product/11.2.0/db_1 Oracle user: oracle Spfile: /u01/app/oracle/product/12.1.0/db_1/dbs/spfileAVDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Database instance: AVDB Disk Groups: DG01 Services:
- Run modifyhostname.sh again.
Related Articles
ADC fails with 'ORA-01400: cannot insert NULL into ("AVUSER"."GTT_CE_RELATIONS"."SRCPK_ID")' Admin error in RSA Identity G… Number of Views install.sh fails with 'gethostip: command not found' and 'gethostip -d <domainname> does not match hostname -i' errors in… Number of Views customizeACM.sh -d fails with - Undeploy failed: - error in RSA Governance & Lifecycle Number of Views How to add a domain name to the DB service name on tnsnames.ora in RSA Identity Management and Governance Number of Views Importing new token seed record fails with browser error - AM Number of Views
Trending Articles
Authentication Manager Log Messages (23001-23091) RSA Authentication Manager Upgrade Process How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
