what is the cause of this error:java.sql.SQLException: ORA-0

[nischalsharma]

hi
friends

i am getting this error while running the application on jboss-3.2.3
.It comes after some time .


java.sql.SQLException: ORA-04031: unable to allocate 24588 bytes of shared memory ("large pool","unknown object","koh-kghu sessi","static frame of inst")


If any one had face this kind of problem in past then please help me



with regards
nischal

[nischalsharma]

on further i got this error message:



java.lang.Exception: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-04031: unable to allocate 24 bytes of shared memory ("large pool","unknown object","session heap","UGA heap pool") ); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-04031: unable to allocate 24 bytes of shared memory ("large pool","unknown object","session heap","UGA heap pool") )): Get Access Level from Database error!

[hbaxmann]

You have a problem with the SGA memory config of your Oracle - look at your Oracle docus or at technet.oracle.com.

bax