Home > Oracle in general > ORA-29760: instance_number parameter not specified — without INSTANCE_NUMBER set

ORA-29760: instance_number parameter not specified — without INSTANCE_NUMBER set

July 29th, 2016 Leave a comment Go to comments

Oracle is complaining about:

ORA-29760: instance_number parameter not specified

And you have triple checked that the INSTANCE_NUMBER parameter is specified, but you still get the error.

The reason for that is, that your ORACLE_SID contains a underscore, e.g. ORA_SB. Starting with Oracle 12c the *underscore* parameter is a reserved character to indicate a server pool in a RAC.
Blase do not use the underscore parameter in the SID and the problem is gone.

Categories: Oracle in general Tags:
  1. No comments yet.
  1. No trackbacks yet.