Home » Infrastructure » Linux » missing INITSID.ORA file
missing INITSID.ORA file [message #137376] Thu, 15 September 2005 00:05 Go to next message
nookersatya
Messages: 7
Registered: September 2005
Junior Member
hello,
After installing oracle 9i in linux, i found that INITSID.ORA file. so can anyone suggest me why it is happened and wat could be the solution.
Actaully in this file the CONTROL_FILES parameter specify where the control files are, So this was needed at the time of database mount.
thanks in advance
satya
Re: missing INITSID.ORA file [message #137455 is a reply to message #137376] Thu, 15 September 2005 05:24 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
I don't understand what you are asking. Have you installed 9i to an existing Oracle home directory and now some file that was there previously is missing?

As far as I know this can only happen if you've uninstalled stuff from that Oracle Home, or if somebody deleted it.

Best regards.

Frank
Re: missing INITSID.ORA file [message #137503 is a reply to message #137455] Thu, 15 September 2005 07:14 Go to previous messageGo to next message
nookersatya
Messages: 7
Registered: September 2005
Junior Member
hello,
actually we installed the oracle9i for the first
time, and after the istallation we tried to mount the
database and got the error msg

alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying controlfile, check
alert log for more info

so while searching for the solution at
http://www.orafaq.com/wiki/ORA-00205

we found that there should be a INITSID.ora to specify
control file parameter, but unfortunately we did'nt
find that file, is that we made any wrong in the
installation process.
is there any solution or do we need to re-install the
oracle again
thanks in advance
satya
Re: missing INITSID.ORA file [message #137661 is a reply to message #137503] Fri, 16 September 2005 00:52 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

The error is there because Oracle is unable to identify the location of controlfile.

generally pfile is present in two locations.

>> $ORACLE_BASE/admin/$ORACLE_SID/pfile folder

or

>> $ORACLE_HOME/dbs folder

u can search file at these locations & if it is not there.

even then 9i provides u the concept of spfile.
 SQL> startup nomount;

 SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      %ORACLE_HOME%\DATABASE\SPFILE%
                                                 ORACLE_SID%.ORA


The above result on my machine shows that Oracle is using spfile instead of pfile so u can modify spfile accordingly and mount ur database provided u know the location of control files.

SQL> Alter system set control_files='Path/control1.ctl, path/control2.ctl';

and the mount the database.

regards,
tarun
Re: missing INITSID.ORA file [message #561178 is a reply to message #137661] Thu, 19 July 2012 05:19 Go to previous message
valiantvimal
Messages: 2
Registered: March 2012
Junior Member
Thanks Tarun. I am under the same situation and your answer solved my issue. Thanks mate.

Regards,
Vimal.
Previous Topic: Shell script for table purging
Next Topic: VIPCA failing
Goto Forum:
  


Current Time: Fri Mar 29 09:18:58 CDT 2024