unable to allocate 4200 bytes of shared memory
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: unable to allocate 4200 bytes of shared memory

  1. #1
    Join Date
    Jan 2002
    Posts
    94

    Unhappy

    Hallo,

    there is a Oracle 9i data base running on a Linux plattform. My Oracle 9i client is on a seperat node running on windows 2000 plattform.

    So, and now my problem:
    When I tried last time to connect to the database server I got the following error message:
    ORA-00604: orror occurred at recursive SQL level 2
    ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","TRIGGERS$","sga heap","state objects")

    If I remember right, I finished my last telnet session (and than working with svrmgrl) to the server database not correctly. Could that be the reason? And, what could do to solve the problem?

    Thank you in advance!

    Christian

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    that means your shared pool is fragmentated, normally this happens quite often with MTS and not using large pool

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Thumbs up

    Increase the shared_pool_size.


    If the amount of free memory is less (< 5mb) for shared pool then must increase. (check v$sgastat). So also for the large pool.

    HTH.

    [Edited by ggnanaraj on 07-26-2002 at 04:53 AM]

  4. #4
    Join Date
    Jul 2002
    Posts
    132
    As of now, issue
    Alter System Flush Shared Pool;

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    As far as I know this is a bug and the workaround is to set _db_handles_cached = 0
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    a bug in 9.0.1.3.0 or 9.2.0.1?

  7. #7
    Join Date
    Jan 2002
    Posts
    94
    It seems to be a bug....

    shared_pool_size = 81457280
    large_pool_size = 8014400

    My personal problem now is, that I do not know the pwd of internal ... no connection (sys, system) is possible... so it seems that I can not reboot the database to change the init.ora parameter...

    Christian

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    to start with we dont have internal in 9i

    itīs sqlplus "/ as sysdba"

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pando
    a bug in 9.0.1.3.0 or 9.2.0.1?
    8.1.7. I thought it was fixed in 9i. Don't know...
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  10. #10
    Join Date
    Jan 2002
    Posts
    94
    Originally posted by pando
    to start with we dont have internal in 9i

    itīs sqlplus "/ as sysdba"
    It is two weeks ago I started with 9i ... Sorry for that question ;>

    Christian

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