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

When i am going to import schema facing below issue on 12c Database.

ERROR:-

EXP-00008: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","oracle/i18n/util/LocaleMapper","JOXLE^aff8222c",":SGAClass")
EXP-00000: Export terminated unsuccessfully.

Solution:-

SQL> ALTER SYSTEM SET SGA_MAX_SIZE=512M SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET SGA_TARGET=512M SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='512M' scope=spfile;

System altered.

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate;

SQL> startup;

Retest issue.


No comments:

ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%'

 This MySQL error — ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' — means that MySQL cannot find the user ...