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

  • 7015967
  • 09-Dec-2014
  • 10-Dec-2014


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.