Category: Oracle

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01100 to ORA-01200 ORA-01100: database already mounted Cause: A database is already mounted in this instance. Action: n/a ORA-01101: database being created currently mounted by some other instance Cause: Some other instance has the database of same name currently mounted and you are trying to create it. Action: Either change…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00900 to ORA-01100 ORA-00910: specified length too long for its datatype Cause: for datatypes CHAR and RAW, the length specified was > 2000; otherwise, the length specified was > 4000. Action: use a shorter length or switch to a datatype permitting a longer length such as a VARCHAR2,…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00500 to ORA-00900 ORA-00500: Listener registration process terminated with an error. Cause: The listener registration process died. Action: Warm start the instance. ORA-00501: CLMN process terminated with error Cause: The cleanup process died. Action: Warm start the instance. ORA-00502: PMAN process terminated with error Cause: The manager process died. Action: Warm start…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00400 to ORA-00500 ORA-00400: invalid release value string for parameter string Cause: The release level given for the specified init parameter is invalid. Action: Correct the parameter value in the parameter file and retry. ORA-00401: the value for parameter string is not supported by this release Cause: The value specified cannot be supported by…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00300 to ORA-00400 ORA-00300: illegal redo log block size string specified – exceeds limit of string Cause: The specified block size of the redo log is greater than the maximum block size for the operating system. Action: Create the redo log on a device with a smaller block size ORA-00301: error…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00200 to ORA-00300 ORA-00200: control file could not be created Cause: It was not possible to create the control file. Action: Check that there is sufficient disk space and no conflicts in filenames and try to create the control file again. ORA-00201: control file version string incompatible with ORACLE version string…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00100 to ORA-00200 ORA-00100: no data found Cause: An application made reference to unknown or inaccessible data. Action: Handle this condition within the application or make appropriate modifications to the application code. NOTE: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00000 to ORA-00100 ORA-00000: normal, successful completion Cause: Normal exit. Action: None ORA-00001: unique constraint (string.string) violated Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a…