OraFAQ Forum: Server Administration » Start up problem in oracle 9i on Windows XP professional 2002

Home » RDBMS Server » Server Administration » Start up problem in oracle 9i on Windows XP professional 2002

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Start up problem in oracle 9i on Windows XP professional 2002 [message #197361]

Wed, 11 October 2006 01:28

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

Report message to a moderator

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

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

pardeshi_varsha
Messages: 3
Registered: October 2006

Junior Member

Thanks. I will communicate with oracle people for my problem & metalink login.

Reg.
Varsha

Report message to a moderator

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

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

You're Welcome.

Good Luck

Report message to a moderator

Previous Topic:	Cannot Cpen Database
Next Topic:	tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:41:01 CDT 2024