ORA-29760: instance_number parameter not specified — without INSTANCE_NUMBER set
July 29th, 2016
No 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