Path: news.easynews.com!easynews!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:26:19 -0800
Organization: http://groups.google.com/
Lines: 126
Message-ID: <3662159b.0203030526.4e56194f@posting.google.com>
References: <3662159b.0203010622.7a4e6bb9@posting.google.com> <u818m0hv2iidc4@corp.supernews.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 1015161979 7072 127.0.0.1 (3 Mar 2002 13:26:19 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 3 Mar 2002 13:26:19 GMT
Xref: easynews comp.databases.oracle.misc:77560
X-Received-Date: Sun, 03 Mar 2002 06:24:14 MST (news.easynews.com)

ok for the fact that it doesn't work on the client.. but, still, why
can't I issue an alter index that would be triggered from a client
session..

"Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote in message news:<u818m0hv2iidc4@corp.supernews.com>...
> "Eric" <eric@nortam.com> 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
> 
> 
> External procedures are running on the server.
> They use the IPC protocol, which stands for Inter Process Communication.
> This is a *local* protocol, it doesn't work in client/server situations.
> It is *never* going to work on a client, the server executes external
> procedures on the server on behalf of the client.
> I'm not too sure whether an EXTPROC definition needs a SID, please verify
> that in the documentation.
> 
> Regards