Troubleshooting

LRM-00109: could not open parameter file

Hello Everyone,

When trying to start the instance , getting this ..
Enter user-name: sys as sysdba;
Enter password:
Connected to an idle instance.
SQL> startup;

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/u01/app/oracle/product/11.2.0/db_1/dbs/initDemo.ora’

solutuon one :
Check the Oracle SID name.  Wrong settings in bash profile.

Solution two :

I used to face this issue.

I realized that the error can be caused by the pfile not being found. You have to start the Oracle instance using a fully referenced pfile by issuing the following command:

SQL> startup pfile=<your pfile full path here>

path location: cd $ORACLE_HOME/db/dbs/init<SID>.ora

demo : /oracle/product/11.2.0.4/db/dbs/initDEMO.ora

SQL> startup pfile=’/oracle/product/11.2.0.4/db/dbs/initDEMO.ora’;

then sql>create spfile from pfile;

have a good day.

Advertisements
Standard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s