on 08-24-2011 9:33 AM
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?
Problem solved by MySelf!
Missing the entry in TNSNames.ora under Sap Profile directory!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.