Intermedia - External Proc Problem

From: Eric <eric_at_nortam.com>
Date: 1 Mar 2002 06:22:01 -0800
Message-ID: <3662159b.0203010622.7a4e6bb9@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_STACK=(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 Fri Mar 01 2002 - 08:22:01 CST