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

Cause: An attempt was made to detach the current session when it contains references to process private memory.

Action: A session may contain references to process memory (PGA) if it has an open network connection, a very large context area, or operating system privileges. To allow the detach, it may be necessary to close the session’s database links and/or cursors. Detaching a session with operating system privileges is always disallowed.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00022: invalid session ID; access denied

Cause: Either the session specified does not exist or the caller does not have the privilege to access it.

Action: Specify a valid session ID that you have privilege to access, that is either you own it or you have the CHANGE_USER privilege.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

Cause: The user session is currently used by others.

Action: Do not switch to a session attached to some other process.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

Cause: All process state objects are in use.

Action: Increase the value of the PROCESSES initialization parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00019: maximum number of session licenses exceeded

Cause: All licenses are in use.

Action: Increase the value of the LICENSE MAX SESSIONS initialization parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00018: maximum number of sessions exceeded

Cause: All session state objects are in use.

Action: Increase the value of the SESSIONS initialization parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00017: session requested to set trace event

Cause: The current session was requested to set a trace event by another session.

Action: This is used internally; no action is required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00001: unique constraint (string.string) violated

Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.

Action: Either remove the unique restriction or do not insert the key.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00000: normal, successful completion

Cause: Normal exit

Action: None

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/