Main menu

Post navigation

Connecting SAP on Microsoft SQL to an External Oracle Database Server

During a recent bit of consulting I was asked to connect SAP to various External Databases. SAP impressed me with its Multi-Connect feature and I thought it worthy of a couple of quick videos.

If you’re already running SAP on Oracle then you can skip to Step 5

Step 1: Download the database library. Under Kernel Patches and make sure you select the database version you want to connect to in this example Oracle.
Step 2: Unpack and copy the library itself dboraslib.dll to your application instances kernel folders. In the video I leveraged the instance.lst file to get SAP to do this for me as part of the SAP startup sapcpe process.

Step 3: Download and unpack the Oracle Client Tools

Step 4: Install the Client Tools. Select Runtime or Administrator
(InstantClient on its own is not enough)

Step 5: Configure Oracle Net Manager to point to our External Oracle ServerAs the client tools are installed its very simple to test the connection using tnsping

Step 6: In SAP transaction SM30 table maintenance for DBCON. Add the connection using the connection name we just created in Oracle Net Manager.

Thanks Matt,
We have already connected to external SQL Server using DBCON. However, we were looking for connecting to external Oracle Database through our SAP which is on SQL.
Your document proved to be a exact guide to us.
Thanks again.
Regards,
Firoz.

Thanks Matt,
We have already connected to external SQL Server using DBCON. However, we were looking for connecting to external Oracle Database through our SAP which is on SQL.
Your document proved to be an exact guide to us.
Thanks again.
Regards,
Firoz.