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.
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;
SQL> startup;
Retest issue.
No comments:
Post a Comment