Category: Databases

Oracle 11g Error Codes and Solution Suggestions from ORA-01201 to ORA-01300 ORA-01201: file string header failed to write correctly Cause: An I/O error was reported for the file header. The error was trapped and a second attempt will be made. Action: The file probably will require recovery. Further error messages will indicate what is needed….

Oracle 11g Error Codes and Solution Suggestions from ORA-01101 to ORA-01200 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 the database name or shutdown the other instance. ORA-01102: cannot mount database…

Oracle 11g Error Codes and Solution Suggestions from ORA-01000 to ORA-01100 ORA-01002: fetch out of sequence Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of…

Oracle 11g Error Codes and Solution Suggestions from ORA-00900 to ORA-01000 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…

Oracle 11g Error Codes and Solution Suggestions from ORA-00801 to ORA-00900 ORA-00820: Specified value of sga_max_size is too small, needs to be at least string Cause: The specified value of sga_max_size is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc….

Oracle 11g Error Codes and Solution Suggestions from ORA-00701 to ORA-00800 ORA-00701: object necessary for warmstarting database cannot be altered Cause: Attempt to alter or drop a database object (table, cluster, or index) which are needed for warmstarting the database. Action: None ORA-00702: bootstrap verison ‘string’ inconsistent with version ‘string’ Cause: The reading version of…

Oracle 11g Error Codes and Solution Suggestions from ORA-00601 to ORA-00700 ORA-00601: cleanup lock conflict Cause: PMON process runs into lock conflict trying to recovery processes Action: This is trapped internally, no action necessary ORA-00602: internal programming exception Cause: Internal programming exception Action: Report as bug ORA-00603: ORACLE server session terminated by fatal error Cause:…

Oracle 11g Error Codes and Solution Suggestions from ORA-00501 to ORA-00600 ORA-00566: cannot request processor group – NUMA not enabled Cause: Cannot start process in a requested processor group when the NUMA feature is disabled. Action: Start the process without requesting a NUMA processor group. ORA-00567: Requested processor group string is too large (maximum string)…

Oracle 11g Error Codes and Solution Suggestions from ORA-00401 to ORA-00500 ORA-00401: the value for parameter string is not supported by this release Cause: The value specified cannot be supported by this release of the software. Action: Choose an appropriate value, or remove the parameter value to use the default value. ORA-00402: database changes by…

Oracle 11g Error Codes and Solution Suggestions from ORA-00301 to ORA-00400 ORA-00301: error in adding log file ‘string’ – file cannot be created Cause: The creation of the redo log file failed Action: Check: 1) there is enough storage space on the device 2) the name of the file is valid 3) the device is…