Monday, November 30, 2015

ORA-01078: && LRM-00109 failure in processing system parameters

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/initORCL.ora'

solution:

there ware two options to resolve this issue.

1. in linux system export the SID and then try to start the db.

[oracle@murthy dbs]$ export ORACLE_SID=orcl
[oracle@murthy dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 30 18:23:35 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 

2. create the init.ora file to 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/initORCL.ora'
SQL> exit
Disconnected
[oracle@murthy dbs]$ ls
hc_orcl.dat  init.ora  lkORCL  orapworcl  spfileorcl.ora
[oracle@murthy dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 30 18:10:27 2015

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

Connected to an idle instance.

SQL> create pfile from spfile='/u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl.ora';

File created.


after successfully created the file then try to start the db.

No comments:

Post a Comment

Thanks for giving comments!!