Re: Extproc & shared server mode

From: Dmitry Pavlov <dmitry.pavlov_at_gmail.com>
Date: 9 Mar 2005 03:59:12 -0800
Message-ID: <1110369552.357804.201180@z14g2000cwz.googlegroups.com>

Yes, my listener is actually running:

Here is 2 lines from elist.log (after trying to call external procedure) :
09-МАР-2005 14:31:41 *
(CONNECT_DATA=(SID=PLSExtProc)(PRESENTATION=RO)(SERVER=SHARED)(CID=(PROGRAM=)(HOST=VDEV\VO-0112)(USER=VDEV\dpavlov))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\XYZZYipc)) * establish * PLSExtProc * 12519
TNS-12519: TNS: no appropriate service handler found

Here is the ouput of 'status ELIST' in lsnrctl:

Alias                     ELIST
Version                   TNSLSNR for 32-bit Windows: Version 9.2.0.4.0
- Production
Start Date                09-mar-2005 14:31:14
Uptime                    0 days 0 hr. 18 min. 40 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   C:\oracle\ora92\network\admin\listener.ora
Listener Log File         C:\oracle\ora92\network\log\elist.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\XYZZYipc))) Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Here is the ouput of 'services ELIST' in lsnrctl:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=XYZZY))) Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Handler(s):

      "DEDICATED" established:0 refused:0
         LOCAL SERVER

The command completed successfully

I see "dedicated" handler for external PLSExtProc service, maybe it's the problem... But I don't know how to fix it. Do you? I didn't get much help from error code explanations.

I have SHARED_SERVERS=1, MAX_DISPATCHERS=5, and DISPATCHERS=(PROTOCOL=TCP)(SERVICE=ORCLXDB). Received on Wed Mar 09 2005 - 05:59:12 CST