DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Instance problem

  1. #1
    Join Date
    Dec 2000
    Posts
    14

    Post

    I am getting some strage errors intermittedly.

    My Oracle instance is running and after some time it is not accepting new connections ( Sessions ). I can continue work on existing sessions. The error messages I am getting are

    TNS-12500: TNS:listener failed to start a dedicated server process
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error

    This is from client end. Then I tried to connect svrmgr at server end that time I am getting ORA-12203 TNS Unable to connect destination.

    Can any one help to solve this problem.

    I contacted Oracle Suppoprt and they advised me to install patch 8.0.2.6. Still I am getting same errors after installation of patch.


    Software details

    OS: WIN NT4.0
    Oracle Version : 8.0.5.0.0

    Subbarao Manchikanti

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sounds like a resource problem. Most likely, you don't have enough memory on your box to support the number of users you wish to accomodate.
    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
    Dec 2000
    Posts
    14
    Yes I have enough memory,

    I have 1GB of memory and 2GB of paging. Once I bounce the database I can work for two days. Some times even I can get connection some time.

    Subbarao Manchikanti

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    OK, you have 1G of memory. How big is your SGA? How big is each dedicated user process?
    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."

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Some of the possible options to venture into are

    1. set the user profile to remove the idle sessions
    2. Check the number of processes in your system.
    3. Increase the sessions in your instances
    4. Try doing the MTS with shared/dedicated server setup

    Hope one of these would provide you some solution.

    Sam

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