Redhat 6.1 Linux
Perl 5.005_03
Oracle 8i (8.1.6)
DBI 1.14
DBD::Oracle 1.06
According to the DBD::Oracle perldoc, I'm using the
"Connecting without environment variables or tnsname.ora file"
method, like:
my $dsn = "DBI:Oracle:host=my.domain.com;sid=MYSID";
my $dbh = DBI->connect($dsn,
'user',
'password',
{ RaiseError => 1, AutoCommit => 1 }
);
on an Oracle "client" machine to connect to an Oracle "server".
Using this connection method, have any of you received ORA-12547
errors:
12547, 00000, "TNS:lost contact"
// *Cause: Partner has unexpectedly gone away, usually during process
// startup.
// *Action: Investigate partner application for abnormal termination. On an
// Interchange, this can happen if the machine is overloaded.
when trying to connect? This seems to occur intermittantly under
consistent(regular selects/inserts/updates) light load. Any ideas
for how to figure out what is causing this?
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com