<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=windows-1252"
 http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">      
    
Ok, renamed the tnsnames.ora and re-ran   spacewalk-setup --upgrade
<br>
<br>
Stopped and started oracle and spacewalk and getting the folloign in
the catalina logs:<br>
<br>
07-Feb-2011 15:56:19
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run<br>
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).<br>
2011-02-07 15:56:19,562 [TP-Processor3] WARN 
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null<br>
2011-02-07 15:56:19,562 [TP-Processor3] ERROR
org.hibernate.util.JDBCExceptionReporter - Connections could not be
acquired from the underlying database!<br>
2011-02-07 15:56:19,562 [TP-Processor3] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during
transaction. Rolling back<br>
com.redhat.rhn.common.hibernate.HibernateRuntimeException: couldn't
open session<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:303)<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getSession(ConnectionManager.java:287)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.getSession(HibernateFactory.java:318)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:277)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:291)<br>
        at
com.redhat.rhn.domain.session.WebSessionFactory.save(WebSessionFactory.java:71)<br>
        at
com.redhat.rhn.manager.session.SessionManager.makeSession(SessionManager.java:87)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.createPxtSession(PxtSessionDelegateImpl.java:164)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.loadPxtSession(PxtSessionDelegateImpl.java:110)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.getPxtSession(PxtSessionDelegateImpl.java:46)<br>
        at
com.redhat.rhn.frontend.struts.RequestContext.getWebSession(RequestContext.java:532)<br>
        at
com.redhat.rhn.frontend.struts.RequestContext.getLoggedInUser(RequestContext.java:172)<br>
        at
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.initializeContext(LocalizedEnvironmentFilter.java:78)<br>
        at
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:66)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)<br>
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)<br>
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br>
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br>
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br>
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br>
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<br>
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<br>
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<br>
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<br>
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<br>
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<br>
        at java.lang.Thread.run(Thread.java:636)<br>
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open
connection<br>
        at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)<br>
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)<br>
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<br>
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)<br>
        at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)<br>
        at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)<br>
        at
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)<br>
        at
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)<br>
        at
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:300)<br>
        ... 37 more<br>
Caused by: java.sql.SQLException: Connections could not be acquired
from the underlying database!<br>
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)<br>
        at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236)<br>
        at
com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)<br>
        at
org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)<br>
        at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)<br>
        ... 42 more<br>
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException:
A ResourcePool could not acquire a resource from its primary factory or
source.<br>
        at
com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)<br>
        at
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)<br>
        at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)<br>
        ... 45 more<br>
2011-02-07 15:56:19,563 [TP-Processor3] ERROR
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action]
- Servlet.service() for servlet action threw exception<br>
com.redhat.rhn.common.hibernate.HibernateRuntimeException: couldn't
open session<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:303)<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getSession(ConnectionManager.java:287)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.getSession(HibernateFactory.java:318)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:277)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:291)<br>
        at
com.redhat.rhn.domain.session.WebSessionFactory.save(WebSessionFactory.java:71)<br>
        at
com.redhat.rhn.manager.session.SessionManager.makeSession(SessionManager.java:87)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.createPxtSession(PxtSessionDelegateImpl.java:164)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.loadPxtSession(PxtSessionDelegateImpl.java:110)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.getPxtSession(PxtSessionDelegateImpl.java:46)<br>
        at
com.redhat.rhn.frontend.struts.RequestContext.getWebSession(RequestContext.java:532)<br>
        at
com.redhat.rhn.frontend.struts.RequestContext.getLoggedInUser(RequestContext.java:172)<br>
        at
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.initializeContext(LocalizedEnvironmentFilter.java:78)<br>
        at
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:66)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)<br>
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)<br>
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br>
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br>
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br>
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br>
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<br>
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<br>
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<br>
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<br>
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<br>
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<br>
        at java.lang.Thread.run(Thread.java:636)<br>
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open
connection<br>
        at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)<br>
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)<br>
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<br>
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)<br>
        at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)<br>
        at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)<br>
        at
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)<br>
        at
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)<br>
        at
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:300)<br>
        ... 37 more<br>
Caused by: java.sql.SQLException: Connections could not be acquired
from the underlying database!<br>
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)<br>
        at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236)<br>
        at
com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)<br>
        at
org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)<br>
        at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)<br>
        ... 42 more<br>
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException:
A ResourcePool could not acquire a resource from its primary factory or
source.<br>
        at
com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)<br>
        at
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)<br>
        at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)<br>
        ... 45 more<br>
