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'
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: 10180
Registered: March 2005
Location: Canberra ACT 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
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: 2836
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.
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: 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>

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


Current Time: Sat Dec 10 13:10:47 CST 2016

Total time taken to generate the page: 0.08083 seconds