John, My guess is you do not have the correct Oracle environment set up. See the below metalink notes:
1012295.102 - HOW TO SUPPORT TWO-TASK COMMON ERRORS 1020408.102 - ORA-03106 WHEN CONNECTING TO UTF8 DATABASE Also, I would print the Oracle error message when you encounter errors: $DBI::errstr ----------------- Ron Reidy Senior DBA Array BioPharma, Inc. -----Original Message----- From: Moon, John [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:14 PM To: '[EMAIL PROTECTED]' Subject: DBI & DBD::Oracle I originally sent this to the CGI list so please excuse me if you are on both. This is perl, version 5.004_01 # $Id: DBI.pm,v 11.3 2001/08/24 23:33:40 timbo Exp $ $DBI::VERSION = "1.20"; # $Id: Oracle.pm,v 1.92 2001/08/31 16:23:59 timbo Exp $ $DBD::Oracle::VERSION = '1.12'; I have "many" databases on "many" different platforms (Sun boxes). One of the boxes has a tnsnames files that contains all of the various instances. I connect from this box to all of the instances except three... I have tried various ways to connect but can not connect to three from my Perl script - I can connect with SqlPlus from the command line to the three databases. I get this error message when trying to connect: DBI->connect() failed: ORA-03106: fatal two-task communication protocol error (DBD: login failed) at /.../ThisConnect.pm line 8 Below is the connection sub. Any help or suggestions will be greatly appreciated. Thanks in advance... sub MyConnect{ use strict; my($instance) = @_; # alias name my $driver = 'dbi:Oracle:'; my $user = 'xxx'; my $passwd = 'xxx'; # DBI->trace(5) if $instance =~ /efis/i; my $dbh = DBI->connect($driver, "[EMAIL PROTECTED]", $passwd); # or die "Could not connect to instance <$instance>: " . DBI->errstr; return $dbh; } 1; I've included the threads I have to the original post to show what I've tried... ------ OK... I "WAS" thinking it was a "TWO_TASK" error but now see the difference... But I don't understand why I can connect & select from SqlPlus but not even Connect with DBI? The referenced doc seems to imply that I should NOT be able to connect at all(?). My Sqlplus connect looks like: >sqlplus [EMAIL PROTECTED] which is the same(?) connection I'm using with DBI(?). Thanks again for the information and the help... jwm -----Original Message----- From: Gene Dascher [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 12:48 PM To: Moon, John Subject: RE: [CGI] DBI & DBD::Oracle Try looking at this page to see if it can give you any direction: http://www.fors.com/velpuri2/ERRORS/TWO-TASK%20COMMON%20ERRORS Gene > -----Original Message----- > From: Moon, John [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 29, 2004 11:37 > To: 'Gene Dascher' > Subject: RE: [CGI] DBI & DBD::Oracle > > > Same error with the below and "alias name"... > > Thanks, > > jwm > > -----Original Message----- > From: Gene Dascher [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 29, 2004 12:25 PM > To: Moon, John > Subject: RE: [CGI] DBI & DBD::Oracle > > Try connecting like this: > > DBI->connect($driver . $instance, $username, $password); > > Gene > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf > > Of Moon, John > > Sent: Tuesday, June 29, 2004 11:11 > > To: [EMAIL PROTECTED] > > Subject: [CGI] DBI & DBD::Oracle > > > > This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
