Oraclue

Oracle internals, debugging and undocumented features

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: