Troubleshooting Oracle Error Codes

Table describes the Oracle error codes, cause, and action.

Error code

Cause

Action

ORA-00018: maximum number of sessions exceeded

All session state objects are in use.

Increase the value of the SESSIONS initialization parameter.

ORA-00019: maximum number of session licenses exceeded

All licenses are in use.

Increase the value of the LICENSE MAX SESSIONS initialization parameter.

ORA-00020: maximum number of processes (string) exceeded

All process state objects are in use.

Increase the value of the PROCESSES initialization parameter.