Hardy,
There are numerous possibilities. One of the first things to check for is a
tracefile on the server side in user_dump_dest. If you don't know what
user_dump_dest is, mail me off-line, as this has nothing to do with DBI.
You mention the Oracle version is 8.1.6. On both sides (client and server) ?
Brgds,
Mark
Hardy Merrill wrote:
> 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
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
EMEA Support Information Systems Email : [EMAIL PROTECTED]
AIM : markvdb
