[Spacewalk-list] Oracle 11g issues
Mark Watts
m.watts at linux-corner.info
Tue Apr 19 14:07:09 UTC 2011
On Tue, 19 Apr 2011 12:02:18 +0100, Mark Watts <m.watts at linux-corner.info>
wrote:
> On Tue, 19 Apr 2011 11:18:46 +0200, Michael Mraka
> <michael.mraka at redhat.com> wrote:
>> Mark Watts wrote:
>> % I'm currently trying to install Spacewalk 1.3 with Oracle 11g
> ("Standard
>> % Edition One").
>> %
>> % I've followed these guides:
>> %
>> % https://fedorahosted.org/spacewalk/wiki/HowToInstall
>> % https://fedorahosted.org/spacewalk/wiki/OracleXeSetup
>> %
>>
>
http://flakrat.blogspot.com/2010/04/migrate-red-hat-spacewalk-server-from.html
>> %
>> % The latter guide being where I got my Oracle installation settings
> from.
>> %
>> % I can install Oracle OK.
>> % I can run "spacewalk-setup --disconnected", and it will happily
> populate
>> % the "orcl" database for me.
>> %
>> % My problems begin when the installer tries to restart osa-dispatcher,
>> % which fails to start with the following:
>>
>> Hi Mark,
>>
>> is it 'nothing works' or 'everything but osa-dispatcher works' issue?
>> Are there any errors in alert_*.log or listener.log on your oracle
> database
>> server?
>
> Well since the installer never completes (it never gets a page back from
> the server), I guess nothing works.
>
> https://satellite.example.com/ redirects me to
> https://satellite.example.com/rhn/Login.do
>
> But I get a blank page and a 500 in the logs.
>
With help from people in #spacewalk, I added ORACLE_HOME, ORACLE_BASE and
ORACLE_SID to /etc/sysconfig/osa-dispatcher, and that made osa-dispatcher
happy.
I'm not sure why these weren't being picked up from
/etc/profile.d/ora_env.sh though.
Tomcat is my next stumbling block;
Using CATALINA_BASE: /usr/share/tomcat5
Using CATALINA_HOME: /usr/share/tomcat5
Using CATALINA_TMPDIR: /usr/share/tomcat5/temp
Using JRE_HOME:
Apr 19, 2011 2:47:17 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in
production environments was not found on the java.library.path:
/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64/server:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/../lib/amd64:/usr/lib/oracle/11.2/client64/lib:/usr/lib/oracle/11.2/client/lib:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
Apr 19, 2011 2:47:17 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-127.0.0.1-8080
Apr 19, 2011 2:47:17 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 461 ms
Apr 19, 2011 2:47:17 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 19, 2011 2:47:17 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Apr 19, 2011 2:47:17 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Apr 19, 2011 2:47:17 PM org.apache.catalina.startup.HostConfig
deployDescriptor
WARNING: A docBase /var/lib/tomcat5/webapps/rhn inside the host appBase
has been specified, and will be ignored
Apr 19, 2011 2:47:17 PM org.apache.catalina.core.ContainerBase
addChildInternal
SEVERE: ContainerBase.addChild: start:
LifecycleException: Error initializaing : java.lang.NullPointerException
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3986)
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:634)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:561)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:496)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1193)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319)
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)
Apr 19, 2011 2:47:17 PM org.apache.catalina.startup.HostConfig
deployDescriptor
SEVERE: Error deploying configuration descriptor rhn.xml
java.lang.IllegalStateException: ContainerBase.addChild: start:
LifecycleException: Error initializaing : java.lang.NullPointerException
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:764)
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:634)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:561)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:496)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1193)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319)
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)
Apr 19, 2011 2:47:21 PM com.mchange.v2.log.MLog <clinit>
INFO: MLog clients using java 1.4+ standard logging.
Apr 19, 2011 2:47:21 PM com.mchange.v2.c3p0.C3P0Registry banner
INFO: Initializing c3p0-0.9.0 [built 13-July-2007 10:11:26 -0400; debug?
false; trace: 5]
Apr 19, 2011 2:47:21 PM com.mchange.v2.c3p0.PoolBackedDataSource
getPoolManager
INFO: Initializing c3p0 pool...
com.mchange.v2.c3p0.PoolBackedDataSource at c423d4f [ connectionPoolDataSource
-> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource at 5735b26 [
acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay ->
1000, autoCommitOnClose -> false, automaticTestTable -> null,
breakAfterAcquireFailure -> false, checkoutTimeout -> 0,
connectionTesterClassName ->
com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation ->
null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 5735b26,
idleConnectionTestPeriod -> 300, initialPoolSize -> 5, maxIdleTime -> 300,
maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0,
minPoolSize -> 5, nestedDataSource ->
com.mchange.v2.c3p0.DriverManagerDataSource at 9d532ae [ description -> null,
driverClass -> null, factoryClassLocation -> null, identityToken ->
9d532ae, jdbcUrl -> jdbc:oracle:oci:@orcl, properties -> {user=******,
password=******, driver_proto=jdbc:oracle:oci} ], preferredTestQuery ->
null, propertyCycle -> 300, testConnectionOnCheckin -> false,
testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies ->
false ], factoryClassLocation -> null, identityToken -> c423d4f,
numHelperThreads -> 3 ]
Apr 19, 2011 2:47:57 PM
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 919db9e
-- 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-04-19 14:47:57,086 [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:222)
at
com.redhat.rhn.common.hibernate.ConnectionManager.initialize(ConnectionManager.java:132)
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.deployDirectory(HostConfig.java:975)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:938)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1193)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319)
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
Apr 19, 2011 2:47:57 PM
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
WARNING:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 2d9f90e3 --
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).
Mark.
More information about the Spacewalk-list
mailing list