Jack,
This is a post from a few weeks ago that gives a setup
TNSNAMES:
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = extproc_agent) <--- Key1
)
(CONNECT_DATA = (SID = 11) <--- Key2
(server=dedicated))
)
Listener:
EXTPROC_LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = extproc_agent) <---- Key1
)
)
SID_LIST_EXTPROC_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = 11) <---- Key2
(ORACLE_HOME = /ora1/81764)
(PROGRAM = extproc)
)
)
BTW: Oracle's recommendation is to use a seperate listener for extproc calls.
-----Original Message-----
Sent: 24 July 2003 15:10
To: Multiple recipients of list ORACLE-L
<http://www.quantsystems.nl/>
Tried that still the same error message.
Any other hints & tips for me to try?
Just curious though ,why is it DLLS if I'm working on LINUX
Jack
-----Original Message-----
Sent: Thursday, July 24, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
Please add the line in red to your listener.ora file. Extproc has been made secure in
Oracle 9i. The following line has to be added to execute your own external procedures.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = plsextproc)
(ORACLE_HOME = /oracle/app/product/9.2.0)
(PROGRAM = extproc)
(ENVS="EXTPROC_DLLS=ANY")
)
(SID_DESC =
(GLOBAL_DBNAME = Ora92)
(ORACLE_HOME = /oracle/app/product/9.2.0)
(SID_NAME = ora92)
)
)
Regards
Munish Bajaj
-----Original Message-----
Sent: Thursday, July 24, 2003 16:24
To: Multiple recipients of list ORACLE-L
Hi All,
I am trying to setup EXTPROC but keep getting ORA-28575 (Check your tnsnames.ora &
listener.ora)
Attached are my files that look OK to me
Anybody??
****************************************************************************************************
[EMAIL PROTECTED] admin]$ cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File:
/oracle/app/product/9.2.0/network/admin/tnsnames.ora
ORA92 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Ora92)
)
)
extproc_connection_data =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent))
(CONNECT_DATA = (SID = plsextproc))
)
)
[EMAIL PROTECTED] admin]$ cat listener.ora
# LISTENER.ORA Network Configuration File:
/oracle/app/product/9.2.0/network/admin/listener.ora
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = plsextproc)
(ORACLE_HOME = /oracle/app/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Ora92)
(ORACLE_HOME = /oracle/app/product/9.2.0)
(SID_NAME = ora92)
)
)
****************************************************************************************************
TIA
Jack van Zanen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hallas, John, Tech Dev
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
