Hi Thomas
Loaded plugins: fastestmirror, rhnplugin
This system is not registered with RHN.
RHN support will be disabled.
Loading mirror speeds from cached hostfile
* addons: mirror.ox.ac.uk
* base: mirror.netrino.co.uk
* epel: mirror01.th.ifl.net
* extras: www.mirrorservice.org
* rpmforge: fr2.rpmfind.net
* updates: mirror.netrino.co.uk
repo id repo
name status
addons CentOS-5 -
Addons enabled: 0
base CentOS-5 -
Base enabled: 3,434
epel Extra Packages for Enterprise Linux
5 - x86_64 enabled: 6,218
extras CentOS-5 -
Extras enabled: 296
rpmforge RHEL 5 - RPMforge.net -
dag enabled: 10,272
spacewalk
Spacewalk
enabled: 199
spacewalk-client Spacewalk Client
Tools enabled: 22
updates CentOS-5 -
Updates enabled: 1,135
repolist: 21,576
Tomas Lestach wrote:
Hello
Kobus,
would you post output of
yum repolist
?
Regards,
Tomas
--
Tomas Lestach
RHN Satellite Engineering, Red Hat
On 02/09/2011 03:29 PM, Kobus Bensch wrote:
Hi Sander
Sander Grendelman wrote:
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?
removed the 10g version and installed the 11g one
* Could this be a non-upgrade-related
DB-issue (e.g. size> 4GB)?
db size = 2.47GB
* What are the differences between the pre-
and post-upgrade rhn.conf
files?
diff is that i am now not using tnsnames.ora, but get the same result
no
matter which one I use.
ran spacewalk-setup --upgrade after tnsnames.ora removal
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
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
--
*Kobus Bensch*
Linux Administrator
kobus.ben...@lovefilm.com
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 visithttp://www.mimecast.co.uk
------------------------------------------------------------------------
------------------------------------------------------------------------
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
--
*Kobus Bensch*
Linux Administrator
kobus.ben...@lovefilm.com
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
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
--
*Kobus Bensch*
Linux Administrator
kobus.ben...@lovefilm.com
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
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
--
Kobus Bensch
Linux Administrator
kobus.ben...@lovefilm.com
No.9 | 6 Portal Way | London | W3 6RU |
T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111
|