An exception occurred in the method CacheAccess.get

We faced an issue in one of our cloned instance. OACORE j2ee container was throwing the following error in application.log. The users were seeing Internal Server Error in their browsers.

html: LeakSetting: global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false:$ at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:926) at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:891) at oracle.apps.fnd.common.AppsContext.(AppsContext.java:751) at oracle.apps.fnd.common.WebAppsContext.(WebAppsContext.java:1014) at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:525) at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:120) at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2231) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4617) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4541) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2821) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:740) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)Caused by: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: java.lang.NullPointerException: null Connection at oracle.apps.jtf.cache.IASCacheProvider.get(IASCacheProvider.java:712) at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:4802) at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:4624) at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:216) ... 30 moreCaused by: oracle.apps.jtf.base.resources.FrameworkException:An exception occurred in the method CacheAccess.getnullThe base exception is:null Connection at oracle.apps.jtf.base.resources.FrameworkException.convertException(FrameworkException.java:607) at oracle.apps.jtf.base.resources.FrameworkException.addException(FrameworkException.java:585) at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:66) at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:88) at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:202) at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:218) at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:249) ... 34 more09/12/14 22:27:10.447 html: 10.1.3.0.0 Stopped

Fix:
Services work fine on one web node but not in other web node. The reason this was happening was that the node name (where error is encountered) was missing from fnd_nodes. Run autoconfig on the node where you have the issue and it should be fine.

- Aravind Kamath Posral

RC-40201: Unable to connect to Database LT1QSC while running adclonectx.pl

We were trying to generate the xml file in our 11.5.9 environment as part of autoconfig implementation in our environment and we were using adclonectx.pl for this purpose.

The database is a RAC instance and we starting seeing the following issue:
RC-40201: Unable to connect to Database LT1QSC.

The log revealed that database listener was rejecting jdbc connections from adclonectx.pl:
getConnection() -->
sDbHost : psf-db1
sDbDomain : domain.com
sDbPort : 1527
sDbSid : LT1QSC
sDbUser : APPS
Trying to connect using SID...getConnectionUsingSID() --> JDBC URL: jdbc:oracle:thin:@psf-db1.domain.com:1527:LT1QSC
Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Trying to connect using SID as ServiceNamegetConnectionUsingServiceName() --> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=psf-db1.domain.com)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=LT1QSC))) Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
Trying to connect using SID as ServiceName.DomainNamegetConnectionUsingServiceName() --> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=psf-db1.domain.com)(PORT=1527))(CONNECT_DATA=SERVICE_NAME=LT1QSC.domain.com)))
Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=153093888)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=tcp)(HOST=psf-db2.domain.com)(PORT=1527))'))(ERROR=(CO
DE=305)(EMFI=1)))) Connection could not be obtained; returning null

Quick Fix:
shutdown db node 2 and rerun the command, it will go through. This way we are forcing the connection to node 1 itself, as I believe this issue is specific to load balanced environment.

- Aravind Kamath Posral