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
