Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01300 to ORA-01400 ORA-01300: writable database required for specified LogMiner options Cause: Options were specified which required the database to be writable. Action: Specify different options or open the database for write access. ORA-01301: error writing to file during flat file build Cause: Error writing to file during flat…
Month: August 2016
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01200 to ORA-01300
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01200 to ORA-01300 ORA-01200: actual file size of string is smaller than correct size of string blocks Cause: The size of the file as returned by the operating system is smaller than the size of the file as indicated in the file header and the control file. Somehow the file has…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01100 to ORA-01200
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
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
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
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
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
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
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
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…