Home > Oracle News > Fast Guide: Solving common Oracle errors
Oracle News:
EMAIL THIS LICENSING & REPRINTS

Fast Guide: Solving common Oracle errors

By SearchOracle.com editorial team
15 Apr 2008 | SearchOracle.com

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

Stumped 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.

TABLE OF CONTENTS
   Resources for working with errors
   ORA-00000 - ORA-01999
   ORA-02000 - ORA-03999
   ORA-04000 - ORA-05999
   ORA-06000 - ORA-07999
   ORA-08000 - ORA-11999
   ORA-12000 - ORA-13999
   ORA-14000 - ORA-23999
   ORA-24000 - ORA-25999
   ORA-26000 - ORA-27999
   ORA-28000 - ORA-30100
   Other error messages
   For more information


General information about working with errors
[ Return to Table of Contents ]

  • Where to get a complete list of all ORA errors
  • Capturing errors from merge statement
  • Perform a check or wait for an error?
  • What should monitoring reports identify
  • Oracle alert log miner
  • Logging the command that caused server error
  • Catching error code that arises in PL/SQL
  • Advanced error checking using a trigger


  • ORA-00000 - ORA-01999
    [ Return to Table of Contents ]

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

  • Is there a way to stop a rollback?
  • Error trying to rebuild index after cancelled transaction
  • How long does a rollback take?
  • Identifying locks to resolve ORA-01658 and ORA-00054 errors
  • ORA-00054 error with shell scripts

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

  • Deadlock error when a specific batch process runs in parallel

    ORA-00200: controlfile could not be created
    Solutions:

  • Avoiding Oracle errors
  • ORA-00235: controlfile fixed table inconsistent due to concurrent update
    Solutions:

  • Using the RMAN level 0 hot backup process

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

  • Errors causing Oracle instance to shut down
  • Receiving ORA-313 and ORA-312 errors when trying to open database

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

  • Receiving ORA-313 and ORA-312 errors when trying to open database

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

  • Getting Oracle errors -- database and Web site are down
  • ORA-00321: ORACLE_HOME Redo1.log
    Solutions:

  • Getting Oracle errors -- database and Web site are down
  • Errors causing Oracle instance to shut down

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

  • Why am I getting the ORA-00381 error when initializing the parameter?
  • ORA-00396: error string required fallback to single-pass recovery
    Solutions:

  • ORA-00396 and ORA-00397 while loading data

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

  • ORA-00396 and ORA-00397 while loading data

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

  • ORA-00406 when trying to create a function index
  • ORA-00439: feature not enabled: string
    Solutions:

  • Creating a table partition
  • Managed standby error in ARCHIVE MODE
  • Problems with installation of Partitioning

    ORA-00510: internal limit restriction exceeded
    Solutions:

  • Is the number of processes causing listener error?
  • ORA-00600: internal error
    Solutions:

  • System timing out writing to control file
  • Error when updating table in Oracle 8i
  • "Disconnection forced" message
  • ORA-00604: error occurred at recursive SQL level string
    Solutions:

  • Table update fails at recursive SQL level 2
  • Recursive SQL error when using Web app
  • Errors executing Oracle recursive query
  • Getting ORA-00604 error when connecting to database user
  • ORA-00604: error with recursive SQL
  • Unexplained daily errors

    ORA-00903: invalid table name
    Solutions:

  • Trigger error in SQL*Plus
  • ORA-00904: invalid column name
    Solutions:

  • Error accessing all SQL Server fields in Oracle environment
  • Getting invalid column name without access to system tables
  • Error viewing records in table that has abstract column datatype
  • "Invalid column name" error
  • Error on "select timestamp" command
  • SQL execution error ORA-00904

    0RA-00922: missing or invalid option
    Solutions:

  • Substitution variables
  • ORA-00932: inconsistent datatypes
    Solutions:

  • Help creating a script from a view
  • UNION of two Oracle8i views with CLOBs
  • How to get the lengths of values in "long" datatype
  • Unexplained daily errors

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

  • Export errors on Solaris
  • Export errors on Linux
  • Oracle9i R1 allows any user to access any table
  • Errors with export command
  • Unable to select or drop a table

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

  • Installing the recovery catalog from RMAN prompt
  • ORA-00959: tablespace 'string' does not exist
    Solutions:

  • Importing a table that contains LOB segments
  • ORA-00980: synonym translation is no longer valid
    Solutions:

  • Information on ORA-00980
  • ORA-01000: Maximum open cursors exceeded
    Solutions:

  • Errors executing Oracle recursive query
  • ORA-01000 errors on Windows XP

    ORA-01002: fetch out of sequence
    Solutions:

  • ORA-01002 error when trying to describe a table
  • Resolving the ORA-01002 error #1
  • Resolving the ORA-01002 error #2
  • ORA-01017: Invalid username/password
    Solutions:

  • Error when trying to restore a specific table
  • "Invalid username/password" error
  • ORA-01017 error when connecting through Windows XP client
  • Unable to log in to database from desktop

    ORA-01031: insufficient privileges
    Solutions:

  • Trouble inserting large CLOB
  • Password file generation
  • Creating a function-based index
  • "Insufficient privileges" error
  • Logging in to a test database
  • ORA-01031: insufficient privileges trying to restore a database

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

  • Database stopped, showing multiple error messages
  • Getting ORA-01033 when logging in to 9i application
  • Restoring default database in 8i
  • Encountering error while cloning a production database
  • Initialization or shutdown in progress
  • ORA-01033 error when taking backup

    ORA-01034: ORACLE not available
    Solutions:

  • After starting SQL*Plus after 9i install
  • On Linux Fedora Core 2
  • When rebooting 9i
  • Errors during reboot
  • Error accessing database after migration to 9.2.0.3
  • Errors connecting Oracle through SQL*Plus
  • Domain name changes causing error
  • Trouble getting two database instances running
  • Error when starting Oracle
  • Resolving the ORA-01034 error
  • Oracle not available after installing 8i on WinXP Pro
  • ORA-01034 after upgrading to version 9.2
  • ORA-01034: Oracle not available error
  • Resolving the "ORA-01034: ORACLE not available" error
  • "Oracle not available" error
  • Can't log in to database from SQL*Plus
  • Error with tnsping
  • ORA-01034 and ORA-27101 on trying to log in to database
  • Receiving "Oracle is not available" error after restart
  • Receiving ORA-01034 error while connecting
  • Suddenly getting ORA-01034 and ORA-27101
  • Unable to connect to server with Oracle8i
  • Why won't the mount and open happen automatically?

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

  • Insufficient privileges error ORA-01039

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

  • ORA-1053 error after 8i installation on Windows 2003

    ORA-01078: failure in processing system parameters
    Solutions:

  • Help with error ORA-01078
  • ORA-01081: cannot start already-running ORACLE - shut it down first
    Solutions:

  • Problems starting one of two databases on same server

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

  • When opening database
  • Cause of ORA-1089 error
  • Error when stopping/starting Oracle SID
  • ORA-01092: Oracle instance terminated. Disconnection forced
    Solutions:

  • Database Configuration Assistant not executing
  • Oracle installed, but error when creating db
  • ORA-01092 error during 9i installation
  • ORA-01092 error while executing database creation command
  • ORA-01092 on creating a new database

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

  • Database stopped, showing multiple error messages
  • Input/output errors
  • ORA-01110 error when not in archive log mode
  • ORA-01113 and ORA-01110 errors on restarting database
  • Too many open files error message

    ORA-01113: file n needs media recovery
    Solutions:

  • ORA-01113 and ORA-01110 errors on restarting database

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

  • Database stopped, showing multiple error messages
  • User datafile needs media recovery
  • Input/output errors
  • Too many open files error message

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

  • Database crash during hot backup
  • ORA-1122 error and huge TEMP tablespace

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

  • ORA-01033 error when taking backup

    ORA-01158: database %s already mounted
    Solutions:

  • Cloning a production database into a development server

    ORA-01403: no data found
    Solutions:

  • Errors during import of a dump file

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

  • ORA-1452 error after export/import

    ORA-01501: CREATE DATABASE failed
    Solutions:

  • Avoiding Oracle errors
  • ORA-01503: CREATE CONTROLFILE failed
    Solutions:

  • Cloning a production database into a development server

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

  • Errors when importing from same version
  • ORA-01543: tablespace 'TEMP' already exists
    Solutions:

  • Errors when importing from same version
  • ORA-01555: snapshot too old: rollback segment number string with name "string" too small
    Solutions:

  • Help with ORA-01555: snapshot too old
  • Help with ORA-01555 during export
  • Exporting a table that is constantly updated
  • RBS monitor to catch ORA-01555 errors
  • Can't escape ORA-01555 error!
  • Cause of "snapshot too old" error
  • Errors and slowness during export

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

  • Errors and slowness during export

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

  • Errors and slowness during export

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

  • Resolving the ORA-01630 error
  • ORA-01650: unable to extend rollback segment string by string in tablespace string
    Solutions:

  • Errors and slowness during export

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

  • Help with ORA-01652 error -- unable to extend temp segment
  • Solving ORA-1652 error
  • High IO program is throwing ORA-01652 errors
  • ORA-01652: add or resize datafile?
  • Resolving errors ORA-01652 and ORA-04031
  • Errors during building of tables
  • ORA-01652 error when running query to delete large amount of data
  • Questions about ORA-1652 error

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

  • Action can't be handled

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

  • Identifying locks to resolve ORA-01658 and ORA-00054 errors

    ORA-01756: quoted string not properly terminated
    Solutions:

  • Error inserting data into customer table
  • Error inserting single quote into string

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

  • Adding a new NOT NULL field to an existing table
  • ORA-01940: cannot drop a user that is currently connected
    Solutions:

  • Deleting a user from a tablespace


    ORA-02000 - ORA-03999
    [ Return to Table of Contents ]

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

  • Why am I getting the ORA-02019 error?

    ORA-02035: illegal bundled operation combination
    Solutions:

  • When does 02035 error occur?

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

  • Problem with dblink: ORA-02085
  • Setting GLOBAL_NAMES to false to use dblink
  • Error after creating DBLink

    ORA-02201: sequence not allowed here
    Solutions:

  • Can triggers be applied to sequence objects?
  • ORA-02266: unique/primary keys in table referenced by enabled foreign keys
    Solutions:

  • Truncate tables using PL/SQL
  • ORA-02449: unique/primary keys in table referenced by foreign keys
    Solutions:

  • Error when dropping objects
  • Find all the 'son' constraints
  • ORA-03001: unimplemented feature
    Solutions:

  • Solving ORA-03001
  • ORA-03113: end-of-file on communication channel
    Solutions:

  • Whenever the client is idle for five minutes
  • When trying to start up