Hi, It means, which your Oracle server has not appropriate listener configured[1]. Please configure you rdbms, using lsnrctl utility.
[1]: http://www.dba-oracle.com/sf_ora_12519_tns_no_appropriate_service_handler_found.htm On Tue, Dec 27, 2016 at 1:05 PM, rishi007bansod <[email protected]> wrote: > When I enable writethrough operation to oracle DB and writebehind operation > is disabled, I am getting following error: > > Exception in thread "main" javax.cache.integration.CacheWriterException: > class > org.apache.ignite.internal.processors.cache.CachePartialUpdateCheckedExcep > tion: > Failed to update keys (retry update if possible).: [Orders5Key [oId=3015, > oDId=7, oWId=4]] > at > org.apache.ignite.internal.processors.cache.GridCacheUtils. > convertToCacheException(GridCacheUtils.java:1485) > at > org.apache.ignite.internal.processors.cache.IgniteCacheProxy. > cacheException(IgniteCacheProxy.java:2021) > at > org.apache.ignite.internal.processors.cache.IgniteCacheProxy.put( > IgniteCacheProxy.java:1221) > at test370.new_order(test370.java:765) > at test370.main(test370.java:477) > Caused by: class > org.apache.ignite.internal.processors.cache.CachePartialUpdateCheckedExcep > tion: > Failed to update keys (retry update if possible).: [Orders5Key [oId=3015, > oDId=7, oWId=4]] > at > org.apache.ignite.internal.processors.cache.distributed.dht.atomic. > GridNearAtomicSingleUpdateFuture.onResult(GridNearAtomicSingleUpdateFutu > re.java:232) > at > org.apache.ignite.internal.processors.cache.distributed.dht.atomic. > GridNearAtomicSingleUpdateFuture$3.apply(GridNearAtomicSingleUpdateFutu > re.java:455) > at > org.apache.ignite.internal.processors.cache.distributed.dht.atomic. > GridNearAtomicSingleUpdateFuture$3.apply(GridNearAtomicSingleUpdateFutu > re.java:453) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal0( > GridDhtAtomicCache.java:1744) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal( > GridDhtAtomicCache.java:1490) > at > org.apache.ignite.internal.processors.cache.distributed.dht.atomic. > GridNearAtomicSingleUpdateFuture.mapSingle(GridNearAtomicSingleUpdateFutu > re.java:452) > at > org.apache.ignite.internal.processors.cache.distributed.dht.atomic. > GridNearAtomicSingleUpdateFuture.map(GridNearAtomicSingleUpdateFutu > re.java:569) > at > org.apache.ignite.internal.processors.cache.distributed.dht.atomic. > GridNearAtomicSingleUpdateFuture.mapOnTopology( > GridNearAtomicSingleUpdateFuture.java:441) > at > org.apache.ignite.internal.processors.cache.distributed.dht.atomic. > GridNearAtomicAbstractUpdateFuture.map(GridNearAtomicAbstractUpdateFu > ture.java:207) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache$22.apply(GridDhtAtomicCache.java:1015) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache$22.apply(GridDhtAtomicCache.java:1013) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache.asyncOp(GridDhtAtomicCache.java:711) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache.updateAsync0(GridDhtAtomicCache.java:1013) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache.putAsync0(GridDhtAtomicCache.java:483) > at > org.apache.ignite.internal.processors.cache.GridCacheAdapter.putAsync( > GridCacheAdapter.java:2541) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache.put(GridDhtAtomicCache.java:460) > at > org.apache.ignite.internal.processors.cache.GridCacheAdapter.put( > GridCacheAdapter.java:2215) > at > org.apache.ignite.internal.processors.cache.IgniteCacheProxy.put( > IgniteCacheProxy.java:1214) > ... 2 more > Suppressed: class org.apache.ignite.IgniteCheckedException: > Failed to > update keys on primary node. > at > org.apache.ignite.internal.processors.cache.distributed.dht.atomic. > GridNearAtomicUpdateResponse.addFailedKey(GridNearAtomicUpdateResponse. > java:350) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache.updateSingle(GridDhtAtomicCache.java:2393) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal0( > GridDhtAtomicCache.java:1652) > ... 16 more > Suppressed: class org.apache.ignite.IgniteCheckedException: > Failed to > write entry to database [table=C##TPCCTEST.ORDERS5, entry=Entry > [key=Orders5Key [oId=3015, oDId=7, oWId=4], val=Orders5 [oId=3015, oDId=7, > oWId=4, oCId=2020, oEntryD=2016-12-27 15:04:34.172, oCarrierId=null, > oOlCnt=12, oAllLocal=1]]] > at > org.apache.ignite.internal.processors.cache.store. > GridCacheStoreManagerAdapter.put(GridCacheStoreManagerAdapter.java:583) > at > org.apache.ignite.internal.processors.cache.GridCacheMapEntry.innerUpdate( > GridCacheMapEntry.java:2425) > at > org.apache.ignite.internal.processors.cache.distributed. > dht.atomic.GridDhtAtomicCache.updateSingle(GridDhtAtomicCache.java:2252) > ... 17 more > Caused by: javax.cache.integration.CacheWriterException: > Failed to write > entry to database [table=C##TPCCTEST.ORDERS5, entry=Entry [key=Orders5Key > [oId=3015, oDId=7, oWId=4], val=Orders5 [oId=3015, oDId=7, oWId=4, > oCId=2020, oEntryD=2016-12-27 15:04:34.172, oCarrierId=null, oOlCnt=12, > oAllLocal=1]]] > at > org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore. > write(CacheAbstractJdbcStore.java:1020) > at > org.apache.ignite.internal.processors.cache.store. > GridCacheStoreManagerAdapter.put(GridCacheStoreManagerAdapter.java:575) > ... 19 more > Caused by: java.sql.SQLException: Listener refused the > connection with the > following error: > ORA-12519, TNS:no appropriate service handler found > > at oracle.jdbc.driver.T4CConnection.logon( > T4CConnection.java:673) > at > oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:711) > at oracle.jdbc.driver.T4CConnection.<init>( > T4CConnection.java:385) > at > oracle.jdbc.driver.T4CDriverExtension.getConnection( > T4CDriverExtension.java:30) > at oracle.jdbc.driver.OracleDriver.connect( > OracleDriver.java:558) > at > oracle.jdbc.pool.OracleDataSource.getPhysicalConnection( > OracleDataSource.java:297) > at > oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:224) > at > oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:169) > at > org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.openConnection( > CacheAbstractJdbcStore.java:322) > at > org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.connection( > CacheAbstractJdbcStore.java:352) > at > org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore. > write(CacheAbstractJdbcStore.java:978) > ... 20 more > Caused by: oracle.net.ns.NetException: Listener refused > the connection > with the following error: > ORA-12519, TNS:no appropriate service handler found > > at > oracle.net.ns.NSProtocolStream.negotiateConnection( > NSProtocolStream.java:272) > at oracle.net.ns.NSProtocol. > connect(NSProtocol.java:263) > at oracle.jdbc.driver.T4CConnection.connect( > T4CConnection.java:1360) > at oracle.jdbc.driver.T4CConnection.logon( > T4CConnection.java:486) > ... 30 more > > What can be cause for this error? > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Error-while-writing-to-oracle-DB-tp9740.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Vladislav Pyatkov
