Solving common Oracle errors guide

Solve your Oracle errors quickly and easily with help from this fast guide. It covers every expert response pertaining to Oracle errors on SearchOracle.com.

lStumped by an Oracle error? We've compiled a list of every expert response pertaining to Oracle errors on SearchOracle.com.

You've already asked the questions, now find the answers quickly and easily in the guide below.

If the error you're dealing with is not listed, or if your dilemma is not specifically addressed, just ask one of our experts for help and we'll add the response to this ever-growing guide to common Oracle errors.

General information about working with errors

ORA-00000 - ORA-01999

ORA-00054: resource busy and acquire with NOWAIT specified
Solutions:

ORA-00060: deadlock detected while waiting for resource
Solutions:

ORA-00200: controlfile could not be created
Solutions:

ORA-00235: controlfile fixed table inconsistent due to concurrent update
Solutions:

ORA-00312: online log string thread string: 'string'
Solutions:

ORA-00313: open failed for members of log group string of thread string
Solutions:

ORA-00320: can not read file header from log 1 thread 1
Solutions:

ORA-00321: ORACLE_HOME Redo1.log
Solutions:

ORA-00381: cannot use both new and old parameters for buffer cache size specification
Solutions:

ORA-00396: error string required fallback to single-pass recovery
Solutions:

ORA-00397: lost write detected for file string, block string
Solutions:

ORA-00406: COMPATIBLE parameter needs to be string or greater
Solutions:

ORA-00439: feature not enabled: string
Solutions:

ORA-00510: internal limit restriction exceeded
Solutions:

ORA-00600: internal error
Solutions:

ORA-00604: error occurred at recursive SQL level string
Solutions:

ORA-00903: invalid table name
Solutions:

ORA-00904: invalid column name
Solutions:

ORA-00922: missing or invalid option
Solutions:

ORA-00932: inconsistent datatypes
Solutions:

ORA-00942: table or view does not exist
Solutions:

ORA-00955: name is already used by exsisting object
Solutions:

ORA-00959: tablespace 'string' does not exist
Solutions:

ORA-00980: synonym translation is no longer valid
Solutions:

ORA-01000: Maximum open cursors exceeded
Solutions:

ORA-01002: fetch out of sequence
Solutions:

ORA-01017: Invalid username/password
Solutions:

ORA-01031: insufficient privileges
Solutions:

ORA-01033: ORACLE initialization or shutdown in progress
Solutions:

ORA-01034: ORACLE not available
Solutions:

ORA-01039: insufficient privilege on underlying objects of the view
Solutions:

ORA-01053: user storage address cannot be read
Solutions:

ORA-01078: failure in processing system parameters
Solutions:

ORA-01081: cannot start already-running ORACLE - shut it down first
Solutions:

ORA-01089: immediate shutdown in progress - no operations are permitted
Solutions:

ORA-01092: Oracle instance terminated. Disconnection forced
Solutions:

ORA-01110: data file string: 'string'
Solutions:

ORA-01113: file n needs media recovery
Solutions:

ORA-01115: IO error reading block from file string (block # string)
Solutions:

ORA-01122: database file string failed verification check
Solutions:

ORA-01157: cannot identify/lock data file string - see DBWR trace file
Solutions:

ORA-01158: database %s already mounted
Solutions:

ORA-01403: no data found
Solutions:

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Solutions:

ORA-01501: CREATE DATABASE failed
Solutions:

ORA-01503: CREATE CONTROLFILE failed
Solutions:

ORA-01535: rollback segment 'name' already exists
Solutions:

ORA-01543: tablespace 'TEMP' already exists
Solutions:

ORA-01555: snapshot too old: rollback segment number string with name "string" too small
Solutions:

ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)
Solutions:

ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed
Solutions:

ORA-01630: max # extents (string) reached in temp segment in tablespace string
Solutions:

ORA-01650: unable to extend rollback segment string by string in tablespace string
Solutions:

ORA-01652: unable to extend temp segment by string in tablespace string
Solutions:

ORA-01653: unable to extend table xxx by xxx
Solutions:

ORA-01658: unable to create INITIAL extent for segment in tablespace string
Solutions:

ORA-01756: quoted string not properly terminated
Solutions:

ORA-01758: table must be empty to add mandatory (NOT NULL) column
Solutions:

ORA-01940: cannot drop a user that is currently connected
Solutions:

ORA-02000 - ORA-03999

ORA-02019: connection description for remote database not found
Solutions:

ORA-02035: illegal bundled operation combination
Solutions:

ORA-02085: database link string connects to string
Solutions:

ORA-02201: sequence not allowed here
Solutions:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys
Solutions:

ORA-02449: unique/primary keys in table referenced by foreign keys
Solutions:

ORA-03001: unimplemented feature
Solutions:

ORA-03113: end-of-file on communication channel
Solutions:

ORA-03114: not connected to ORACLE
Solutions:

