Oracle probe metrics populating with concatenated or incorrect device names
Article ID: 434840
Updated On:
Products
Issue/Introduction
When the oracle probe is configured using an Oracle Service Name that contains multiple hosts (e.g., for failover or RAC in tnsnames.ora), the probe may populate the device name in UIM by concatenating the primary and backup server strings into a single, incorrect string. Please note that in this specific configuration, the probe is not configured with the 'Is RAC' option enabled.
Environment
Any oracle probe version
Resolution
To resolve this behavior and ensure checkpoints and metrics are correctly collected under the proper device name, modify the connection configuration to use a specific server connection string instead of a service name.
1. Open the oracle probe configuration.
2. Locate the connection profile for the affected database.
3. Update the Service name field from a Service Name to a full TNS description string
Example:
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = [primary_host])(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = [service_name])))
4. Restart the oracle probe to apply changes.
Additional Information
Feedback
