Results 1 to 5 of 5

Thread: TNS Lproblem

  1. #1
    Join Date
    Jul 2003
    Posts
    6

    Unanswered: TNS Lproblem

    Hi all ,

    I am Abhijit Kurlekar, i would like to share a problem with the forum.
    I have a win 2k machine which has the database server.
    It is oracle 8.1.7 and the SGA size is 1.8 GB. The RAM size on the win2k machine is 3.4 GB.

    If i try to start explicit SQL* Plus sessions i get an error when i have started around 110 sessions. At that point of time a select count(*) from v$process yields a value of 92. But after this if i tryt o start another session through SQL* plus it gives me this error ...
    TNS-12500: TNS:listener failed to start a dedicated server process
    TNS-12540: TNS:internal limit restriction exceeded
    TNS-12560: TNS: protocol adapter error
    TNS-00510: Internal limit restriction exceeded


    The init.ora parameters are ...
    processes = 300
    license_max_sessions=300
    sessions = 335

    I was under the impression that if my license_max_sessions parameter is set to 300 then i can have at least those many explicit sessions through SQL* Plus or any client.

    But now this problem has come up ...
    I have a doubt that the RAM size may be needs to be increased.

    Can anyone pls expertise on this issue ?? It will be of immense help for me and my team here.

  2. #2
    Join Date
    Jan 2002
    Posts
    165
    Try carefully reading alert log-there is information what it cannot start.Last time I have to increase parameter named CIRCUITS.
    Zvonimir

  3. #3
    Join Date
    Jul 2003
    Posts
    23
    Originally posted by zkajfez
    Try carefully reading alert log-there is information what it cannot start.Last time I have to increase parameter named CIRCUITS.

    Zvonimir
    PLease Check The Listiner service
    System Support Engineer &Developer

  4. #4
    Join Date
    Jul 2003
    Posts
    6
    Thanks for the replies.
    I do not have the MTS configuration. Its the default DSS configuration.

    will increasing the RAM size of the win2k server help in this regard. it is currently 3.4 GB.
    say increasing it by 1GB or so will help ???

  5. #5
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Check v$resource_limit to see the high water mark for sessions etc.

    Check your alert log to see if there are any out of memory messages or any other errors.

    Check your OS event logs to make sure your not hitting some OS limit. Also run the windows performance monitor to see memory usage.

    Look at v$sgastat to see free memory in the shared pool.

    Alan

Posting Permissions

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