ORA-03121: no interface driver connected
Solutions:

ORA-03232: unable to allocate an extent of x blocks from tablespace x
Solutions:

ORA-04000 - ORA-05999

ORA-04030: out of process memory
Solutions:

ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
Solutions:

ORA-04043: object string does not exist
Solutions:

ORA-04052: error occurred when looking up remote object name
Solutions:

ORA-04076: invalid NEW or OLD specification
Solutions:

ORA-04091: table string.string is mutating, trigger/function may not see it
Solutions:

ORA-04098: trigger 'SYSTEM.LOG_ERRORS_TRIG' is invalid and failed re-validation
Solutions:

ORA-06000 - ORA-07999

ORA-06401: NETCMN: invalid driver designator
Solutions:

ORA-06508: PL/SQL: could not find program unit being called
Solutions:

ORA-06512: Backtrace message as the stack is unwound by unhandled exceptions
Solutions:

ORA-06532: Subscript outside of limit
Solutions:

ORA-06544: PL/SQL: internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
Solutions:

ORA-06550: line string, column string:string
Solutions:

ORA-06553: PLS-string: string
Solutions:

ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
Solutions:

ORA-07445: exception encountered: core dump [10]
Solutions:

ORA-08000 - ORA-11999

ORA-10033: sort run information (SRD*/SRS*)
Solutions:

ORA-10902: disable seghdr conversion for ro operation
Solutions:

ORA-12000 - ORA-13999

ORA-12154: TNS-12154: TNS:could not resolve service name
Solutions:

ORA-12203: TNS-12203: TNS:unable to connect to destination
Solutions:

ORA-12502: TNS-12502: TNS:listener received no CONNECT_DATA from client
Solutions:

ORA-12505: TNS-12505: TNS:listener could not resolve SID given in connect descriptor
Solutions:

ORA-12514: TNS-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Solutions:

ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Solutions:

ORA-12531: TNS-12531: TNS:cannot allocate memory
Solutions:

ORA-12533: TNS-12533: TNS:illegal ADDRESS parameters
Solutions:

ORA-12535: TNS-12535: TNS:operation timed out
Solutions:

ORA-12537: TNS connection closed
Solutions:

ORA-12541: TNS: no listener
Solutions:

ORA-12542: TNS: address already in use
Solutions:

ORA-12545: TNS-12545: Connect failed because target host or object does not exist
Solutions:

ORA-12546: TNS: permission denied
Solutions:

ORA-12560: TNS-12560: TNS:protocol adapter error
Solutions:

ORA-12571: TNS-12571: TNS:packet writer failure
Solutions:

ORA-12638: Credential retrieval failed
Solutions:

ORA-12640: TNS-12640: Authentication adapter initialization failed
Solutions:

ORA-12663: TNS-12663: Services required by client not available on the server
Solutions:

ORA-12801: error signaled in parallel query server string
Solutions:

ORA-14000 - ORA-23999

ORA-1650: unable to extend rollback segment R05 by 512 in tablespace RBS Failure to extend rollback segment 6 because of 1650 condition.
Solutions:

ORA-24000 - ORA-25999

ORA-24008: queue table string.string must be dropped first
Solutions:

ORA-24801: illegal parameter value in OCI lob function
Solutions:

ORA-25143: default storage clause is not compatible with allocation policy
Solutions:

ORA-25150: ALTERING of extent parameters not permitted
Solutions:

ORA-26000 - ORA-27999

ORA-27038: skgfrcre: file exists
Solutions:

ORA-27072: skgfdisp: I/O error
Solutions:

ORA-27091: skgfqio: unable to queue I/O
Solutions:

ORA-27101: shared memory realm does not exist
Solutions:

ORA-27123: unable to attach to shared memory segment
Solutions:

ORA-27125: unable to create shared memory segment
Solutions:

ORA-28000 - ORA-30100

ORA-28030: Server encountered problems accessing LDAP directory service
Solutions:

ORA-28547: connection to server failed, probable Net8 admin error
Solutions:

ORA-29516: Aurora assertion failure: string
Solutions:

ORA-30036: unable to extend segment by string in undo tablespace 'string'
Solutions:

Other error messages

SQL*Plus error messages

SP2-0678: Column or attribute type can not be displayed by SQL*Plus
Solutions:

Import error messages

IMP-00009: abnormal end of export file Solutions:

IMP-00010: not a valid export file, header failed verification
Solutions:

IMP-00015: following statement failed because the object already exists
Solutions:

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
Solutions:

IMP-00028: partial import of previous table rolled back
Solutions:

Export error messages

EXP-00002: error in writing to export file
Solutions:

ORADIM command syntax errors

DIM-00019: Create Service Error
Solutions:

More on solving Oracle errors

Avoid errors when copying Oracle Database 9i to a new server

Find out why this error kept TNS listener from connecting

Learn to use Oracle Data Recovery Advisory for database backup and recovery

This was first published in April 2008

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close