Re: Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time

>The DB tools I use (Oracle SQL Developer and DBVisualizer) are working 
>as expected with the instances I have, but trying to run my Perl code 
>using DBI/DBD::Oracle/Oracle Instant Client is giving me  extreme 
>delays creating the DB handle; running a simple test program to time 
>the process shows the program taking a minute or longer to create the 
>database handle.

My thoughts in such a scenario usually move towards DNS. I don't know 
if DBI, or DBD::Oracle, or some Oracle library is doing name to address 
translation, but perhaps IPv6 Happy Eyeballs is in play with a 60 
second timeout?

>my $dbnamel="host=xxxxxxx.pharmacy.arizona.edu;sid=xxxxxxx";
>my $dbnamec="host=xxxxxxxx.us-west-2.rds.amazonaws.com;sid=xxxxxxx";

Maybe try with IP addresses?

-- 
Mark Lawrence