Accessing external oracle database from SAP using DB link

[Former Member]

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

[sunny_pahuja2 · Accepted solution]

Hi,

Check SAP note 443867 (point no-6)

Thanks

Sunny

[Former Member]

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