Oracle configuration in DataProtector fails with ORA-27209: syntax error in device PARMS - unknown keyword or missing =

  • KM02736857
  • 17-Feb-2017
  • 09-Mar-2021

Summary

Oracle configuration fails in DataProtector.

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.