database stuck up after opening

[satishpc]

hi,

whenever i start my database instance, the alert file shows that the database has been mounted in exclusive mode. it also shows "alter database open". but after that, the oracle instance simply keeps on processing but the the instance does startup completely. while connecting, it shows, "initisaisation or shutdown in progress". this goes on for hours. how can i rectify this ?

satish

[reydp]

Can you shutdown your db with normal/immediate option?

If not, shutdown with abort option then try
startup mount
recover database;

If there is a media failure recovered:
alter database open noresetlogs; /*or resetlogs*/

otherwise
alter database open;

But as usual make a backup first, before anything else.

If you can post more details of your problem like after an instance started
is your database mounted, and opened normally, error codes, specs of your db and platform, etc. Then this will give more info to troubleshoot your problem.

[vinit]

What oracle ./OS version r u running. Check out your alert log and related trace files and post them here.

Cheers