Re: Intermedia - External Proc Problem

From: Chris Weiss <chris_at_www.hpdbe.com>
Date: Sat, 2 Mar 2002 19:19:47 -0500
Message-ID: <a5rp4b$28l2$1@msunews.cl.msu.edu>

Here is a sample listener entry that works under 8.1.6 on Linux:

extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)

                 (KEY = extproc))

    )
    (CONNECT_DATA =
(SID = extproc)

    )
  )

In the listener file the corresponding entry is:

(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /home/u01/app/oracle/product/8.1.6)
(PROGRAM = extproc)

    )

The listener and extproc run a little differnently under NT/Win2k due to required registry entries, but the principle should be the same.

From our production Solaris servers, the entries are:

TNSNAMES: xtproc_connection_data, extproc_connection_data.world =   (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = ipc)(KEY = extproc))
    )
    (CONNECT_DATA =
(SID = extproc)

    )
  )

LISTENER.ORA -> Description:

(ADDRESS = (PROTOCOL = IPC)(KEY = extproc)

--

Good Luck!

~~~~~~~~~~~~~~~~
Chris Weiss
www.hpdbe.com
High Performance Database Engineering
~~~~~~~~~~~~~~~~


"Eric" <eric_at_nortam.com> wrote in message
news:3662159b.0203010622.7a4e6bb9_at_posting.google.com...
> Hi,
>    I've browsed through the messages and so far, haven't found a
> solution to the problem I have, so I'll expose it here in details:
>
> 1. On the server if I issue this command in pl/sql it works fine:
> alter index ndx_blahblah rebuild online parameters('sync');
>
> 2. If I issue the same command with the same user but through a
> servlet running on the same server I get this error, the reaction is
> the same if I do it from a client PC:
> DRG-10595: ALTER INDEX NDX_RAW_RESULT failed
> DRG-50704: Net8 listener is not running or cannot start external
> procedures
> ORA-28575: unable to open RPC connection to external procedure agent
> ORA-12154: TNS:could not resolve service name
>
> 3. Oracle version 8.1.6
>    Running on Win2K Server
>
> 4. Listener.ora on server
> LISTENER =
>   (DESCRIPTION_LIST =
>     (DESCRIPTION =
>       (ADDRESS_LIST =
>         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
>       )
>       (ADDRESS_LIST =
>         (ADDRESS = (PROTOCOL = TCP)(HOST = myhostname)(PORT = 1521))
>       )
>     )
>     (DESCRIPTION =
>       (PROTOCOL_STACK =
>         (PRESENTATION = GIOP)
>         (SESSION = RAW)
>       )
>       (ADDRESS = (PROTOCOL = TCP)(HOST = myhostname)(PORT = 2481))
>     )
>   )
>
> SID_LIST_LISTENER =
>   (SID_LIST =
>     (SID_DESC =
>       (SID_NAME = ep_agt1)
>       (ORACLE_HOME = C:\Oracle\Ora81)
>       (ENVS = LD_LIBRARY_PATH=C:\oracle\Ora81\CTX\bin)
>       (PROGRAM = extproc)
>     )
>     (SID_DESC =
>       (GLOBAL_DBNAME = MyDB)
>       (ORACLE_HOME = C:\Oracle\Ora81)
>       (SID_NAME = MyDB)
>     )
>   )
> 5. TNSNAMES.ORA on server:
> ...
> extproc_connection_data =
>         (DESCRIPTION =
>         (ADDRESS = (PROTOCOL = IPC)
>                    (KEY = EXTPROC0))
>         (CONNECT_DATA = (SID = ep_agt1)))
> 6. listener.log
> Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
> Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostname)(PORT=1521)))
> Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostname)(PORT=2481))(PROTOCOL_S
TACK=(PRESENTATION=GIOP)(SESSION=RAW)))
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
> CODE
> 01-MAR-2002 08:57:15 *
>
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=auser))(COMMAND=status)(ARGUMENTS=
64)(SERVICE=LISTENER)(VERSION=135290880))
> * status * 0
> Trace information written to
> C:\Oracle\Ora81\network\trace\listener.trc
> 01-MAR-2002 08:57:49 * trace * 0
> Trace information written to
> C:\Oracle\Ora81\network\trace\listener.trc
> 01-MAR-2002 08:57:53 * trace * 0
> Trace information written to
> C:\Oracle\Ora81\network\trace\listener.trc
> 01-MAR-2002 08:57:58 * trace * 0
> 01-MAR-2002 08:58:01 * service_register * MyDB * 0
> Trace information written to
> C:\Oracle\Ora81\network\trace\listener.trc
> 01-MAR-2002 08:58:36 * trace * 0
>
>
> 7. TNSNAMES.ORA on client
> extproc_connection_data =
>         (DESCRIPTION =
>         (ADDRESS = (PROTOCOL = IPC)(HOST=myhostname) ** Tried with and
> without host specified
>                    (KEY = EXTPROC0))
>         (CONNECT_DATA = (SID = ep_agt1)))
>
> 8. sqlplus apps/apps_at_extproc_connection_data on server results in:
> 'Application Error' !!!
> 9. on client: ORA-12541: TNS:no listener
>
> So if you have any clues.. this would help..
> because I don't want to have ctxsrv (which works).. running when I'm
> doing MAJOR inserts on an indexed table, I want to control when the
> update is to happen
>
> Thanks

Received on Sat Mar 02 2002 - 18:19:47 CST