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

0 Likes
over 1 year ago

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:

Support Tip
Comment List
Anonymous
Related Discussions
Recommended