Skip to Content
avatar image
Former Member

how to connect to external database oracle from sap

Hi gurus,

I need to connect to oracle database which is an external database from sap.

can any one tell the steps for connectivity and for reading the data from the database that resides in the oracle database.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 31, 2007 at 09:36 AM

    Hi Naga,

    First you have to check the sqlnet.ora this file and choose the connection mode in server side .

    And then install an oracle client in your client side , and copy the sqlnet.ora to your oracle directory .

    and now you can access the oracle database via 'SQLPLUS' ..

    hope it useful ...

    But before do this please take care ... i am not recommend you do this for security .

    Best Regards,

    Carlos

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 31, 2007 at 09:42 AM

    sorry Naga,

    i make a mistake ....

    you mean that you want to connect another external ORACLE from SAP via <b>ABAP/4</b> ?

    Add comment
    10|10000 characters needed characters exceeded

    • The file is usually located in the following path on the central instance (CI) box (if your DB server is on a different box than your app server, this is important to note):

      /network/admin

      An example entry (Change to fit your Oracle DB)

      EXAMPLEDB.WORLD =

      (DESCRIPTION =

      (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = exampleoraclehostbox)(PORT = 1525))

      )

      (CONNECT_DATA =

      (SID = EXAMPLEDB)

      )

      )

      *Note, the .WORLD suffix may or may not need to be there based on your configuration.

      You can run ABAP Program in SE38 called 'ADBC_TEST_CONNECTION' to test the connection (it reads from DBCON, so make sure you have that information there as well).

  • avatar image
    Former Member
    Aug 31, 2007 at 12:04 PM

    Perhaps something is wrong with the Oracle Net configuration. For example you need a section with the remote <sid> in tnsnames.ora. Often you can find a more

    precise error in the work process trace file dev_w<wp_number> (e.g. via transaction ST11).

    Add comment
    10|10000 characters needed characters exceeded