java out of memory errors on database creation, how do I increase the java heap size in oracle?
I try to create a small database on an M8000 box with only one domain and get this error:
create or replace java system
begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then
*
ERROR at line 1:
ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","BEGIN
BEGIN
IF (sys.is...","KGLH0^dabd6d97","kglHeapInitialize:temp")
ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","unknown
object","KGLH0^b3ea5c40","kglHeapInitialize:temp")
ORA-06512: at "SYS.INITJVMAUX", line 28
ORA-06512: at line 5
How can I increase the JAVA_OPTS= -Xmx4096M ?
Smitty