Oracle Error Message ORA-00000 to ORA-000100

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