Oracle错误代码超级大全

ORACLE错误代码超级大全

ORA-00000: normal, successful completion

原因：Normal exit.

解决：None.

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

原因：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.

解决：Either remove the unique restriction or do not insert the key.

ORA-00017: session requested to set trace event

原因：The current session was requested to set a trace event by another session.

解决：This is used internally; no action is required.

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.

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

原因：The user session is currently used by others.

解决：Do not switch to a session attached to some other process.

ORA-00022: invalid session ID; access denied

原因：Either the session specified does not exist or the caller does not have the privilege to access it.

解决：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

原因：An attempt was made to detach the current session when it contains references to process private memory.

解决：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

原因：Trying to login more than once from different processes for ORACLE started in single-process mode.

解决：Logoff from the other process.

ORA-00025: failed to allocate string

原因：Out of memory.

解决：Restart with larger sga heap.

ORA-00026: missing or invalid session ID

原因：Missing or invalid session ID string for ALTER SYSTEM KILL SESSION.

解决：Retry with a valid session ID.

ORA-00027: cannot kill current session

原因：Attempted to use ALTER SYSTEM KILL SESSION to kill the current session.

解决：None.

ORA-00028: your session has been killed

原因：A privileged user has killed your session and you are no longer logged on to the database. 解决：Login again if you wish to continue working.

ORA-00029: session is not a user session

原因：The session ID specified in an ALTER SYSTEM KILL SESSION command was not a user session (for example, recursive, etc.).

解决：Retry with a user session ID.

ORA-00030: User session ID does not exist.

原因：The user session ID no longer exists, probably because the session was logged out.

解决：Use a valid session ID.

ORA-00031: session marked for kill

原因：The session specified in an ALTER SYSTEM KILL SESSION command cannot be killed immediately (because it is rolling back or blocked on a network operation), but it has been marked for kill. This means it will be killed as soon as possible after its current uninterruptable operation is done.

解决：No action is required for the session to be killed, but further executions of the ALTER SYSTEM KILL SESSION command on this session may cause the session to be killed sooner. ORA-00032: invalid session migration password

原因：The session migration password specified in a session creation call was invalid (probably too long).

解决：Retry with a valid password (less than 30 chars).

ORA-00033: current session has empty migration password

原因：An attempt was made to detach or clone the current session and it has an empty migration password. This is not allowed.

解决：Create the session with a non-empty migration password.

ORA-00034: cannot string in current PL/SQL session

原因：An attempt was made to issue a commit or rollback from a PL/SQL object (procedure, function, package) in a session that has this disabled (by "alter session disable commit in procedure")

解决：Enable commits from PL/SQL in this session, or do not attempt to use commit or rollback in PL/SQL when they are disabled in the current session.

ORA-00036: maximum number of recursive SQL levels (string) exceeded

原因：An attempt was made to go more than the specified number of recursive SQL levels.

解决：Remove the recursive SQL, possibly a recursive trigger.

ORA-00037: cannot switch to a session belonging to a different server group

原因：An attempt was made to switch to a session in a different server group. This is not allowed. 解决：Make sure the server switches to a session that belongs to its server group.

ORA-00038: Cannot create session: server group belongs to another user

原因：An attempt was made to create a non-migratable session in a server group that is owned by