srvctl Returns Wrong Instance Details for RAC One Database (Doc ID 1926877.1)

Last updated on SEPTEMBER 24, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Enterprise Manager for Oracle Database - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

The OEM RACONENODE database status displays one instance as up and the other instances as down for RACONENODE instance after the failover.

Also, "srvctl status database" command with -inner option displays multiple instance names for the RACONENODE database type after the OS reboot.

./srvctl status database -d DB -S 1
#@=result[0]: dbunique_name={DB} inst_name={DB_1} node_name={NODEb} up={true} online_relocation={INACTIVE} source={} destination={} state_details={Open} internal_state={STABLE}
#@=result[1]: dbunique_name={DB} inst_name={DB_2} node_name={NODEa} up={false} online_relocation={INACTIVE} source={} destination={} state_details={} internal_state={}

The "srvctl status database" command used to display only one node before the problem occurred.

./srvctl status database -d DB -S 1
#@=result[0]: dbunique_name={DB} inst_name={DB_1} node_name={NODEb} up={true} online_relocation={INACTIVE} source={} destination={} state_details={Open} internal_state={STABLE}


Changes

The primary RACONENODE instance node was rebooted or it was manually failed over.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms