NetVault 10.01
NetVault Plug-in for Oracle Version: 7.1.1
Oracle backup fails assigning device sbt_tape with error 7111 as seen in binary extract below:
Information 2015/02/02 16:50:55 352 Data Plugin BDULMA RMAN-03009: failure allocate command in the channel c1 02/02/2015 17:50:55
Information 2015/02/02 16:50:55 352 Data Plugin BDULMA ORA-19554: error in assigning the device, device type: sbt_tape, device name:
Information 2015/02/02 16:50:55 352 Data Plugin BDULMA ORA-27000: skgfqsbi: failed to initialize storage subsystem level (SBT)
Information 2015/02/02 16:50:55 352 Data Plugin BDULMA ORA-19511: I received error level media manager f musicians, error text?:
Information 2015/02/02 16:50:55 352 Data Plugin BDULMA SBT error = 7111, errno = 0, sbtinit: system error
The following situation happens in Windows Operating System, it does not happen in Linux or Unix systems. In Windows Operating systems DLLs are used. Oracle uses the NetVault Backup orasbt.dll, which represents the Media Management Library. On occasions, if an error occurs, or a job is aborted, this could cause the NetVault Backup orasbt.dll to exit. In some situations, even the NetVault Backup orasbt.dll has exited, the handle that Oracle maintains with the DLL is not released. In these situations when you try to allocate another channel, Oracle instead of opening a new handle to orasbt.dll, Oracle will try to access the orasbt.dll using the previous handle that was already pointing to a DLL which had already exited. And that is the error that you see.
In order to release the handle that Oracle has Oracle Service needs to be restarted.
example:
Start -> Administrative Tools -> Services; then look for a Service named OracleService<oracleSID> (for example, OracleServiceGLONTANA), then Restart.
This problem is being addressed in BUG 21345 see future NetVault and Oracle plugin release notes to track this bug
