Connecting to oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Connecting to oracle

  1. #1
    Join Date
    Aug 2002
    Posts
    5

    Connecting to oracle

    The following message is diaplayed when i am connecting to Oracle on Sun Solaris 5.8 , Oracle 8.1.6 .
    It connects sometimes and when you come out and try again it displays the same error message shown below.
    The Oracle env variables like ORACLE_HOME , TNS_ADMIN , NLS_LANG etc... have been set before.
    Can somebody tell me why it is behaving like this.

    [eco4]-/u01/oracle/product/8.1.6/network/admin> sqlplus dd/dd

    SQL*Plus: Release 8.1.6.0.0 - Production on Mon Jan 6 20:06:18 2003

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

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


    Enter user-name:


    Thanks in advance
    Sridhar

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I have seen this error when there are resource (memory) issues on the server.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    Your server may have been set as 'shared process' but your client tries to use (SERVER = DEDICATED) in tnsnames.ora.

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Did you try restarting the listener?
    Agasimani
    OCP(10g/9i/8i/8)

  5. #5
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    This can be seen if there is a resource issue (as someone else has said) I've check the number of sessions in v$session as it sounds like oracle cant get the resources it needs for the session. Have a search for TNS-12500 on metalink.

  6. #6
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    I believe it is a bug in 8.1.6. If you set database in dedicated server rather than MTS, the problem disappear.

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