ORA:12500 TNS:Listener Failed to start a dedicated server process
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: ORA:12500 TNS:Listener Failed to start a dedicated server process

  1. #1
    Join Date
    Feb 2001
    Posts
    8
    I make an application in delphi 4 with my database in Oracle 8i, but when I running my aplication, after a week, my listener of my Database failed, and I have to restard my server. my server machine its plataform is Windows NT server 4.0 and all my clientes are Windons NT workstation 4.0
    Can you Help me?, this mistake i have every week

  2. #2
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    Check the listener log file in %ORACLE_HOME%\NETWORK\LOG.

  3. #3
    Join Date
    Feb 2001
    Posts
    8
    i checked but i don't know to mean this.

    i send a new post its subject si Re. ORA - 12500

    thanks

  4. #4
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    Here is an explanation for ORA 12500

    *Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly.

    Baliga

  5. #5
    Join Date
    Feb 2001
    Posts
    8
    Ok, but the enviroment what does it mean?, i don't understand its.

    do you think that it have an error, or its configuration is bad?

  6. #6
    Join Date
    Feb 2001
    Posts
    8
    I Checked the listener.log but I don't know that means


    TNSLSNR for 32-bit Windows: Version 2.3.4.0.0 - Production on 06-FEB-01 17:05:33

    Copyright (c) Oracle Corporation 1994. All rights reserved.

    System parameter file is d:\orant\network\admin\listener.ora
    Log messages written to d:\orant\network\log\listener.log
    Trace information written to d:\orant\network\trace\listener.trc
    Trace level is currently 0

    Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\oracle.worldipc))
    Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ORCLipc))
    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

    This Listener start 06-FEB and yestarday I Restart.

    what do you mean about that?

  7. #7
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Environment means
    ORACLE_HOME
    ORACLE_SID
    TNS_ADMIN home etc.,
    <font face=courier>
    12500, 00000, "TNS:listener failed to start a dedicated server process"
    // *Cause: The process of starting up a dedicated server process failed.
    // The executable could not be found or the environment may be set up
    // incorrectly.
    // *Action: Turn on tracing at the ADMIN level and reexecute the operation.
    // Verify that the ORACLE Server executable is present and has execute
    // permissions enabled. Ensure that the ORACLE environment is specified
    // correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being
    // called may not be installed on the local hard drive. Please check that
    // the correct Protocol Adapter are successfully linked.
    // If error persists, contact Oracle Customer Support.
    </font>

  8. #8
    Join Date
    Feb 2001
    Posts
    8
    I'm looking for a similary post with this error, and I found where anybody tell, that check the number of conections server or the Dispatcher, but I don't Know What's Dispatcher?


    thank

  9. #9
    Join Date
    Feb 2001
    Posts
    8
    How do I active the Trace ?

  10. #10
    Join Date
    Jun 2000
    Posts
    295
    add TRACE_LEVEL_LISTENER = ADMIN
    TRACE_DIRECTORY_LISTENER=my_directory

    to your listener.ora and restart listener.

    You can find trace file under my_directory.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width