1 Reply Latest reply: Apr 15, 2013 5:13 AM by Mahir M. Quluzade RSS

    ORA-01078: failure in processing system parameters

    Thunder2777
      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
          Mahir M. Quluzade
          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