DRCP with DBD::Oracle and Oracle 11.1.0.7
849800Aug 15 2012 — edited Aug 15 2012I 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.