After an Oracle version or patch upgrade you are seeing the following in the event log with Read exiting due to error:
07/09/07 15:33 Process exited sp_ordr (for o.mbprd511) [pid = 12923] - exit(1)
07/09/07 15:33 Error: 11000 - sp_ordr failed: Invalid NLS_LANG [sp_ordr/12923]
07/09/07 15:33 Error: SP_ORD_NLS_LANG was set to a bad value. Please reset to default or correct with proper value and RESTART reade
r. Exiting. [sp_ordr/12923]
07/09/07 15:33 Error: 12035 - OCISessionBegin failed with ORA-12705. [sp_ordr(osp)/12923]
07/09/07 15:33 Notice: Oracle env - mbprd511:/app/oracle/product/920 [sp_ordr(pdb)/12923]
07/09/07 15:33 Process launched: sp_ordr (for o.mbprd511) [pid = 12923]
07/09/07 15:33 Logging user command: oracle start read
Wrong Oracle libraries may be in use due to the incorrect ORACLE_HOME/lib32 specified in the environment.
The example assumes that you are on Shareplex 5.3 with Oracle 9.2. Go to the /var/adm/.splex/V-5.3/lib92 and do ls -l and see if libclntsh.so.9.0 links to the appropriate $ORACLE_HOME/lib32. If not, then you may want to shutdown Shareplex, correct that link and restart Shareplex and Read.
The following is an example of the ls -l on that directory:
irvsupu16 # pwd
/var/adm/.splex/V-5.3/lib92
irvsupu16 # ls -l
total 16
lrwxrwxrwx 1 root other 44 May 18 23:53 libclntsh.so.9.0 -> /u02/o
racle/product/9.2.0/lib32/libclntsh.so
lrwxrwxrwx 1 root other 36 May 18 23:48 libopstcom.so -> /u01/anu/
539i/prod/lib/libopstcom.so
.
.
.
If the link is not an issue, or if amending the link does not resolve it, then you may want to call Support so that other further investigation can be done. For Shareplex versions, the notation used with "V" in the directory name is:
V-4.5
V-5.0
V-5.1
V-5.2
V-5.3
For Oracle, it is:
lib81
lib92
lib100
