Solving common Oracle error codes 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.

Stumped by an Oracle error? Find the answers quickly and easily in the guide below. If the error you're dealing...

with is not listed, just ask one of our experts for help and we'll add the response to this ever-growing guide to common Oracle error codes.

ORA-00000 - ORA-01999

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

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

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:

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

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:

  • Errors causing Oracle instance to shut down
  • Getting Oracle errors -- database and website are 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:

  • "Disconnection forced" message
  • System timing out writing to control file
  • Error when updating table in Oracle 8i

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

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

ORA-00903: invalid table name
Solutions:

  • Trigger error in SQL*Plus

ORA-00904: invalid column name
Solutions:

  • SQL execution error ORA-00904
  • "Invalid column name" error
  • Error on "select timestamp" command
  • 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

ORA-00922: missing or invalid option
Solutions:

  • Substitution variables

ORA-00932: inconsistent datatypes
Solutions:

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

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

  • Unable to select or drop a table
  • Errors with export command
  • Export errors on Solaris
  • Export errors on Linux
  • Oracle9i R1 allows any user to access any 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:

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

ORA-01002: fetch out of sequence
Solutions:

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:

  • Solving an ORA-1555 error in the testing database
  • 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:

  • Advice from the TechTarget community on the ORA-01652 error code
  • 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

More resources from Oracle.com

Detailed error documentation

Search for an error

ORA-02000 - ORA-03999

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

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
  • ORA-03113 when running a query
  • Error when creating a queue table
  • Problem installing Oracle on Red Hat Linux
  • Failure installing 9i Database Configuration Assistant Tool on Win2000
  • Getting end of communication error when submitting a query
  • Solving error ORA-03113
  • Archive log files generating quickly
  • ORA-03113 error when querying table
  • ORA-03113 trying to rebuild indexes
  • What is the ORA-03113 error?

ORA-03114: not connected to ORACLE
Solutions:

  • ORA-03114 causing instability to application services
  • During the initializing database step
  • Resolving the ORA-03114 error

ORA-03121: no interface driver connected
Solutions:

  • ORA-03121 while attaching database
  • What is the solution of the ORA-03121 error?

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

  • ORA-03232 error

ORA-04000 - ORA-05999

ORA-04030: out of process memory
Solutions:

  • Help with ORA-04030 -- out of process memory
  • RMAN process ran out of memory
  • ORA-04030: Out of process memory

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

  • In the job queue process
  • Recursive SQL error when using Web app
  • Consistently getting ORA-04031 error
  • Error during patch installation
  • Need fixes for ORA-04031
  • Help with ORA-4031 error
  • Resolving errors ORA-01652 and ORA-04031
  • Error when trying to reduce temp tablespace
  • Resolving a 04031 error
  • Resolving the ORA-04031 error
  • Minimizing generation of archive logs

ORA-04043: object string does not exist
Solutions:

  • Workaround for ORA-04043: Can't describe object using db_link

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

  • Error creating database link

ORA-04076: invalid NEW or OLD specification
Solutions:

  • How to solve ORA-04076 error?

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

  • Selecting rows from the same table in the trigger
  • Resolving ORA-04091
  • Workaround for the ORA-04091 error when checking ranges
  • Resolving an ORA-04091 error
  • Timestamping all rows of some tables on insert and update
  • Writing an ON INSERT trigger without encountering mutating table error

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

  • Trigger error in SQL*Plu

ORA-06000 - ORA-07999

ORA-06401: NETCMN: invalid driver designator
Solutions:

  • When trying to connect from Dreamweaver
  • When using SQL*Plus on host computer
  • Password creation in Oracle Developer 6i
  • Error using JDBC to query local database
  • Error trying to insert record through database link
  • Resovling the ORA-06401 error

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

  • Resolving the ORA-06508 error

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

  • What is ORA-06512?
  • Errors during import of a dump file
  • Problems with exp utility after migration

ORA-06532: Subscript outside of limit
Solutions:

  • New user error
  • Determining the reason for the error message

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

  • How to resolve ORA-06544

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

  • Error when calling stored procedure
  • Help with ORA-06550 error
  • Resolving error ORA-06550
  • Cause of ORA-06550 error
  • Error during export of database
  • Error when executing procedures
  • Receiving error at export command
  • Receiving ORA-06550 error
  • Ways to handle an error on an INSERT statement

ORA-06553: PLS-string: string
Solutions:

  • Error calling stored procedure from Java
  • Removing Services entries, fixing ORA-06553
  • Problems with exporting database after modifying database characterset

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

  • Help with ORA-06554 regarding package DBMS_STANDARD

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

  • SQL subquery errors

ORA-08000 - ORA-11999

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

  • ORA-10033 error won't let me connect

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

  • Cause of ORA-10902 error

