Home » SQL & PL/SQL » SQL & PL/SQL » Ora-03106 fatal two task communication protocol error (Oracle9i, 9.2.0.1.0, windows 2000 server)
Ora-03106 fatal two task communication protocol error [message #320408] Thu, 15 May 2008 01:05 Go to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
I have two oracle database instance.
Oracle9i-1
Oracle9i-2

We have created a database link from Oracle9i-2 database to Oracle9i-1 with databaselink
name as testdblink.

We are successful to query data from tables in the database oracle9i-2 connecting via
oracle9i-1

However we face a problem that if we query all columns from emp table or more than three
columns we get Ora-03106 error.

Can anyone please help as this is very urgent we are planning to run forms on synonyms
using dblink for remote database.

Please shed some light if the above planned use of dblink should be done in production
environment.

Thanks in advance.

Dhanuka. Rajesh

Re: Ora-03106 fatal two task communication protocol error [message #320430 is a reply to message #320408] Thu, 15 May 2008 02:18 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
From the documentation:
ORA-03106 fatal two-task communication protocol error

    Cause: The communication path between Oracle and the user task has stopped. This is an internal error message not usually issued.

    Action: Contact Oracle Support Services.


It can happen for a wide variety of reasons, (just try putting 'ORA-3106 dblink' into google and you'll see).

Really, Oracle Support are your first port of call for this one.
Re: Ora-03106 fatal two task communication protocol error [message #320468 is a reply to message #320430] Thu, 15 May 2008 03:47 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
Thanks for the response.

Have certain queries kindly help us for the same..

1. Are there any oracle initilization parameters that can
define what amount of data can be transfered between the
two database via a database link.

2. When we query records using dblink on normal sqlplus (not
from toad) it gives ORA-01801: date format is too long for
internal buffer

3. Is it a good idea to run forms uwing dblinks.
Main blocks will be accessing data from remote database.


Thanking you in advance.

Dhanuka. Rajesh
Re: Ora-03106 fatal two task communication protocol error [message #320470 is a reply to message #320468] Thu, 15 May 2008 03:51 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
1) Not that I know of.

2) Sounds like you might be transfering a date across the DB link as a char, and trying to do an implicit to_date on it.

Check that the NLS_DATE_FORMATs match on the two databases.
Re: Ora-03106 fatal two task communication protocol error [message #320476 is a reply to message #320470] Thu, 15 May 2008 04:03 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member

We have checked the all nls parameters in both database using table NLS_DATABASE_PARAMETERS.

The parameters are identical. There is no mismatch between any of them.

Following are the list of parameters.

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 9.2.0.1.0

Is this a bug with oracle and we need to install a patch to get it resolved?

We are very thankful for your response.

Dhanuka. Rajesh
Re: Ora-03106 fatal two task communication protocol error [message #320485 is a reply to message #320476] Thu, 15 May 2008 04:40 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Why does everyone seem to assume that the moment they get an error, there must be a massive internal problem with Oracle?

There are many, many causes of this error (just have a look on Metalink)

Do yuo get this error when querying this data while connected to the remote DB (there are cases where this is caused by invalid data being put into a Date field by an OCI process).

Does this error happen for all date queries across the Db link?

Does it happen for a single, specific row of data?

You're going to have to do some investigation of your own here.
Re: Ora-03106 fatal two task communication protocol error [message #320510 is a reply to message #320485] Thu, 15 May 2008 05:45 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
Why does everyone seem to assume that the moment they get an error, there must be a massive internal problem with Oracle?

There are many, many causes of this error (just have a look on Metalink)

Answer:- We tried looking for the error on OTN and there i read
a post saying that please apply patchset 9.1.0.4 in
this patch the error is solved.

Was not ok with the reply just wanted to confirm if this
direction of thinking is correct.

Do yuo get this error when querying this data while connected to the remote DB (there are cases where this is caused by invalid data being put into a Date field by an OCI process).

Does this error happen for all date queries across the Db link?

Does it happen for a single, specific row of data?

You're going to have to do some investigation of your own here.

Answer: - 1. When we query all records from the table at that
time it gives error ora-03106.

2. If one record is queried at a time then complete
record is queried, no error.

3. But for more than one record or complete table is
queried using select * from table_name then it
gives above mentioned error.

4. We build one form on synonym of table name using
dblink, we were able to save data in remote
database successfully but once we try to query
more than one record from the form it starts
giving same error.

5. Are there any initialization parameter
restrictions on amount of data that can be queried
or number of dblinks that can be opened?

Thanks in advance.









Re: Ora-03106 fatal two task communication protocol error [message #320518 is a reply to message #320510] Thu, 15 May 2008 05:55 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
So, if you write a query to retrieve two rows across the Dblink, does that produce the error?
Try it both by specifying two unique id values, and with a rownum<=2 clause.

If selecting two rows that you specify a unique id for doesn't error, then write some code to individually query each record, by a unique id - see if one of them errors.

Do you get this error when querying this data while connected to the remote DB - ie not querying across the dblink

Have a look on Metalink, and see if any of the reported problems there match yours.

Have you fixed that ORA-3106 problem yet - it's quite possible that the two problems are related.
Re: Ora-03106 fatal two task communication protocol error [message #320537 is a reply to message #320518] Thu, 15 May 2008 07:43 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
So, if you write a query to retrieve two rows across the Dblink, does that produce the error?
Try it both by specifying two unique id values, and with a rownum<=2 clause.

Answer: - If we try to select more than one record from the
table using dblink, instance get hanged and have to
kill the instance.
(Used rownum<2 and in clause, and or clause also to
query)

If selecting two rows that you specify a unique id for doesn't error, then write some code to individually query each record, by a unique id - see if one of them errors.

Answer: - If selecting one record at a time no error occurs.

Do you get this error when querying this data while connected to the remote DB - ie not querying across the dblink

Answer: - No error occurs when we query data on the remote
database itself. we are able to query all records
also.

Have a look on Metalink, and see if any of the reported problems there match yours.

Answer: - Searching metalink the same error no result as of now.

Have you fixed that ORA-3106 problem yet - it's quite possible that the two problems are related.

Answer: - The problmes are related agreed but not able to get
to root cause of problem.

Re: Ora-03106 fatal two task communication protocol error [message #320539 is a reply to message #320537] Thu, 15 May 2008 07:53 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What makes you think "the instance hangs" ?
Re: Ora-03106 fatal two task communication protocol error [message #320548 is a reply to message #320539] Thu, 15 May 2008 08:09 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
We can generally query all records within a second.
But when we try to query two records from remote database using
dblink, sqlplus does not returns output on screen even after
two hours.

When this particular session is queried from DBA sessions it
shows in process and the query which it is executing but no
output which is expected withing the desired time frame.

We have to kill session and then reconnect to sqlplus to
execute the query.



Re: Ora-03106 fatal two task communication protocol error [message #320553 is a reply to message #320537] Thu, 15 May 2008 08:19 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
So, it sounds like the error you're experiencing has changed.

Originally, you said that querying more than one record across the Db link gave you an ORA-01801.
Now you're saying that it hangs the entire database instance (you might mean session, to be fair).
What is the difference between the queries that produce the 1801, and the queries that hang the session.

Come to that, what are the 'hung' sessions doing - what are they waiting on.

Is the remote DB also Oracle?

I strongly suspect that Support are the only people who can fix this - you'll have to start providing us with a lot mor information to ahve a chance of an answer.
Re: Ora-03106 fatal two task communication protocol error [message #320573 is a reply to message #320548] Thu, 15 May 2008 08:59 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
dhanuka.rajesh wrote on Thu, 15 May 2008 15:09

When this particular session is queried from DBA sessions it
shows in process and the query which it is executing but no
output which is expected withing the desired time frame.

The fact that the query does not return a result within the desired time does not necessarily indicate a hanging session. As a matter of fact, hanging session are quite rare in Oracle.
This could very well be caused by the fact that a large table is sent over the dblink to be able to do a join.

Trace the sessions, ask your dba what the session is doing.
Re: Ora-03106 fatal two task communication protocol error [message #320962 is a reply to message #320539] Sat, 17 May 2008 00:53 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
Hi all,

I am glad to inform you that we have identified the root cause
of Ora-03106 successfully.

The net8 version on client machine was using of oracle forms6i
which is by default version 8 (lower than oracle9i) version.

If we try to query the same data from sqlplus provided by
oracle9i there are no errors and complete data from table is
queried successfully.

Thanks for your help and support we really appreciate your
efforts.

Best Regards,

Dhanuka. Rajesh

Re: Ora-03106 fatal two task communication protocol error [message #324061 is a reply to message #320408] Fri, 30 May 2008 08:31 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
Hi All,

Guys need your help once again for the same problem.

As per earlier msgs we have identified problem that if we try to query data over dblink from any clinet application e.g. SQLPLUS, TOAD, D2K forms ORA-03106 error is encountered.

But on further analysis we have identified that if we try to retreive data from a pl/sql by writing a cursor to fetch data from the table via dblink it fetches complete data and gives no oracle error.

We have a major delivery next week and as we have designed D2k forms to run on dblink we are not able to perform query operation via forms.

Kindly provide your expertise for the same.

Best Regards,

Dhanuka. Rajesh
Re: Ora-03106 fatal two task communication protocol error [message #324069 is a reply to message #320408] Fri, 30 May 2008 10:18 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
You are running obsoleted OS & obsoleted & unpatched RDBMS.

many bugs are reported on MetaLink for ORA-03106 including
ORA-3106 When Using Character Sets Other Than US7ASCII

I suggested you do your own research on Metalink to determine exactly which bug you are hitting.

Re: Ora-03106 fatal two task communication protocol error [message #324121 is a reply to message #320408] Fri, 30 May 2008 23:53 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
We have now installed Oracle 10g R2 version of oracle database
and connecting D2k forms 6i, and facing same problem.

We have tried searching metalink for Ora-03106 but as mentioned
it has been not of much help.

We have identified the problem is related to d2k net8 is there any patch or way to upgrade net8 of d2k forms.

You help is of utmost importance.

Best Regards,

Dhanuka. Rajesh
Re: Ora-03106 fatal two task communication protocol error [message #324123 is a reply to message #320408] Sat, 31 May 2008 00:05 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>and connecting D2k forms 6i, and facing same problem.
>We have identified the problem is related to d2k net8
Forms6b - obsoleted
Net8 - obsoleted
Both obsoleted for a reason & neither supported this century.

>You help is of utmost importance.
you either live with the bugs of the past or bite the bullet & UPGRADE to stay current

You pick your poison & live or DIE with the consequences!
Re: Ora-03106 fatal two task communication protocol error [message #324124 is a reply to message #324123] Sat, 31 May 2008 00:13 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member

We are providing support for a existing sale and there a due to the need of business in existing application we have to provide the solution of querying data via forms over dblink.

Oracle Version Oracle9i Enterprise Edition Release 9.2.0.1.0
D2k Version 6.0.8.19.2 (Production)

We have upgraded our application to 10g forms and database
(FYI).

Is there a patch that can be applied to solve this bug.

Please provide any insights for the same.

Best Regards,

Dhanuka. Rajesh


Re: Ora-03106 fatal two task communication protocol error [message #324125 is a reply to message #320408] Sat, 31 May 2008 00:18 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>Is there a patch that can be applied to solve this bug.
what Oracle Bug #?
Re: Ora-03106 fatal two task communication protocol error [message #324127 is a reply to message #324125] Sat, 31 May 2008 00:21 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
BUG:2222694
Re: Ora-03106 fatal two task communication protocol error [message #324128 is a reply to message #324127] Sat, 31 May 2008 00:22 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
Got more information on BUG

9014 [BUG:2222694] ORA-3106/ORA-1455/ORA-1426 possible for
Code :
OCI_EXACT_FETCH array fetch over dblink
Re: Ora-03106 fatal two task communication protocol error [message #324129 is a reply to message #320408] Sat, 31 May 2008 00:26 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
MetaLink is currently unavailable due to scheduled maintenance.

MetaLink will be offline for maintenance on Friday, May 30 (Saturday, May 31, 4:00 AM GMT) for approximately 3 hours beginning at 9:00 PM PT.

If Oracle has no solution, why do you expect magic solution here?
Re: Ora-03106 fatal two task communication protocol error [message #324132 is a reply to message #324129] Sat, 31 May 2008 01:21 Go to previous message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member

Thanks for your help.
Previous Topic: how to delete the particular column
Next Topic: trouble in selecting case
Goto Forum:
  


Current Time: Wed Dec 07 06:35:29 CST 2016

Total time taken to generate the page: 0.10512 seconds