Home » RDBMS Server » Server Utilities » LRM-00109: Urgent. Pl help
LRM-00109: Urgent. Pl help [message #74737] Thu, 10 February 2005 11:31 Go to next message
Sarah
Messages: 15
Registered: June 1999
Junior Member
After a routine bounce, I failed to bringup the db. No changed were done in the db before the bounce. Pl help.

SQL>
SQL> startup pfile=/export/home/orale/mydb/pfile/iinit.ora
LRM-00109: could not open parameter file '/export/home/orale/mydb/pfile/init.ora'
ORA-01078: failure in processing system parameters
SQL>

My envoronment is: Sun solaris 64 bit Oracle 9.2.0.5

regards,
Sarah

Report message to a moderator

Re: LRM-00109: Urgent. Pl help [message #74738 is a reply to message #74737] Thu, 10 February 2005 13:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The error message clearly says, oracle is unable to find init< sid >.ora

>>SQL> startup pfile=/export/home/orale/mydb/pfile/iinit.ora

Unless orale is the real directory structure, your issue is just a typo.

Report message to a moderator

Re: LRM-00109: Urgent. Pl help [message #74739 is a reply to message #74738] Thu, 10 February 2005 13:56 Go to previous messageGo to next message
Sarah
Messages: 15
Registered: June 1999
Junior Member
Hi.

That was a typo in the forum only, But actually the line is as follows:

startup pfile=/export/home/oracle/mydb/pfile/iinit.ora

Pl suggest.

regards,
Sarah

Report message to a moderator

Re: LRM-00109: Urgent. Pl help [message #74740 is a reply to message #74739] Thu, 10 February 2005 16:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it is the same reply as before.
oracle is not finding the file in that directory.
Please make sure that there is a so called file.
in 9i by default only spfile is used.
and by default pfile should be in location $ORACLE_HOME/dbs.

try the default option using spfile

sql> startup

Report message to a moderator

Re: LRM-00109: Urgent. Pl help [message #74741 is a reply to message #74740] Thu, 10 February 2005 19:02 Go to previous message
Sarah
Messages: 15
Registered: June 1999
Junior Member
Thank you very much Mahesh, It worked.

Much appreciated,

Sarah

Report message to a moderator

Previous Topic: IMPORT-DESIGNER 2000
Next Topic: while loading data using SQL*Loader--error--ORA-01722: invalid number
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 18:49:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.