This discussion is archived
8 Replies Latest reply: Aug 18, 2010 7:28 AM by user3636719 RSS

ORA-01078: failure in processing system parameters

user3636719 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Try
    create spfile from pfile='full_path_pfile';
  • 5. Re: ORA-01078: failure in processing system parameters
    user3636719 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    -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 Newbie
    Currently Being Moderated
    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>

Legend

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