Home » RDBMS Server » Server Administration » err01033:oracle initialization or shutdown in progress (linux(fedora))
err01033:oracle initialization or shutdown in progress [message #527797] Thu, 20 October 2011 04:13 Go to next message
prabhakar445
Messages: 5
Registered: October 2011
Location: bangalore
Junior Member
hi,
i am using fedora in that i had installed oracle 10g express edition and from last few days i used it successfully from morning
am facing problem to login in to database.and when am connecting sql*plus to database after entering username and password am getting this below
error err01033:oracle initialization or shutdown in progress

can you help me any one how to resolve this error





thanks
prabhakar
Email:prabhakar445@gmail.com
Re: err01033:oracle initialization or shutdown in progress [message #527800 is a reply to message #527797] Thu, 20 October 2011 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 59968
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Check alert.log file to know if there was any problem.
2/ Connect as sysdba and shut down and restart the database.

Regards
Michel
Re: err01033:oracle initialization or shutdown in progress [message #527804 is a reply to message #527800] Thu, 20 October 2011 04:28 Go to previous messageGo to next message
prabhakar445
Messages: 5
Registered: October 2011
Location: bangalore
Junior Member
hi Michel Cadot,
if i connect to / sys dba what should be the password given to the sys dba and how to check alert.log files





thanks
prabhakar
Re: err01033:oracle initialization or shutdown in progress [message #527805 is a reply to message #527804] Thu, 20 October 2011 04:37 Go to previous message
Michel Cadot
Messages: 59968
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"alert.log" is in the directory pointed by "background_dump_dest" parameter.
If you don't know there use "find / -name 'alert*log' -ls".

If you are OS connected with an account that is in the dba group you don't need any password to connect as sysdba, just use "/ as sysdba"

Regards
Michel
Previous Topic: sys to see alert log....
Next Topic: enable/ disable row movement
Goto Forum:
  


Current Time: Wed Dec 17 14:19:38 CST 2014

Total time taken to generate the page: 0.10649 seconds