Home » RDBMS Server » Server Administration » Start up problem in oracle 9i on Windows XP professional 2002
Start up problem in oracle 9i on Windows XP professional 2002 [message #197361] Wed, 11 October 2006 01:28 Go to next message
pardeshi_varsha
Messages: 3
Registered: October 2006
Junior Member
While connecting through User Database I am getting following error.
ORA-01033: ORACLE initialization or shutdown in progress

but I am able to login through sysdba.
After searching a lot related to this error I have tried the following:

SQL> connect sysdba/cglmanager@cglmd_m7 as sysdba
Connected.
SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
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
SQL> alter database mount;

Database altered.

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


I am not able to find out what are the parameters required for alter database open with the given error code.

If any of you are aware of the parameters required for "alter database" command please help.

Thanks in advance.

Regards,
Varsha
Re: Start up problem in oracle 9i on Windows XP professional 2002 [message #197368 is a reply to message #197361] Wed, 11 October 2006 01:41 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []



Above error is generic error.
simple way to fix it "Call Oracle Support"
or
if u able to access "Metalink" then search "err-00600".

And Plz. also tell me what u did before startup ur database bcoz of above err is raised.

and one possible reason for above is "corrupted datafile or block". fix ur corrupted block or if u have bkp and restore or recover database. and open ur database successfully.

Note. : If ur database is production then plz. Call Oracle Or Experienced DBA Support before doing something.
thanx.

[Updated on: Wed, 11 October 2006 01:46]

Report message to a moderator

Re: Start up problem in oracle 9i on Windows XP professional 2002 [message #197385 is a reply to message #197368] Wed, 11 October 2006 02:02 Go to previous messageGo to next message
pardeshi_varsha
Messages: 3
Registered: October 2006
Junior Member
Thanks for your reply.

where can i get Metalink access. I am not aware of it. If you know please tell me how to access it.

Regards,
Varsha
Re: Start up problem in oracle 9i on Windows XP professional 2002 [message #197390 is a reply to message #197385] Wed, 11 October 2006 02:12 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

For Access to Metalink you are member of Metalink.

Oracle Provide Metalink support for every company who purchase Oracle Product.

Re: Start up problem in oracle 9i on Windows XP professional 2002 [message #197402 is a reply to message #197390] Wed, 11 October 2006 02:48 Go to previous messageGo to next message
pardeshi_varsha
Messages: 3
Registered: October 2006
Junior Member
Thanks. I will communicate with oracle people for my problem & metalink login.


Reg.
Varsha
Re: Start up problem in oracle 9i on Windows XP professional 2002 [message #197403 is a reply to message #197402] Wed, 11 October 2006 02:52 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You're Welcome.

Good Luck
Previous Topic: Cannot Cpen Database
Next Topic: tablespace
Goto Forum:
  


Current Time: Mon Dec 05 23:56:23 CST 2016

Total time taken to generate the page: 0.18211 seconds