Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    22

    Wink Unanswered: ORA-12500: TNS:listener failed to start a dedicated server process

    Hi,

    I can not connect to my Oracle 9i Server on Windows2000 Adv. Server platform(with 4G RAM), it just give me following message:

    SQL> connect system@t885
    Enter password:
    ERROR:
    ORA-12500: TNS:listener failed to start a dedicated server process


    sometimes I can connect, somtimes cannot , with ora-12500 error. There are about 80 sessions when I cannot connect.

    I set processes=300

    Thanks for your help.

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    There is a problem running the file defined in the "program=" parameter of your LISTENER.ORA file . Check that the file referenced in the "program=" parameter of the LISTENER.ORA file executes with no errors.

    Try to set a still more higher value for process.
    SATHISH .

  3. #3
    Join Date
    Nov 2003
    Posts
    22
    Hi satish_ct ,

    listener.ora:

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

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = T885)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\ora92)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = t885)
    (ORACLE_HOME = D:\oracle\ora92)
    (SID_NAME = t885)
    )
    )


    and PROGRAM = extproc, how to check if there's error on executing of extproc?

    thanks for your help.



    error in listener.log:

    02-DEC-2003 16:54:11 * service_update * t885 * 0
    02-DEC-2003 16:54:52 * (CONNECT_DATA=(SERVICE_NAME=T885)(CID=(PROGRAM=E:\ tadvs3\lr.exe)(HOST=HUANGDACHENG)(USER=huangdachen g))) * (ADDRESS=(PROTOCOL=tcp)(HOST=86.100.88.67)(PORT=10 40)) * establish * T885 * 12500
    TNS-12500: TNS£º listener failed to start dedicated server
    TNS-12540: TNS£ºinternal limit restriction exceeded
    TNS-12560: TNSrotocol adapter error
    TNS-00510: Internal limit restriction exceeded
    32-bit Windows Error: 8: Exec format error
    Last edited by Jovih; 12-02-03 at 20:52.

  4. #4
    Join Date
    Nov 2003
    Posts
    22
    Did anybody face the same problem? Can you help me?

Posting Permissions

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