Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LRM-00109:could not open parameter file '/u01/app/oracle/product/10.2.0/db

735680Nov 25 2009 — edited Nov 25 2009

hi
i have manually created a database called ora.i have done all the relative tasks.i can open the database by startup nomount pfile.but when i try to create spfile from pfile, it is showing an error that it is already created.when i give the startup command the

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

above error occurs.acutally my pfile is in another location and it is trying to open it from another loc.ihave added the line
export ORACLE_SID=ora in bashrc file.Already there is one database called orcl and it is also been added to the
bashrc file.

Pz solve it for me.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2009

Added on Nov 25 2009

#general-database-discussions

7 comments

3,593 views