In "address_list" to listen for extproc connection through IPC protocol use
"EXTPROC0" as a KEY.
SID_NAME for extproc is always "PLSExtProc".
ORACLE_HOME is your regular oracle_home directory.
Here is an example:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = PLNT))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\OraNT)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = PLNT)
(ORACLE_HOME = d:\OraNT)
(SID_NAME = PLNT)
)
)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, June 03, 2002 9:28 AM
> Hi all,
>
> I've recently been asked to set up an extproc listener and as this is the
> first non-apps one I have had to deal with, I was hopping somebody could
> give some pointers. I have RTFM, and <sarcasm> it's oh so clear
</sarcasm>.
> Anyway, how does one go about figuring out the <LISTENER_KEY>? Is the
> <EXTPROC_SID> really a SID, or a program name (like FNDFS or OEORPC in the
> Apps)? Is the ORACLE_HOME really the ORACLE_HOME or the directory the
> program name is in (again, like the apps). Any real examples would be
> greatly appreciated.
>
> Thanks,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Weatherman
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Igor Neyman
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
