Oracle Error Messages ORA-01501 to ORA-001700

In this post, we will be listing all the Oracle error messages or error codes from ORA-01501 to ORA-001700.

Oracle Error Messages ORA-01501 to ORA-001700

 

ORA-01501

CREATE DATABASE failed

ORA-01502

index ‘string.string’ or partition of such index is in unusable state

ORA-01503

CREATE CONTROLFILE failed

ORA-01504

database name ‘string’ does not match parameter db_name ‘string’

ORA-01505

error in adding log files

ORA-01506

missing or illegal database name

ORA-01507

database not mounted

ORA-01508

cannot create database; error in file ‘string’ at line string

ORA-01509

specified name ‘string’ does not match actual ‘string’

ORA-01510

error in deleting log files

ORA-01511

error in renaming log/data files

ORA-01512

error renaming log file string – new file string not found

ORA-01513

invalid current time returned by operating system

ORA-01514

error in log specification: no such log

ORA-01515

error dropping log group string: no such log

ORA-01516

nonexistent log file, data file, or temporary file “string”

ORA-01517

log member: ‘string’

ORA-01518

CREATE DATABASE must specify more than one log file

ORA-01519

error while processing file ‘string’ near line string

ORA-01520

number of data files to add (string) exceeds limit of string

ORA-01521

error in adding data files

ORA-01522

file ‘string’ to be renamed does not exist

ORA-01523

cannot rename data file to ‘string’ – file already part of database

ORA-01524

cannot create data file as ‘string’ – file already part of database

ORA-01525

error in renaming data files

ORA-01526

error in opening file ‘string’

ORA-01527

error while reading file

ORA-01528

EOF while processing SQL statement

ORA-01529

error closing file ‘string’

ORA-01530

a database already mounted by the instance

ORA-01531

a database already open by the instance

ORA-01532

cannot create database; instance being started elsewhere

ORA-01533

cannot rename file ‘string’; file does not belong to tablespace

ORA-01534

rollback segment ‘string’ doesn’t exist

ORA-01535

rollback segment ‘string’ already exists or given name has prefix _SYSSMU

ORA-01536

space quota exceeded for tablespace ‘string’

ORA-01537

cannot add file ‘string’ – file already part of database

ORA-01538

failed to acquire any rollback segment

ORA-01539

tablespace ‘string’ is not online

ORA-01540

tablespace ‘string’ is not offline

ORA-01541

system tablespace cannot be brought offline; shut down if necessary

ORA-01542

tablespace ‘string’ is offline, cannot allocate space in it

ORA-01543

tablespace ‘string’ already exists

ORA-01544

cannot drop system rollback segment

ORA-01545

rollback segment ‘string’ specified not available

ORA-01546

tablespace contains active rollback segment ‘string’

ORA-01547

warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01548

active rollback segment ‘string’ found, terminate dropping tablespace

ORA-01549

tablespace not empty, use INCLUDING CONTENTS option

ORA-01550

cannot drop system tablespace

ORA-01551

extended rollback segment, pinned blocks released

ORA-01552

cannot use system rollback segment for non-system tablespace ‘string’

ORA-01553

MAXEXTENTS must be no smaller than the string extents currently allocated

ORA-01554

transaction concurrency limit reached reason:string params:string, string

ORA-01555

snapshot too old: rollback segment number string with name “string” too small

ORA-01556

MINEXTENTS for rollback segment must be greater than 1

ORA-01557

rollback segment extents must be at least string blocks

ORA-01558

out of transaction ID’s in rollback segment string

ORA-01559

MAXEXTENTS for rollback segment must be greater than 1

ORA-01560

LIKE pattern contains partial or illegal character

ORA-01561

failed to remove all objects in the tablespace specified

ORA-01562

failed to extend rollback segment number string

ORA-01563

rollback segment is PUBLIC, need to use the keyword PUBLIC

ORA-01564

rollback segment is not PUBLIC

ORA-01565

error in identifying file ‘string’

ORA-01566

file specified more than once in ALTER DATABASE

