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: frie...@gmail.com
> To: dbi-users@perl.org
>
> 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
