ORA-00211: control file does not match previous control files Database version: Oracle 11g Release 2 (11.2) Cause: A control file was specified that belongs to another database. Solution: Find and install the correct control file.  Read More →

ORA-12672: Database logon failure Database version: Oracle 11g Release 2 (11.2) Cause: The authentication service adapter in use encountered an error it attempted to validate the logon attempt of a user. Solution: Enable tracing to determine the exact error encountered by the adapter.  Read More →

ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred Database version: Oracle 11g Release 2 (11.2) Cause: See alert file or other errors on the stack for a cause of the problem. Solution: This error is just a warning: You may not be able to open the database with resetlogs immediately after this error. However, you may continue media/standby recovery, and... 

ORA-07746: slemrd: invalid error message file handle Database version: Oracle 11g Release 2 (11.2) Cause: seal in passed in handle does not match correct value Solution: this is an internal error, please report to Oracle  Read More →

ORA-06413: Connection not open. Database version: Oracle 11g Release 2 (11.2) Cause: Unable to establish connection. Solution: Use diagnostic procedures to ascertain exact problem.  Read More →

ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications Database version: Oracle 11g Release 2 (11.2) Cause: Self-evident. Solution: Remove the duplicate or conflicting specification.  Read More →

ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions Database version: Oracle 11g Release 2 (11.2) Cause: An attempt was made to alter a tablespace read-only while there were changes in the tablespace made by in-doubt distributed transactions. The in-doubt transactions must commit or rollback to ensure that there is no undo for a tablespace before it can be made read-only. Solution:... 

ORA-01163: SIZE clause indicates string (blocks), but should match header string Database version: Oracle 11g Release 2 (11.2) Cause: The size specified in bytes in the SIZE clause of the CREATE CONTROLFILE statement does not equate to the number of blocks recorded in the header. Solution: Specify the correct filename and size ( in bytes ).  Read More →

ORA-25333: Buffered Queue to Queue propagation did not connect to the correct instance Database version: Oracle 11g Release 2 (11.2) Cause: Queue to Queue propagation for buffered messages didn’t connect to the correct instance, most likely because service was not started for the destination queue. Solution: No user action is required. Propagation will start the service for the destination... 

ORA-22343: Compilation error for type invalidated by ALTER TYPE Database version: Oracle 11g Release 2 (11.2) Cause: Compilation failed for a type which was invalidated by ALTER TYPE. We throw this error and rollback the compilation effort so that the user may be able to fix whatever is causing the compilation error and try again. It is important that we do not chnage status here and modify the... 

ORA-19668: cannot do full restore of datafile string Database version: Oracle 11g Release 2 (11.2) Cause: The backup of the datafile is an incremental backup Solution: If you wish to restore the datafile, you must do an incremental restore of the datafile  Read More →

ORA-12999: cannot DROP or SET UNUSED a column that has been set unused Database version: Oracle 11g Release 2 (11.2) Cause: An attempt was made to DROP or SET UNUSED a column that has already been ’set unused’. Solution: Use the DROP UNUSED COLUMNS option to remove the column.  Read More →