Summary
Error
While trying to create an Oracle 12c backup we get the following error message:
The database reported error while performing requested operation.
SBT_LIBRARY=C:/Program Files/OmniBack/bin/orasbt.dll
CHILDERROR:1
Process exit code: 1, Signal: 0
RMAN PID=948
APPERROR:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on DP_TEST channel at 02/08/2017 22:07:23
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27209: syntax error in device PARMS - unknown keyword or missing =
OSD-08192: Message 8192 not found; product=RDBMS; facility=SOSD
Recovery Manager complete.
Cause
The problem is that there is a space between "Program" and "Files" that DataProtector is passing to Oracle's rman and this is not allowed. This issue is a known Data Protector problem documented in QCCR2A70575 :
SBT_LIBRARY=C:/Program Files/OmniBack/bin/orasbt.dll
Fix
The issue is fixed by doing the following :
1. Make sure you are on Data Protector 9.09 or later.
2. Create a link in a directory that does not have spaces in the directory name. For example, this is where to create the link :
mklink C:\orasbt.dll "C:\program files\omniback\bin\orasbt.dll"
3. Now add the SBT_LIBRARY variable to the Data Protector oracle configuration file via command :
C:\>util_cmd -putopt Oracle8 <SID> SBT_LIBRARY c:\orasbt.dll -local "C:\ProgramData\OmniBack\Config\Server\Integ\Config\Oracle8\hostname.domain.suffix%SID"
Be sure to replace "SID" with the instance that is being configured and also replace "hostname.domain.suffix" with the FQDN of the Oracle client.