Skip to Content
0
Former Member
Aug 24, 2011 at 08:33 AM

DB Link To External Oracle Database

25 Views

Hello everybody,

I'm trying to connect a SAP EHP 1 for SAP NetWeaver 7.0 system, based on Windows NT AMD64 Operating System (Database Oracle 10.2) to an external Oracle DB connected on the same local network.

I did the following steps:

- Added TNSName definition, in TNSName file (path c:/oracle/SR7/102/network/admin/tnsnames.ora )

CE7.WORLD = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = 
        (COMMUNITY = SAP.WORLD)
        (PROTOCOL = TCP)
        (HOST = sykxxxx.xxxx)
        (PORT = 1527)
      )
    )
    (CONNECT_DATA = 
      (SID = ce7)
      (GLOBAL_NAME = CE7.WORLD)
    )
  )

- Added in DBCO transaction:

Connection DB    CE7
DBMS                  ORA
User                    XXX
Password DB                                       /
Info.coll.              CE7.world
Connection Lim.   10
Opt. Connection.  1

With 'TNSPING CE7' command, seem to work fine:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = CE7

.WORLD) (PROTOCOL = TCP) (HOST = sykxxxx.xxxxx) (PORT = 1527))) (CONNE

CT_DATA = (SID = ce7) (GLOBAL_NAME = CE7.WORLD)))

OK (30 msec)

When I'm trying to use this connection, as follow, Sap return SY-SUBRC = 4 and CX_SY_NATIVE_SQL_ERROR exception.

EXEC SQL.
      CONNECT TO 'CE7'
ENDEXEC.

I did some mistake or something is missing?