SAP Knowledge Base Article - Preview

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"

Symptom

  • 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)


Read more...

Environment

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

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.