Oracle Error Messages ORA-01101 to ORA-001200

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

Oracle Error Messages ORA-01101 to ORA-001200

 

ORA-01101

database being created currently mounted by some other instance

ORA-01102

cannot mount database in EXCLUSIVE mode

ORA-01103

database name ‘string’ in control file is not ‘string’

ORA-01104

number of control files (string) does not equal string

ORA-01105

mount is incompatible with mounts by other instances

ORA-01106

database must be closed before dismounting

ORA-01107

database must be mounted for media recovery

ORA-01108

file string is in backup or media recovery

ORA-01109

database not open

ORA-01110

data file string: ‘string’

ORA-01111

name for data file string is unknown – rename to correct file

ORA-01112

media recovery not started

ORA-01113

file string needs media recovery

ORA-01114

IO error writing block to file string (block # string)

ORA-01115

IO error reading block from file string (block # string)

ORA-01116

error in opening database file string

ORA-01117

adding file ‘string’ with illegal block size: string; limit is string

ORA-01118

cannot add any more database files: limit of string exceeded

ORA-01119

error in creating database file ‘string’

ORA-01120

cannot remove online database file string

ORA-01121

cannot rename database file string – file is in use or recovery

ORA-01122

database file string failed verification check

ORA-01123

cannot start online backup; media recovery not enabled

ORA-01124

cannot recover data file string – file is in use or recovery

ORA-01125

cannot disable media recovery – file string has online backup set

ORA-01126

database must be mounted in this instance and not open in any instance

ORA-01127

database name ‘string’ exceeds size limit of string characters

ORA-01128

cannot start online backup – file string is offline

ORA-01129

user’s default or temporary tablespace does not exist

ORA-01135

file string accessed for DML/query is offline

ORA-01136

specified size of file string (string blocks) is less than original size of string blocks

ORA-01137

data file string is still in the middle of going offline

ORA-01138

database must either be open in this instance or not at all

ORA-01139

RESETLOGS option only valid after an incomplete database recovery

ORA-01140

cannot end online backup – all files are offline or readonly

ORA-01141

error renaming data file string – new file ‘string’ not found

ORA-01142

cannot end online backup – none of the files are in backup

ORA-01143

cannot disable media recovery – file string needs media recovery

ORA-01144

File size (string blocks) exceeds maximum of string blocks

ORA-01145

offline immediate disallowed unless media recovery enabled

ORA-01146

cannot start online backup – file string is already in backup

ORA-01147

SYSTEM tablespace file string is offline

ORA-01148

cannot refresh file size for datafile string

ORA-01149

cannot shutdown – file string has online backup set

ORA-01150

cannot prevent writes – file string has online backup set

ORA-01151

use media recovery to recover block, restore backup if needed

ORA-01152

file string was not restored from a sufficiently old backup

ORA-01153

an incompatible media recovery is active

ORA-01154

database busy. Open, close, mount, and dismount not allowed now

ORA-01155

the database is being opened, closed, mounted or dismounted

ORA-01156

recovery or flashback in progress may need access to files

ORA-01157

cannot identify/lock data file string – see DBWR trace file

ORA-01158

database string already mounted

ORA-01159

file is not from same database as previous files – wrong database id

ORA-01160

file is not a string

ORA-01161

database name string in file header does not match given name of string

ORA-01162

block size string in file header does not match configured block sizes

ORA-01163

SIZE clause indicates string (blocks), but should match header string

ORA-01164

MAXLOGFILES may not exceed string

ORA-01165

MAXDATAFILES may not exceed string

ORA-01166

file number string is larger than string (string)

ORA-01167

two files are the same file/group number or the same file

ORA-01168

physical block size string does not match size string of other members

ORA-01169

DATAFILE number 1 not found. Must be present

ORA-01170

file not found ‘string’

ORA-01171

datafile string going offline due to error advancing checkpoint

ORA-01172

recovery of thread string stuck at block string of file string

ORA-01173

data dictionary indicates missing data file from system tablespace

ORA-01174

DB_FILES is string buts needs to be string to be compatible

ORA-01175

data dictionary has more than the string files allowed by the instance

ORA-01176

data dictionary has more than the string files allowed by the controlfie

ORA-01177

data file does not match dictionary – probably old incarnation

ORA-01178

file string created before last CREATE CONTROLFILE, cannot recreate

ORA-01179

file string does not exist

ORA-01180

can not create datafile 1

ORA-01181

file string created before last known RESETLOGS, cannot recreate

ORA-01182

cannot create database file string – file is in use or recovery

ORA-01183

cannot mount database in SHARED mode

ORA-01184

logfile group string already exists

ORA-01185

logfile group number string is invalid

ORA-01186

file string failed verification tests

ORA-01187

cannot read from file string because it failed verification tests

ORA-01188

The block size specified string does not match header block size string

ORA-01189

file is from a different RESETLOGS than previous files

ORA-01190

control file or data file string is from before the last RESETLOGS

ORA-01191

file string is already offline – cannot do a normal offline

ORA-01192

must have at least one enabled thread

ORA-01193

file string is not the same file seen at start of recovery

ORA-01194

file string needs more recovery to be consistent

ORA-01195

online backup of file string needs more recovery to be consistent

ORA-01196

file string is inconsistent due to a failed media recovery session

ORA-01197

thread string only contains one log

ORA-01198

must specify size for log file if RESETLOGS

ORA-01199

file string is not in online backup mode

ORA-01200

actual file size of string is smaller than correct size of string blocks