RE: DBD::Oracle 1.25 and DRCP

Hard to say. 
 
Not sureif the way you are pasing in the sid will work.
 
add dbd_verbose=>15
 
to the conection options hash 
Run the perl and post the output on this thread
so I can have a look at what is going on.
 
Just do a simple connect no need for any other DBI stuff.
 
I would also give the other flavours of connecting a try as well
 
Cheers
John
 

> Date: Fri, 14 Oct 2011 15:06:48 -0400
> Subject: Re: DBD::Oracle 1.25 and DRCP
> From: [email protected]
> To: [email protected]
> 
> Hey Cliff and John,
> 
> on Sept 22, 2010 you posted about issues you were having with getting
> Oracle DRCP working using the ora_drcp_class. I am running into
> similar issues and was wondering if you got DRCP to work and have it
> share the connection. We are using oracle 11.2.0.2 and I have perl
> v5.8.8, DBI 1.602 and DBD::Oracle 1.28.
> 
> here is my Tnsnames and basic connect string(DRCP is setup at the Listener):
> 
> $sid = (DESCRIPTION = (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = $host)(PORT = 1521)))
> (CONNECT_DATA = (SERVICE_NAME = $service)(SERVER=POOLED)))
> 
> 
> $self->{dbh} = DBI->connect("dbi:Oracle:$config->{sid}",
> $config->{user}, $config->{pass},
> { AutoCommit => 0, ora_drcp_class =>
> "feedAutomation" } );
> 
> yet I am not seeing the $user.feedAutomation CClass and I see no
> increase in Num_hits for any class that is there:
> 
> 1* select * from v$cpool_cc_stats
> 
> CCLASS_NAME
> --------------------------------------------------------------------------------
> NUM_REQUESTS NUM_HITS NUM_MISSES NUM_WAITS WAIT_TIME CLIENT_REQ_TIMEOUTS
> ------------ ---------- ---------- ---------- ---------- -------------------
> NUM_AUTHENTICATIONS
> -------------------
> 
> $user.SHARED
> 1346245 0 1346245 61582 0 0
> 1346245
> 
> Everything runs fine, it just doesn't share the connections and
> increase Num_hits.
> 
> any thoughts?
> 
> thanks!
> -Rob