General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-04031 when migrating to ORACLE9i

SOLVED
Go to solution
Enrico Venturi
Super Advisor

ORA-04031 when migrating to ORACLE9i

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
5 REPLIES
Jean-Luc Oudart
Honored Contributor
Solution

Re: ORA-04031 when migrating to ORACLE9i

Hi

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

check aatchment

Regards
Jean-Luc
fiat lux
Alex Lavrov.
Honored Contributor

Re: ORA-04031 when migrating to ORACLE9i

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.
I don't give a damn for a man that can only spell a word one way. (M. Twain)
Arunvijai_4
Honored Contributor

Re: ORA-04031 when migrating to ORACLE9i

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
"A ship in the harbor is safe, but that is not what ships are built for"
Jean-Luc Oudart
Honored Contributor

Re: ORA-04031 when migrating to ORACLE9i

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
fiat lux
Yogeeraj_1
Honored Contributor

Re: ORA-04031 when migrating to ORACLE9i

hi enrico,

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

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)