ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change Database version: Oracle 11g Release 2 (11.2) Cause: An attempt was made to specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change. Solution: Specify CONVERT TO SUBSTITUTABLE option only for ALTER TYPE NOT FINAL change.  Read More →

ORA-19669: proxy copy functions cannot be run on DISK channel Database version: Oracle 11g Release 2 (11.2) Cause: A proxy copy procedure was called, but the device which is allocated to the current session has type DISK. Solution: Allocate a non-DISK channel and retry the operation. Note that proxy copy requires a 3rd-party media management software product that supports the this backup/restore... 

ORA-13000: dimension number is out of range Database version: Oracle 11g Release 2 (11.2) Cause: The specified dimension is either smaller than 1 or greater than the number of dimensions encoded in the HHCODE. Solution: Make sure that the dimension number is between 1 and the maximum number of dimensions encoded in the HHCODE.  Read More →

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