[Spacewalk-list] Spacewalk with oracle standard edition errors

[Michael Mraka]

Matt Carey wrote:
% Michael,
% 
% Thanks for the reply.
% 
% [root at 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)
% [root at 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:
% [root at 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:
% [root at 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