Configuration Of Connection Pool (Doc ID 1391628.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1 [21112] and later
Information in this document applies to any platform.
***Checked for relevance on 20-Nov-2013***

Symptoms


=== ODM Issue Clarification ===

A JDBC application deployed to OAS 10.1.3.5.0 ("home" instance) fails when retrieving records in
a particular page of the application. This issue occurs only in production but not in pre-production environment.

Testing the connection pool in EM console also fails with the error:
ORA-01017: invalid username/password

Application log shows the following stacks:

11/10/24 08:25:44.95 ViewArchive: Servlet error
JBO-30003: The application pool (oracle.apps.ss.base.model.security.SessionAMLocal) failed to checkout an application module due to the following exception:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: oracle.jbo.DMLException, msg=JBO-26061: Error while opening JDBC connection.
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2002)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2793)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:453)
at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:233)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:424)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:419)
at oracle.adf.model.bc4j.DCJboDataControl.rebuildApplicationModule(DCJboDataControl.java:1517)
at oracle.adf.model.bc4j.DCJboDataControl.beginRequest(DCJboDataControl.java:1381)
at oracle.adf.model.binding.DCDataControlReference.getDataControl(DCDataControlReference.java:99)
at oracle.adf.model.BindingContext.get(BindingContext.java:457)
at oracle.adf.model.BindingContext.findDataControl(BindingContext.java:308)
at oracle.apps.ss.base.view.util.SelfServiceFilter.doFilter(SelfServiceFilter.java:155)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
:::::::::::

Environment:
------------------
OAS 10.1.3.5.0
Linux x86 (Red Hat Enterprise 5/Oracle VM)
Oracle Database 11.2.0.2

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