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
>
.
.
LD_LIBRARY_PATH=/u01/app/oracle/product/10g/lib:/u01/app/oracle/product/10g/rdbms/lib
LIBPATH=/u01/app/oracle/product/10g/lib:/lib
.
.
The resolution is to include it in these two variables as:
export LD_LIBRARY_PATH=/u01/app/oracle/product/10g/lib32:/u01/app/oracle/product/10g/lib:/u01/app/oracle/product/10g/rdbms/lib
export LIBPATH=/u01/app/oracle/product/10g/lib32:/u01/app/oracle/product/10g/lib:/lib
After this one should be able to launch qview as well as sp_cop from the same session.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center