Xref: alice comp.databases.oracle.tools:42450
Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!newshub2.home.com!news.home.com!news1.gvcl1.bc.home.com.POSTED!not-for-mail
From: "Tim McClelland" <cst97042@camosun.bc.ca>
Newsgroups: comp.databases.oracle.tools
Subject: external procedures
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.3825.400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.3825.400
Message-ID: <w3fH4.72768$_d.2679607@news1.gvcl1.bc.home.com>
Date: Fri, 07 Apr 2000 06:17:00 GMT
X-Complaints-To: abuse@home.net
X-Trace: news1.gvcl1.bc.home.com 955088220 24.69.26.63 (Thu, 06 Apr 2000 23:17:00 PDT)
NNTP-Posting-Date: Thu, 06 Apr 2000 23:17:00 PDT
Organization: @Home Network Canada

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