ORA-00304: requested INSTANCE_NUMBER is busy
On starting upon instance in 2 Node RAC Database,We got the below error message.
SQL> startup;
ORA-00304: requested INSTANCE_NUMBER is busy
We have identified the background sessions are still hanging at the OS level.
Solution:
Solution is to Kill the hanging sessions at the os level and restart the instance.
ps -ef | grep -i DATABASE_SID
kill -9 pid1 pid2
after killing the hanging session , we are able to startup the instance without any issues.
On starting upon instance in 2 Node RAC Database,We got the below error message.
SQL> startup;
ORA-00304: requested INSTANCE_NUMBER is busy
We have identified the background sessions are still hanging at the OS level.
Solution:
Solution is to Kill the hanging sessions at the os level and restart the instance.
ps -ef | grep -i DATABASE_SID
kill -9 pid1 pid2
after killing the hanging session , we are able to startup the instance without any issues.