startup problems Oracle on Windows Server 2003

[Stephen Badgett]

Would someone help on this.

SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00214: controlfile 'C:\PCSI\ORADATA\WRX\CONTROL02.CTL' version 616
inconsistent with file 'C:\PCSI\ORADATA\WRX\CONTROL01.CTL' version 613

[Jon Finley · Accepted solution]

Read Metalink note 1014751.6 ORA-00214: On Startup

Basically, it's the following procedure:

Two of three control files were become bad due to unsual shutdown of the server.
Replace control02 and control03 with control01 at the OS level

summary of the actions:

SQL>startup mount
SQL>show parameter spfile
Used SPFILE
SQL> alter system set control_files='...control02.ctl' scope=spfile
SQL>shutdown immediate
SQL>startup
Database opened.
SQL>shutdown immediate
Replace control01 and control03 with control02 at the OS level
SQL>startup mount
SQL>alter system set control_files='...control01.ctl, ...control02.ctl,...control03.ctl' scope=spfile;
SQL>alter database open
SQL>show parameter control_files


Jon

[Yogeeraj_1]

hi,

to add to the above remark, make sure that you backup your controlfiles as part of your daily backup.

You can also run the following command:

alter database backup controlfile to trace;

each time you make changes to your tablespaces/data files...


kind regards
Yogeeraj

[Frank de Vries]

also beware that you can copy the good controlfile with -p
cp -p CONTROL02.CTL CONTROL01.CTL
to make them consistent again.

Also another remark,
this is for the future, and won't help
you right now, but maybe you can use it.

before you start a backup it
is helpfull to always run the
command
alter database backup controlfile to trace;

this will generate a script in the udump
directory and can be used to re-generate
the controlfiles.

Hopefully you will never need to do that,
but it is alwas handy to have it at hand

regards,

[Stephen Badgett]

I have been following along ....
SQL>startup mount
SQL>show parameter spfile
Used SPFILE
SQL> alter system set control_files='C:\PCSI\ORADATA\WRX\control02.ctl' scope=spfile
SQL>shutdown immediate
SQL>startup

ORA-00600: internal error code, arguments: [3619], [24], [0], [], [], [], []
[]

Is this a problme before I go on

[Stephen Badgett]

sorry this is where I am at ...

SQL> alter system set control_files='C:\PCSI\ORADATA\WRX\control01.ctl, C:\PCSI\
ORADATA\WRX\control02.ctl,C:\PCSI\ORADATA\WRX\control03.ctl' scope=spfile;

System altered.

SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [3619], [24], [0], [], [], [], [],
[]

[Frank de Vries]

That does not look good.

Internal codes 600 are best reported to
Oracle worlwide support.

good luck

[Stephen Badgett]

Thank you all -- a challenge is what I need

[Stephen Badgett]

All worked till the point of the last error -- I knew the information that was provided do what it should have --

Steve

[Hammad Qureshi]

from Hammad Qureshi

check ur paths

1. Shutdown abort â the oracle
2. Find the file initorcl.ora on C drive normally on path C:\oracle\admin\ORACLE\pfile\initOrcl.ora
3. Open the file initOrcl.ora in notepad and find the string
control_files = ("C:\Oracle\oradata\ORACLE\control01.ctl", "C:\Oracle\oradata\ORACLE\control02.ctl", "C:\Oracle\oradata\ORACLE\control03.ctl")
make it
#control_files = ("C:\Oracle\oradata\ORACLE\control01.ctl", "C:\Oracle\oradata\ORACLE\control02.ctl", "C:\Oracle\oradata\ORACLE\control03.ctl")
Note the # mark
Make a copy of the line and chage it to
control_files = ("C:\Oracle\oradata\ORACLE\control01.ctl")
it will seems like

service_names = ORACLE

db_files = 1024

#control_files = ("C:\Oracle\oradata\ORACLE\control01.ctl", "C:\Oracle\oradata\ORACLE\control02.ctl", "C:\Oracle\oradata\ORACLE\control03.ctl")
control_files = ("C:\Oracle\oradata\ORACLE\control01.ctl")
open_cursors = 300
max_enabled_roles = 30

4. Start the database with â startupâ command then â shutdown immediateâ command to close it again
5. Make the copy of files control02.ctl,control03.ctl and delete them
6. Make the 2 copies of control01.ctl at same path and rename the to control02.ctl,control03.ctl
7. Go the initOrcl.ora and remove the # and the line we add means undo the changes.
Again startup the database and we will be back working gain.