Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

SPFILE parameter not updated (Oracle 11g)

edited Mar 9, 2020 5:10AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center