2127285 - Troubleshooting Oracle connectivity issues in Information Design Tool *** Master KBA *** | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2127285 - Troubleshooting Oracle connectivity issues in Information Design Tool *** Master KBA ***

Symptom

When connecting to an Oracle database in IDT, there are many connectivity issues that can be encountered. 

Examples:

    • No driver is shown (Empty list)
    • No Oracle <version> exist under Oracle category
    • Oracle <version> exists under Oracle category but only JDBC Drivers is available
    • Oracle <version> exists under Oracle category but only Oracle Client drivers is not available (JDBC and ODBC is available)
    • DBDriver failed to load : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib32\dbd_oci.dll (Library does not exist)
    • DBDriver failed to load : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib32\dbd_oci.dll (The specified module could not be found.)
    • Unexpected behavior when selecting Oracle Client driver
    • Error "ORA-12154: TNS:could not resolve the connect identifier specified" when testing connection
    • Error "ORA-12170: TNS:Connect timeout occurred" when testing connection

Note: To connect to the Oracle database from IDT, both the data access driver (provided by BI product) and the database middleware (provided by database vendor) are required

Current best practice is to use the cscheck command under <BI client tools install directory>\win32_x86\ to troubshoot Oracle connectivity issues (for 32-bit only)


Read more...

Environment

  • SAP BusinessObjects Enterprise BI 4.x
  • Information Design Tool (IDT)
  • Oracle

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

IDT, "Oracle Client", OCI, "Library does not exist", "The specified module could not be found", dbd_oci.dll, ORA-12154, ORA-12170, "Unexpected behavior", cscheck , biSL , KBA , BI-BIP-IDT , Information design tool , BI-BIP-SL , Semantic Layer , How To

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.