Home » RDBMS Server » Server Administration » error in identifying control file, check alert log for more info (database 10g windows 7)
error in identifying control file, check alert log for more info [message #594150] Sat, 24 August 2013 01:02 Go to next message
oracle2013
Messages: 4
Registered: July 2013
Location: hyd
Junior Member
Hi,
I am creating a database manually,
I am hitting with the following error :

SQL> startup
ORACLE instance started.

Total System Global Area 587202560 bytes
Fixed Size 1220724 bytes
Variable Size 192941964 bytes
Database Buffers 390070272 bytes
Redo Buffers 2969600 bytes
ORA-00205: error in identifying control file, check alert log for more info



thanks &regards
Re: error in identifying control file, check alert log for more info [message #594151 is a reply to message #594150] Sat, 24 August 2013 01:06 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
This is the expected situation, if you have not yet created the database. You now need to create it. One command of just two words will do:

CREATE DATABASE;

run that now.
Re: error in identifying control file, check alert log for more info [message #594193 is a reply to message #594151] Sun, 25 August 2013 21:35 Go to previous messageGo to next message
oracle_awen
Messages: 5
Registered: July 2012
Location: china
Junior Member

post your alert logs,i guess one of your control file has been corrupted,if that you can copy file from another and rename.
Re: error in identifying control file, check alert log for more info [message #594200 is a reply to message #594193] Mon, 26 August 2013 00:20 Go to previous messageGo to next message
Michel Cadot
Messages: 57650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Wrong guess.
Read the clue "I am creating a database manually".
So there is no database, no control file.

Regards
Michel
Re: error in identifying control file, check alert log for more info [message #594201 is a reply to message #594200] Mon, 26 August 2013 00:23 Go to previous messageGo to next message
oracle_awen
Messages: 5
Registered: July 2012
Location: china
Junior Member

so that:
export ORACLE_SID=
sqlplus / as sysdba
startup nomount ;
create database ..........
Re: error in identifying control file, check alert log for more info [message #594203 is a reply to message #594201] Mon, 26 August 2013 01:19 Go to previous message
Michel Cadot
Messages: 57650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No "export" in Windows.
Please CAREFULLY read the posts.
Anyway, John already gave the solution.

Regards
Michel
Previous Topic: Unable to create database
Next Topic: Upgrading the database to 11g from oracle 8i
Goto Forum:
  


Current Time: Thu Apr 24 20:29:08 CDT 2014

Total time taken to generate the page: 0.13037 seconds