Oracle Connection from ABAP Program

[Former Member]

Hello everybody,

I need to connect to an external database in another server from ABAP Program, now I've reading some Blogs and Thread about it but I'm really lost in wich are the actual steps to do this, I've read about a "tnsnames.ora" file, but I have the next doubts:

- This tns file exists in the sap server where is running the ABAP Program or in the Oracle database server or in both??

- Wich should be an example or what it needs to be written in the CON_ENV field of the DBCON table entrie.

- The CON_NAME can be any name or it should have relation to the database name or something like that?

I would really appreciate any kind of help cause I've never done this before with any external database so I don't know the steps to do this, I'm clear on the ABAP Code to connect but I'm lost in the DBCON entrie and any other steps necessary for this, I'm actually reading SAP Notes but they're very confuse about this, thanks in advance for your help.

Regards,

Paul

[former_member222860]

Hey,

Here goes some answers:

1. TNS file can be found at Oracle database, here's is ex. path

C:\oracle\ora81\network\ADMIN

2. Regarding DBCON entry, look at this help link

http://help.sap.com/saphelp_nw70/helpdata/en/9c/d736b880c34f76b507bac7751a0474/content.htm

thanks\

Mahesh

[Former Member]

Thanks for your answer, I've read the help you gave me, now the system where is my ABAP Code is a IBM Database, and the DB I'm trying to connect to is a Oracle Database, now the TNS name should be in the TNS File in the Oracle System?, and how is that going to help me in the DBCON table???, maybe I'm approaching this incorrectly, do you think????

Regards,

Paul

[Former Member]

Did you gone through these below Web Blogs?

[Using ABAP to access non-SAP databases|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11543] [original link is broken] [original link is broken] [original link is broken];

[Suck that data out ! Connect from Oracle to MaxDB|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/6225] [original link is broken] [original link is broken] [original link is broken];

[Configure DBCO (Database Multiconnect) on IBM i5/iSeries|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4198] [original link is broken] [original link is broken] [original link is broken];