Fast Guide: Solving common Oracle errors |
 |
By SearchOracle.com editorial team
15 Apr 2008 | SearchOracle.com |
|
|
Stumped by an Oracle error? We've compiled a list of every expert response pertaining to Oracle errors on SearchOracle.com. You've already asked the questions, now find the answers quickly and easily in the guide below. If the error you're dealing with is not listed, or if your dilemma is not specifically addressed, just ask one of our experts for help and we'll add the response to this ever-growing guide to common Oracle errors.
TABLE OF CONTENTS
 Resources for working with errors
ORA-00000 - ORA-01999
ORA-02000 - ORA-03999
ORA-04000 - ORA-05999
ORA-06000 - ORA-07999
ORA-08000 - ORA-11999
ORA-12000 - ORA-13999
ORA-14000 - ORA-23999
ORA-24000 - ORA-25999
ORA-26000 - ORA-27999
ORA-28000 - ORA-30100
Other error messages
For more information
General information about working with errors
[ Return to Table of Contents ]
Where to get a complete list of all ORA errors
Capturing errors from merge statement
Perform a check or wait for an error?
What should monitoring reports identify
Oracle alert log miner
Logging the command that caused server error
Catching error code that arises in PL/SQL
Advanced error checking using a trigger
ORA-00000 - ORA-01999
[ Return to Table of Contents ]
ORA-00054: resource busy and acquire with NOWAIT specified
Solutions:
Is there a way to stop a rollback?
Error trying to rebuild index after cancelled transaction
How long does a rollback take?
Identifying locks to resolve ORA-01658 and ORA-00054 errors
ORA-00054 error with shell scripts
ORA-00060: deadlock detected while waiting for resource
Solutions:
Deadlock error when a specific batch process runs in parallel
ORA-00200: controlfile could not be created
Solutions:
Avoiding Oracle errors
ORA-00235: controlfile fixed table inconsistent due to concurrent update
Solutions:
Using the RMAN level 0 hot backup process
ORA-00312: online log string thread string: 'string'
Solutions:
Errors causing Oracle instance to shut down
Receiving ORA-313 and ORA-312 errors when trying to open database
ORA-00313: open failed for members of log group string of thread string
Solutions:
Receiving ORA-313 and ORA-312 errors when trying to open database
ORA-00320: can not read file header from log 1 thread 1
Solutions:
Getting Oracle errors -- database and Web site are down
ORA-00321: ORACLE_HOME Redo1.log
Solutions:
Getting Oracle errors -- database and Web site are down
Errors causing Oracle instance to shut down
ORA-00381: cannot use both new and old parameters for buffer cache size specification
Solutions:
Why am I getting the ORA-00381 error when initializing the parameter?
ORA-00396: error string required fallback to single-pass recovery
Solutions:
ORA-00396 and ORA-00397 while loading data
ORA-00397: lost write detected for file string, block string
Solutions:
ORA-00396 and ORA-00397 while loading data
ORA-00406: COMPATIBLE parameter needs to be string or greater
Solutions:
ORA-00406 when trying to create a function index
ORA-00439: feature not enabled: string
Solutions:
Creating a table partition
Managed standby error in ARCHIVE MODE
Problems with installation of Partitioning
ORA-00510: internal limit restriction exceeded
Solutions:
Is the number of processes causing listener error?
ORA-00600: internal error
Solutions:
System timing out writing to control file
Error when updating table in Oracle 8i
"Disconnection forced" message
ORA-00604: error occurred at recursive SQL level string
Solutions:
Table update fails at recursive SQL level 2
Recursive SQL error when using Web app
Errors executing Oracle recursive query
Getting ORA-00604 error when connecting to database user
ORA-00604: error with recursive SQL
Unexplained daily errors
ORA-00903: invalid table name
Solutions:
Trigger error in SQL*Plus
ORA-00904: invalid column name
Solutions:
Error accessing all SQL Server fields in Oracle environment
Getting invalid column name without access to system tables
Error viewing records in table that has abstract column datatype
"Invalid column name" error
Error on "select timestamp" command
SQL execution error ORA-00904
0RA-00922: missing or invalid option
Solutions:
Substitution variables
ORA-00932: inconsistent datatypes
Solutions:
Help creating a script from a view
UNION of two Oracle8i views with CLOBs
How to get the lengths of values in "long" datatype
Unexplained daily errors
ORA-00942: table or view does not exist
Solutions:
Export errors on Solaris
Export errors on Linux
Oracle9i R1 allows any user to access any table
Errors with export command
Unable to select or drop a table
ORA-00955: name is already used by exsisting object
Solutions:
Installing the recovery catalog from RMAN prompt
ORA-00959: tablespace 'string' does not exist
Solutions:
Importing a table that contains LOB segments
ORA-00980: synonym translation is no longer valid
Solutions:
Information on ORA-00980
ORA-01000: Maximum open cursors exceeded
Solutions:
Errors executing Oracle recursive query
ORA-01000 errors on Windows XP
ORA-01002: fetch out of sequence
Solutions:
ORA-01002 error when trying to describe a table
Resolving the ORA-01002 error #1
Resolving the ORA-01002 error #2
ORA-01017: Invalid username/password
Solutions:
Error when trying to restore a specific table
"Invalid username/password" error
ORA-01017 error when connecting through Windows XP client
Unable to log in to database from desktop
ORA-01031: insufficient privileges
Solutions:
Trouble inserting large CLOB
Password file generation
Creating a function-based index
"Insufficient privileges" error
Logging in to a test database
ORA-01031: insufficient privileges trying to restore a database
ORA-01033: ORACLE initialization or shutdown in progress
Solutions:
Database stopped, showing multiple error messages
Getting ORA-01033 when logging in to 9i application
Restoring default database in 8i
Encountering error while cloning a production database
Initialization or shutdown in progress
ORA-01033 error when taking backup
ORA-01034: ORACLE not available
Solutions:
After starting SQL*Plus after 9i install
On Linux Fedora Core 2
When rebooting 9i
Errors during reboot
Error accessing database after migration to 9.2.0.3
Errors connecting Oracle through SQL*Plus
Domain name changes causing error
Trouble getting two database instances running
Error when starting Oracle
Resolving the ORA-01034 error
Oracle not available after installing 8i on WinXP Pro
ORA-01034 after upgrading to version 9.2
ORA-01034: Oracle not available error
Resolving the "ORA-01034: ORACLE not available" error
"Oracle not available" error
Can't log in to database from SQL*Plus
Error with tnsping
ORA-01034 and ORA-27101 on trying to log in to database
Receiving "Oracle is not available" error after restart
Receiving ORA-01034 error while connecting
Suddenly getting ORA-01034 and ORA-27101
Unable to connect to server with Oracle8i
Why won't the mount and open happen automatically?
ORA-01039: insufficient privilege on underlying objects of the view
Solutions:
Insufficient privileges error ORA-01039
ORA-01053: user storage address cannot be read
Solutions:
ORA-1053 error after 8i installation on Windows 2003
ORA-01078: failure in processing system parameters
Solutions:
Help with error ORA-01078
ORA-01081: cannot start already-running ORACLE - shut it down first
Solutions:
Problems starting one of two databases on same server
ORA-01089: immediate shutdown in progress - no operations are permitted
Solutions:
When opening database
Cause of ORA-1089 error
Error when stopping/starting Oracle SID
ORA-01092: Oracle instance terminated. Disconnection forced
Solutions:
Database Configuration Assistant not executing
Oracle installed, but error when creating db
ORA-01092 error during 9i installation
ORA-01092 error while executing database creation command
ORA-01092 on creating a new database
ORA-01110: data file string: 'string'
Solutions:
Database stopped, showing multiple error messages
Input/output errors
ORA-01110 error when not in archive log mode
ORA-01113 and ORA-01110 errors on restarting database
Too many open files error message
ORA-01113: file n needs media recovery
Solutions:
ORA-01113 and ORA-01110 errors on restarting database
ORA-01115: IO error reading block from file string (block # string)
Solutions:
Database stopped, showing multiple error messages
User datafile needs media recovery
Input/output errors
Too many open files error message
ORA-01122: database file string failed verification check
Solutions:
Database crash during hot backup
ORA-1122 error and huge TEMP tablespace
ORA-01157: cannot identify/lock data file string - see DBWR trace file
Solutions:
ORA-01033 error when taking backup
ORA-01158: database %s already mounted
Solutions:
Cloning a production database into a development server
ORA-01403: no data found
Solutions:
Errors during import of a dump file
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Solutions:
ORA-1452 error after export/import
ORA-01501: CREATE DATABASE failed
Solutions:
Avoiding Oracle errors
ORA-01503: CREATE CONTROLFILE failed
Solutions:
Cloning a production database into a development server
ORA-01535: rollback segment 'name' already exists
Solutions:
Errors when importing from same version
ORA-01543: tablespace 'TEMP' already exists
Solutions:
Errors when importing from same version
ORA-01555: snapshot too old: rollback segment number string with name "string" too small
Solutions:
Help with ORA-01555: snapshot too old
Help with ORA-01555 during export
Exporting a table that is constantly updated
RBS monitor to catch ORA-01555 errors
Can't escape ORA-01555 error!
Cause of "snapshot too old" error
Errors and slowness during export
ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)
Solutions:
Errors and slowness during export
ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed
Solutions:
Errors and slowness during export
ORA-01630: max # extents (string) reached in temp segment in tablespace string
Solutions:
Resolving the ORA-01630 error
ORA-01650: unable to extend rollback segment string by string in tablespace string
Solutions:
Errors and slowness during export
ORA-01652: unable to extend temp segment by string in tablespace string
Solutions:
Help with ORA-01652 error -- unable to extend temp segment
Solving ORA-1652 error
High IO program is throwing ORA-01652 errors
ORA-01652: add or resize datafile?
Resolving errors ORA-01652 and ORA-04031
Errors during building of tables
ORA-01652 error when running query to delete large amount of data
Questions about ORA-1652 error
ORA-01653: unable to extend table xxx by xxx
Solutions:
Action can't be handled
ORA-01658: unable to create INITIAL extent for segment in tablespace string
Solutions:
Identifying locks to resolve ORA-01658 and ORA-00054 errors
ORA-01756: quoted string not properly terminated
Solutions:
Error inserting data into customer table
Error inserting single quote into string
ORA-01758: table must be empty to add mandatory (NOT NULL) column
Solutions:
Adding a new NOT NULL field to an existing table
ORA-01940: cannot drop a user that is currently connected
Solutions:
Deleting a user from a tablespace
ORA-02000 - ORA-03999
[ Return to Table of Contents ]
ORA-02019: connection description for remote database not found
Solutions:
Why am I getting the ORA-02019 error?
ORA-02035: illegal bundled operation combination
Solutions:
When does 02035 error occur?
ORA-02085: database link string connects to string
Solutions:
Problem with dblink: ORA-02085
Setting GLOBAL_NAMES to false to use dblink
Error after creating DBLink
ORA-02201: sequence not allowed here
Solutions:
Can triggers be applied to sequence objects?
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
Solutions:
Truncate tables using PL/SQL
ORA-02449: unique/primary keys in table referenced by foreign keys
Solutions:
Error when dropping objects
Find all the 'son' constraints
ORA-03001: unimplemented feature
Solutions:
Solving ORA-03001
ORA-03113: end-of-file on communication channel
Solutions:
Whenever the client is idle for five minutes
When trying to start up
| 
