ORA-04031: unable to allocate 64 bytes of shared memory

[ajjunit84]

Hi All,

We are performing System copy on a distributed environment with OS Windows 2003 and DB Oracle 10.2.0.4

While importing the Database (ABAP) only ,we are facing error and 5 import steps are failing in Import ABAP phase.

Error is "ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select user#,type# from user...","Typecheck","kgghteInit")

(DB) INFO: disconnected from DB"

There is already one Oracel Instance OracleXX1 is runing this is the second instance and the server has around 1.75 GB RAM...i

Can you please suggest what could be the error.

Regards

Ajay

[Former Member]

Dears,

Please try increase your database parameter shared_pool_size in pfile and then try to resume the activity.

Regards,

Shivam

[ajjunit84]

Thanks..yes referred this SAP note as well 690241.

Installation is running fine now.!!

Regards

Ajay