A Oracle DBA's BLOG

Welcome to my ORACLE DBA blog. You will be Amazing!!!

Wednesday, August 7, 2013

ORA-01078: failure in processing system parameters

Today, I got a issue during my experience
 ORA-01078: Failure in processing system parameters,
 LRM-00109: could not open parameter file '/app/oracle/product/11.2.0/db_1/dbs/init.ora
 Its first time I'm on this issue
 So, i realized that Failure caused during processing of INIT.ORA parameters during system startup.

My action was like the following and it had fixed, May be we can see easy/different way on the internet,However let me fix it :) 

[oracle@localhost ]$ sqlplus as sysdba 

SQL>startup 


ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/app/oracle/product/11.2.0/db_1/dbs/init.ora' 

SQL> exit

Disconnected
Open database nomount mode by pfile
SQL> startup nomount pfile=/app/oracle/admin/orcl/pfile/init.ora
ORACLE instance started.

Create pfile again
SQL> create spfile from pfile
2 ;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing systemparameters
LRM-00109: could not open parameter file
'/app/oracle/product/11.2.0/db_1/dbs/init.ora'


 Create like that
SQL> create spfile from pfile='/app/oracle/admin/orcl/pfile/init.ora';

File created.

NOW create pfile 
SQL> create pfile from spfile;

File created.

SQL> exit
I got init.ora
 [oracle@localhost pfile]$ ls
init.ora
 [oracle@localhost pfile]$sqlplus


Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and RealApplication Testing options

I thought i resolved my issue but after this select 
SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01507: database not mounted


Close database
SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.

Open it should work i guess :)
SQL> startup
ORACLE instance started.

Total System Global Area 224760096 bytes
Fixed Size 1235143 bytes
Variable Size 218627450 bytes
Database Buffers 87557892 bytes
Redo Buffers 5427622 bytes
Database mounted.
Database opened.

Finnaly

SQL> select name from v$database;

NAME
---------
orcl




No comments:

Post a Comment