on 12-22-2011 4:53 PM
Dear All
I am trying to access non SAP oracle database (EMC2 Documentum database) from SAP for which i have done following configuration in SAP
Oracle database TNSNAME entry in non SAP oracle database is
ELRMS.TTP.CO.IN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.XXX.XX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = elrms)
)
)
using above configuration we are able to access the oracle database from different client machines
WE have addedd following entry in SAP TNSNAME.ora file
ELRMS.TTP.CO.IN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.XXX.XX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = elrms)
)
)
We have created db link with name SAP_ELRMS in SAP with following details
connection name :ELRMS
database system: oracle
connection maximum :
connection optimum :
user name :ELRMS
password:
confirm password:
Connection parameters :ELRMS.TTP.CO.IN
TNSNAME :ELRMS.TTP.CO.IN
while testing this linke system is giving following error
-- ERROR Database connection SAP_ELRMS: SQL error 12154 ORA-12154: TNS:could not resolve the connect identifier specified
pls help how to resolve it.
regards
dube
Hi,
Check SAP note 443867 (point no-6)
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shivshankar,
Check the firewall configuration and check whether "tcp.invited_nodes" parameter is exist at the non-sap Oracle, in sqlnet.ora.
Additionally, check whether the the port is available from SAP system by "telnet <non-SAP host> 1521"
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
13 | |
13 | |
11 | |
11 | |
7 | |
5 | |
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.