Skip to Content
Author's profile photo Marius Burger

Creating DBCO connections

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

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      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.

      Author's profile photo MARCO RONCOLONI
      MARCO RONCOLONI

      Hi Ramesh,


      In application server site put the information in the following path:


      /usr/sap/<SID>/SYS/profile/oracle

      Best regards


      Marco

      Author's profile photo Former Member
      Former Member

      Thank you much. I am able to connect now.

      Author's profile photo Marco Baiocco
      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....

      Author's profile photo Former Member
      Former Member

      Hello Ramesh,

      What is the Username and Password used to make this connection a success?

      Author's profile photo Zia Nauman
      Zia Nauman

      https://help.sap.com/saphelp_nw74/helpdata/en/88/134e70f61f48d0a2c4af3a6d484eab/frameset.htm  refer to this