Matt Carey wrote:
% Michael,
%
% Thanks for the reply.
%
% [r...@spacewalk ~]# ldd `rpm -ql cx_Oracle | grep cx_Oracle.so`
% linux-gate.so.1 => (0x009dd000)
% libclntsh.so.10.1 =>
/usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 (0x00c11000)
This is an instanclient library.
% libpthread.so.0 => /lib/libpthread.so.0 (0x00110000)
% libc.so.6 => /lib/libc.so.6 (0x00127000)
% libnnz10.so => /usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so
(0x00360000)
% libdl.so.2 => /lib/libdl.so.2 (0x0026b000)
% libm.so.6 => /lib/libm.so.6 (0x00856000)
% libnsl.so.1 => /lib/libnsl.so.1 (0x0026f000)
% /lib/ld-linux.so.2 (0x00720000)
% [r...@spacewalk ~]# lsof -p `ps ax | awk '/[o]sa-dispatcher/ {print $1}' ` |
grep oracle
% osa-dispa 3183 root mem REG 253,7 17764670 1942698
/u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
% osa-dispa 3183 root mem REG 253,7 5480533 1943219
/u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so
And these come from server installation.
% I did install the oracle-xe client libraries to satisfy the RPM deps when
doing the yum install spacewalk:
% [r...@spacewalk ~]# rpm -qa oracle-instant\*
% oracle-instantclient-sqlplus-10.2.0.4-1
% oracle-instantclient-basic-10.2.0.4-1
% oracle-instantclient-sqlplus-selinux-10.2-15.el5
% oracle-instantclient-selinux-10.2-15.el5
%
% So my client libraries are in /usr/lib/oracle and the database is running out
of /u01/app/oracle. I did try to add the environment variables to the entire
system by doing the following:
% [r...@spacewalk ~]# cat /etc/profile.d/oracle.sh
I've seen several troubles caused by (randomly) mixing instanclient and
server libraries like this.
General recomendation is to put oracle.sh only to oracle's (the database
server user) profile and remove it from /etc/profile.d so clients
will use instanclient's libs.
Regards,
--
Michael Mráka
Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
