Not sure it's the right forum neither the right topic to talk about but I'm very excited by 11g new features and I wish I could make everything run (huge work !). I'm facing a pb with DRCP :
1- I've slightly changed the default pool settings to reach the limit faster :
exec dbms_connection_pool.alter_param( -
'SYS_DEFAULT_CONNECTION_POOL','MAX_THINK_TIME',30)
exec dbms_connection_pool.alter_param( -
'SYS_DEFAULT_CONNECTION_POOL','MINSIZE',1)
exec dbms_connection_pool.alter_param( -
'SYS_DEFAULT_CONNECTION_POOL','MAXSIZE',2)
exec dbms_connection_pool.alter_param( -
'SYS_DEFAULT_CONNECTION_POOL','INCRSIZE',1)
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 1 2 1 20
300 30 500000 86400
2- I use SQL Plus to connect (serveroutput is off). The first session connect well :
sqlplus scott/tiger@orcl_pooled
3- After 1 minute, I issue a SELECT and get something like that :
select sys_context('USERENV', 'SESSIONID') from dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 6810
Session ID: 139 Serial number: 9
4- If I connect from another session before the first connection die I get this error message:
ORA-03114: not connected to ORACLE
Errors in file :
OCI-21500: internal error code, arguments: [kpplcSyncState:Error in sync], [1041], [], [], [], [], [], []
...
I use 11.1.0.6 for database and sqlplus.
Do you manage to make DRCP work ? Is it some limitations due to the Developer Preview ?