| 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
|
|
|
|
| Re: missing INITSID.ORA file [message #137455 is a reply to message #137376] |
Thu, 15 September 2005 05:24  |
Frank Naude
Messages: 4587
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 |
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
