topic Re: startup problems Oracle on Windows Server 2003 in Windows Server 2003

startup problems Oracle on Windows Server 2003

Stephen Badgett — Thu, 15 Dec 2005 16:56:52 GMT

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

Re: startup problems Oracle on Windows Server 2003

Jon Finley — Thu, 15 Dec 2005 18:39:40 GMT

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

Re: startup problems Oracle on Windows Server 2003

Yogeeraj_1 — Fri, 16 Dec 2005 00:05:10 GMT

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

Re: startup problems Oracle on Windows Server 2003

Frank de Vries — Fri, 16 Dec 2005 03:21:35 GMT

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,

Re: startup problems Oracle on Windows Server 2003

Stephen Badgett — Fri, 16 Dec 2005 14:32:18 GMT

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

Re: startup problems Oracle on Windows Server 2003

Stephen Badgett — Fri, 16 Dec 2005 15:33:55 GMT

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], [], [], [], [],
[]

Re: startup problems Oracle on Windows Server 2003

Frank de Vries — Tue, 20 Dec 2005 09:48:42 GMT

That does not look good.

Internal codes 600 are best reported to
Oracle worlwide support.

good luck

Re: startup problems Oracle on Windows Server 2003

Stephen Badgett — Thu, 22 Dec 2005 14:54:42 GMT

Thank you all -- a challenge is what I need

Re: startup problems Oracle on Windows Server 2003

Stephen Badgett — Thu, 22 Dec 2005 14:57:35 GMT

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

Steve

Re: startup problems Oracle on Windows Server 2003

Hammad Qureshi — Thu, 05 Jan 2006 04:44:58 GMT

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.