Important parameters are there
File init.ora
###########################################
# Pools
###########################################
java_pool_size=1048576
large_pool_size=1048576
shared_pool_size=50000000
parameters
1* select substr(NAME,1,30) NAME, substr(VALUE,1,20) VALUE from v$parameter where name like
'%shared%'
SQL> /
NAME VALUE
------------------------------ --------------------
shared_pool_size 62914560
shared_pool_reserved_size 2516582
shared_memory_address 0
hi_shared_memory_address 0
shared_servers 1
max_shared_servers 20
shared_server_sessions 165
1* select substr(NAME,1,30) NAME, substr(VALUE,1,20) VALUE from v$parameter where name like
'%large%'
SQL> /
NAME VALUE
------------------------------ --------------------
large_pool_size 1048576
04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")"
// *Cause: More shared memory is needed than was allocated in the shared
// pool.
// *Action: If the shared pool is out of memory, either use the
// dbms_shared_pool package to pin large packages,
// reduce your use of shared memory, or increase the amount of
// available shared memory by increasing the value of the
// INIT.ORA parameters "shared_pool_reserved_size" and
// "shared_pool_size".
// If the large pool is out of memory, increase the INIT.ORA
// parameter "large_pool_size".