Unable to connect to Oracle Event Source when connecting to an Oracle RAC

Document ID:7015967
Creation Date:09-Dec-2014
Modified Date:10-Dec-2014
- Micro Focus Products:
  Sentinel

Environment

NetIQ Sentinel 7.0 Sentinel Server

Situation

When trying to connect to an Oracle event source hosted on Oracle 11gR2 RAC database, the following error is returned:

"Error message from database: Listener refused the connection with the following error: 
 ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"

If the event source is configured to connect to a specific node, the connection is successful.

Resolution

In Sentinel ESM while adding eventsource

1. Select Database Type as 'Custom' Connection     a. Custom JDBC URL : make an entry as follows: (replacing the respective hostnames, ports, nd SERVICE_NAME values for your setup)

b. jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)
                    (ADDRESS=(PROTOCOL=TCP)(HOST=hostname_node1)(PORT=1521)) 
                    (ADDRESS=(PROTOCOL=TCP)(HOST=hostname_node2)(PORT=1521)))
                    (CONNECT_DATA=(SERVICE_NAME=service_name)(SERVER=DEDICATED)))

2. Enter the value ('1970-01-01 00:00:00') manually at the 'Specify offset' option.

Cause

The default connection string for the Oracle Event Source is for a single node. A custom string is required for connecting to the RAC.