I have shutdown (Immediate) the oracle instance

It gived me error:
01089: Immediate shutdown in progress ---no operations are permitted

Oracle ver 8.1.7


WHat could be the reason???

Thanks
Reema

What is in your <SID>alrt.log? Whenever you do a shutdown it will put entries in this file.

Here is the entry in alert_<SID>.log file

Shutting down instance (immediate)
License high water mark = 37
Tue Oct 14 08:27:48 2003
ALTER DATABASE CLOSE NORMAL
Tue Oct 14 08:27:48 2003
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Oct 14 08:27:49 2003
Thread 1 closed at log sequence 19709
Tue Oct 14 08:27:49 2003
Completed: ALTER DATABASE CLOSE NORMAL

It looks like the database is waiting for a transaction to complete.

This might be the Bug in Oracle 8.1.7 where an additional archive
process gets created. Oracle waits until this process completes
prior to shutting down...

Shutdown abort (from another session) will get you down.
you might try this prior to shutdown as documented in Metalink

ALTER SYSTEM SET log_archive_max_processes=10;
alter system archive log stop;
ALTER SYSTEM SET log_archive_max_processes=1;
alter system archive log start;

HTH
Gregg

Gregg,

Thanks for your response

Where do I run these commands from
It is not letting me login

Reema

You need to start another svrmgrl session or sqlplus session

svrmgrl> set instance xxx (xxx is the service name)
svrmgrl> connect internal/password@xxx
svrmgrl> shutdown abort

next time try the above mentioned for archive processes...

Thanks for your reply.

I will try it next time

Reema