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: 15
Registered: July 2013
Location: Hyderabad
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

Report message to a moderator

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: 8499
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.

Report message to a moderator

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.

Report message to a moderator

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: 67745
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

Report message to a moderator

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 ..........

Report message to a moderator

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: 67745
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 27 16:29:43 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.