07-Feb-2011 15:56:48
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run<br>
WARNING:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2e6b611e --
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).<br>
2011-02-07 15:56:48,398 [TP-Processor3] WARN 
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null<br>
2011-02-07 15:56:48,398 [TP-Processor3] ERROR
org.hibernate.util.JDBCExceptionReporter - Connections could not be
acquired from the underlying database!<br>
2011-02-07 15:56:48,399 [TP-Processor3] ERROR
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp]
- Servlet.service() for servlet
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp threw
exception<br>
com.mchange.v2.resourcepool.CannotAcquireResourceException: A
ResourcePool could not acquire a resource from its primary factory or
source.<br>
        at
com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)<br>
        at
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)<br>
        at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)<br>
        at
com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)<br>
        at
org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)<br>
        at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)<br>
        at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)<br>
        at
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)<br>
        at
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)<br>
        at
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:300)<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getSession(ConnectionManager.java:287)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.getSession(HibernateFactory.java:318)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:277)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:291)<br>
        at
com.redhat.rhn.domain.session.WebSessionFactory.save(WebSessionFactory.java:71)<br>
        at
com.redhat.rhn.manager.session.SessionManager.makeSession(SessionManager.java:87)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.createPxtSession(PxtSessionDelegateImpl.java:164)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.loadPxtSession(PxtSessionDelegateImpl.java:110)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.getPxtSession(PxtSessionDelegateImpl.java:46)<br>
        at
com.redhat.rhn.frontend.struts.RequestContext.getWebSession(RequestContext.java:532)<br>
        at
com.redhat.rhn.frontend.struts.RequestContext.getLoggedInUser(RequestContext.java:172)<br>
        at
com.redhat.rhn.manager.acl.AclManager.hasAcl(AclManager.java:49)<br>
        at
com.redhat.rhn.frontend.taglibs.RequireTag.doStartTag(RequireTag.java:101)<br>
        at
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspx_meth_rhn_005frequire_005f0(Unknown
Source)<br>
        at
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)<br>
        at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)<br>
        at
org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)<br>
        at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)<br>
        at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:605)<br>
        at
com.opensymphony.module.sitemesh.taglib.page.ApplyDecoratorTag.doEndTag(ApplyDecoratorTag.java:255)<br>
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspx_meth_page_005fapplyDecorator_005f0(Unknown
Source)<br>
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br>
        at
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)<br>
        at
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)<br>
        at
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)<br>
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)<br>
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br>
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br>
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br>
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<br>
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<br>
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<br>
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<br>
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<br>
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<br>
        at java.lang.Thread.run(Thread.java:636)<br>
2011-02-07 15:56:48,399 [TP-Processor3] ERROR
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp]
- Servlet.service() for servlet
org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp threw exception<br>
com.mchange.v2.resourcepool.CannotAcquireResourceException: A
ResourcePool could not acquire a resource from its primary factory or
source.<br>
        at
com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)<br>
        at
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)<br>
        at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)<br>
        at
com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)<br>
        at
org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)<br>
        at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)<br>
        at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)<br>
        at
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)<br>
        at
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)<br>
        at
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:300)<br>
        at
com.redhat.rhn.common.hibernate.ConnectionManager.getSession(ConnectionManager.java:287)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.getSession(HibernateFactory.java:318)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:277)<br>
        at
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:291)<br>
        at
com.redhat.rhn.domain.session.WebSessionFactory.save(WebSessionFactory.java:71)<br>
        at
com.redhat.rhn.manager.session.SessionManager.makeSession(SessionManager.java:87)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.createPxtSession(PxtSessionDelegateImpl.java:164)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.loadPxtSession(PxtSessionDelegateImpl.java:110)<br>
        at
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.getPxtSession(PxtSessionDelegateImpl.java:46)<br>
        at
com.redhat.rhn.frontend.struts.RequestContext.getWebSession(RequestContext.java:532)<br>
        at
com.redhat.rhn.frontend.struts.RequestContext.getLoggedInUser(RequestContext.java:172)<br>
        at
com.redhat.rhn.manager.acl.AclManager.hasAcl(AclManager.java:49)<br>
        at
com.redhat.rhn.frontend.taglibs.RequireTag.doStartTag(RequireTag.java:101)<br>
        at
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspx_meth_rhn_005frequire_005f0(Unknown
Source)<br>
        at
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)<br>
        at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)<br>
        at
org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)<br>
        at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)<br>
        at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:605)<br>
        at
com.opensymphony.module.sitemesh.taglib.page.ApplyDecoratorTag.doEndTag(ApplyDecoratorTag.java:255)<br>
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspx_meth_page_005fapplyDecorator_005f0(Unknown
Source)<br>
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br>
        at
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)<br>
        at
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)<br>
        at
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)<br>
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)<br>
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br>
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br>
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br>
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<br>
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<br>
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<br>
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<br>
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<br>
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<br>
        at java.lang.Thread.run(Thread.java:636)<br>
