Hello,
besides looking at your tnsnames.ora file (and validating with an ordinary
sqlplus connect) you should take care about your ORACLE_SID and TWO_TASK
environment Variables (on UNIX). See below.
ORA-03106: fatal two-task communication protocol error
This points to an Oracle nativ connection problem.
I found the following posting:
----- Original Message -----
From: "Radu Caulea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 2:09 AM
Subject: Linux & Redhat & Oracle 9.2.0.1.0
...
> Running make test
...
> Connecting
> to '' (from command line, else uses ORACLE_SID or TWO_TASK -
> recommended)
> as 'owa/[EMAIL PROTECTED]' (via ORACLE_USERID env var or default -
> recommend name/[EMAIL PROTECTED]) (ORACLE_SID='aleph', TWO_TASK='')
> ora_login: 604: ORA-00604: error occurred at recursive SQL level 1
> ORA-00911: invalid character (DBD ERROR: OCISessionBegin)
>
> Generally set TWO_TASK or ORACLE_SID but not both at the same time. Try
> to connect to the database using an oracle tool like sqlplus only if
> that works should you suspect problems with DBD::Oracle. Try leaving
> dbname value empty and set dbuser to name/[EMAIL PROTECTED]
---------------------------------------------------------
Landeshauptstadt München
Direktorium - AFID 3.3 - Oracle DBA
C.A. Merz
What difference does it make to the dead, the orphans,
and the homeless, whether the mad destruction is brought
under the name of totalitarianism or the holy name of liberty
and democracy?
- Gandhi
----- Original Message -----
From: "David N Murray" <[EMAIL PROTECTED]>
To: "rbamidip" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 5:48 PM
Subject: Re: ERROR: ORA-03106: fatal two-task communication
> Can post a sample of your connect statement? Searching Google Groups for
> ORA-03106 yields something about not using BEQ. I've only ever done
> TCP/IP connections, so the problem may be in your tnsnames.ora file. Can
> you connect from sqlplus on the same machine?
>
> Dave
>
> On Apr 2, rbamidip scribed:
>
> > I get the following error while trying to open a database handle, not
> > sure if this is a Oracle problem or the DBI problem, any pointers are
> > appreciated..
> >
> > ERROR: ORA-03106: fatal two-task communication
> >
> > Thx
> > Ramesh
> >
>
