Product:
Cognos Controller FAP 10.1.1
Oracle Database
Problem:
Error log when start the Controller FAP service
Error message in file C:\Program Files (x86)\ibm\cognos\c10\Server\FAP\error.log
2015-03-17 13:02:48,664 [schedulerThread] ERROR Scheduler – Connection error to FAP database
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername2488.domain.com:1521:FAP42.Domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.trace(LogDaoOracle.java:53)
at com.ibm.cognos.fap.common.persistence.dao.LogDao.info(LogDao.java:121)
at com.ibm.cognos.fap.common.persistence.dao.LogDao$$FastClassByCGLIB$$60127973.invoke(
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:56)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$bd9ad5c2.info(
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:197)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 9 more
Caused by:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.
at oracle.jdbc.driver.T4CConnection.
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 11 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 19 more
2015-03-17 13:02:48,680 [schedulerThread] ERROR RetryInterceptor – Trial 1 failed for method pingDatabase
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$bd9ad5c2.pingDatabase(
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:213)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername2488.domain.com:1521:FAP42.Domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.pingDatabase(LogDaoOracle.java:107)
… 9 more
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 10 more
Caused by:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.
at oracle.jdbc.driver.T4CConnection.
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 12 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 20 more
2015-03-17 13:03:18,695 [schedulerThread] ERROR RetryInterceptor – Trial 2 failed for method pingDatabase
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$bd9ad5c2.pingDatabase(
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:213)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername2488.domain.com:1521:FAP42.Domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.pingDatabase(LogDaoOracle.java:107)
… 9 more
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 10 more
Caused by:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.
at oracle.jdbc.driver.T4CConnection.
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 12 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 20 more
2015-03-17 13:03:48,710 [schedulerThread] ERROR RetryInterceptor – Trial 3 failed for method pingDatabase
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$bd9ad5c2.pingDatabase(
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:213)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername2488.domain.com:1521:FAP42.Domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.pingDatabase(LogDaoOracle.java:107)
… 9 more
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 10 more
Caused by:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.
at oracle.jdbc.driver.T4CConnection.
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 12 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 20 more
Possible solution:
Change in the FAPService.properties file to use a different SID name, try without the domain.com values at the end. The Oracle listener is setup to listen to only the name.
Change from db=fap42.domain.com
To db=fap42
In below file example;
u# IBM SOURCE CODE HEADER START
# =====================================================================
# OCO Source Materials
#
# BI and PM: ccr
#
# (C) Copyright IBM Corp. 2004, 2009. All Rights Reserved
#
# The source code for this program is not published or
# otherwise divested of its trade secrets, irrespective of
# what has been deposited with the U.S. Copyright Office.
# =====================================================================
# IBM SOURCE CODE HEADER END
db=fap42
host=servername.domain.com
dbType=oracle
user=COGFAP
passwd=xxxxxx
clientcamuri=http://biwebalias.domain.com/ibmcognos/cgi-bin/cognosisapi.dll