on 03-02-2016 12:54 PM
Hi All,
When i am trying to startup the oracle database it shows the following error::
lx-ch902:orajdr 7> sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Mar 2 13:53:20 2016
Copyright (c) 1982, 2014, 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 '/oracle/JDR/121/dbs/initJDR.ora'
SQL>
The listener is up and running.
Kindly help.
Regards,
Kavish
Hi,
Regarding this "ORA-01078/LRM-00109" issue, you can also refer to SAP Note
653247 - "Composite note: ORA-01078" (especially point 4) for troubleshooting.
Regards,
Bíborka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kavish,
You need to check whether the file initJDR.ora exist at location '/oracle/JDR/121/dbs/'.
If the file does not exist then create a pfile from spfile.
create pfile from spfile;
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are sure that the spfile and pfile were kept in the above location then the options are:
1 - Copy pfile from a similar system and modify it with the target system details.
2 - If there is a filesystem backup available then restore it and retrieve the file.
3 - Check the alert log and get the parameters from there and create a pfile
Hallo,
does the file /oracle/JDR/121/dbs/initJDR.ora exists?
What is the ownership/flags if it does?
Regards
Thomas.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.