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

1.JPG

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

2.JPG

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

3.JPG

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

4.JPG

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

5.JPG

and the final result connection working

6.JPG

Best Regards

Marius

To report this post you need to login first.

5 Comments

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

  1. Ramesh Putta

    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.

    (0) 
      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….

        (0) 

Leave a Reply