Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DRCP with DBD::Oracle and Oracle 11.1.0.7

849800Aug 15 2012 — edited Aug 15 2012
I am using DBD::Oracle 1.48 with Oracle 11.1.0.7.

I have setup the tns names entry as below

BESDRCPDEV = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oragdev1-v)(PORT = 1531)) (ADDRESS = (PROTOCOL = TCP)(HOST = oragdev2-v)(PORT = 1530)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = POOLED) (SERVICE_NAME = BLOANDEV.xxx.com) (failover_mode = (type = select) (method = basic) ) ) )

I connect to my database using the following :

my $dbh = DBI->connect("dbi:Oracle:besdrcpdev","testuser","testpass",{ora_drcp=>1,ora_drcp_class=>'myapp' });

I never see any evidence that the connection class (myapp) is getting passed or used on the connection.
I do see the "testuser.shared" columns in the pool related views getting updated - but never see "usertest.myapp".
Has anyone been able to pass the connection class successfully as specified above ?
Note that this is a pure perl (no PHP) application.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2012
Added on Aug 15 2012
7 comments
306 views