Friday, March 18, 2011

ORA-00304: requested INSTANCE_NUMBER is busy

OMG...
Its a new database that i want to create and Oracle yells at me stating that INSTANCE_NUMBER is busy?
Oracle Error Code Says:
ORA-00304:
requested INSTANCE_NUMBER is busy
Cause: An instance tried to start by using a value of the initialization parameter INSTANCE_NUMBER that is already in use.
Action: Either a) specify another INSTANCE_NUMBER, b) shut down the running instance with this number c) wait for instance recovery to complete on the instance with this number.

But that is not true in this case. This is neither a RAC to have instance_number parameter assigned nor the database is already running. So, whats going on then...

Found that there are some wrong values for compatible parameter in init.ora file!!! So, do I get the INSTANCE_NUMBER busy error? Wow.... anyways, next time when this shows up, don't panic, just scan thru init.ora to make sure values are correct for compatible, service_names, db_name etc.,

1 comment:

  1. Hi Santosh, thanks for the tip!! ;-) Margaret Lane

    ReplyDelete