Solving common Oracle error codes guide

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

• 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

ORA-02000 - ORA-03999

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