I haven't upgraded to 1.3 yet ( and I'm quite glad I didn't at the moment ). So I can only offer some pointers from my experience working with Oracle DB's ;)
* Did you remove the 10.2 instantclient or did you install the 11g-instantclient side-by-side? * Could this be a non-upgrade-related DB-issue (e.g. size > 4GB)? * What are the differences between the pre- and post-upgrade rhn.conf files? On Wed, Feb 09, 2011 at 12:58:11PM +0000, Kobus Bensch wrote: > Is anybody able to assist please. I need to manage some servers > > Thanks > > Kobus > > Kobus Bensch wrote: >> 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: >>> 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 >>> [email protected] >>> https://www.redhat.com/mailman/listinfo/spacewalk-list >> >> -- >> *Kobus Bensch* >> Linux Administrator >> [email protected] >> >> No.9 | 6 Portal Way | London | W3 6RU | >> T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111 >> <http://www.lovefilm.com> >> >> >> ------------------------------------------------------------------------ >> >> 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 http://www.mimecast.co.uk >> >> ------------------------------------------------------------------------ >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Spacewalk-list mailing list >> [email protected] >> https://www.redhat.com/mailman/listinfo/spacewalk-list > > -- > *Kobus Bensch* > Linux Administrator > [email protected] > > No.9 | 6 Portal Way | London | W3 6RU | > T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111 > <http://www.lovefilm.com> > _______________________________________________ > 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
