ORA-04031: unable to allocate 4200 bytes of shared memory - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: ORA-04031: unable to allocate 4200 bytes of shared memory

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by Akila
    if u r running 8.1.7.0 then its a bug
    the metalink suggest to set the parameter _db_handles_cached=0
    that only happenes with versions <= 8.1.7.2, you should have 8.1.7.4 anyways

  2. #12
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    It is 8.1.7.0 - the contractor installed only to here from some emergency disks. the plan is to upgrade to 9.2+ asap.

    Question about the error messages: I've been told by a consultant that this type of message SHOULD NOT appear in the alert log as its a client side error? Doesn't sit easily with me that one. Any comments.

  3. #13
    Join Date
    Nov 2004
    Location
    Chennai
    Posts
    38
    Hi,

    Did u set the parameter _db_handles_cached=0 ? any results for that.

    Akila Rajakumar

  4. #14
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Doing that today. Will check the effectiveness tomorrow.

  5. #15
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    I know you've probably called the consultants everything in the book by now but just out of curiosity would it be possible instead of upgrading to do a fresh install of 9.2.0.6 and just import the schemas? Based on the assumption that the database isn't all that big?
    I've got a database that was upgraded from 8.1.6 to 8.1.7.4 to 9.2.0.5 and I've had nothing but problems with it. It's 75 gigs and I'm going to take a weekend here sometime and do a fresh install of 9.2.0.6 and import the schemas. I still have dictionary managed tablespaces for christs sake!

    shawd up! Davey I don't want to hear it
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #16
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    I'd feel more comfortable doing that anyway Doc. I have 3 Oracle Homes now and 1 Db at 9.2.0.5 and 1 Db at 8.1.7.0. I believe that the 9.2.0.5 one was a fresh install and an import whilst the 8.1.7 one was an 8.1.5-8.1.7 upgrade.

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