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...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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:
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:
- 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:
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:
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-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-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:
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:
- 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:
ORA-01940: cannot drop a user that is currently connected
Solutions:
- Deleting a user from a tablespace
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:
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:
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:
- 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:
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:
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:
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:
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:
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