| ora-00205: error in identifying control files [message #61194] |
Mon, 05 April 2004 02:06  |
Bharath Kumar ,V
Messages: 18
Registered: February 2004
|
Junior Member |
|
|
I've some problem to startup my oracle database 9iR2 in SuSE Linux 8.0
I had done the following :
oracle@Test01:~> sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Apr 5 20:23:20 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 42741800 bytes
Fixed Size 450600 bytes
Variable Size 41943040 bytes
Database Buffers 204800 bytes
Redo Buffers 143360 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
After that I've shutdown the oracle instance,
Then I try
SQL> startup nomount pfile=/opt/oracle/product/9ir2/dbs/init.ora
ORACLE instance started.
Total System Global Area 42741800 bytes
Fixed Size 450600 bytes
Variable Size 41943040 bytes
Database Buffers 204800 bytes
Redo Buffers 143360 bytes
SQL>
How do I excute the CREATE CONTROLFILE command?
|
|
|
|
|
|
| Re: ora-00205: error in identifying control files [message #61197 is a reply to message #61194] |
Mon, 05 April 2004 02:45  |
sanu
Messages: 6
Registered: April 2004
|
Junior Member |
|
|
sorry I did not read your mail fully. As said earlier if you have a daily copy then do restore that. Try to keep a multiple copy of controlfile in different directory.
If you do not have the controlfile script try the command 'ALTER DATABASE backup controlfile to trace'. A trace file will be created in a background destination. Modify as per your need (but be very careful with options like RESETLOGS/NORESETLOGS/ARCHIVELOGS/NOARCHIVELOGS/USE/RESUE mentioned in the create controlfile command) and then run the script on the sql prompt.
If you have a script to create a controlfile then run the script on sql prompt in nomount state.
Once the file should is created then do 'alter database open' to open the database it.
|
|
|
|
| Re: ora-00205: error in identifying control files [message #61198 is a reply to message #61195] |
Mon, 05 April 2004 02:46 |
Bharath Kumar ,V
Messages: 18
Registered: February 2004
|
Junior Member |
|
|
Thank you very much,
Now its working properly.
My ORACLE_SID was set wrongly.
--
And I've one more problem in different PC.
I've one IDE HDD (Not a RAID box),with Oracle 9iR2 (SuSE Linux 8.0).
and I've the following partitions
/
/boot
/usr
/opt
/var
I've installed Oracle in /opt partitions , this partitions has been fulled, so that I'm not able to start the Oracle server.
Could you please help me out regarding this issue.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
