Welcome to the Technical Portal: ORA-00000 to ORA-00025

ORA Code Code Description Cause Action
ORA-00000 Normal and Successful Completion Normal Exit None
ORA-00001 Unique Constraint An update or insert statement has tried to insert a duplicate key Either remove the unique restriction or don't insert the key
ORA-00002 Message 2 not found;  product=RDBMS; facility=ORA    
ORA-00003 Message 3 not found;  product=RDBMS; facility=ORA    
ORA-00004 Message 4 not found;  product=RDBMS; facility=ORA    
ORA-00005 Message 5 not found;  product=RDBMS; facility=ORA
 
   
ORA-00006 Message 6 not found;  product=RDBMS; facility=ORA    
ORA-00007 Message 7 not found;  product=RDBMS; facility=ORA    
ORA-00008 Message 8 not found;  product=RDBMS; facility=ORA    
ORA-00009 Message 9 not found;  product=RDBMS; facility=ORA    
ORA-00010 Message 10 not found;  product=RDBMS; facility=ORA    
ORA-00011 Message 11 not found;  product=RDBMS; facility=ORA    
ORA-00012 Message 12 not found;  product=RDBMS; facility=ORA    
ORA-00013 Message 13 not found;  product=RDBMS; facility=ORA    
ORA-00014 Message 14 not found;  product=RDBMS; facility=ORA    
ORA-00015 Message 15 not found;  product=RDBMS; facility=ORA    
ORA-00016 Message 16 not found;  product=RDBMS; facility=ORA    
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 exceeded The maximum number processes have exceeded Reduce the number of processes at back end
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

    Back to ORA Code Topics

 

Google