Moving the location of ORACLE_HOME on UNIX systems
Changing the location of ORACLE_HOME requires re-linking SharePlex to the Oracle libraries. Follow these steps.
1 Shut down SharePlex.
to make sure that all the shareplex processes are down do
#ps -ef |grep sp_
2 Move the ORACLE_HOME (or oracle home changes due to patch)
3 Update the oratab file to the path for the new ORACLE_HOME.
4 Update the defaults.yaml file in the [proddir]/data directory with the path for the new ORACLE _HOME.
5 Re-start SharePlex.
If you are using the 32 bit oracle client then make sure that the path is pointing to the correct lib32.