How to refresh connection pools connecting to SQL server 2008 server on OracleAS 10.1.3.4 ?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    How to refresh connection pools connecting to SQL server 2008 server on OracleAS 10.1.3.4 ?

We have connection pools connecting to SQL server 2008 server. Every time SQL server reboots we need to restart OAS containers also to refresh all connections in production

Solution:

OracleAS OC4J 10.1.3.x only provides auto-refresh of connection pool connecting to Oracle Database. So this mechanism doesn't work for connection pool connecting to other database such as SQL Server. You have to manually refresh it.

 instead of manually refresh the connection pool, you can run against each connection pool the class "ConnectionPoolRefresher"
a tool provided in the

- note 852972.1: How to Refresh a Connection Pool Within OC4J 10.1.3.x Remotely.
- note 567784.1 - How To Monitor A Connection Pool Within OC4J 10.1.3.x Remotely

References:

Note 852972.1: How to Refresh a Connection Pool Within OC4J 10.1.3.x Remotely.
Note 567784.1 - How To Monitor A Connection Pool Within OC4J 10.1.3.x Remotely

Get Oracle Certifications for all Exams
Free Online Exams.com