Backup of the Oracle server fails with "database script returned an error" and RMAN output section of job log shows "ORA-27211: Failed to load Media Management Library"

Article:TECH59661  |  Created: 2008-01-16  |  Updated: 2012-03-23  |  Article URL http://www.symantec.com/docs/TECH59661
Article Type
Technical Solution


Issue



Backup of the Oracle server fails with "The database script returned an error" and RMAN output section of job log shows "ORA-27211: Failed to load Media Management Library"


Error



Backup of an Oracle database fails with error "The Database script returned an error. Refer to the Database script output section in job logs for more details" in the job log. RMAN output section of job log shows the following:
 
Using target database controlfile instead of recovery catalog
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch0 channel at "Date and Time"
ORA-19554: error allocating device, device type: SBT_TAPE, device name: 
ORA-27211: Failed to load Media Management Library

Solution



To resolve the issue enable debug logging on the Oracle server and run a backup of the Oracle database (Refer to the technote in the related documents section for information on how to enable debug logging on the Oracle server).
 
Check the stubtrace.pid log in the logs folder on the Oracle server (name of the log will be something like stubtrace.pid=1848.tid=5332.1207924357.log).
 
The log will have the following entry:
 
Stub dll loaded successfully.
Trying to load beorasbt.dll (real SBT library) and its dependent dlls ...
Failed to load beorasbt.dll. Reason: 127: The specified procedure could not be found.
 
This error comes up because beorasbt.dll is not loaded on the Oracle server. This can happen if the Oracle server is not rebooted after installing Backup Exec Remote Agent for Windows Servers. Rebooting the Oracle server should resolve this problem.  If the problem persists after reboot, then try the following:
 
1. Uninstall the Backup Exec Remote Agent for Windows Servers from the Oracle server using Add-Remove Programs.
2. Reboot the Oracle server.
3. Install the Backup Exec Remote Agent for Windows Servers on the Oracle server.
4. Reboot the Oracle server.

Supplemental Materials

SourceError Code
Value0xe0000340
Description

The Database script returned an error. Refer to the Database script output section in job logs for more details



Legacy ID



302933


Article URL http://www.symantec.com/docs/TECH59661


Terms of use for this information are found in Legal Notices