<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=UTF-8" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> As I have had NO HELP from anybody on this issue, here or bugzilla, i will be reinstalling spacewalk thanks for nothing Kobus Bensch wrote: <blockquote cite="mid:4D511C93.6090505@lovefilm.com" type="cite"> <meta content="text/html;charset=UTF-8" http-equiv="Content-Type"> Hi Michael Here is result from commands you requested: 1.) s-08 ~]# egrep 'hibernate|db_name' /etc/rhn/rhn.conf db_name = //localhost/XE hibernate.dialect=org.hibernate.dialect.Oracle10gDialect hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver hibernate.connection.driver_proto=jdbc:oracle:oci 2.) s-08 ~]# sqlplus $(spacewalk-cfg-get default_db) SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 8 10:26:27 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> 3.) see attached 4.) I have now also restarted SW s-08 ~]# /usr/sbin/spacewalk-service restart Shutting down spacewalk services... Stopping RHN Taskomatic... RHN Taskomatic was not running. Stopping cobbler daemon: [ OK ] Stopping rhn-search... rhn-search was not running. Stopping MonitoringScout ... [ OK ] Stopping Monitoring ... [ OK ] Stopping httpd: [ OK ] Stopping tomcat5: [ OK ] Shutting down osa-dispatcher: [FAILED] Terminating jabberd processes ... Stopping router: [ OK ] Stopping sm: [ OK ] Stopping c2s: [ OK ] Stopping s2s: [ OK ] Done. Starting spacewalk services... Initializing jabberd processes ... Starting router: [ OK ] Starting sm: [ OK ] Starting c2s: [ OK ] Starting s2s: [ OK ] Starting osa-dispatcher: [ OK ] Starting tomcat5: [ OK ] Waiting for tomcat to be ready ... Starting httpd: [ OK ] Starting Monitoring ... [ OK ] Starting MonitoringScout ... [ OK ] Starting rhn-search... Starting cobbler daemon: [ OK ] Starting RHN Taskomatic... Done. 5.) and result from point 3 again attached in seperate file Kobus Michael Mraka wrote: <blockquote cite="mid:20110208100818.GB2968@magni.brq.redhat.com" type="cite"> <pre wrap="">Kobus Bensch wrote: % Ok, renamed the tnsnames.ora and re-ran spacewalk-setup --upgrade % % Stopped and started oracle and spacewalk and getting the folloign in % the catalina logs: % % 07-Feb-2011 15:56:19 % com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run % WARNING: % com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2857a293 % -- Acquisition Attempt Failed!!! Clearing pending acquires. While % trying to acquire a needed new resource, we failed to succeed more % than the maximum number of allowed acquisition attempts (30). % 2011-02-07 15:56:19,562 [TP-Processor3] WARN % org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: % null % 2011-02-07 15:56:19,562 [TP-Processor3] ERROR % org.hibernate.util.JDBCExceptionReporter - Connections could not be % acquired from the underlying database! % 2011-02-07 15:56:19,562 [TP-Processor3] ERROR % com.redhat.rhn.frontend.servlets.SessionFilter - Error during % transaction. Rolling back % com.redhat.rhn.common.hibernate.HibernateRuntimeException: couldn't % open session It still looks like tomcat wasn't able connect to database. What's your db connection in rhn.conf? # egrep 'hibernate|db_name' /etc/rhn/rhn.conf Are you able connect to database with sqlplus? # sqlplus $(spacewalk-cfg-get default_db) Does any other java based service (e.g rhn-search, taskomatic) work? # service rhn-search status # grep ERROR /var/log/rhn/search/rhn_search_daemon.log # service taskomatic status # grep ERROR /var/log/rhn/rhn_taskomatic_daemon.log Regards, -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></pre> </blockquote> <div class="moz-signature">-- Kobus Bensch Linux Administrator <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:kobus.bensch@lovefilm.com">kobus.bensch@lovefilm.com</a> No.9 | 6 Portal Way | London | W3 6RU | T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111 <a moz-do-not-send="true" href="http://www.lovefilm.com"><img src="cid:part1.02040200.00040204@lovefilm.com"></a> </div> <hr width="100%"> LOVEFiLM UK Limited is a company registered in England and Wales. Registered Number: 06528297. Registered Office: No.9, 6 Portal Way, London W3 6RU, United Kingdom. This e-mail is confidential to the ordinary user of the e-mail address to which it was addressed. If you have received it in error, please delete it from your system and notify the sender immediately. This email message has been delivered safely and archived online by Mimecast. For more information please visit <a moz-do-not-send="true" href="http://www.mimecast.co.uk">http://www.mimecast.co.uk</a> <hr width="100%"> <pre wrap=""><pre wrap=""><pre wrap=""> <hr size="4" width="90%"> _______________________________________________ Spacewalk-list mailing list <a class="moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a class="moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></pre></pre></pre> </blockquote> <div class="moz-signature">-- Kobus Bensch Linux Administrator <a class="moz-txt-link-abbreviated" href="mailto:kobus.bensch@lovefilm.com">kobus.bensch@lovefilm.com</a> No.9 | 6 Portal Way | London | W3 6RU | T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111 <a href="http://www.lovefilm.com"><img src="cid:part2.04030706.03000901@lovefilm.com"></a> </div> </body> </html>