Connecting to SAP Oracle DB from External Oracle system

[Former Member]

Dear DB Gurus

I have to connect the Oracle server on my desktop system to the Oracle Database of my SAP DEV System. Both the Oracle versions are Oracle 9i. However hard I try, I end up with either Oracle error ORA 12541 - No Listener or ORA 12154 : TNS could not resolve service name. I have checked and listener is running on both the servers. Even have started it through lsnrctl start.

For reference, I am enclosing the respective file entries of bbot my server & SAP server.

tnsnames.ora file at my server

DEV.PIIL.COM =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.XXX.X.XX)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = DEV.WORLD)

)

)

I presume that there might a problem with the domain name understanding as my machine is in domain A and the SAP Servers are out of domain or domain WORLD.

The tnsnames.ora file of the SAP server says

DEV.WORLD=

(DESCRIPTION =

(SDU = <sdu no.>)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = <hostname>)

(PORT = <port>)

)

)

(CONNECT_DATA =

(SID = DEV)

(GLOBAL_NAME = DEV.WORLD)

)

)

sqlnet. ora files - at my server

NAMES.DEFAULT_DOMAIN = piil.com

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

sqlnet. ora files - at SAP server

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

NAME.DEFAULT_ZONE = WORLD

SQLNET.EXPIRE_TIME = 0

TCP.NODELAY=YES

listener.ora file at my server

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = lokeshsvr)(PORT = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D:\oracle\ora92)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = OLG)

(ORACLE_HOME = D:\oracle\ora92)

(SID_NAME = OLG)

)

)

listener.ora file at SAP server

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DEV.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DEV)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = <hostname>)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = <sduno>)

(SID_NAME = DEV)

(ORACLE_HOME = /oracle/DEV/920_64)

)

)

Any kind of help would be appreciable

Regards

Lokesh Gupta

[Former Member]

The port number configuration was mismatched between my server and SAP Server due to which listener was not able to setup the connection.