When Invoking qview to troubleshoot failure of launch of sp_cop (with a view to rule out queue corruption) results in the following error:
$ qview -i
Dependent module /u01/app/oracle/product/10g/lib/libclntsh.a(shr.o) could not be loaded.
The module has an invalid magic number.
There is no apparent error in event log for the failure of launch. Launching sp_cop manually and results in the same error. The Shareplex could be launched earlier and something changed in the environment.
Some library issue is causing the error.
The first thing to check is whether the LD_LIBRARY_PATH and LIBPATH include 32 bit Oracle Library in their path. This is because Shareplex is a 32 bit application and would require 32 bit libraries. The following shows that they do not:
> env | sort
The resolution is to include it in these two variables as:
After this one should be able to launch qview as well as sp_cop from the same session.