Configure DB13 to work with a standalone Oracle database in Distributed/ HA Environment

 Problem :

Oracle database runs on the host where no SAP Instance are installed / running . in DB13 database jobs will fail and in SM59 SAPXPG_DBDEST_<SAPDBHOST> RFC will fail

Solution :

Windows :

1. Check the parameter SAPDBHOST in DEFAULT.PFL and the host names of SAP instances in SM51.

2. Install the standalone gateway on Database server

2. Check for destination SM59 -> TCO/IP -> SAPXPG_DBDEST_<SAPDBHOST> in SM59 exists and Update the installed gateway host and gateway service of  standalone gateway server.

Linux :

1. Check the parameter SAPDBHOST in DEFAULT.PFL

2. Install the OS sofware package "rsh" on application and database host

3. Set the profile variable gw/netstat_once = 0 & gw/remsh = rsh

4. Enable password ssh connection between application and database host with <sid>adm user.

5. Perform the connection test from OS level

           rsh <database host> -l <sid>adm sapxpg

6. RFC destination SAPXPG_DBDEST_<SAPDBHOST> will be created automatically and no gateway options set for that destination.

7. Restart the SAP Instance to reflect the parameter