Integration

Hi,

I am getting the following stack trace in b2b.log file:

2009.01.06 at 14:34:35:869: Thread-108: BusinessLogicLayer - (ERROR) caught error: Error -: AIP-13002: SQL error getting the DataSource
2009.01.06 at 14:34:35:870: Thread-108: IP - (ERROR) java.sql.SQLException: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVICE_NAME=test)))

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:292)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:429)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:608)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:217)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:113)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:76)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:58)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getNewPoolOrXAConnection(OracleConnectionCacheImpl.java:493)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getPooledConnection(OracleConnectionCacheImpl.java:368)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:306)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:285)
at oracle.tip.buslogic.common.DBConnectivity.getConnection(DBConnectivity.java:151)
at oracle.tip.buslogic.common.ExecutionContextImpl.getService(ExecutionContextImpl.java:379)
at oracle.tip.buslogic.common.ExecutionContextImpl.setRuntimeActiveandQuiescing(ExecutionContextImpl.java:799)
at oracle.tip.adapter.b2b.data.B2BExecutionContext.setRuntimeActiveAndQuiescing(B2BExecutionContext.java:130)
at oracle.tip.adapter.b2b.data.B2BExecutionContext.activate(B2BExecutionContext.java:98)
at oracle.tip.adapter.b2b.data.DBContext.initialize(DBContext.java:90)
at oracle.tip.adapter.b2b.data.DataContext.getNewDBContext(DataContext.java:365)
at oracle.tip.adapter.b2b.data.DataContext.getDBContext(DataContext.java:346)
at oracle.tip.adapter.b2b.transport.InterfaceListener.onMessage(InterfaceListener.java:232)
at oracle.tip.transport.basic.FileSourceMonitor.processMessages(FileSourceMonitor.java:858)
at oracle.tip.transport.basic.FileSourceMonitor.run(FileSourceMonitor.java:302)


When I ran the enquire script. I am getting the following exception:

IPEnqueue start...
Action Name = null
oracle.jms.AQjmsException: ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
ORA-06512: at "SYS.DBMS_AQIN", line 454
ORA-06512: at line 1

at oracle.jms.AQjmsProducer.enqueue(AQjmsProducer.java:1180)
at oracle.jms.AQjmsProducer.publish(AQjmsProducer.java:1407)
at oracle.jms.AQjmsProducer.publish(AQjmsProducer.java:1512)
at oracle.tip.adapter.b2b.data.IPEnqueue.main(IPEnqueue.java:201)

[Linked-exception]
java.sql.SQLException: ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
ORA-06512: at "SYS.DBMS_AQIN", line 454
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:183)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:872)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1085)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2983)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3025)
at oracle.jms.AQjmsProducer.enqueue(AQjmsProducer.java:1110)
at oracle.jms.AQjmsProducer.publish(AQjmsProducer.java:1407)
at oracle.jms.AQjmsProducer.publish(AQjmsProducer.java:1512)
at oracle.tip.adapter.b2b.data.IPEnqueue.main(IPEnqueue.java:201)

Error -: AIP-13121: Connection-related error. Please verify that the database server is running.: java.sql.SQLException: Closed Connection
at oracle.tip.buslogic.common.SessionDownException.isSessionDown(SessionDownException.java:96)
at oracle.tip.common.IPException.initIPException(IPException.java:179)
at oracle.tip.common.IPException.<init>(IPException.java:114)
at oracle.tip.repos.core.persistency.DCException.<init>(DCException.java:68)
at oracle.tip.repos.core.driver.CatalogDriver.disconnect(CatalogDriver.java:1666)
at oracle.tip.repos.core.persistency.PersistencyService.disconnect(PersistencyService.java:578)
at oracle.tip.buslogic.common.ExecutionContextImpl.disconnectService(ExecutionContextImpl.java:602)
at oracle.tip.buslogic.common.ExecutionContextManager.cleanContextResources(ExecutionContextManager.java:629)
at oracle.tip.buslogic.common.ExecutionContextManager.leaveContext(ExecutionContextManager.java:581)
at oracle.tip.buslogic.common.ExecutionContextManager.leaveContext(ExecutionContextManager.java:720)
at oracle.tip.adapter.b2b.data.IPEnqueue.main(IPEnqueue.java:245)
Caused by: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:226)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1041)
at oracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:90)
at oracle.tip.repos.core.driver.CatalogDriver.disconnect(CatalogDriver.java:1662)
... 6 more

I tested the database and it was up. Any help is appreciated.