This happens very rarely, when you are not able startup the DB.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initTest.ora'
SQL>
The issue is the Oracle could not fine the Pfile or SPfile to startup the DB.
So, if both the files are deleted then restore the file backup and start the DBA.
I just restored,
SQL> startup;
ORACLE instance started.
Total System Global Area 730714112 bytes
Fixed Size 2216944 bytes
Variable Size 478153744 bytes
Database Buffers 247463936 bytes
Redo Buffers 2879488 bytes
Database mounted.
Database opened.
SQL> select name from v$database;
NAME
---------
TEST
SQL>
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initTest.ora'
SQL>
The issue is the Oracle could not fine the Pfile or SPfile to startup the DB.
So, if both the files are deleted then restore the file backup and start the DBA.
I just restored,
SQL> startup;
ORACLE instance started.
Total System Global Area 730714112 bytes
Fixed Size 2216944 bytes
Variable Size 478153744 bytes
Database Buffers 247463936 bytes
Redo Buffers 2879488 bytes
Database mounted.
Database opened.
SQL> select name from v$database;
NAME
---------
TEST
SQL>
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/11.2.0
/db_1/dbs/spfileTest.ora
SQL>
And it just got up from SPfile.
No comments:
Post a Comment