ORA-04031 when migrating to ORACLE9i

[Enrico Venturi]

Hello colleagues,
I've installed ORACLE9, I've created a database using the parameters tuned for ORACLE8, then I run my processes letting them to refer ORACLE8 libraries; some of my processes starts then fails to connect to the database with the following error:
Message :ORA-04031: unable to allocate 26104 bytes of shared memory

some suggestions???

thanks a lot
Enrico

[Jean-Luc Oudart · Accepted solution]

Hi

could be different possibilities.
Ususally either the shared pool is too small or is fragmented (or both)

check aatchment

Regards
Jean-Luc

[Alex Lavrov.]

ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the DBMS_SHARED_ POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.

Try to increase the shared pool size.



Or are you short in memory?

swapifo -tam
vmstat


Alex.

[Arunvijai_4]

http://ora-04031.ora-code.com/msg/43019.html

http://forums.oracle.com/forums/message.jspa?messageID=1066992

>If you have access to metalink, I advise you >to read 146599.1 Diagnosing and Resolving >Error ORA-04031.

-Arun

[Jean-Luc Oudart]

ORACLE9I MEMORY MANAGEMENT: EASIER THAN EVER

Hi again,

see also this document on Memory management for 9i :"ORACLE9I MEMORY MANAGEMENT: EASIER THAN EVER"

Regards
Jean-Luc

[Yogeeraj_1]

hi enrico,

see also note:223730.1
Subject: Automatic PGA Memory Managment in 9i

regards
yogeeraj