When I try to startup my Oracle database I get the following error:
LRM-00109: could not open parameter file '/opt/app/oracle/product/11.2.0/db_1/dbs/initjicdbaex.ora'
The /dbs
directory in my Oracle home contains the init.ora
file I want to use, but I don't know how to point the database to read that file.
How do I set the correct parameter file path to init.ora
?
Best Answer
You can not or at least you should not. The right pfile (or spfile) should contain ORACLE_SID in it's name.
Theoretically you can start the database using:
But I won't recommend it.