Restore Data - SAP for Oracle and SAP for MAXDB - Troubleshoot

Troubleshooting Oracle Errors

If you receive an Oracle error during a SAP for Oracle backup or restore operation, we recommend that you follow procedures published by Oracle Corporation on resolving the specific error. We also advise you to consult with your on-site Oracle database administrator, as needed.
If a restore fails with the error PLS-00553: character set name is not recognized; then make sure the character sets are the same between the locations of where you are running RMAN from and the location of the target database. Because this is an Oracle related issue, please contact Oracle support for more information.

If a SAP command line backup fails with the error "Unable to open lock file /oracle/<software installation path>/Base/Temp/locks/.dir_lock: Permission denied", it may be because the "unmask" is set as "022" in .profile for instances on SAP for Oracle. If this occurs, change the "unmask" to "000" or "002" and try the backup again. Also, ensure that the users for SAP for Oracle are in the group "dba".