Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: external procedures

Re: external procedures

From: TimKArnold <timkarnold_at_aol.com>
Date: 2000/04/13
Message-ID: <20000413082251.08679.00001217@ng-cj1.aol.com>#1/1

In SQLNET.ORA, if your domain
is set ( to something like world)
you need to add .world to
EXTPROC_CONNECTION_DATA so
it looks like
EXTPROC_CONNECTION_DATA.WORLD
>Hi, I'm running Oracle 8i on NT. I had the system configured to run
>external procedures, but after a recent system crash it's giving me the
>following error when I test EXTPROC_CONNECTION_DATA through net8 easy
>config:
>
>ORA-12500: TNS:listener failed to start a dedicated server process
>
>I find the same error in listener.log after trying to create an intermedia
>text index.
>
>Here's my setup...
>
>listener.ora:
>
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> (PROTOCOL_STACK = (PRESENTATION = TTC)(SESSION = NS))
> )
> ...
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\Oracle\OraHome)
> (PROGRAM = extproc)
> )
> ...
> )
>
>tnsnames.ora:
>
>EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (ORACLE_HOME = D:\Oracle\OraHome)
> )
> )
>
>Any suggestions are greatly appreciated.
>
>Tim
Received on Thu Apr 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US