Post is stopped with error. Event_log has the following message:
1] 04/22/08 17:46 Error: 12035 - OCISessionBegin failed with ORA-12705. [sp_opst_mt(osp)/14669]
[1] 04/22/08 17:46 Error: 12035 - OCISessionBegin failed with ORA-12705. [sp_opst_mt(osp)/14670]
All of the following variables are correct:
environment variable NLS_LANG matches database NLS_LANG
/var/adm/.splex library links point to the correct oracle library
ORACLE_HOME and SID are correct
oratab is correct
LD_LIBRARY_PATH points to the correct location
The problem was that sp_cop was started using the location specified in the PATH variable (as opposed to starting sp_cop with the full location or ./). The PATH variable contained a 10G splex proddir, however this was an 8i database. As a result an sp_cop for oracle 10G was being started for an 8i database (instead of sp_cop for oracle 8i). This can be easily viewed by "which sp_cop", this command showed that the session was using the 10G sp_cop.
This may also cause by using the wrong version of shareplex for example: using 5.3 instead of 7.0 or others.
Modify PATH to point to 8i (or start sp_cop explicitly from an 8i location)
Modify PATH to use the right shareplex binary.
