-
Title
It is possible to install SharePlex on a server which is different from Oracle server, for posting purposes? -
Description
It is possible to install SharePlex on a server which is different from Oracle server, for posting purposes?
-
Cause
General information. -
Resolution
It is possible to install SharePlex on a server, which is different from Oracle server so long as one can configure the tnsalias to connect remotely to that database server. The only caveat is, this will slow down Post.
Though this type of configuration has been possible since a long time, it was only documented after replication to RDS was supported. The reason being, this is the only way to connect to the RDS.
The SharePlex Installation Guide for 9.2 section "Installation and setup for remote capture" delves on this and the principles discussed in it also apply to Post. The salient points are:
1. The tnsnames.ora need to be configured appropriately.
2. When running ora_setup, one need to use the sql*net (tnsnames) option instead of Bequeath option.