<html><head><style type="text/css"></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>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 </div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"> <div style="font-family: arial,helvetica,sans-serif; font-size: 13px;"><hr size="1">From: Michael Mraka <michael.mraka@redhat.com> To: spacewalk-list@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@spacewalk ~]# ldd `rpm -ql cx_Oracle | grep <a target="_blank" href="http://cx_Oracle.so">cx_Oracle.so</a>` % <a target="_blank" href="http://linux-gate.so">linux-gate.so</a>.1 => (0x009dd000) % <a target="_blank" href="http://libclntsh.so">libclntsh.so</a>.10.1 => /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 (0x00c11000) This is an instanclient library. % <a target="_blank" href="http://libpthread.so">libpthread.so</a>.0 => /lib/libpthread.so.0 (0x00110000) % <a target="_blank" href="http://libc.so">libc.so</a>.6 => /lib/libc.so.6 (0x00127000) % <a target="_blank" href="http://libnnz10.so">libnnz10.so</a> => /usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so (0x00360000) % <a target="_blank" href="http://libdl.so">libdl.so</a>.2 => /lib/libdl.so.2 (0x0026b000) % <a target="_blank" href="http://libm.so">libm.so</a>.6 => /lib/libm.so.6 (0x00856000) % <a target="_blank" href="http://libnsl.so">libnsl.so</a>.1 => /lib/libnsl.so.1 (0x0026f000) % /lib/ld-linux.so.2 (0x00720000) % [root@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@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@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 <a target="_blank" href="http://oracle.sh">oracle.sh</a> 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 <a ymailto="mailto:Spacewalk-list@redhat.com" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </div></div></div> </body></html>