OTAS Server fails to start from the ICSM - OTAS LOG SHOWS: APPS.IEO_ICSM_AQ_PUB (Doc ID 781709.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Advanced Inbound Telephony - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Oracle Telephony Manager - Version: 11.5.10.2
***Checked for relevance on 14-AUG-2013***


Symptoms

Run the ieoicsm.sh script from a Unix platform.

The OTAS Server fails to start.

The following error occurs in OTAS log file:

ERROR
[Thu Jan 15 17:09:19 GMT+04:00 2009] - [ieo:error] - [log.thread:Thread-7] -
java.sql.SQLException: ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_AQ", line 335
ORA-06512: at "APPS.IEO_ICSM_AQ_PUB", line 304
ORA-06512: at line 1

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
at oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Protocol.java:977)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2199)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2059)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2976)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:734)
at oracle.apps.ieo.icsm.db.ICSMDataSourceImpl.dequeueRequest(ICSMDataSourceImpl.java:217)
at oracle.apps.ieo.icsm.db.ICSMDataSourceWrapper.dequeueRequest(ICSMDataSourceWrapper.java:428)
at oracle.apps.ieo.icsm.serverWrapper.RmiBootstrap$AQRunnable.run(RmiBootstrap.java:99)
at java.lang.Thread.run(Thread.java:534)
.
.
.
[Thu Jan 15 17:09:19 GMT+04:00 2009] - [ieo:error] - [log.thread:Thread-7] - Database Connection
Lost :
oracle.apps.ieo.icsm.db.ICSMDataSourceImpl@32efa7 recycled
requesting new connection
[Thu Jan 15 17:09:19 GMT+04:00 2009] - [ieo:verbose] - [log.thread:Thread-7] - No database
connection available , waiting...
[Thu Jan 15 17:09:19 GMT+04:00 2009] - [db:info] - [log.thread:Thread-8] - DB down, this is the 1
time to reconnect
[Thu Jan 15 17:09:19 GMT+04:00 2009] - [db:info] - [log.thread:Thread-8] - trying to get new
database connection...
[Thu Jan 15 17:09:20 GMT+04:00 2009] - [db:info] - [log.thread:Thread-8] - failed to get database
connection, Unknown Error, stack trace :
[Thu Jan 15 17:09:20 GMT+04:00 2009] - [db:info] - [log.thread:Thread-8] -
oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1321)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1062)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:752)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:246)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1951)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2617)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2550)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2408)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2212)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2126)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2139)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1682)
at oracle.apps.ieo.common.db.DBCConnectionFactory.getConnection(DBCConnectionFactory.java:41)
at oracle.apps.ieo.icsm.db.ICSMDataSourceWrapper.createDataSource(ICSMDataSourceWrapper.java:37)
at
oracle.apps.ieo.common.db.BaseDataSourceWrapper$GetConnectionThread.run(BaseDataSourceWrapper.java:4
29)
Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException:
java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:709)
at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:766)
at
oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:603)
at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:246)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1308)
... 14 more
Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: Io exception: Got minus
one from a read call
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1355)
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1258)
at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:694)
... 22 more
Caused by: java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3664)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:353)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1342)
... 24 more



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms