RMAN Backups Failing Since Upgrade To 12.1.0.2 ORA-27211: Failed To Load Media Management Library (Doc ID 2109221.1)

Last updated on JULY 03, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Microsoft Windows x64 (64-bit)

Symptoms

After upgrading to 12c DBMS_SCHEDULER jobs to execute RMAN backup scripts fails with an incorrect path on windows.

Issue specific to Windows

Because of the failure to load media library error, EMC directed  to copy ORASBT.DLL from C:\Program Files\Legato\NSR\bin to C:\Windows\System32 so it would be “found” by oracle –

Though it was already in the path anyway. Once we did that and reran the following it crashed the database:

RMAN> run {
2> allocate channel ch1 type sbt_tape;
3> release channel ch1;}

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
RMAN-03009: failure of allocate command on ch1 channel at 06/17/2015 11:24:32
ORA-03135: connection lost contact



Partial Alert log abstract

Wed Jun 17 11:24:28 2015
Thread 1 cannot allocate new log, sequence 1825464
Checkpoint not complete
  Current log# 6 seq# 1825463 mem# 0: R:\REDOLOGS\RV07\REDO06.LOG
Wed Jun 17 11:24:30 2015
Thread 1 advanced to log sequence 1825464 (LGWR switch)
  Current log# 7 seq# 1825464 mem# 0: R:\REDOLOGS\RV07\REDO07.LOG
Wed Jun 17 11:24:31 2015
Archived Log entry 1806264 added for thread 1 sequence 1825463 ID 0x95e49a2d dest 1:
Wed Jun 17 11:27:43 2015
Starting ORACLE instance (normal) (OS id: 11700)
Wed Jun 17 11:27:43 2015
CLI notifier numLatches:29 maxDescs:1355
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 16
Number of processor cores in the system is 8
Number of processor sockets in the system is 2
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =135
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
NUMA system with 2 nodes detected
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
Windows NT Version V6.1 Service Pack 1
CPU : 16 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:74365M/131059M, Ph+PgF:74681M/131073M
Using parameter settings in server-side spfile C:\ORACLE11\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILERV07.ORA

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms