SPFILE parameter not updated (Oracle 11g)
Hi
I am created a standby database and trying to create a spfile from pfile obtained from the primary server
I have created spfile in ASM (not in $ORACLE_HOME/dbs)
SQL> create spfile='+DATA/GPSICDDBFDR/spfileGPSICDDB.ora' from pfile='/rman_backup/RMAN_DAILY_FULL/GPSICDDB/20200104/initGPSICDDB.ora';
File created.
Above command get s executed successfully
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
Value is null
SQL> startup nomount force;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initGPSICDDB.ora'
Server still looking at the default spfile location ie ?/dbs/initGPSICDDBFDR.ora