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
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
Marius
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.
Hi Ramesh,
In application server site put the information in the following path:
/usr/sap/<SID>/SYS/profile/oracle
Best regards
Marco
Thank you much. I am able to connect now.
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....
Hello Ramesh,
What is the Username and Password used to make this connection a success?
https://help.sap.com/saphelp_nw74/helpdata/en/88/134e70f61f48d0a2c4af3a6d484eab/frameset.htm refer to this