Oracle 12c failed to start

[Former Member]

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

[former_member207186]

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

[former_member185239]

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

[Former Member]

Hi Ashutosh,

well in /oracle/JDR/121/dbs i only have init.ora

[oracle@lx-ch902 121]$ cd dbs

[oracle@lx-ch902 dbs]$ ll

total 4

-rw-r--r--. 1 oracle oinstall 2992 Feb  3  2012 init.ora

How how can i create both spfile and pfile?

Thanks

Kavish

[Reagan]

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

[Former Member]

Hallo,

does the file /oracle/JDR/121/dbs/initJDR.ora exists?

What is the ownership/flags if it does?

Regards

Thomas.