Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Intermedia - External Proc Problem
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))
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 > > ThanksReceived on Sat Mar 02 2002 - 18:19:47 CST
![]() |
![]() |