Connecting to an External Oracle DB using DBCO

[former_member273752]

Hello All,

We are planning to use ABAP based Native SQL connectivity with an external Oracle DB (within the Organization landscape itself). Our ABAP Application server is based on IBM DB2. We did a quick search in notes to look up the settings that we need to maintain, but there seems to be no comprehensive step-by-step guide which tells about the measures that we must take. True, we found few information that we need installation of Oracle client, we need to maintain DBCON table and so on, but is there an end-to-end guide for this task? Some SAP note, or How-to document? Can someone point us to that direction?

Thanks in advance for your co-operation.

Regards,

Sid

[Reagan]

You need to install Oracle Instant Client and adapt the <SID>adm environment variable. You also need to deploy the DBSL file for the Oracle and restart the system. A general procedure is available in the SAP note 1261329 - DBA Cockpit: Oracle as a remote database

Once you have the system setup as recommended create a connection in DBACOCKPIT and test the connection to see if the system is able to establish the connection.

Cheers

RB

[manumohandas82]

Hi Sid ,

Please take a look at the following OSS Notes

808505 - Secondary connections to Oracle database

339092 - DB MultiConnect with Oracle as secondary database

If you search in SCN you should get multiple documents for the same

Thanks ,

Manu