Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » RDBMS Server » Server Administration » its the error (oracle10G, widows-xp)
its the error [message #318468] Tue, 06 May 2008 23:32 Go to next message
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 Go to previous messageGo to next message
djmartin
Messages: 6893
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
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 Go to previous messageGo to next message
pablolee
Messages: 936
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 Go to previous message
Mohammad Taj
Messages: 2197
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:how many instances can be run in one server?
Next Topic:using dbms_metadata
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 00:09:24 CDT 2008

Total time taken to generate the page: 0.17234 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.