Accessing external oracle database from SAP using DB link

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