ORA-03135 : Database Resident Connection Pool
Trying to setup DRCP 11g patchset 11.1.0.6 on Linux x86-64..
The pool can be configured using the PLSQL package DBMS_CONNECTION_POOL.
First start connection pool ( I am using default parameters ):
SQL> execute dbms_connection_pool.start_pool;
PL/SQL procedure successfully completed.
Then simply change tnsnames.ora and set
SERVER=POOLED Let’s try to connect
C:\Documents and Settings\admin>sqlplus system@demo11g
SQL*Plus: Release 10.2.0.1.0 – Production on Tue Sep 23 12:58:25 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-03135: connection lost contact
Enter user-name: system@demo11g
Enter password:
ERROR:
ORA-03135: connection lost contact
Enter user-name: system@demo11g
Enter password:
ERROR:
ORA-03135: connection lost contact
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
Check my pool
SQL> select * from dba_cpool_info;
CONNECTION_POOL
——————————————————————————–
STATUS MINSIZE MAXSIZE INCRSIZE SESSION_CACHED_CURSORS
—————- ———- ———- ———- ———————-
INACTIVITY_TIMEOUT MAX_THINK_TIME MAX_USE_SESSION MAX_LIFETIME_SESSION
—————— ————– ————— ——————–
SYS_DEFAULT_CONNECTION_POOL
ACTIVE 4 40 2 20
300 120 500000 86400
It’s ok .. then must be something else ..
Quick look on metalink:
DRCP Connections Fail With ORA-03135: CONNECTION LOST CONTACT
Metalink note: 731301.1
This issue has been reported in Bug 7110055 which has been closed as a duplicate of unpublished <Bug 6183123 >
Fix: Apply patch# 6183123
Download patch
Check the file \etc\config\inventory
<online_rac_installable>true</online_rac_installable>
this is a rolling patch.
Applied patch
Interim patches (1) :
Patch 6183123 : applied on Tue Sep 23 13:48:09 EDT 2008
Created on 15 Aug 2008, 03:51:33 hrs PST8PDT
Bugs fixed:
6183123
Let’s try to connect again
C:\Documents and Settings\admin>sqlplus system@demo11g
SQL*Plus: Release 10.2.0.1.0 – Production on Tue Sep 23 13:53:33 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-56606: DRCP: Client version doesnot support the feature
Patch is good but it’s time to upgrade old Oracle client to 11g.More info about DRCP
http://www.oracle.com/technology/tech/oci/pdf/oracledrcp11g.pdf
