-1

I log on to my database but giving me this error message

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0.2/db_1/dbs/initAKINTT.ora'

How can i resolve the problem ?

  • are you able to read the paramter file? try cat '/u01/app/oracle/product/12.1.0.2/db_1/dbs/initAKINTT.ora' – miracle173 Jul 15 '15 at 8:05
0

Did you correctly set ORACLE_SID environment variable to match your database name?

Assuming you didn't delete the spfile and pfile, incorrect ORACLE_SID setting might be causing the error, since when you issue "startup" command, Oracle will search for spfile in $ORACLE_HOME/dbs, and if it doesn't find, will alternatively search for pfile in format init.ora

So, if I have a database named test (lowercase), and I export ORACLE_SID in uppercase and attempt to start the instance, this error will ocurr.

[oracle@oracle $] export ORACLE_SID=TESTE [oracle@oracle $] sqlplus / as sysdba

SQL> startup...

-- ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file

In this case, there is no such file as initTEST.ora, only inittest.ora

So:

Check if you're using proper case while exporting ORACLE_SID and if the name is correct.

Given your db has been configured through dbca, you can find the name entry at:

[oracle@oracle $] cat /etc/oratab

-1
  1. Create pfile manually or get it from old database and edit it
  2. start database
  3. create spfile from pfile CREATE SPFILE (Oracle Docs)
  • It helps if you provide additional references and working examples. You could clean up your answer some more and provide a good working solution. It also helps if you read the help on formatting to format your text correctly. – hot2use Nov 16 '17 at 10:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.