ORA-01567

dropping log string would leave less than 2 log files for instance string (thread string)

ORA-01568

cannot set space quota on PUBLIC

ORA-01569

data file too small for system dictionary tables

ORA-01570

MINEXTENTS must be no larger than the string extents currently allocated

ORA-01571

redo version string incompatible with ORACLE version string

ORA-01572

rollback segment ‘string’ cannot be brought online, string extents exceeded

ORA-01573

shutting down instance, no further change allowed

ORA-01574

maximum number of concurrent transactions exceeded

ORA-01575

timeout waiting for space management resource

ORA-01576

The instance string is not enabled

ORA-01577

cannot add log file ‘string’ – file already part of database

ORA-01578

ORACLE data block corrupted (file # string, block # string)

ORA-01579

write error occurred during recovery

ORA-01580

error creating control backup file string

ORA-01581

attempt to use rollback segment (string) new extent (string) which is being allocated

ORA-01582

unable to open control file for backup

ORA-01583

unable to get block size of control file to be backed up

ORA-01584

unable to get file size of control file to be backed up

ORA-01585

error identifying backup file string

ORA-01586

database must be mounted EXCLUSIVE and not open for this operation

ORA-01588

must use RESETLOGS option for database open

ORA-01589

must use RESETLOGS or NORESETLOGS option for database open

ORA-01590

number of segment free list (string) exceeds maximum of string

ORA-01591

lock held by in-doubt distributed transaction string

ORA-01592

error converting Version 7 rollback segment (string) to Oracle 8 format

ORA-01593

rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

ORA-01594

attempt to wrap into rollback segment (string) extent (string) which is being freed

ORA-01595

error freeing extent (string) of rollback segment (string))

ORA-01596

cannot specify system in string parameter

ORA-01597

cannot alter system rollback segment online or offline

ORA-01598

rollback segment ‘string’ is not online

ORA-01599

failed to acquire rollback segment (string), cache space is full

ORA-01600

at most one “string” in clause “string” of string

ORA-01601

illegal bucket size in clause “string” of string

ORA-01603

illegal grouping size in clause “string” of string

ORA-01604

illegal number range in clause “string” of string

ORA-01605

missing numbers in clause “string” of string

ORA-01606

parameter not identical to that of another mounted instance

ORA-01607

cannot add logfile to the specified instance

ORA-01608

cannot bring rollback segment ‘string’ online, its status is (string)

ORA-01609

log string is the current log for thread string – cannot drop members

ORA-01610

recovery using the BACKUP CONTROLFILE option must be done

ORA-01611

thread number string is invalid – must be between 1 and string

ORA-01612

instance string (thread string) is already enabled

ORA-01613

instance string (thread string) only has string logs – at least 2 logs required to enable.

ORA-01614

instance string (thread string) is busy – cannot enable

ORA-01615

instance string (thread string) is mounted – cannot disable

ORA-01616

instance string (thread string) is open – cannot disable

ORA-01617

cannot mount: string is not a valid thread number

ORA-01618

redo thread string is not enabled – cannot mount

ORA-01619

thread string is mounted by another instance

ORA-01620

no public threads are available for mounting

ORA-01621

cannot rename member of current log if database is open

ORA-01622

thread number must be specified – default not specific

ORA-01623

log string is current log for instance string (thread string) – cannot drop

ORA-01624

log string needed for crash recovery of instance string (thread string)

ORA-01625

rollback segment ‘string’ does not belong to this instance

ORA-01626

rollback segment number ‘string’ cannot handle more transactions

ORA-01627

rollback segment number ‘string’ is not online

ORA-01628

max # extents (string) reached for rollback segment string

ORA-01629

max # extents (string) reached saving undo for tablespace string

ORA-01630

max # extents (string) reached in temp segment in tablespace string

ORA-01631

max # extents (string) reached in table string.string

ORA-01632

max # extents (string) reached in index string.string

ORA-01633

Real Application Clusters Option needed for this operation

ORA-01634

rollback segment number ‘string’ is about to go offline

ORA-01635

