Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: external procedures
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