ORA-12547: TNS:lost contact urgent urgent!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-12547: TNS:lost contact urgent urgent!!!

  1. #1
    Join Date
    Apr 2002
    Posts
    291
    Hi All,
    I'm working on Linux 7.2,Oracle 9i on production box. My users are very frequently getting this error when they are trying to connect from TOAD or SQL*PLUS, or on telnet session. At the same time, at $ prompt, i'm getting core dumped error too. This is my ulimit parameters with their values, please try to help me.

    This is from TOAD/SQLPLUS/DBASTUDIO
    ERROR:ORA-12500: TNS:listener failed to start a dedicated server process

    This is from Telnet/Hyperterminal session:
    ERROR: Enter user-name: devlcms
    Enter password:
    ERROR:
    ORA-12547: TNS:lost contact

    This is my ulimit
    core file size (blocks) 1000000
    data seg size (kbytes) unlimited
    file size (blocks) unlimited
    max locked memory (kbytes) unlimited
    max memory size (kbytes) unlimited
    open files 1024
    pipe size (512 bytes) 8
    stack size (kbytes) 8192
    cpu time (seconds) unlimited
    max user processes 136192
    virtual memory (kbytes) unlimited


    Please suggest me . Your earliest responce is most appreciated.

    Thanks in advance


    PNRDBA

  2. #2
    Join Date
    Sep 2001
    Posts
    120
    hi,
    i think you have a dedicated listener process for the users.In dedicated listener the server process keep on waiting for the user queries even if user is not working.you can change the dedicated mode to shared server mode and start 5 dispatchers initally and max you can set to 10 and as and when necessary you can start more process dynamically.

    Saurabh
    Saurabh Garg
    OCP 9i

  3. #3
    Join Date
    Apr 2002
    Posts
    291
    thanks suarabh,
    but we are already running with the similar set up and environment on another machine very smoothly and absolutely fine. is No.of dipatchers=5 is the default value for either a dediacted server or an MTS?? Are there any other parameters need to be set along with this? please let me know.

    thanks
    PNRDBA

  4. #4
    Join Date
    Sep 2001
    Posts
    120
    hi,

    i think there are no default value for dedeicated server.
    In dispatchers parameter there is no default value but oracle recomends that you have atleast 2.i gave you 5 because i think you have very excessive load.

    i think you should read "Oracle9i Database Administrator's Guide".

    There they have given the shared server configuration.

    saurabh
    Saurabh Garg
    OCP 9i

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Hi

    The ora-12500 & ora-12547 errors may be an indication that the RAM amount may be reaching its limit.

    What is the size of your physical RAM, and the sum of the sizes of all instances on that linux box ? Moreover, at peak time what is the memory usage(free also), using top.

    HTH.



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