Extproc on Windows98

From: <jrlongo_at_my-deja.com>
Date: Tue, 18 Jan 2000 15:46:21 GMT
Message-ID: <8621sa$ada$1@nnrp1.deja.com>

I am trying to call an external procedure using Oracle8 Personal Edition (8.0.4.0.0)
on Windows98. I have a dedicated listenering running which looks good:

Starting tnslsnr80: please wait...

  TNSLSNR80 for 32-bit Windows: Version 8.0.4.0.0 - Production   System parameter file is C:\orawin95\net80\admin\listener.ora   Log messages written to C:\orawin95\net80 \log\external_procedure_listener.log
  Trace information written to C:\orawin95\net80 \trace\external_procedure_listener.trc
  Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)) STATUS of the LISTENER

  Alias                     EXTERNAL_PROCEDURE_LISTENER
  Version                   TNSLSNR80 for 32-bit Windows: Version
8.0.4.0.0 - Production
  Start Date                18-JAN-00 08:48:04
  Uptime                    0 days 0 hr. 0 min. 1 sec
  Trace Level               user
  Security                  OFF
  SNMP                      OFF
  Listener Parameter File   C:\orawin95\net80\admin\listener.ora
  Listener Log File         C:\orawin95\net80
\log\external_procedure_listener.log
  Listener Trace File       C:\orawin95\net80

\trace\external_procedure_listener.trc
  Services Summary...
    extproc has 1 service handler(s)
  The command completed successfully

I can ping the listener:

TNS Ping Utility for 32-bit Windows: Version 8.0.4.0.0 - Production on 18-JAN-00 08:52:35

Attempting to contact (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))

  OK (240 msec)
  OK (320 msec)
  OK (70 msec)
  OK (30 msec)
  OK (50 msec)

But when I try to use the Net8 Assistant to test the connection, I get:

Connecting....

The test did not succeed.
ORA-12500: TNS:listener failed to start a dedicated server process

There may be an error in the fields entered or the server may not be ready for a connection. You can check the server and retry, or continue.

The log says:

18-JAN-00 08:54:29 * (CONNECT_DATA=(SID=extproc)(CID= (PROGRAM=C:\ORAWIN95\JRE11\BIN\JAVA.EXE)(HOST=PRLLAP)(USER=longo))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * extproc * 12500
TNS-12500: TNS:listener failed to start a dedicated server process TNS-12560: TNS:protocol adapter error TNS-00102: Keyword-Value binding operation error

If I try to call the external procedure using a trigger from Oracle, I get:

ORA-03113: end-of-file on communications channel

Any ideas? Can this even be done on Windows? I am trying to create a demo of triggers
and external procedure calls. See below for listener.ora and tnsnames.ora.

Thanks,

Jason Longo

...
listener.ora

EXTERNAL_PROCEDURE_LISTENER =
(ADDRESS = (PROTOCOL = ipc)(KEY = EXTPROC0))

SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
(SID_LIST =

(SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = c:\orawin95)
      (PROGRAM = extproc)

)
)

...

tnsnames.ora

EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =

    (ADDRESS = (PROTOCOL = ipc)(KEY = EXTPROC0))     (CONNECT_DATA =
      (SID = extproc)
    )
  )

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 18 2000 - 09:46:21 CST