Oracle Error ORA-00304: requested INSTANCE_NUMBER is busy

Oracle 339 Views 0 Min Read

Oracle Error Message

ORA-00304: requested INSTANCE_NUMBER is busy

Reason for the Error

You attempted to start an Oracle instance with an already-used INSTANCE NUMBER parameter value.

Solution

There are 2 ways to fix this Oracle Error.

  • To use a different number, change the INSTANCE NUMBER initialization parameter in the initialization file. Then, restart the instance.
  • Wait for that instance number’s recovery to complete.