Skip to content
Advertisements

ORA-01078: failure in processing system parameters

I tried to start my test db , it shows following errors, I struggled with these errors, though finally i find out and fix it. oops but It’s so easy 🙂

Enter user-name:sys/sys as sysdba
Connected to an idle instance.

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/initorcl.ora' SQL> exit
Disconnected

[oracle@localhost dbs]# ls
hc_azar.dat  initdw.ora  lkAZAR  orapwazar  spfileazar.ora
hc_TEST.dat  init.ora    lkTEST  orapwTEST  spfileTEST.ora

Here inittest.ora file is does not exist, so i created pfile from spfile and then It’s working.

SQL> create pfile from spfile='/home/oracle/oracle/product/10.2.0/db_1/dbs/spfileTEST.ora';

File created.

SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size              92276304 bytes
Database Buffers          188743680 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
SQL>

Or

If you’re not set proper SID Path , you may get this error

[oracle@netbackuptest ~]$ cat /etc/oratab
netbktest:/u01/app/oracle/product/11.2.0/dbhome_1:N
cigna:/u02/oracle/product/10.2.0/db_1:N
brokertest:/u02/oracle/product/10.2.0/db_1:N
The above three are my current database. Here I'm going to set another Oracle Sid here,
[oracle@netbackuptest ~]$ export ORACLE_SID=testdb
[oracle@netbackuptest ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 25 08:56:42 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u02/oracle/product/10.2.0/db_1/dbs/inittestdb.ora'
SQL> exit
Disconnected

If I set proper Oracle SID , I can able to start the database.

[oracle@netbackuptest ~]$ export ORACLE_SID=cigna
[oracle@netbackuptest ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 25 08:57:28 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size                  2020384 bytes
Variable Size             167775200 bytes
Database Buffers         1040187392 bytes
Redo Buffers               14753792 bytes
Database mounted.
Database opened.
SQL>
Advertisements
42 Comments Post a comment
  1. Sajreena #

    I was trying to create a db in oracle 10g manually.In the step of creating the SPFILE from PFILE,I’m gettin errors–
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file ‘D:\SAJ\INIT.ORA’
    How can I solve this?I’m using Windows XP platform.Please help me to sort this out.

    September 18, 2010
  2. Did you follow my steps what i posted in my blog? Did you startup your database using Init.ora file?

    September 18, 2010
  3. Vamsi #

    Thank u so much….

    February 25, 2011
  4. Syed Jahangir #

    As salamalali kum Azar Bahi,

    alhamdolilah its worked for me. thanking you very much, jazak allai khair.

    March 19, 2011
  5. Ali Marjan #

    Hi Azar…
    please help..

    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file ‘/oracle/ID1/102_64/dbs/initID1.ora’
    SQL> create pfile from spfile=’/oracle/ID1/102_64/dbs/initID1.ora’;
    create pfile from spfile=’/oracle/ID1/102_64/dbs/initID1.ora’
    *
    ERROR at line 1:
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3

    any suggest..??
    Thanks..

    August 21, 2011
    • Ali Marjan #

      [oraid01@sapid01 ~]$ cd /oracle/ID1/102_64/dbs
      [oraid01@sapid01 dbs]$ ls
      initdw.ora init.ora
      [oraid01@sapid01 dbs]$

      August 21, 2011
  6. sandeep #

    thank u…

    October 30, 2011
  7. Julio Antiche #

    Hi good afternoon I have a problem like you mention my error is something like the following:

    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file ‘/u01/app/oracle/product/10.2.0/db_1/dbs/initTSH1.ora’

    try to do what you say does not work I’m doing something wrong beforehand greetings and thanks to Venezuela

    SQL> create pfile from spfile= ‘/u01/app/oracle/product/10.2.0/db_1/dbs/initTSH1.ora’;

    error in line 1 :S

    November 4, 2011
  8. Gabu #

    gracias Mohamed

    December 13, 2011
  9. Prashant #

    thanks it worked for me..

    December 18, 2011
  10. kumaresan nethaji #

    Hi Friends,

    I’m also getting some while starting database,i followed your step finally database started , thanks given wonderfull steps

    December 28, 2011
  11. sandesh sharma #

    hi azar,

    i am facing this problem..please rectify this

    ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
    ORA-48140: the specified ADR Base directory does not exist [/opt/oracle/111/dbs/]
    ORA-48187: specified directory does not exist
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 1

    as i followed your steps to reduce the previous problem
    thax a lot in advance.

    January 22, 2012
  12. Hema #

    Great information !!
    Thanks Azar.

    January 23, 2012
  13. This was really really helpful.
    Thanks Azar 🙂

    February 4, 2012
  14. pradeep(patna) #

    how can open the parameter file in window xp

    February 27, 2012
  15. Tanvir Tonu #

    very helpful
    thank you

    February 28, 2012
  16. hi sir..
    actually i created a new control file from exiting file
    then added new control file path in dbs location and
    then after i want to open the database by using pfile but
    it’s shows an error.
    ERROR:
    LRM-00123:invalid character 0 found in the input file.
    ORA-01078:failed in processing system parameters

    March 6, 2012
    • set proper controlfile location in pfile,

      or try to start using spfile (startup without using pfile)

      March 6, 2012
      • hi azar.
        thank you for replying me.
        Their is an error in opening the database can u plz help me.
        alter database mount;
        mounted the database

        alter database open;
        error:
        ORA:01589:must use resetlogs or noresetlogs option for database open
        then i shut down the database again open the database in mount stage
        after that i gave a queire
        alter database open resetlogs
        but showing an error at line 1:
        ORA -01157:cannot identify/lock datafiles-see DBWR tracefile.
        ORA-01110:datafile 6:’/u01/kusuma/oradata/KUSUMA/ts1.dbf’

        i cheaked at os level in oradata their is no ts1.dbf file
        can we recover the database it.

        March 13, 2012
      • your datafile was missed, If you have backup, you should restore the datafile at database mount stage and if you have archivelog file after created database , you can able to restore and recover tablespace.

        https://mohamedazar.com/2011/01/03/how-to-recover-datafile-not-backed-up/

        If you don’t have backup, you can recover this tablespace. This datafile not important, you can offline this datafile and after open the database

        SQL> host
        [oracle@netbackuptest ~]$ cd /u01/app/oracle/product/11.2.0.2/dbhome_2/dbs/
        [oracle@netbackuptest dbs]$ mv testarc.dbf /u01/app/oracle
        [oracle@netbackuptest dbs]$ exit
        exit

        SQL> shutdown immediate
        Database closed.
        Database dismounted.
        ORACLE instance shut down.
        SQL> startup
        ORACLE instance started.

        Total System Global Area 1603411968 bytes
        Fixed Size 2226912 bytes
        Variable Size 721421600 bytes
        Database Buffers 872415232 bytes
        Redo Buffers 7348224 bytes
        Database mounted.
        ORA-01157: cannot identify/lock data file 8 – see DBWR trace file
        ORA-01110: data file 8:
        ‘/u01/app/oracle/product/11.2.0.2/dbhome_2/dbs/testarc.dbf’

        SQL> select file#,name,status from v$datafile where name like ‘/u01/app/oracle/product/11.2.0.2/dbhome_2/dbs/testarc.dbf’;

        FILE#
        ———-
        NAME
        ——————————————————————————–
        STATUS
        ——-
        8
        /u01/app/oracle/product/11.2.0.2/dbhome_2/dbs/testarc.dbf
        ONLINE

        SQL> alter database datafile ‘/u01/app/oracle/product/11.2.0.2/dbhome_2/dbs/testarc.dbf’ offline;

        Database altered.

        SQL> alter database open;

        Database altered.

        SQL>

        March 14, 2012
  17. thank you…….

    March 6, 2012
  18. ali #

    thanks for all the info regarding
    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/initorcl.ora’ SQL> exit
    Disconnected

    You have saved my time

    Ali
    Ajman , UAE

    July 29, 2012
  19. sunny #

    Thanks a lot

    August 13, 2012
  20. kyaw thu #

    hello azard .. i want to do oracle datagurad to automatically ..
    without command .. means .. before i write alter system switch archive log;
    there is no record in standby.

    how to activate automatically ..

    please show me the way to do ..

    BEST REGARDS,
    kyaw thu

    August 31, 2012
  21. kyawthu #

    SQL> startup
    ORACLE instance started.

    Total System Global Area 722366464 bytes
    Fixed Size 2216864 bytes
    Variable Size 444599392 bytes
    Database Buffers 268435456 bytes
    Redo Buffers 7114752 bytes
    Database mounted.
    ORA-10458: standby database requires recovery
    ORA-01157: cannot identify/lock data file 1 – see DBWR trace file
    ORA-01110: data file 1: ‘/oracle01/oracledb/pce/system01.dbf’

    SQL>

    hello azar please help me.
    i was in trouble.

    September 7, 2012
  22. kyaw thu #

    Mr.Modamedazar..

    thank for your suggestion, in this time..i would like to ask you about the fail over step by step
    cos when i done to switch over status.. i want to test the fail over.. in that step how to create the snapshot and create to restore point…please help me..

    Best regards
    Kyaw Thu

    September 8, 2012
  23. mahrukh #

    Hi, after creating pfile from spfile when i do startup i get following error
    SQL> startup
    ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
    ORA-48140: the specified ADR Base directory does not exist [/u01/app/oracle/product/11.2.0/dbhome_1/dbs/]
    ORA-48187: specified directory does not exist
    Linux Error: 2: No such file or directory
    Additional information: 1
    can you please help me to fix it. I will appreciate it.

    October 19, 2012
  24. Rohan #

    i am using database with SID but dont know why i am geting this error now.I tried to solve it but i am unable. to solve it.Tell me reason and solution.

    October 23, 2012
  25. Marcelo Barbosa #

    Hello Mohamed, I’ve did your first advice and works! So, thanks a lot!

    November 15, 2012
  26. peddapeeraiah #

    hi,
    it’s very good solution.
    Thanks.

    March 2, 2013
  27. Excellent way of explaining, and good paragraph to get data on the topic of my presentation
    focus, which i am going to present in university.

    March 28, 2013
  28. Thanks!!! just what I needed

    June 17, 2013
  29. Thanks!!! Just what I needed right in front of me … awesome

    June 17, 2013
  30. Sushant Gaikwad #

    Great work Mohamed. Thanks alot.

    November 2, 2015
  31. vikash #

    hii azhar,

    i follow your statement like you given above but i am not able to resolve these problem so what to do can you help me out from these

    December 20, 2015
  32. vikash #

    hii azahar,

    i do the same things which is you given in these image but i am not able to do i have a file like initorcl.ora when i create pfile then it give a error that it could n’t find that file so please solve these issue

    December 20, 2015
  33. Hi Azhar, thank you for the fix, i have faced this problem many a times before and tried similar fixes and i had always ended up reinstalling, this time i just followed your first step and it worked fantastic. thanks again.

    just wanted to understand why this error occurs at the first place, do we need to take care of any prerequisites related to this issue? please let us know your suggestion.

    take Care,
    Jay

    May 7, 2016
  34. faiqkhan #

    bai what is permently solution of this problem.when i rebot my system i and connect to oracle i face this problem again

    April 9, 2017

Trackbacks & Pingbacks

  1. 2010 in review « DBA
  2. wordpress templates
  3. référencement naturel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: