8 Replies Latest reply: Aug 18, 2010 9:28 AM by user3636719 RSS

    ORA-01078: failure in processing system parameters

    user3636719
      Can someone help me here?

      I am trying to startup database I am getting following error.
      SQL> startup
      ORA-01078: failure in processing system parameters
      LRM-00109: could not open parameter file '/home/oracle/oracle/product/10.2.0/db_ 1/dbs/initPROD.ora'
      I followed some threads posted earlier on this board, to create spfile from pfile in case if it is corrupted but, here is what happened
      SQL> create spfile from pfile;
      create spfile from pfile
      *
      ERROR at line 1:
      ORA-01078: failure in processing system parameters
      LRM-00109: could not open parameter file
      '/home/oracle/oracle/product/10.2.0/db_1/dbs/initPROD.ora'
      Thanks
      --Sam                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
        • 1. Re: ORA-01078: failure in processing system parameters
          753877
          Hi,

          Kindly check the init file is available there in $ORACLE_HOME/dbs/


          cd $ORACLE_HOME

          ls -lrt init* (initPROD.ora) should be present.


          Regards,
          Praful Kawaji
          • 2. Re: ORA-01078: failure in processing system parameters
            Nicolas.Gasparotto
            What is the ORACLE_HOME (default location of pfile/spfile are under $ORACLE_HOME.dbs) ? ORACLE_BASE (pfile/spfile are most likely in $ORACLE_BASE/admin/<dbname>/pfile) ?

            Nicolas.
            • 3. Re: ORA-01078: failure in processing system parameters
              sb92075
              post results from following command

              ls -ltr /home/oracle/oracle/product/10.2.0/db_ 1/dbs/
              • 4. Re: ORA-01078: failure in processing system parameters
                Chinar
                Try
                create spfile from pfile='full_path_pfile';
                • 5. Re: ORA-01078: failure in processing system parameters
                  user3636719
                  Thanks for the reply, here is what you have asked for
                  [oracle@sam ~]$ ls -ltr /home/oracle/oracle/product/10.2.0/db_ 1/dbs/
                  ls: /home/oracle/oracle/product/10.2.0/db_: No such file or directory
                  ls: 1/dbs/: No such file or directory
                  [oracle@sam ~]$ ls -ltr /home/oracle/oracle/product/10.2.0/db_ 1/
                  ls: /home/oracle/oracle/product/10.2.0/db_: No such file or directory
                  ls: 1/: No such file or directory
                  [oracle@sam ~]$ cd $ORACLE_HOME
                  [oracle@sam db_1]$ pwd
                  /home/oracle/oracle/product/10.2.0/db_1
                  [oracle@sam db_1]$ ls
                  admin       cfgtoollogs  css   diagnostics          install           jdbc  ldap  mesg     oc4j    opmn         oui    precomp   root.sh      sqlj     uix
                  assistants  clone        ctx   flash_recovery_area  install.platform  jdk   lib   mgw      odbc    oracore      owm    racg      root.sh.old  sqlplus  wwg
                  bin         config       dbs   has                  inventory         jlib  log   network  olap    oraInst.loc  perl   rdbms     sam_demo1  srvm     xdk
                  cdata       crs          demo  hs                   javavm            jre   md    nls      OPatch  ord          plsql  relnotes  slax         sysman
                  [oracle@sam db_1]$ cd dbs
                  [oracle@sam dbs]$ ls
                  hc_demo1.dat  initdw.ora  init.ora  lkDEMO1  orapwdemo1  spfiledemo1.ora
                  [oracle@sam dbs]$ ls -lrt
                  total 68
                  -rw-r-----  1 oracle oinstall  8385 Sep 11  1998 init.ora
                  -rw-r-----  1 oracle oinstall 12920 May  3  2001 initdw.ora
                  -rw-r-----  1 oracle oinstall  1544 Aug  5 14:12 hc_demo1.dat
                  -rw-r-----  1 oracle oinstall    24 Aug  5 14:13 lkDEMO1
                  -rw-r-----  1 oracle oinstall  1536 Aug  5 14:17 orapwdemo1
                  -rw-r-----  1 oracle oinstall  3584 Aug  6 00:01 spfiledemo1.ora 
                  • 6. Re: ORA-01078: failure in processing system parameters
                    Nicolas.Gasparotto
                    You set ORACLE_SID=PROD, so ORacle is looking for a spfile named spfilePROD.ora, if not exist, then it is looking for a pfile named initPROD.ora. One of them must be under $ORACLE_HOME/dbs (it could be symbilic link as well to the file in an other path directory).
                    None of them exists out of there.
                    Check $ORACLE_BASE/admin/PROD/pfile
                    Otherwise, are you sure the dbname you want to start up is PROD ?

                    Nicolas.
                    • 7. Re: ORA-01078: failure in processing system parameters
                      sb92075
                      -rw-r----- 1 oracle oinstall 3584 Aug 6 00:01 spfiledemo1.ora
                      ORACLE_SID=demo1
                      • 8. Re: ORA-01078: failure in processing system parameters
                        user3636719
                        Thanks for all replies, the problem got resolved. It was wrong SID.
                        [oracle@sam dbs]$ export ORACLE_SID=demo1
                        [oracle@sam dbs]$ sqlplus / as sysdba
                        
                        SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 18 10:25:42 2010
                        
                        Copyright (c) 1982, 2005, Oracle.  All rights reserved.
                        
                        Connected to an idle instance.
                        
                        SQL> startup
                        ORACLE instance started.
                        
                        Total System Global Area  285212672 bytes
                        Fixed Size                  1218992 bytes
                        Variable Size             100664912 bytes
                        Database Buffers          180355072 bytes
                        Redo Buffers                2973696 bytes
                        Database mounted.
                        Database opened.
                        SQL>