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
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