OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » its the error (oracle10G, widows-xp)

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

its the error [message #318468]

Tue, 06 May 2008 23:32

chand.sarat
Messages: 1
Registered: May 2008
Location: vsp

Junior Member

ORA-00214: control file 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL'

Report message to a moderator

Re: its the error [message #318472 is a reply to message #318468]

Tue, 06 May 2008 23:51

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry about deleting your other thread but please don't 'Report message to a moderator' unless there is something wrong with the contents of the thread.

David

Report message to a moderator

Re: its the error [message #318488 is a reply to message #318468]

Wed, 07 May 2008 00:48

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Have you even tried searching for the error on google? (or even HERE for that matter). Please do so, there are many answers on this out there.

Report message to a moderator

Re: its the error [message #318686 is a reply to message #318468]

Wed, 07 May 2008 10:07

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
ORA-00214: controlfile 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB01\CONTROL02.CTL'
version 1302 inconsistent with file
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB01\CONTROL01.CTL' version 1292


SQL> shutdown abort
ORACLE instance shut down.
SQL> --FIRST DELETE "control01.ctl" and create new one from "control02.ctl"
SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL>

Report message to a moderator

Previous Topic:	About Temporary Tablespace Contents.
Next Topic:	using dbms_metadata

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 02:07:15 CST 2024