Skip to Content
avatar image
Former Member

Oracle 12c failed to start

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 02, 2016 at 01:03 PM

    Hallo,

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

    What is the ownership/flags if it does?

    Regards

    Thomas.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 02, 2016 at 02:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Mar 02, 2016 at 04:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded