Hi,
Oracle Version : 10.2.0.3
Operating system: Linux
we are unable to connect to the database through any of the client and we decide to shut down the database but it is unable to shut down the database since 30min the shut immediate statement hangs when i try to connect to another session and it is showing the status of the database as open and when i am trying to shut down the database from that session it is showing the message like this
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> shut immediate
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file
Linux Error: 11: Resource temporarily unavailable
Additional information: 9127
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL>
and mmnl trace file was generated in bdump location when we got this problem
Please help me out to solve this problem
Thanks & Regards,
Poorna Prasad.