Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 28, 2010 at 06:40 AM

    Dears,

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

    Regards,

    Shivam

    Add comment
    10|10000 characters needed characters exceeded