ORA-12000 - ORA-13999

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

  • No connection to run Forms
  • Copying tables from one DB to another via database link
  • Configuring the TNSNAMES.ORA file
  • Connecting to 10g database after rebooting server

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

  • On home computer
  • After installing 7.3
  • Unable to install Developer 2000
  • Unable to connect to destination
  • Resolving the PDE-POCO11 ORA-12203 error
  • Problem connecting to a remote database
  • Database crash during hot backup
  • Problems connecting to database after installing Forms

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

  • Resolving the TNS-12502 error

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

  • Resolving the ORA-12505 TNS error

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

  • When trying to create db link
  • Error connecting through SQL*Plus
  • Resolving the ORA-12514 TNS listener error
  • Resolving the ORA-12514
  • Accessing an Oracle instance with SQL*Plus
  • ORA-12514 error when connecting through SQL*Plus
  • Problems accessing 10g through SQL*Plus and Enterprise Manager
  • Problems connecting after installation of 10g

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

  • ORA-12528 after shutting down and restarting instance

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

  • No new connections allowed

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

  • ORA-12533 during installation

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

  • Timed out error and slow computer performance
  • Error since converting to 9.2
  • Getting ORA-12535 since upgrade
  • "TNS: Operation timed out" error
  • Error in ODBC connections
  • TNS-12535 error connecting to remote machine

ORA-12537: TNS connection closed
Solutions:

  • "TNS:connection closed" error
  • ORA-12537 error when trying to connect

ORA-12541: TNS: no listener
Solutions:

  • Causes
  • Connecting to database through forms builder
  • No listener error when logging in to Oracle8
  • No listener error after install on XP
  • Receiving ORA-12541 error trying to connect through Forms/Reports

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

  • Error affecting nightly batch jobs

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

  • Error accessing 9i on Linux
  • Error in Oracle connection
  • Resolving error ORA-12545
  • Resolving error ORA-12545
  • Error message ORA-12545 during remote connect
  • ORA-12545 error trying to open forms in Oracle 8i on Windows 2000
  • ORA-12545 error when connecting to database via client

ORA-12546: TNS: permission denied
Solutions:

  • DBA cannot connect to database
  • Help with listener error

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

  • When connecting to Oracle 9.0.2 on Win2K
  • When logging in to svrmgr after install
  • When connecting over dial-up
  • When installing 8.1.7 on Windows 2000
  • When creating new database
  • When running exp
  • Trouble connecting to listener after install
  • Error running a form in a browser
  • Connection problem with Forms/Reports
  • Resolving ORA-12560 error
  • Uninstalling Oracle9i
  • "TNS:Could not resolve Service name" error
  • Oracle 9i login error
  • Receiving "TNSListener protocol adapter error" during installation
  • Unable to connect to 9i on Windows 98
  • Unable to log in after installing Oracle Client 9i

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

  • Resolving the "ORA-12571: TNS:Packet writer failure" error
  • ORA-12571 error with Oracle 8i on Windows XP

ORA-12638: Credential retrieval failed
Solutions:

  • Another Oracle server from a different LAN
  • "TNS: Operation timed out" error
  • ORA-12638 and ORA-01031 on Windows cluster
  • Problems with Oracle applications after upgrading to XP

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

  • Backup batch jobs not running
  • Error creating database link
  • Database link works for a few days, then ORA-12640

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

  • Error using DESC across dblink

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

  • Errors during building of tables

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:

  • Solving the ORA-1650 error message

ORA-24000 - ORA-25999

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

  • How to drop the example schemas from Oracle9i

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

  • Export/import on table with clob datatype column

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

  • Error inserting new record in table

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

  • Error inserting new record in table

ORA-26000 - ORA-27999

ORA-27038: skgfrcre: file exists
Solutions:

  • Avoiding ORA-27038 when creating a tablespace in 8i
  • Avoiding Oracle errors
  • ORA-27041: unable to open file
    Solutions:
  • Errors causing Oracle instance to shut down
  • Too many open files error message

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

  • Database stopped, showing multiple error messages
  • Input/output errors

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

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

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

  • When trying to connect to the database
  • Errors during reboot
  • Unable to login after installation
  • Trouble getting two database instances running
  • Error when starting Oracle
  • "Oracle not available" error
  • Can't log in to database from SQL*Plus
  • ORA-01034 and ORA-27101 on trying to log in to database
  • ORA-27101 error after moving DB to new domain
  • Suddenly getting ORA-01034 and ORA-27101
  • Why won't the mount and open happen automatically?

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

  • Error accessing database after migration to 9.2.0.3
  • Error after upgrading to 9i Data Server patch set
  • ORA-27123 while trying to create database after Red Hat Linux installation

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

  • When creating Oracle database on Fedora Core 2

ORA-28000 - ORA-30100

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

  • Using dblink to access a different server

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

  • ORA-28547 trying to set up practice database

ORA-29516: Aurora assertion failure: string
Solutions:

  • Hit an error
  • "Aurora assertion failure" error

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

  • Error loading data into target
  • ORA-30036 error when executing update query

Other error messages

SQL*Plus error messages

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

  • What is error SP2-0678?

Import error messages

IMP-00009: abnormal end of export file Solutions:

  • Dump file error
  • Error during import from 9i to 10g
  • Errors during import of dump file

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

  • Create tablespace to resolve IMP-00010 error?

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

  • Which IMP messages are warnings and which are errors?

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

  • Which IMP messages are warnings and which are errors?

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

  • Dump file error
  • Error during import from 9i to 10g
  • Errors during import of dump file

Export error messages

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

  • Errors with character set in export

ORADIM command syntax errors

DIM-00019: Create Service Error
Solutions:

  • "Create service" error when starting DBCA

General information about working with errors

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

 

Next Steps

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

Get more information on Oracle Business Accelerators and how they can speed up ERP deployment

Learn three tips for using Oracle insert syntax

Dig Deeper on Oracle database backup and recovery

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close