ORA-00000:
normal, successful completion
Cause:
Normal exit.
Action:
None
ORA-00001
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.
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.
ORA-00018:
maximum number of sessions exceeded
Cause:
All session state objects are in use.
Action:
Increase the value of the SESSIONS initialization parameter
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
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.
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.
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.
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.
ORA-00024:
logins from more than one process not allowed in single-process mode
Cause:
Trying to login more than once from different processes for ORACLE started in single-process mode.
Action:
Logoff from the other process.
ORA-00025:
failed to allocate string
Cause:
Out of memory.
Action:
Restart with larger sga heap.
ORA-00026:
missing or invalid session ID
Cause:
Missing or invalid session ID string for ALTER SYSTEM KILL SESSION.
Action:
Retry with a valid session ID.
ORA-00027:
cannot kill current session
Cause:
Attempted to use ALTER SYSTEM KILL SESSION to kill the current session.
Action:
None.
ORA-00028:
your session has been killed
Cause:
A privileged user has killed your session and you are no longer logged on to the database.
Action:
Login again if you wish to continue working.
normal, successful completion
Cause:
Normal exit.
Action:
None
ORA-00001
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.
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.
ORA-00018:
maximum number of sessions exceeded
Cause:
All session state objects are in use.
Action:
Increase the value of the SESSIONS initialization parameter
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
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.
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.
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.
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.
ORA-00024:
logins from more than one process not allowed in single-process mode
Cause:
Trying to login more than once from different processes for ORACLE started in single-process mode.
Action:
Logoff from the other process.
ORA-00025:
failed to allocate string
Cause:
Out of memory.
Action:
Restart with larger sga heap.
ORA-00026:
missing or invalid session ID
Cause:
Missing or invalid session ID string for ALTER SYSTEM KILL SESSION.
Action:
Retry with a valid session ID.
ORA-00027:
cannot kill current session
Cause:
Attempted to use ALTER SYSTEM KILL SESSION to kill the current session.
Action:
None.
ORA-00028:
your session has been killed
Cause:
A privileged user has killed your session and you are no longer logged on to the database.
Action:
Login again if you wish to continue working.
