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?