javax.servlet.ServletException: javax.servlet.jsp.JspException: Error
writing to JSP file:<br>
        at
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:842)<br>
        at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)<br>
        at
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)<br>
        at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)<br>
        at
org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)<br>
        at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)<br>
        at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:605)<br>
        at
com.opensymphony.module.sitemesh.taglib.page.ApplyDecoratorTag.doEndTag(ApplyDecoratorTag.java:255)<br>
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspx_meth_page_005fapplyDecorator_005f0(Unknown
Source)<br>
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br>
        at
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)<br>
        at
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)<br>
        at
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)<br>
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)<br>
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br>
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br>
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br>
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<br>
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<br>
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<br>
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<br>
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<br>
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<br>
        at java.lang.Thread.run(Thread.java:636)<br>
2011-02-07 15:56:48,402 [TP-Processor3] ERROR
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp]
- Servlet.service() for servlet
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp threw exception<br>
javax.servlet.jsp.JspException: javax.servlet.ServletException:
javax.servlet.jsp.JspException: Error writing to JSP file:<br>
        at
com.opensymphony.module.sitemesh.taglib.page.ApplyDecoratorTag.doEndTag(ApplyDecoratorTag.java:270)<br>
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspx_meth_page_005fapplyDecorator_005f0(Unknown
Source)<br>
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br>
        at
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)<br>
        at
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)<br>
        at
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)<br>
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)<br>
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br>
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br>
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br>
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<br>
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<br>
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<br>
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<br>
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<br>
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<br>
        at java.lang.Thread.run(Thread.java:636)<br>
07-Feb-2011 15:56:48 org.apache.catalina.core.StandardHostValve custom<br>
SEVERE: Exception Processing ErrorPage[errorCode=500,
location=/WEB-INF/pages/common/errors/500.jsp]<br>
javax.servlet.ServletException: javax.servlet.ServletException:
javax.servlet.jsp.JspException: Error writing to JSP file:<br>
        at
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)<br>
        at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)<br>
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown
Source)<br>
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br>
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)<br>
        at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br>
        at
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)<br>
        at
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)<br>
        at
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)<br>
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)<br>
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br>
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br>
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br>
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<br>
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<br>
        at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<br>
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<br>
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<br>
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<br>
        at java.lang.Thread.run(Thread.java:636)<br>
07-Feb-2011 15:56:49
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run<br>
WARNING:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1c465648 --
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).<br>
07-Feb-2011 15:56:57
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run<br>
WARNING:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@4dca9f78 --
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).<br>
<br>
<br>
Jan Pazdziora wrote:
<blockquote cite="mid:20110207150600.GL3514@redhat.com" type="cite">
  <pre wrap="">On Mon, Feb 07, 2011 at 02:55:09PM +0000, Kobus Bensch wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">I tried again after removeing the tnsnames.ora and restart both
oracle and spacewalk.

I started oracle xe and it seems to be ok.
/etc/init.d/oracle-xe status
    </pre>
  </blockquote>
  <pre wrap=""><!---->
[...]

  </pre>
  <blockquote type="cite">
    <pre wrap="">/etc/init.d/oracle-xe status
    </pre>
  </blockquote>
  <pre wrap=""><!---->
[...]

  </pre>
  <blockquote type="cite">
    <pre wrap="">I then started spacwalk and got the following

/usr/sbin/spacewalk-service start
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Did you run spacewalk-setup --upgrade after doing that change? Because
otherwise you have bad connect information in /etc/rhn/rhn.conf for
sure. You cannot just remove tnsnames.ora and expect things to
continue working.

  </pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b>Kobus Bensch</b><br>
Linux Administrator<br>
<a class="moz-txt-link-abbreviated" href="mailto:kobus.bensch@lovefilm.com">kobus.bensch@lovefilm.com</a><br>
<br>
No.9 | 6 Portal Way | London | W3 6RU |<br>
T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111<br>
<a href="http://www.lovefilm.com"><img
 src="cid:part1.01010805.00000202@lovefilm.com"></a>
</div>

    <BR>
    <BR>
   <span style="font-family:Arial; Font-size:10.0pt">
<hr width="100%">
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face=Verdana size=2>LOVEFiLM UK Limited is a 
company registered in England and Wales. <BR>Registered Number: 06528297. <BR>Registered Office: 
No.9, 6 Portal Way, London W3 6RU, United Kingdom.</FONT></P> <P><FONT face=Verdana size=2>
This e-mail is confidential to the ordinary user of the e-mail address to which it was <BR>addressed. 
If you have received it in error, please delete it from your system and notify <BR>the sender 
immediately.<BR><BR> 

This email message has been delivered safely and archived online by Mimecast.<BR>
For more information please visit <a href="http://www.mimecast.co.uk">http://www.mimecast.co.uk</a>
</P><hr width="100%">
  </span>
 </body>
</html>