Oracle - Errores y soluciones

Error ORA-01165

ORA-01165: MAXDATAFILES may not exceed string

 

---

 

Cause: MAXDATAFILES specified on the command line too large.

 

Action: Resubmit the command with a smaller MAXDATAFILES.

Error ORA-01166

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.

Error ORA-01167

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.

Error ORA-01168

ORA-01168: physical block size string does not match size string of other members

 

---

 

Cause: The file is located on a device with a different physical block size than the other members in the group.

 

Action: Use a physical device with matching block size.

Error ORA-01169

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

 

---

 

Cause: Datafile number 1 was not specified in a CREATE CONTROLFILE command.

 

Action: Locate datafile number 1 and resubmit the CREATE CONTROLFILE command.

Error ORA-01170

ORA-01170: file not found 'string'

 

---

 

Cause: ALL datafiles and, if NORESETLOGS, ALL logfiles MUST be accessible by the process for CREATE CONTROLFILE.

 

Action: The file specified probably contains a typing error. Double check command and the existance of all files and then resubmit.