[Spacewalk-list] Spacewalk with oracle standard edition errors

[Matt Carey]

Michael,

Spot on with the fix. I took out the /etc/profile.d/oracle.sh file, modified /etc/ld.so.conf.d/oracle-lib-compat.conf, and ran ldconfig to get everything working prior to bouncing the satellite services. The only thing left that I can see is the osad daemon can't talk to the jabber server because of what looks to be authentication issues:
2009/10/19 13:24:45 -04:00 3172 0.0.0.0: rhnSQL/driver_cx_Oracle.connect('Connecting to database', 'TSH1')
2009/10/19 13:24:45 -04:00 3172 0.0.0.0: osad/jabber_lib.__init__
2009/10/19 13:24:46 -04:00 3172 0.0.0.0: osad/jabber_lib.setup_connection('Connected to jabber server', 'spacewalk.ose.ntta.com')
2009/10/19 13:24:46 -04:00 3172 0.0.0.0: osad/jabber_lib.register('ERROR', 'Invalid password')

How would I go about resetting those credentials and what configuration files would I need to modify with the updated creds?

Thx again,
Matt




________________________________
From: Michael Mraka <michael.mraka at redhat.com>
To: spacewalk-list at redhat.com
Sent: Mon, October 19, 2009 9:44:56 AM
Subject: Re: [Spacewalk-list] Spacewalk with oracle standard edition errors

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

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20091019/309bb53c/attachment.htm>