(ORA-12500) error message
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: (ORA-12500) error message

  1. #1
    Join Date
    Aug 2001
    Posts
    27
    Sometimes this errors appears when a user is working :
    ORA-12500 Listener failed to start a dedicated server process
    I tried to stop the listner and start again, the database work properly,,,
    After some hours, the message appears again, and I stoped the listner and started again, the database work properly,,, and so on,,,
    What is the problem ? How can I solve this problem ?


    [Edited by abcd on 09-02-2001 at 07:07 AM]

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution

    Dear Friend, 2nd Sep 2001 17:04 hrs chennai

    Welcome to dbasupport.com .I kindly request you to mention O/S and DB version in future.

    I persume it should ne windows NT.Its where lot of Problem like this Occurs.With win2000 its still more.

    Look at the folowing solution i traced from a simillar problem.


    A. TNS-12500 on Microsoft Windows NT
    B. Intermittent TNS-12500 Errors on Microsoft Windows NT


    A. TNS-12500 on Microsoft Windows NT
    -----------------------------------------
    1. Please make sure that the userid that installed/started
    oracle, and started the listener is administrator.

    2. Go to the Control Panel by clicking on [START]-->
    [Settings]---> [Control Panel] and then double click
    on "Services". A window is displayed which
    looks similar to this:

    +---------------------------------------------------------+
    | |
    | Service Status Startup |
    +---------------------------------------------------------+
    |OracleNamesService80 Manual |
    |OracleServiceORCL Started Auto |
    |OracleStartORCL Started Auto |
    |OracleTNSListener Started Auto |
    |OracleTNSListener80 Manual |
    |OracleWebAssistant Manual |
    |pcANYWHERE Service Started Manual |
    +---------------------------------------------------------+

    Look at "OracleService" and "OracleStart". These two
    services are followed by your SID name (in this case ORCL).
    These services should be started. If they are not click
    on the [START] button on the right side of the dialog box.

    3. Verify the SID names shown with "OracleService" and
    "OracleStart" in the Control Panel:Services are the same
    SID names in the client's TNSNAMES.ORA and the server's
    LISTENER.ORA files.

    4. Make sure that the listener is logged on as the System
    Account. You can check this by going into Control
    Panel/Services highlight the OracleTNSListener then
    click on Startup. The listener should be logged on as
    the System Account. Once you make this change make
    sure that you stop and start the listener.

    5. Make sure that the tnsnames.ora file doesn't specify the
    ORACLE_HOME parameter in the connect_data section. If it
    does, remove it.

    6. You may want to simply try restarting your instance.

    B. Intermittent TNS-12500 Errors on Microsoft Windows NT
    ---------------------------------------------------------

    1. Increase the amount of memory available to the system
    either by removing unnecessary processes or increasing
    the amount of physical memory.

    2. Increasing the amount of swap space will also
    temporarily help relieve the symptoms.

    3. Disable OTRACE. OTRACE is a tracing feature that can
    cause many problems. OTRACE is enabled by default.
    To disable OTRACE:

    a. Stop the Oracle database.
    b. Go to the orant/otrace/admin directory.
    c. Delete all files with a ‘.dat’ extension.
    d. Restart the Oracle database.

    4. The TNS-12500 can be a result of the 'processes'
    parameter in the init.ora file being too low.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Re: Solution on Unix platform

    Hi, 2nd sep 2001 17:25 hrs chennai

    On unix platform look at this link.

    http://technet.oracle.com/support/bb...ontent/508.htm

    I am sorry the problem is not only with win ,not even with unix ,even not with oracle but with all softwares.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

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