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 <[email protected]>
To: [email protected]
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.
%
% [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
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
