In this post, we will be listing all the Oracle error messages or error codes from ORA-00000 to ORA-000100.
Oracle Error Message ORA-00000 to ORA-000100
ORA-00000 |
normal, successful completion |
ORA-00001 |
unique constraint (string.string) violated |
ORA-00017 |
session requested to set trace event |
ORA-00018 |
maximum number of sessions exceeded |
ORA-00019 |
maximum number of session licenses exceeded |
ORA-00020 |
maximum number of processes (string) exceeded |
ORA-00021 |
session attached to some other process; cannot switch session |
ORA-00022 |
invalid session ID; access denied |
ORA-00023 |
session references process private memory; cannot detach session |
ORA-00024 |
logins from more than one process not allowed in single-process mode |
ORA-00025 |
failed to allocate string |
ORA-00026 |
missing or invalid session ID |
ORA-00027 |
cannot kill current session |
ORA-00028 |
your session has been killed |
ORA-00029 |
session is not a user session |
ORA-00030 |
User session ID does not exist. |
ORA-00031 |
session marked for kill |
ORA-00032 |
invalid session migration password |
ORA-00033 |
current session has empty migration password |
ORA-00034 |
cannot string in current PL/SQL session |
ORA-00036 |
maximum number of recursive SQL levels (string) exceeded |
ORA-00037 |
cannot switch to a session belonging to a different server group |
ORA-00038 |
Cannot create session: server group belongs to another user |
ORA-00039 |
error during periodic action |
ORA-00040 |
active time limit exceeded – call aborted |
ORA-00041 |
active time limit exceeded – session terminated |
ORA-00042 |
Unknown Service name string |
ORA-00043 |
remote operation failed |
ORA-00044 |
timed_statistics must be TRUE when statistics_level is not BASIC |
ORA-00050 |
operating system error occurred while obtaining an enqueue |
ORA-00051 |
timeout occurred while waiting for a resource |
ORA-00052 |
maximum number of enqueue resources (string) exceeded |
ORA-00053 |
maximum number of enqueues exceeded |
ORA-00054 |
resource busy and acquire with NOWAIT specified or timeout expired |
ORA-00055 |
maximum number of DML locks exceeded |
ORA-00056 |
DDL lock on object ‘string.string’ is already held in an incompatible mode |
ORA-00057 |
maximum number of temporary table locks exceeded |
ORA-00058 |
DB_BLOCK_SIZE must be string to mount this database (not string) |
ORA-00059 |
maximum number of DB_FILES exceeded |
ORA-00060 |
deadlock detected while waiting for resource |
ORA-00061 |
another instance has a different DML_LOCKS setting |
ORA-00062 |
DML full-table lock cannot be acquired; DML_LOCKS is 0 |
ORA-00063 |
maximum number of log files exceeded string |
ORA-00064 |
object is too large to allocate on this O/S (string,string,string) |
ORA-00065 |
initialization of FIXED_DATE failed |
ORA-00066 |
SID ‘string’ contains an illegal character or is too long |
ORA-00067 |
invalid value string for parameter string; must be at least string |
ORA-00068 |
invalid value string for parameter string, must be between string and string |
ORA-00069 |
cannot acquire lock — table locks disabled for string |
ORA-00070 |
command string is not valid |
ORA-00071 |
process number must be between 1 and string |
ORA-00072 |
process “string” is not active |
ORA-00073 |
command string takes between string and string argument(s) |
ORA-00074 |
no process has been specified |
ORA-00075 |
process “string” not found in this instance |
ORA-00076 |
dump string not found |
ORA-00077 |
dump string is not valid |
ORA-00078 |
cannot dump variables by name |
ORA-00079 |
variable string not found |
ORA-00080 |
invalid global area specified by level string |
ORA-00081 |
address range [string, string) is not readable |
ORA-00082 |
memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring |
ORA-00083 |
warning: possibly corrupt SGA mapped |
ORA-00084 |
global area must be PGA, SGA, or UGA |
ORA-00085 |
current call does not exist |
ORA-00086 |
user call does not exist |
ORA-00087 |
command cannot be executed on remote instance |
ORA-00088 |
command cannot be executed by shared server |
ORA-00089 |
invalid instance number in ORADEBUG command |
ORA-00090 |
failed to allocate memory for cluster database ORADEBUG command |
ORA-00091 |
LARGE_POOL_SIZE must be at least string |
ORA-00092 |
LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC |
ORA-00093 |
string must be between string and string |
ORA-00094 |
string requires an integer value |
ORA-00096 |
invalid value string for parameter string, must be from among string |
ORA-00097 |
use of Oracle SQL feature not in SQL92 string Level |
ORA-00098 |
creating or mounting the database requires a parameter file |
ORA-00099 |
warning: no parameter file specified for string instance |
ORA-00100 |
no data found |