Oracle - Errores y soluciones

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01156: recovery or flashback in progress may need access to filesbases_datos_2

 


 

Cause: Either media recovery, instance recovery, or flashback was in progress. The recovery or flashback in progress may need the files to which this operation is being applied .

 

Action: Wait for recovery or flashback to complete.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01137: data file string is still in the middle of going offlinebases_datos_2

 


 

Cause: It was not possible to get the lock for a file that is offline when attempting to bring it online. The most likely cause is that the lock is still held by the instance that is took it offline.

 

Action: Wait a bit and try to online the file again.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01138: database must either be open in this instance or not at all.bases_datos_2

 


 

Cause: The requested operation can not be done when the database is mounted but not open in this instance, and another instance has the database open.

 

Action: Execute the operation in an open instance, open the datbase in this instance, or close the database in the other instances.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01148: cannot refresh file size for datafile stringbases_datos_2

 


 

Cause: An operating system or device error occurred when retrieving the file's size. The device on which the file resides may have been offline.

 

Action: Restore access to the device.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01129: user's default or temporary tablespace does not exist.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

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

 


 

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.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

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

 


 

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.