Skip to Content

This is a quick guide how to create a DBCO connection to an External Oracle Database-

First you create the TNSNAMES.ORA entry, in this case i create a new one called TST.WORLD


make sure you can TNSPING TST and its successful (from SIDADM)


Logon to SAP and create the entry in DBCO, for now i called mine just TST

The CONN. INFO must be the name of the new connection I called my TST.WORLD


go to SA38 and run ADBC_TEST_CONNECTION (this is to test the connection)


supply the DB Connectiom name used in DBCO to create the connection (TST)


and the final result connection working


Best Regards


To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Former Member

    This is good information. thank you.

    Where do we need to save the TNSNAMES.ORA in the first place ?

    Does it has to be at the sap side? if yes, what is the location.

      1. Marco Baiocco

        Hello Marco,

        What if the source system where we are creating the DBCON entry is not Oracle?

        In this case, it does not have the /SYS/profile/oracle directory….


Leave a Reply