*Bump* I am probably missing something obvious in this output, but my eyes just don't want to see it.
I had the DBA add the following to the database: >From >https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#AdditionalOracleconfiguration > . SQL> alter system set processes = 400 scope=spfile; SQL> alter system set "_optimizer_filter_pred_pullup"=false scope=spfile; SQL> alter system set "_optimizer_cost_based_transformation"=off scope=spfile; Restart the database. This did not resolve my issue. Regards, -Eric ----- Original Message ---- From: Eric <[email protected]> To: Spacewalk List <[email protected]> Sent: Fri, March 5, 2010 2:36:56 PM Subject: [Spacewalk-list] spacewalk/rhn/Login.do is blank I am trying login to Spacewalk through the webUI and the https://spw.mydomain.local/rhn/Login.do is blank. I am able to get the Oracle Database on the Spacewalk server through sqlplus spacewalk/[passwo...@rhnsat . The Oracle database is 11g RAC. I believe that the issue I am having is related to tomcat errors I am seeing. I will gladly post more logs/info upon request. In /var/log/tomcat5/catalina.out I am seeing the following warning: WARNING: com.mchange.v2.resourcepool.basicresourcepool$acquiret...@4bb369 -- 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). 2010-03-04 15:07:48,840 [main] WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236) at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94) at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292) at com.redhat.rhn.common.hibernate.ConnectionManager.createSessionFactory(ConnectionManager.java:173) at com.redhat.rhn.common.hibernate.ConnectionManager.initialize(ConnectionManager.java:119) at com.redhat.rhn.common.hibernate.HibernateFactory.createSessionFactory(HibernateFactory.java:94) at com.redhat.rhn.webapp.RhnServletListener.startHibernate(RhnServletListener.java:89) at com.redhat.rhn.webapp.RhnServletListener.contextInitialized(RhnServletListener.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4212) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source. at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232) ... 34 more It seems to be related to https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#AdditionalOracleconfiguration , but I had our DBA apply those configuration changes to the database. -Eric _______________________________________________ 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
