| Ora-03106 fatal two task communication protocol error [message #320408] |
Thu, 15 May 2008 01:05  |
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  |
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 |
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 #320476 is a reply to message #320470] |
Thu, 15 May 2008 04:03 |
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 |
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 |
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 |
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 |
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 #320548 is a reply to message #320539] |
Thu, 15 May 2008 08:09 |
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 |
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 |
Frank
Messages: 7901
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 |
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 |
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 #324121 is a reply to message #320408] |
Fri, 30 May 2008 23:53 |
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 #324124 is a reply to message #324123] |
Sat, 31 May 2008 00:13 |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
