OraFAQ Forum: Server Administration » ORA-01033: ORACLE initialization or shutdown in progress

Home » RDBMS Server » Server Administration » ORA-01033: ORACLE initialization or shutdown in progress

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

ORA-01033: ORACLE initialization or shutdown in progress [message #52186]

Mon, 08 July 2002 04:14

kshathrya
Messages: 29
Registered: October 2001

Junior Member

Hi,
I am getting this error, when i try logging into the database.
ORA-01033: ORACLE initialization or shutdown in progress.
I guess I tried shutting down the db, when there was a huge transaction pending. I am not concerned of teh transaction now, but need to get my database up and running asap.
My environment: Oracle 9i on Windows 2k Server.

Please help. Very, very Urgent.

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #52188 is a reply to message #52186]

Mon, 08 July 2002 04:20

B
Messages: 327
Registered: August 1999

Senior Member

start svrmgrl
connect internal
shutdown immediate ...
startup

If it fails ..or it's too long
start svrmgrl
connect internal
shutdown abort
startup

Will do automatic recover. Please use the last option if you can do anything else....

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #52190 is a reply to message #52186]

Mon, 08 July 2002 06:14

nagesh d babu
Messages: 7
Registered: October 2001

Junior Member

Hello,

There is no svrmgrl in 9i.

You have to connect sys to down the database.

Process:

At sql prompt

sql>connect sys/password@string as sysdba
sql>shutdown normal or abort

All the best.

Nagesh.

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #52192 is a reply to message #52186]

Mon, 08 July 2002 06:24

nagesh d babu
Messages: 7
Registered: October 2001

Junior Member

Hello,

There is no svrmgrl in 9i.

You have to connect sys to down the database.

Process:

At sql prompt

sql>connect sys/password@string as sysdba
sql>shutdown normal or abort

Shutdown Normal will take a bit time.

All the best.

Nagesh.

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #52241 is a reply to message #52186]

Wed, 10 July 2002 15:32

P
Messages: 29
Registered: May 2002

Junior Member

I gather you did a shutdown immediate?. When you do this you mush rollback all of your uncommited transactions. After running large uncommited jobs this can take hours. You can use a shutdown abort or startup force, though you do increase risk having some problems.

Report message to a moderator

Previous Topic:	Schedule Job not working
Next Topic:	Re: ORA-01033: ORACLE initialization or shutdown in progress

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 21:08:28 CST 2024