Get started Bring yourself up to speed with our introductory content.

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.

By
  • SearchOracle.com experts
Published: 15 Apr 2008

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:

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

ORA-00200: controlfile could not be created
Solutions:

  • Avoiding Oracle errors

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:

  • 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:

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:

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:

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:

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:

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:

  • 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:

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:

ORA-01403: no data found
Solutions:

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:

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:

  • 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:

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:

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:

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-03121: no interface driver connected
Solutions:

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:

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:

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:

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

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:

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:

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:

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:

ORA-12541: TNS: no listener
Solutions:

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:

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:

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:

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:

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:

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:

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

 

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