SAP Knowledge Base Article - Preview

2638642 - BI CMS will not start with error ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

Symptom

  • SAP BI Central Management Server will not start
  • Attempt to start SIA and Central Management Server using ./startservers (UNIX) or Central Configuration Manager (Windows), Notice that the Central Management Server does not initialize or remain started.
  • Examining the CMS trace logs (cms_PROD.CentralManagementServer_trace.000001.glf and error_boe_cmsd6400.log) we can see the following error:

    siserver.cpp:970:-: TraceLog message 47
    |2898a048-6a6d-3047-9ce9-4ea22e8ff3c3|2018 05 01 13:38:59:401|-0400|Information| |==| | |cms_PROD.CentralManagementServer|25100750| 1|| ||||||||||||||||||||||SIServerController:run: Fail to initialize or uninitialize. Reason is The root server reported an error Initialization Failure. (Reason: SAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database ""ABC"". Reason: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
    SAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database ""ABC"". Reason: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
    CDatabase::Open failure.
    ).:SAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database ""ABC"". Reason: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
    CDatabase::Open failure.

  • TNSPing responds back with a valid test of the TNS entry resolved by LDAP - this was successful - 10 milliseconds.
  • SQLPlus (Using the syntax: sqlplus schema_name@OracleSID) fails with the error:

    ORA-12505:  TNS:listener does not currently know of SID given in connect descriptor

Read more...

Environment

SAP BusinessObjects Business Intelligence Platform 4.x (BI 4.x)

Product

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

Keywords

boe_cmsd, cms.exe, startup, fail, boe, bobj, bi, 40, 41, 42, 4.1, 4.2, 4.0, tns, ora, tnslistener, listener, 12505, , KBA , 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.