miércoles, 1 de abril de 2020

oraopc.dll y ORA-27211: Failed to load Media Management Library

Escenario:
  • Oracle Database EE 12C
  • Microsoft Windows Server 2012 x64 (64-bit)
Comando ejecutado:


rman target /
set encryption ON identified by "dsk45opT4dihg_0f_XXXXXXds7" Only;
run {
allocate channel sbt1 device type sbt PARMS 'SBT_LIBRARY= D:\app\oracle\product\12.0.0\database\lib\libopc.dll, SBT_PARMS=(OPC_PFILE= D:\app\oracle\product\12.0.0\db\config.ora)';
backup backupset completed after 'sysdate-1';
}

Error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 11/16/2015 06:47:37
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

Causa:

Para que la librería libopc.dll funcione correctamente en Windows necesita de la librería complementaria MSVCR100.dll.


Solución:

Se debe instalar la librería MSVCR100.dll dentro del directorio $ORACLE_HOME\bin.

Para obtener la librería debemos descargarla desde https://www.microsoft.com/en-us/download/details.aspx?id=40784

El paquete de instalación ejecutará un wizard que descomprimirá la librería dentro de las librerías de Windows. Una vez instalada copiamos y pegamos el archivo MSVCR100.dll dentro de nuestro directorio $ORACLE_HOME\lib.

Referencia: Oracle Support Document 2078347.1

No hay comentarios:

Publicar un comentario

Oracle ACE Director Award - Deiby Gómez

Thanks #OracleACE Program for this awesome certificate recognizing the work I have done in the community for the last year. Looking forwa...