RAC Database Not Accurately Reflect Instance_Name Parameter if pfile/spfile have instance_name value set
Last updated on JULY 20, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
If one enters 'show parameter instance_name' on a RAC database, instead of seeing current instance_name (for example: ORCL1), result shows database name (for example: ORCL) from all instances. The instance number is correct, but the instance_name is not. The instance name is correct when queries v$instance.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms