Oracle - Errores y soluciones

Ratio: 4 / 5

ORA-01136: specified size of file string (string blocks) is less than original size of string blocks.

Cause: A file size was specified in the AS clause of ALTER DATABASE CREATE DATAFILE, and the size was smaller the the size needed.

Action: Create the file with a larger size.

Ratio: 4 / 5

ORA-01166: file number string is larger than string (string)

Cause: File mentioned in CREATE CONTROLFILE has a file number which is larger than that specified for MAXDATAFILES or MAXLOGFILES.

Action: Increase the maximum specified on the command line.

Ratio: 4 / 5

ORA-01167: two files are the same file/group number or the same file

Cause: There is an overlap of file numbers in the files specified on the command line or the same file is specified twice. If they are not the exact same file then one is likely to be a backup of the other. If they are two members of the same log they must be specified together in a group file spec. This message will also appear if the same control file appears more than once in the control_files parameter in the init.ora file. If this happens, check for additional error messages.

Leer más: Error ORA-01167

Ratio: 4 / 5

ORA-01169: DATAFILE number 1 not found. Must be present

Leer más: Error ORA-01169

Ratio: 4 / 5

ORA-01171: datafile string going offline due to error advancing checkpoint

Cause: The checkpoint in the file header could not be advanced. See accompanying errors for the reason. The datafile will be taken offline the same as for a write error of a data block.

Action: See accompanying errors for details. Restore access to the file, do media recovery, and bring it back online.

Ratio: 4 / 5

ORA-01175: data dictionary has more than the string files allowed by the instance

Cause: The data dictionary is found to have more files than that which can be supported by this instance.

Action: Shutdown the instance and restart with a larger number of db_files.