This discussion is archived
1 Reply Latest reply: Apr 15, 2013 3:13 AM by MahirM.Quluzade RSS

ORA-01078: failure in processing system parameters

Thunder2777 Newbie
Currently Being Moderated
Hi There

While configuring Data Guard as I have inserted following parameters in SPFILEPRMDB.ora
(PRMDB is Primary DB).

*.db_unique_name='PRMDB'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRMDB,STLDB)'
*.LOG_ARCHIVE_DEST_1='LOCATION=C:\oracle\product\10.2.0\flash_recovery_area\PRMDB\ARCHIVELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRMDB'

*.LOG_ARCHIVE_DEST_2='SERVICE=STLDB LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STLDB'

*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=10
*.FAL_SERVER='STLDB'
*.FAL_CLIENT='PRMDB'
*.DB_FILE_NAME_CONVERT='STLDB','PRMDB'
*.LOG_FILE_NAME_CONVERT='D:\ORACLE\FRA\STLDB\','E:\oracle\product\10.2.0\flash_recovery_area\PRMDB\'*.DG_BROKER_START='TRUE'
*.STANDBY_FILE_MANAGEMENT='AUTO'

when I SQL> shutsown immediate; and SQL> Startup;
Oracle gives me following Error

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE
\INITPRMDB.ORA'

When I Restored old spfileprmdb.ora without these parameters then it Starts Up Normally.

What to Do???
Regards
Thunder2777
  • 1. Re: ORA-01078: failure in processing system parameters
    MahirM.Quluzade Guru
    Currently Being Moderated
    While configuring Data Guard as I have inserted following parameters in SPFILEPRMDB.ora
    (PRMDB is Primary DB).
    You can't insert prameters to SPFILEPRMDB.ora - Server parameter file is binary
    and only oracle can change content of this file.

    >
    *.db_unique_name='PRMDB'
    *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRMDB,STLDB)'
    *.LOG_ARCHIVE_DEST_1='LOCATION=C:\oracle\product\10.2.0\flash_recovery_area\PRMDB\ARCHIVELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRMDB'

    *.LOG_ARCHIVE_DEST_2='SERVICE=STLDB LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STLDB'

    *.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
    *.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
    *.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
    *.LOG_ARCHIVE_MAX_PROCESSES=10
    *.FAL_SERVER='STLDB'
    *.FAL_CLIENT='PRMDB'
    *.DB_FILE_NAME_CONVERT='STLDB','PRMDB'
    *.LOG_FILE_NAME_CONVERT='D:\ORACLE\FRA\STLDB\','E:\oracle\product\10.2.0\flash_recovery_area\PRMDB\'
    *.DG_BROKER_START='TRUE'
    *.STANDBY_FILE_MANAGEMENT='AUTO'
    Copy this parameters to a text file.

    You must create SPFILE from pfile again.

    When you start database, first find SPFILESID.ora, SPFILE.ora then InitSID.ora.

    If you want start from spfile,
     create spfile from pfile='<pfile location for exemple : c:\pfile.ora>';
    Regards
    Mahir M. Quluzade
    http://mahir-quluzade.com

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points