On Mon Mar 31, 2025 at 11:20:11PM +0000, Johnson, Bruce E - (bjohnson)
wrote:
Sadly no. It’s still instantaneous on-prem but takes 61 seconds to get
the database handle with the ip address. (and DNS resolves just fine )
Second idea: you aren't explicitly specifying the connection port.
There is evidence[1] of someone else observing a timeout related to
1521, which I guess is the DBI default.
[1]
https://dba.stackexchange.com/questions/60688/perl-dbi-takes-60-seconds-to-connect-to-an-oracle-database-every-single-time
What is your cloud database listening on? As the post suggests, setting
DBI_TRACE will provide more food for investigation.
--
Mark Lawrence
