DRCP Connections Results in ORA-28547 or ORA-3135 (Doc ID 563943.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Net Services - Version 11.1.0.6.0 to 11.1.0.7.0 [Release 11.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Connections using Database Resident Connection Pooling (DRCP), connection string containing SERVER=POOLED, fail with error code

Windows

SQL> connect scott/tiger@sample.com
Enter password:
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error


Oracle Net client trace

nserror: nsres: id=0, op=68, ns=12537, ns2=12560;  nt[0]=507, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsbasic_brc: exit: oln=0, dln=0, tot=0, rc=-1
nioqer: entry
nioqer:  incoming err = 12151
nioqce: entry
nioqce: exit
nioqer:  returning err = 3113

Unix

SQL> connect scott/tiger@sample.com  
ERROR:   
ORA-03135: connection lost contact   
Process ID: 0   
Session ID: 140 Serial number: 84  

Unix Oracle Net Client trace shows

nserror: nsres: id=0, op=68, ns=12547, ns2=12560;  nt[0]=517, nt[1]=104, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0 
nsbasic_brc: exit: oln=0, dln=0, tot=0, rc=-1 
nioqrc: wanted 1 got 0, type 0 
nioqper: error from nioqrc 
nioqper: ns main err code: 12547 
nioqper: ns (2) err code: 12560 
nioqper: nt main err code: 517 
nioqper: nt (2) err code: 104 
nioqper: nt OS err code: 0 
nioqer: entry 
nioqer: incoming err = 12151 
nioqce: entry 
nioqce: exit 
nioqer: returning err = 3135 
nioqer: exit 

Dedicated or Shared Server connections (SERVER=DEDICATED or SERVER=SHARED) work fine.

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