ORA-04031: unable to allocate string bytes of shared memory

ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")

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".

ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","user","PL/SQL MPCODE","BAMIMA: Bam Buffer"):

This is usually followed by the "ORA-06508: PL/SQL: could not find program unit being called" error.

This is likely to be caused by fragmentation within the shared pool, such that there is insufficient contiguous free memory to load entire PL/SQL packages.

The solution is to increase the "shared_pool_reserved_size" parameter in the "init.ora" parameter file. This defaults to 5% of the shared pool, which may be fine if a large shared pool, but not if a small one (where majoriry is used by large PL/SQL objects).

ORA-00060: deadlock detected while waiting for resource

ORA-00936:missing expression

ORA-02063 remote db error and how to fix it

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-04091: table is mutating trigger

ORA-00604: error occurred at recursive SQL level string

PLS-00222: no function with name exists

ORA-00600: internal error code arguments:

ORA-21000:error number argument to raise_application_error is out of range

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00001: unique constraint

ORA-00017: session requested to set trace event

ORA-00018: maximum number of sessions exceeded

ORA-00019: maximum number of session licenses exceeded

ORA-00020: maximum number of processes exceeded.

ORA-00021: session attached to some other process; cannot switch session

ORA-00022: invalid session ID; access denied

ORA-00023: session references process private memory; cannot detach session

ORA-00024: logins from more than one process not allowed in single-process mode

ORA-00025: failed to allocate string

ORA-00026: missing or invalid session ID

ORA-00027: cannot kill current session

ORA-00028: your session has been killed

ORA-00029: session is not a user session

ORA-00030: User session ID does not exist.

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00055: maximum number of DML locks exceeded

ORA-00060: deadlock detected while waiting for resource

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00600: internal error code arguments

ORA-00604: error occurred at recursive SQL level string

ORA-00936:missing expression

ORA-00997: illegal use of LONG datatype

ORA-01000:maximum open cursors exceeded

ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

ORA-01480: trailing null missing from STR bind value

ORA-01555: snapshot too old: rollback segment number string with name "string" too small

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace

ORA-04030: out of process memory when trying to allocate string bytes

ORA-04031: unable to allocate string bytes of shared memory

ORA-04091: table is mutating trigger

ORA-12154: TNS:could not resolve the connect identifier specified - Oracle Error

ORA-21000:error number argument to raise_application_error is out of range

ORA-28009: connection to sys should be as sysdba or sysoper

PLS-00222: no function with name exists

ORA-01422: exact fetch returns more than requested number of rows

Share on Google Plus

About Mindsforest