1165765 – rhn-search doesn't work with oracle

Bug 1165765 - rhn-search doesn't work with oracle

Summary: rhn-search doesn't work with oracle

Keywords:
Status:	CLOSED CURRENTRELEASE
Alias:	None
Product:	Red Hat Satellite 5
Classification:	Red Hat
Component:	Other
Sub Component:
Version:	570
Hardware:	Unspecified
OS:	Unspecified
Priority:	high
Severity:	high
Target Milestone:	---
Assignee:	Stephen Herr
QA Contact:	Pavel Studeník
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:	sat570-blockers
TreeView+	depends on / blocked

Reported:	2014-11-19 16:09 UTC by Pavel Studeník
Modified:	2015-01-13 10:19 UTC (History)
CC List:	3 users (show)
Fixed In Version:	spacewalk-search-2.3.0-7
Doc Type:	Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:	2015-01-13 10:19:01 UTC
Target Upstream Version:
Embargoed:

Attachments	(Terms of Use)

Description Pavel Studeník 2014-11-19 16:09:25 UTC

Description of problem:
Unlink java library "java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path"

Version-Release number of selected component (if applicable):
spacewalk-search-2.3.0-6.el6sat.noarch

How reproducible:
always on oracle

Steps to Reproduce:
1. Install satellite 5.7

Additional info:
>> rhn-search restart
>> tail -f /var/log/rhn/search/rhn_search_daemon.log
STATUS | wrapper  | 2014/11/19 10:53:29 | TERM trapped.  Shutting down.
STATUS | wrapper  | 2014/11/19 10:53:30 | <-- Wrapper Stopped
STATUS | wrapper  | 2014/11/19 10:53:30 | --> Wrapper Started as Daemon
STATUS | wrapper  | 2014/11/19 10:53:30 | Launching a JVM...
INFO   | jvm 1    | 2014/11/19 10:53:30 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
INFO   | jvm 1    | 2014/11/19 10:53:30 |   Copyright 1999-2006 Tanuki Software, Inc.  All Rights Reserved.
INFO   | jvm 1    | 2014/11/19 10:53:30 | 
INFO   | jvm 1    | 2014/11/19 10:53:31 | XI 19, 2014 10:53:31 DOP. com.mchange.v2.log.MLog <clinit>
INFO   | jvm 1    | 2014/11/19 10:53:31 | INFO: MLog clients using java 1.4+ standard logging.
INFO   | jvm 1    | 2014/11/19 10:53:31 | XI 19, 2014 10:53:31 DOP. com.mchange.v2.c3p0.C3P0Registry banner
INFO   | jvm 1    | 2014/11/19 10:53:31 | INFO: Initializing c3p0-0.9.1.2 [built 31-March-2011 15:45:28; debug? false; trace: 5]
INFO   | jvm 1    | 2014/11/19 10:53:31 | XI 19, 2014 10:53:31 DOP. com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
INFO   | jvm 1    | 2014/11/19 10:53:31 | INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> com.redhat.satellite.search.config.translator.RhnConnectionCustomizer, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 2sis33951jpblhdasqbm7|643b0560, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2sis33951jpblhdasqbm7|643b0560, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:oci:@//guest:1522/rhnsat.world, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
INFO   | jvm 1    | 2014/11/19 10:53:32 | Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1" java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1886)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.lang.Runtime.loadLibrary0(Runtime.java:849)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.lang.System.loadLibrary(System.java:1088)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3147)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.security.AccessController.doPrivileged(Native Method)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3143)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
INFO   | jvm 1    | 2014/11/19 10:53:32 | Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0" Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2" java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1886)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.lang.Runtime.loadLibrary0(Runtime.java:849)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.lang.System.loadLibrary(System.java:1088)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3147)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.security.AccessController.doPrivileged(Native Method)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3143)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
INFO   | jvm 1    | 2014/11/19 10:53:32 | java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1886)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.lang.Runtime.loadLibrary0(Runtime.java:849)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.lang.System.loadLibrary(System.java:1088)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3147)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at java.security.AccessController.doPrivileged(Native Method)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3143)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
INFO   | jvm 1    | 2014/11/19 10:53:32 | 	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

Comment 4 Pavel Studeník 2014-11-24 16:36:22 UTC

Verified with spacewalk-search-2.3.0-7.el6sat.noarch

Comment 5 Martin Korbel 2015-01-09 12:18:45 UTC

Re-verified Satellite-5.7.0-RHEL6-re20150105.1 (spacewalk-search-2.3.0-7.el6sat)
Using steps described in comment 0.

> tail -f /var/log/rhn/search/rhn_search_daemon.log
STATUS | wrapper  | 2015/01/09 07:15:27 | Launching a JVM...
INFO   | jvm 1    | 2015/01/09 07:15:27 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
INFO   | jvm 1    | 2015/01/09 07:15:27 |   Copyright 1999-2006 Tanuki Software, Inc.  All Rights Reserved.
INFO   | jvm 1    | 2015/01/09 07:15:27 | 
INFO   | jvm 1    | 2015/01/09 07:15:28 | Jan 09, 2015 7:15:28 AM com.mchange.v2.log.MLog <clinit>
INFO   | jvm 1    | 2015/01/09 07:15:28 | INFO: MLog clients using java 1.4+ standard logging.
INFO   | jvm 1    | 2015/01/09 07:15:28 | Jan 09, 2015 7:15:28 AM com.mchange.v2.c3p0.C3P0Registry banner
INFO   | jvm 1    | 2015/01/09 07:15:28 | INFO: Initializing c3p0-0.9.1.2 [built 31-March-2011 15:45:28; debug? false; trace: 5]
INFO   | jvm 1    | 2015/01/09 07:15:29 | Jan 09, 2015 7:15:29 AM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
INFO   | jvm 1    | 2015/01/09 07:15:29 | INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> com.redhat.satellite.search.config.translator.RhnConnectionCustomizer, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 2sismk961lbvkr71xcjlp8|1f457048, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2sismk961lbvkr71xcjlp8|1f457048, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:oci:@//guest:1522/rhnsat.world, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]

Comment 6 Clifford Perry 2015-01-13 10:19:01 UTC

With the release of Red Hat Satellite 5.7 on January 12th 2015 this bug is
being moved to a Closed Current Release state. 

The Satellite 5.7 GA Errata:
 - https://rhn.redhat.com/errata/RHSA-2015-0033.html 

Satellite 5.7 Release Notes:
 -
https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html-single/Release_Notes/index.html

Satellite Customer Portal Blog announcement for release:
 - https://access.redhat.com/blogs/1169563/posts/1315743 

Cliff

Note You need to log in before you can comment on or make changes to this bug.