Hi there,

Can somebody help me out with this problem. I've prepared a DLL in CPP which
will be invoked from Oracle. The issue is that right now i'm having a
problem with the TNS and listener files in Oracle.

tnsnames.ora

EXTPROC_CONN_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.49.78)(PORT = 1521))
(KEY = ORCL)
)
(CONNECT_DATA =
(SERVICE_NAME = EXTPROC_CONN_DATA)
(PRESENTATION = RO)
)
)

listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)
(KEY = EXTPROC))

-- This is my database
(ADDRESS = (PROTOCOL = TCP)
(HOST = 10.1.49.78)
(PORT =1521))

(ADDRESS = (PROTOCOL = TCP)
(HOST = icici-4X53327)
(PORT =1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS = D:\oracle\ora92\HelloWorld.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = KASTLE)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = PLSExtProc)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS = D:\oracle\ora92\HelloWorld.dll")
)
)

Thanks in advance,

Pravin



---
This e-mail message may contain confidential, proprietary or legally privileged information. It should not be used by anyone who is not the original intended recipient.If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that 3i Infotech or its subsidiaries and associated companies, (collectively "3i Infotech"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of 3i Infotech. Before opening any attachments please check them for viruses and defects.


Oracle LazyDBA home page