NetIQ Sentinel 7.0 Sentinel Server
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.
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)
2. Enter the value ('1970-01-01 00:00:00') manually at the 'Specify offset' option.
The default connection string for the Oracle Event Source is for a single node. A custom string is required for connecting to the RAC.