| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: seperate external procedure listeners for different SIDs
Hmm...so if for some reason I needed two external procedure listeners to
run, (because, for example I wanted them to run as 2 different application
users rather than oracle or use 2 different sets of .so files), I could not
do it?
-----Original Message-----
Sent: 08 January 2004 14:20
To: Multiple recipients of list ORACLE-L
You're right - there isn't any tie between external procedures and a
particular SID in the listener. Here's what I am guessing (educated guess
based on the docs) happens:
1. Nothing supports external procedures until one is called.
2. When a session in a particular database instance calls an external
procedure, it works very much like accessing a remote database through a
database link. A call goes out on Net for a connection to the service named
EXTPROC_CONNECTION_DATA. The naming method (TNSNAMES.ORA in my case) has
associated this service with a protocol, usually IPC (I understand a later
version of Oracle can hook to remote external procedures with TCP/IP). IPC
identifies the service by a key.
3. The listener process that is listening for IPC connections with that key
name, in this case your separate listener, LISTENER_EXT, looks at the
program associated with that key, which is extproc.
Since there is no instance of extproc running, the listener starts one, and
hands off the Net connection to it, just as it might hand off a connection
to a remote database.
4. Your session now tells extproc through its Net connection which .DLL or
.so it wants loaded, and which function to call, passing the proper
parameters. Extproc passes back output parameters and function return
values.
5. The connection between the database session and the extproc program is
maintained for the duration of the session, so that if the session wants to
run another external procedure (or the same one again), it does not have to
go through the listener again. This is similar to the way a connection
through a database link is maintained.
6. I don't know whether another session that runs an external procedure
will get its own copy of extproc, or if it just gets its own connection to
the currently running copy of extproc. In either case, the connection is
between extproc and a single database session on a single database instance.
There is no need to associate the listener with a particular SID, anymore
than there is a need to associate a database listener with a particular
database client.
-----Original Message-----
Sent: Thursday, January 08, 2004 7:20 AM
To: Multiple recipients of list ORACLE-L
I have created a seperate listener for external procedures for one of my SIDs.
My question is, if I want to do the same for another SID in the same instance, what ensures that each external procedure listener will only handle requests for its own SID?.
Here is my listener.ora for the first SID. The external procedure listener is called listener_ext. I don't see anything in the configuration for the external procedure listener that ties it to a SID.
Platform is Oracle 9.2 on AIX 5.2
# LISTENER.ORA Network Configuration File:
/usr/u01/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEMO)(PORT = 1521))
)
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = DEMO)(PORT = 2481))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = FW9i.DEMO)
(ORACLE_HOME = /u03/app/oracle/product/9.2.0.1.0)
(SID_NAME = FW9i)
)
)
LISTENER_EXT =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=IPC)
(key = extproc_key)
SID_LIST_LISTENER_EXT =
(SID_LIST =
(SID_DESC =
(SID_NAME = extproc_agent)
(ORACLE_HOME = /u03/app/oracle/product/9.2.0.1.0)
(PROGRAM = extproc)
(ENV = "EXTPROC_DLLS=ANY")
)
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: john.dunn_at_sefas.co.uk 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: ListGuru_at_fatcity.com (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.net -- Author: John Flack INET: JohnF_at_smdi.com 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: ListGuru_at_fatcity.com (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.net -- Author: John Dunn INET: john.dunn_at_sefas.co.uk 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: ListGuru_at_fatcity.com (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).Received on Thu Jan 08 2004 - 08:39:26 CST
 |
 |