Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!hub1.nntpserver.com!DirecTVinternet!DirecTV-DSL!sn-xit-03!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail From: eric@nortam.com (Eric) Newsgroups: comp.databases.oracle.misc Subject: Re: Intermedia - External Proc Problem Date: 3 Mar 2002 05:27:27 -0800 Organization: http://groups.google.com/ Lines: 169 Message-ID: <3662159b.0203030527.5193fb4c@posting.google.com> References: <3662159b.0203010622.7a4e6bb9@posting.google.com> NNTP-Posting-Host: 24.200.132.25 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1015162047 7093 127.0.0.1 (3 Mar 2002 13:27:27 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 3 Mar 2002 13:27:27 GMT Xref: easynews comp.databases.oracle.misc:77561 X-Received-Date: Sun, 03 Mar 2002 06:25:22 MST (news.easynews.com) More info on the Registry issues on w2k.. because for the files .ora files.. they all seem ok.. "Chris Weiss" wrote in message news:... > 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" wrote in message > news: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_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@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