Home » RDBMS Server » Server Administration » ora-01078 and ora-00109??
ora-01078 and ora-00109?? [message #181726] Tue, 11 July 2006 05:04 Go to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
hey all,
i just issued a command CREATE SPFILE FROM PFILE;
The command failed. Since then whenever i try to issue the STARTUP Command following error is coming
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE\ORA92\DATABASE\INITORA.ORA'.
What is the solution? kindly reply.
Thanks and Regards
yasir hashmi

Report message to a moderator

Re: ora-01078 and ora-00109?? [message #181747 is a reply to message #181726] Tue, 11 July 2006 06:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How are you starting your database? Have you verified that an SPFILE exists in C:\ORACLE\ORA92\DATABASE ?

Report message to a moderator

Re: ora-01078 and ora-00109?? [message #181748 is a reply to message #181726] Tue, 11 July 2006 07:02 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Do you have a file called C:\ORACLE\ORA92\DATABASE\INITORA.ORA? Also, check the permissions on the file. Oracle (obviously) has a problem reading it.

Report message to a moderator

Re: ora-01078 and ora-00109?? [message #181749 is a reply to message #181726] Tue, 11 July 2006 07:06 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
I checked in the location, it does not have any spfile.
How can it be so? I am using 9i . The OUI creates it during the installation.

Report message to a moderator

Re: ora-01078 and ora-00109?? [message #181760 is a reply to message #181749] Tue, 11 July 2006 08:01 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You mention OUI? Did you create a database at the same time you installed the Oracle software?

Did this database ever start? You mentioned that you received an error when you tried to create an SPFILE. What error did you get? As Frank indicated, do you have an init file anywhere on the server?

Report message to a moderator

Re: ora-01078 and ora-00109?? [message #181809 is a reply to message #181726] Tue, 11 July 2006 12:00 Go to previous message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
When i install the oracle software, in the OUI option under the global database name and sid i gave the name ORA.
after the installation ,the database ora was created and the service was started. I had only the init.ora file in oracle\admin\pfile.
the instance ora was started and i connected as sysdba.
When i issued the command create spfile from pfile, the command failed . Since then when ever i log on it says connected to an idle instance. when i issue startup then those errors.

Report message to a moderator

Previous Topic: Can i update the TABLE_OWNER
Next Topic: physical and logical standby database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:45:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.