Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01033: ORACLE intialization or shutdown in progress
ORA-01033: ORACLE intialization or shutdown in progress [message #224848] Thu, 15 March 2007 13:14 Go to next message
sivaram_g
Messages: 3
Registered: March 2007
Location: Bangalore
Junior Member
Hi friends,
i am using oracle 9i, i am connect to database using scott/tiger.

error is: ORA-01033: ORACLE intialization or shutdown in progress

plz help me.....
Re: ORA-01033: ORACLE intialization or shutdown in progress [message #224850 is a reply to message #224848] Thu, 15 March 2007 13:43 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Although recommended action is to wait a few minutes and try again (because Oracle needs some time to start up to be available or, on the other hand, refuses new connection when shutting down), perhaps you'll have to take another step. If this is a standalone PC (I mean, it is your computer and you are trying to connect to the database which is installed on it), the simplest way would be rebooting. This doesn't require restarting services, this_and_that. Simply reboot, wait for a while and - when hard disk LED shows no disk activity, try to connect to Scott's schema again.

If it doesn't help, well, we'll see what next.
Re: ORA-01033: ORACLE intialization or shutdown in progress [message #224854 is a reply to message #224848] Thu, 15 March 2007 14:02 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>error is: ORA-01033: ORACLE intialization or shutdown in progress
SQL> SHUTDOWN ABORT
SQL> STARTUP
Re: ORA-01033: ORACLE intialization or shutdown in progress [message #227183 is a reply to message #224848] Tue, 27 March 2007 08:27 Go to previous messageGo to next message
seraphstream
Messages: 8
Registered: March 2007
Junior Member
First:
- stop all oracle service
- start all oracle service

then try to connect as system/xxx or sys/xxx@sysdba

check user scott

bye


All Oracle Errors Messages


Oracle Forum
Re: ORA-01033: ORACLE intialization or shutdown in progress [message #227185 is a reply to message #227183] Tue, 27 March 2007 08:28 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why are you answering all sorts of questions that already have sufficient answers?

If you want to promote your forum, do it in the open and not by spamming this forum please.

[Updated on: Tue, 27 March 2007 08:30]

Report message to a moderator

Re: ORA-01033: ORACLE intialization or shutdown in progress [message #227192 is a reply to message #227185] Tue, 27 March 2007 08:43 Go to previous message
seraphstream
Messages: 8
Registered: March 2007
Junior Member
You have rights.
Previous Topic: Need logic of the procedure
Next Topic: Script prob after changing from Oracle 9i to 10g R2 ORA-02021 ORA-30041
Goto Forum:
  


Current Time: Sun Dec 11 04:20:25 CST 2016

Total time taken to generate the page: 0.13052 seconds