How to configure DB13 to work with a standalone/Remote Oracle database on Unix/Linux
Problem: Your SAP system runs on Linux, and the Oracle database is on a dedicated host with no SAP instance installed. In this type of distributed setup, scheduling DB jobs from DB13 does not work directly. Rather than adding an additional gateway on the DB instance, the following procedure can be used instead. Solution: Set the variable 'SAPDBHOST' with the database host name. In case of RAC database use the virtual hostname of the first node (see SAP Note 1738351 in case of Solution Manager). For database installed in OS cluster, use the virtual hostname of the cluster; Set the profile variable 'gw/netstat_once' to 0. This is to identify dynamic changes of the logical hostnames; Set the profile variable 'gw/remsh' with the full path of the 'rsh' in case you want to use normal remote shell or full path of 'ssh' in case of secure remote shell; Perform a connection test from the SAP instance host to database host. You should use 'rsh' o...