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>
45 Comments
Post a comment
DBA 
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.
Did you follow my steps what i posted in my blog? Did you startup your database using Init.ora file?
Thank u so much….
As salamalali kum Azar Bahi,
alhamdolilah its worked for me. thanking you very much, jazak allai khair.
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..
[oraid01@sapid01 ~]$ cd /oracle/ID1/102_64/dbs
[oraid01@sapid01 dbs]$ ls
initdw.ora init.ora
[oraid01@sapid01 dbs]$
thank u…
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
gracias Mohamed
thanks it worked for me..
Hi Friends,
I’m also getting some while starting database,i followed your step finally database started , thanks given wonderfull steps
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.
Great information !!
Thanks Azar.
This was really really helpful.
Thanks Azar 🙂
how can open the parameter file in window xp
What do you want exactly?
very helpful
thank you
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
set proper controlfile location in pfile,
or try to start using spfile (startup without using pfile)
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.
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>
thank you…….
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
Thanks a lot
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
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.
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
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.
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.
Hello Mohamed, I’ve did your first advice and works! So, thanks a lot!
hi,
it’s very good solution.
Thanks.
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.
Thanks!!! just what I needed
Thanks!!! Just what I needed right in front of me … awesome
Great work Mohamed. Thanks alot.
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
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
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
bai what is permently solution of this problem.when i rebot my system i and connect to oracle i face this problem again
ORA-01078 & LRM-00109, error showing, actually, I m practice dba on my laptop, I created “hr” name database and then removed and created new one, and now connect to new db as finance, its showing the error.
Very much informative .. I have also faced same issue ..
http://www.moreajays.com/2012/12/ora-01078-ora-29701-grid-home-cloning.html