Re: TNS-12500: TNS:listener failed to start a dedicated server process

From: Vlad <vtsyrlin_at_bigfoot.com>
Date: 13 Jun 2002 17:51:10 -0700
Message-ID: <bc7620c4.0206131651.3e14b988@posting.google.com>

As requested: (Note: searching Oracle metalink points that this error could be due to nt resource depletion and in fact we get even id 2002 in event viewer which correlates to exact times the database goes down. However Micro$oft provides no solution to event id 2002 (perflib source)

listener.ora
# LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = melora01)(PORT = 1521))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = melora01)(PORT = 2481))

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = ejsadmin)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = EJSADMIN)

    )
    (SID_DESC =
(GLOBAL_DBNAME = ejsdev2)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = EJSDEV2)

    )
    (SID_DESC =
(GLOBAL_DBNAME = ejsdev)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = EJSDEV)

    )
    (SID_DESC =
(GLOBAL_DBNAME = AP21)
(ORACLE_HOME = d:\oracle\ora81)
(SID_NAME = AP21)

    )
  )

tnsnames.ora
# TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

EJSADMIN.DOWD.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = melora01)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = ejsadmin)

    )
  )

EJSDEV.DOWD.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = melora01)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = ejsdev)

    )
  )

EXTPROC_CONNECTION_DATA.DOWD.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

AP21.DOWD.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = melora01)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = AP21)

    )
  )

EJSDEV2.DOWD.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = melora01)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = EJSDEV2)

    )
  )

and finally sqlnet.ora
# SQLNET.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = dowd.com

SQLNET.AUTHENTICATION_SERVICES= (NTS) SQLNET.EXPIRE_TIME = 5 trace_level_client=16

trace_unique_client=true

TRACE_LEVEL_CLIENT=ADMIN trace_directory_client = D:\Oracle\ADMIN\ejsadmin\udump

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<9k_N8.864$vB.4836_at_news.indigo.ie>...

> No temp directory in settings maybe
> 
> post listener.ora and tnsnames and sqlnet and let's have a look
> 
> 
> "Vlad" <vtsyrlin_at_bigfoot.com> wrote in message
> news:bc7620c4.0206122333.7666a94c_at_posting.google.com...
> > Hi.
> > We have Oracle 8.1.7.0 database which serves as a database for our
> > ecommerce web site.
> >
> > On average once every 10-14 days we are unable to connect to our life
> > oracle instance. I was able to locate the following errors in the
> > listener.log file:
> >
> > 12-JUN-2002 14:59:11 *
> > (CONNECT_DATA=(SID=ejsadmin)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle)))
> > * (ADDRESS=(PROTOCOL=tcp)(HOST=205.47.49.234)(PORT=1321)) * establish
> > * ejsadmin * 12500
> > TNS-12500: TNS:listener failed to start a dedicated server process
> >  TNS-12560: TNS:protocol adapter error
> >   TNS-00530: Protocol adapter error
> >    32-bit Windows Error: 2: No such file or directory
> > Note: this error only occurs every 10-14 days and the only solution is
> > to restart the oracle server. This fixes it for another 10-14 days.
> > Any help would be much appreciated.
> > Does increasing windows semaphores mean anything?
> > thanks
> > Vlad

Received on Thu Jun 13 2002 - 19:51:10 CDT