You can have APPLY process running on separate server instead of target server where MSSQL database is running. APPLY process communicates with MSSQL database through DSN therefore to offload APPLY to another server, we need to configure DSN on that server.
Please follow Dbvisit Replicate configuration examples on following link and do as instructed on the server where you want to run APPLY instead of target system.
Make sure that the network settings are configured correctly (Firewall, tnsping,DSN). APPLY server must have DSN connecting target MSSQL database and TNS connecting source Oracle database.