Home » RDBMS Server » Server Administration » LRM-00109
LRM-00109 [message #260095] Fri, 17 August 2007 07:22 Go to next message
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?
Re: LRM-00109 [message #260111 is a reply to message #260095] Fri, 17 August 2007 08:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Another problem another topic.
Create a new topic in Server Administration forum.

Regards
Michel
Re: LRM-00109 [message #260193 is a reply to message #260095] Fri, 17 August 2007 12:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64144
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: LRM-00109 [message #260351 is a reply to message #260095] Sat, 18 August 2007 22:30 Go to previous messageGo to next message
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.

Re: LRM-00109 [message #261064 is a reply to message #260351] Tue, 21 August 2007 12:52 Go to previous messageGo to next message
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
Re: LRM-00109 [message #261118 is a reply to message #260095] Tue, 21 August 2007 21:25 Go to previous messageGo to next message
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.

Re: LRM-00109 [message #261187 is a reply to message #261118] Wed, 22 August 2007 02:07 Go to previous message
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
Previous Topic: 07_dictionary_accessibility
Next Topic: Limit session from each clients.
Goto Forum:
  


Current Time: Fri Dec 09 11:28:54 CST 2016

Total time taken to generate the page: 0.08963 seconds