SAP R/3 / Backup did not run due initORACLE_SID.sap not in default path

SAP R/3 / Backup did not run due initORACLE_SID.sap not in default path

Summary

SAP R/3 / Backup did not run due initORACLE_SID.sap not in default path

Problem

New SAP R/3 integration backup has been properly configured but fails like this:

[Normal] From: BSM@cm.server.com "SAPbackup"  Time: 6/1/2020 2:24:41 PM
 OB2BAR application on "sap.server.com" successfully started.

[Normal] From: BSM@cm.server.com "SAPbackup"  Time: 6/1/2020 2:24:42 PM
 OB2BAR application on "sap.server.com" disconnected.

[Critical] From: BSM@cm.server.com "SAPbackup"  Time: 6/1/2020 2:24:42 PM
 None of the Disk Agents completed successfully.
 Session has failed.

DP 10.70

SAP Netweaver 7.40

Cause

Due SAP architecture, when the Oracle DB is installed as RAC or ASM, the initORACLE_SID.sap is placed in a different location than ORACLE_HOME.

This is in the SAP documentation:

 For installations with Oracle 11g (or higher) RAC or ASM, the profile is located in the directory $SAPDATA_HOME/sapprof.

https://help.sap.com/doc/saphelp_nw74/7.4.16/en-us/46/b114d2de5c0763e10000000a1553f6/frameset.htm

DP tries to search the file in the ORACLE_HOME:

UNIX systems:ORACLE_HOME/dbs/initORACLE_SID.sap
Windows systems:ORACLE_HOME\database\initORACLE_SID.sap

https://docs.microfocus.com/itom/Data_Protector:2020.05/SAPR3Backup

 

Fix

To solve this, you can create a softlink on ORACLE_HOME to the current initORACLE_SID.sap

ln -s $SAPDATA_HOME/sapprof/initORACLE_SID.sap ORACLE_HOME/dbs/initORACLE_SID.sap

For Windows you can create a direct access link in the corresponding paths.

Reference

Labels (1)

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2020-06-04 22:21
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.