"sqlplus as sysdba" startup error My setup:


Oracle 11g
32G RAM
8 CUP threads


Three oracle instances have been running. But running this:

sqlplus "/as sysdba"


gives me a prompt:


  Connected to an idle instance.


When I issue the startup  command, I get this error:


  ORA-04031 unable to allocate 2048 bytes shared memory  ("shared pool","unknow object","sga heap(1,0)","procs:ksunfy");


But three Oracle instances are working now.

Maybe I changed some config incorrectly. What can I do to fix this?
Launch this command on OS prompt and will obtain:

[oracle@datab ~]$ oerr ORA 04031
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
//          initialization parameters SHARED_POOL_RESERVED_SIZE and
//          SHARED_POOL_SIZE.
//          If the large pool is out of memory, increase the initialization
//          parameter LARGE_POOL_SIZE.


You can try to increase values as help says, or go and take a look here, for example.