Nasreen Mathias

How to change the location of spfile for Primary DB

Discussion created by Nasreen Mathias Employee on Sep 1, 2017

Version 6.8.1 Patch 10 

appliance 720, OS Redhat 5u8 

appliance A = primary DB

appliance B = standby DB

 

On the primary DB, customer is trying to change the location of the spfile. Currently it is pointing to local  /u01/app/oracle/product/11.2.0 /db_1/dbs/spfileAVDB.ora

and  not oracle base 

 

SQL> show parameter spfile

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

spfile string /u01/app/oracle/product/11.2.0 /db_1/dbs/spfileAVDB.ora

 

Thanks,

Nasreen

Outcomes