OraFAQ Forum: Linux » missing INITSID.ORA file

Home » Infrastructure » Linux » missing INITSID.ORA file

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

missing INITSID.ORA file [message #137376]

Thu, 15 September 2005 00:05

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

Report message to a moderator

Re: missing INITSID.ORA file [message #137455 is a reply to message #137376]

Thu, 15 September 2005 05:24

Frank Naude
Messages: 4596
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

Report message to a moderator

Re: missing INITSID.ORA file [message #137503 is a reply to message #137455]

Thu, 15 September 2005 07:14

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

Report message to a moderator

Re: missing INITSID.ORA file [message #137661 is a reply to message #137503]

Fri, 16 September 2005 00:52

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.

Code: [Select all] [Show/ hide]

 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

Report message to a moderator

Re: missing INITSID.ORA file [message #561178 is a reply to message #137661]

Thu, 19 July 2012 05:19

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.

Report message to a moderator

Previous Topic:	Shell script for table purging
Next Topic:	VIPCA failing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 12:06:03 CDT 2025