rollback segment #string specified not available

ORA-01636

rollback segment ‘string’ is already online

ORA-01637

rollback segment ‘string’ is being used by another instance (#string)

ORA-01638

parameter string does not allow ORACLE version string to mount cluster database

ORA-01639

instance string has no thread assigned to it

ORA-01640

cannot make tablespace read-only with changes by in-doubt transactions

ORA-01641

tablespace ‘string’ is not online – cannot add data file

ORA-01642

begin backup not needed for read-only tablespace ‘string’

ORA-01643

system tablespace can not be made read-only

ORA-01644

tablespace ‘string’ is already read-only

ORA-01645

previous attempt to make read write is half complete

ORA-01646

tablespace ‘string’ is not read-only – cannot make read write

ORA-01647

tablespace ‘string’ is read-only, cannot allocate space in it

ORA-01648

log string is the current log of disabled instance string (thread string)

ORA-01649

operation not allowed with a backup control file

ORA-01650

unable to extend rollback segment string by string in tablespace string

ORA-01651

unable to extend save undo segment by string for tablespace string

ORA-01652

unable to extend temp segment by string in tablespace string

ORA-01653

unable to extend table string.string by string in tablespace string

ORA-01654

unable to extend index string.string by string in tablespace string

ORA-01655

unable to extend cluster string.string by string in tablespace string

ORA-01656

max # extents (string) reached in cluster string.string

ORA-01657

invalid SHRINK option value

ORA-01658

unable to create INITIAL extent for segment in tablespace string

ORA-01659

unable to allocate MINEXTENTS beyond string in tablespace string

ORA-01660

tablespace ‘string’ is already permanent

ORA-01661

tablespace ‘string’ is already temporary

ORA-01662

tablespace ‘string’ is non-empty and cannot be made temporary

ORA-01663

the contents of tablespace ‘string’ is constantly changing

ORA-01664

Transaction which has expanded the Sort Segment has aborted

ORA-01665

control file is not a standby control file

ORA-01666

control file is for a standby database

ORA-01667

cannot add any more tablespaces: limit of string exceeded

ORA-01668

standby database requires DROP option for offline of data file

ORA-01669

standby database control file not consistent

ORA-01670

new datafile string needed for standby database recovery

ORA-01671

control file is a backup, cannot make a standby control file

ORA-01672

control file may be missing files or have extra ones

ORA-01673

data file string has not been identified

ORA-01674

data file string is an old incarnation rather than current file

ORA-01675

max_commit_propagation_delay inconsistent with other instances

ORA-01676

standby file name convert of ‘string’ exceeds maximum length of string

ORA-01677

standby file name convert parameters differ from other instance

ORA-01678

parameter string must be pairs of pattern and replacement strings

ORA-01679

database is being opened

ORA-01680

unable to extend LOB segment by string in tablespace string

ORA-01681

max # extents (string) reached in LOB segment in tablespace string

ORA-01682

read-only DB cannot allocate temporary space in tablespace string

ORA-01683

unable to extend index string.string partition string by string in tablespace string

ORA-01684

max # extents (string) reached in table string.string partition string

ORA-01685

max # extents (string) reached in index string.string partition string

ORA-01686

max # files (string) reached for the tablespace string

ORA-01687

specified logging attribute for tablespace ‘string’ is same as the existing

ORA-01688

unable to extend table string.string partition string by string in tablespace string

ORA-01689

syntax error in clause “string” of string

ORA-01690

sort area size too small

ORA-01691

unable to extend lob segment string.string by string in tablespace string

ORA-01692

unable to extend lob segment string.string partition string by string in tablespace string

ORA-01693

max # extents (string) reached in lob segment string.string

ORA-01694

max # extents (string) reached in lob segment string.string partition string

ORA-01695

error converting rollback segment string to version 8.0.2

ORA-01696

control file is not a clone control file

ORA-01697

control file is for a clone database

ORA-01698

a clone database may only have SYSTEM rollback segment online

ORA-01699

tablespace ‘string’ is being imported for point in time recovery