OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » LRM-00109

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LRM-00109 [message #260095]

Fri, 17 August 2007 07:22

FILIHARDY
Messages: 15
Registered: August 2007

Junior Member

Hi to all,
I have installed oracle10g-10.2.0 in fedora core 4. The installation was completed successful. And then now when i try to connect the database in sql.. The following error occurs

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

can u pls solve my problem?

Report message to a moderator

Re: LRM-00109 [message #260111 is a reply to message #260095]

Fri, 17 August 2007 08:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Another problem another topic.
Create a new topic in Server Administration forum.

Regards
Michel

Report message to a moderator

Re: LRM-00109 [message #260193 is a reply to message #260095]

Fri, 17 August 2007 12:39

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I bet you have your ORACLE_SID set to "Linuxoracle", doesn't it?
Set it to the real SID.
verify that init<SID>.ora or spfile is there in the above directory.

Regards
Michel

Report message to a moderator

Re: LRM-00109 [message #260351 is a reply to message #260095]

Sat, 18 August 2007 22:30

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I think you have lost your spfile.( Michel already pointed it). So create a pfile and load the database with this pfile i.e invoke it in startup option.

startup pfile='...filename....'

then create spfile from pfile

N.B: Oracle_SID is case sensitive.

Report message to a moderator

Re: LRM-00109 [message #261064 is a reply to message #260351]

Tue, 21 August 2007 12:52

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

@Arju

LRM-00109: could not open parameter file '/home/oracle/oracle/product/10.2.0/db_1/dbs/initLinuxoracle.ora'

OP his lost both files (spfile,pfile)

Now he has two ways to startup his database
1. Go $ORACLE_HOME/ADMIN/PFILE/INIT.ORA ---> if exists then use and startup your database

2. Go $ORACLE_HOME/admin/alert<sid>.log----> copy all init.ora parameters and create new init.ora file and startup your database.

Three files for need to startup database
1. spfile<sid>.ora
2. init<sid>.ora
3. init.ora

Regards
Taj

Report message to a moderator

Re: LRM-00109 [message #261118 is a reply to message #260095]

Tue, 21 August 2007 21:25

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Three files for need to startup database

Is not it will be any one of 1 or 2. i.e either need spfile or pfile, not both are mandatory.

Report message to a moderator

Re: LRM-00109 [message #261187 is a reply to message #261118]

Wed, 22 August 2007 02:07

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Is not it will be any one of 1 or 2. i.e either need spfile or pfile, not both are mandatory.

I want to say ...using one of three files we can start our database.
1.spfile --> if not found or lost
then use
2. pfile ---> if not found or lost
then use
5. pfile(init.ora)

Regards
Taj

Report message to a moderator

Previous Topic:	07_dictionary_accessibility
Next Topic:	Limit session from each clients.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 06:51:34 CST 2024