Manual Configuration Required for Oracle RAC Monitoring with SERVICE_NAME (4301904)

When attempting to monitor an Oracle RAC database using the installer wizard, the process fails if the RAC nodes are configured to accept only service name connections. The wizard prompts for a SID, which is incompatible with this setup.

By design, the Foglight database agent installer:

• Detects if the target database is a RAC.
• Automatically retrieves a list of RAC instances.
• Assumes connections should be made using SIDs, not service names.
• Does not associate service names with the retrieved instances.

As a result, the agent attempts to connect using SIDs, which fails if the RAC is configured to accept only service name connections.

Workaround 1: Enable SID-Based Connections on the RAC

Modify the listener.ora file on each RAC node:

SID_LIST_{listener_name} =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = {Oracle_Home_Path})
      (SID_NAME = {Instance_Name})
    )
  )

Also, disable the USE_SID_AS_SERVICE_{instancename} setting if present.

Workaround 2: Manually Configure RAC Monitoring with Service Name

1. Create a DB_Oracle_RAC agent (e.g., RAC-{SERVICE_NAME}).
2. Create DB_Oracle_RAC_Instance agents (e.g., HOSTNAME-SID).
3. Configure each RAC Instance agent with:
   • Host
   • Oracle Instance
   • Port
   • Username/Password
   • Host OS Platform
   • Connection Type: SERVICE_NAME
   • Listener Service Name (if required)
4. Update the Agent Configuration for each RAC node Using Script:
   
   

namespace = "DB_Oracle";
agentType = "DB_Oracle_RAC_Instance";
agentId = "{enter your agent ID here}";

primaryAsp = server["ConfigService"].getAgentInstancePrimaryAsp(namespace, agentType, agentId);
parameterName = "monForceSid";
oldValue = primaryAsp.getString(parameterName);
newValue = "0";
primaryAsp.setValueByString(parameterName, newValue);
server["ConfigService"].saveConfig(primaryAsp);

return parameterName + " was changed from [" + oldValue + "] to [" + newValue + "]";

How to Find the Agent ID:

• Go to Administration > Tooling > Script Console
• Select Agent from the dropdown
• Click List Instances
• Find the agent of type DBO_Agent_Model with the RAC node name
• Switch to the Properties tab and copy the Agent ID

Repeat this process for each RAC node.

Activate the RAC agents and verify the connection in the Foglight UI.

• Even when the monForceSid parameter is set to 0, the Foglight installer will continue to enforce SID-based connections for RAC environments. Therefore, agents must be created manually if a SERVICE_NAME connection type is required.
• When agents are manually configured using SERVICE_NAME and monForceSid is set to 0, connection tests from the Databases Global Administration screen will still fail. This behavior is expected and has been confirmed by development. Despite the failed test, data collection may still function correctly.