1977120 - No trend metrics are written to audit database and Monitoring Service gives error "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"

• The SAP BI Platform Monitoring application has been configured to use the Oracle Auditing data source (ADS) however, no data is being written to the monitoring (MOT) tables
  
  
• After enabing HIGH tracing for the Adaptive Processing Server (Monitoring Service) the following exception is thrown in the monitoring service GLF trace upon service restart:
  

  EXCEPTION [unknown|unknown|ID:0]com.sap.connectivity.cs.java.ConnectionServer{com.businessobjects.connectionserver.Environment}.CreateJob: [com.sap.connectivity.cs.java.drivers.DBDError: Listener refused the connection with the following error:
  ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  at com.sap.connectivity.cs.java.drivers.DDKExceptionImpl.convertToCSException(DDKExceptionImpl.java:147)
  at com.sap.connectivity.cs.java.JAVAGenericJob.<init>(JAVAGenericJob.java:75)
  at com.sap.connectivity.cs.java.JAVAJob.<init>(JAVAJob.java:32)
  at com.sap.connectivity.cs.java.JAVAOpenJob.<init>(JAVAOpenJob.java:39)

• SAP BusinessObjects Business Intelligence Platform 4.x (BI 4.0 / 4.1 / 4.2)
• Monitoring
• Oracle
• Windows
• Linux / Unix 

MON00009, trending, monitor, diagnostics, history, historical, tns, tnsnames.ora, service, name, client, Oracle11g, Oracle10g , KBA , BI-BIP-MON , BI platform monitoring , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem