Oracle Weblogic Server (MOSC)

MOSC Banner

ORA-00604 and ORA-04031 Shared memory JDBC connection Pool Error

edited Dec 20, 2013 12:24AM in Oracle Weblogic Server (MOSC) 3 commentsAnswered
####<Dec 19, 2013 11:59:37 AM EST> <Warning> <JDBC> <machinename> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <f51b4d0bdea44d7a:-6c6d8c99:1430bcbacd0:-8000-0000000000000002> <1387472377377> <WL-001129> <Received exception while creating connection for pool "XXXXX": ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","select  decode(u.type#, 2, u...","sga heap(1,0)","kglsim object batch")

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","kglsim heap")

>
####<Dec 19, 2013 11:59:37 AM EST> <Info> <JDBC> <
machinename> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <f51b4d0bdea44d7a:-6c6d8c99:1430bcbacd0:-8000-0000000000000002> <1387472377377> <WL-001156> <Stack trace associated with message 001129 follows:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center