Home » Developer & Programmer » Forms » ORA-03106 fatal two-task communication protocol error
ORA-03106 fatal two-task communication protocol error [message #201646] Mon, 06 November 2006 03:28 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
i am facing the error "ORA-03106 fatal two-task communication protocol error", while calling an LOV from the Form Builder 6i, trying to fetch data from underlying views. These view are based on the tables of a remote database sever using a DBLINK.

For sample view soruce following statement is given

create or replace view vew_erp_fab_sls_cont_mt as
select a.Col1,
a.Col2
from remote_table@DBLINK_NAME a
WITH READ ONLY;


We have faced the said problem previosly as well, but are not sure how it got corrected.Now we are facign the same problem

We also have tried to resolve it by droping and recreating db_link but unable to do so

Can anyone please provide help regarding this issue?
Re: ORA-03106 fatal two-task communication protocol error [message #201805 is a reply to message #201646] Mon, 06 November 2006 19:46 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this site for "fatal two-task communication protocol error" and you will find http://www.orafaq.com/forum/m/117586/0/?srch=fatal+two-task+communication+protocol+error#msg_117586

David
Re: ORA-03106 fatal two-task communication protocol error [message #201823 is a reply to message #201805] Mon, 06 November 2006 23:06 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear Sir
I have searched all of these links like u provided but unable to find the solution
Perhaps i was unable to correctly explain my question
I have read what could be possible reasons 4 that
one of the reason is
using database link
Yes i am having a problem in db_link but when i query the data using db link from sql*plus it is working

but when i try this in Forms Builder to query data using db Links i got the error desribed earlier

But after sometime its got corrected perhaps by restarting the DB
I also verified the NLS_LANG at both Client and Server Sides
Can u plzzzzzzzzzz help me in this regard?
thanx in advance
Re: ORA-03106 fatal two-task communication protocol error [message #201846 is a reply to message #201823] Tue, 07 November 2006 01:10 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I googled your error message and saw a huge number of threads - you may have to review many of them.

How many Oracle homes do you have on your PC? I believe that SQL*Plus is in a different home to your Oracle Forms. Please verify that you have matching 'tnsnames.ora' files in these two homes. Search this forum for 'ifile' for a more detailed explanation.

David
Re: ORA-03106 fatal two-task communication protocol error [message #203047 is a reply to message #201646] Mon, 13 November 2006 12:44 Go to previous messageGo to next message
artmast
Messages: 11
Registered: October 2006
Junior Member
The Oratip site http://oratip.com/ORA-03106.html has a possible cause and action for you:
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.

Do you have a supprt contract?

Art
Re: ORA-03106 fatal two-task communication protocol error [message #226000 is a reply to message #201823] Thu, 22 March 2007 04:16 Go to previous messageGo to next message
marxello
Messages: 9
Registered: March 2007
Junior Member
Hello M.Shakeel Azeem.

I've got the same problem with Oracle Forms 6. I could contact to Oracle service, but I know Oracle doesn't support this 'obsolete' Forms version.

Have you solved your problem? Could you tell me how? Thank you very much.

Marxello
Re: ORA-03106 fatal two-task communication protocol error [message #226212 is a reply to message #226000] Thu, 22 March 2007 20:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you verified that you have the same NLS_LANG setting on both machines?

David
Re: ORA-03106 fatal two-task communication protocol error [message #226267 is a reply to message #226212] Fri, 23 March 2007 02:19 Go to previous messageGo to next message
marxello
Messages: 9
Registered: March 2007
Junior Member
Yes! I think so!
I've done this query:
SELECT userenv ('language') from dual;

And it shows me the same information in two Oracles, 9 and 8.
I've done this other query too:
SELECT * FROM NLS_SESSION_PARAMETERS;

And it shows me, more or less, the same information. I think that all differences are because of Oracle version.

Do you think that I'm not doing the checks correct?
Thank you for all!

Marxello
Re: ORA-03106 fatal two-task communication protocol error [message #226886 is a reply to message #226267] Mon, 26 March 2007 18:24 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Which version of Oracle 8 and 9 are you using? Is your dblink in the 8 or 9 database? Against which database are you compiling your forms? Have you looked at Oracle's Support Matrix for Interconnectivity and are your versions on it?

David
Re: ORA-03106 fatal two-task communication protocol error [message #226999 is a reply to message #226886] Tue, 27 March 2007 01:46 Go to previous messageGo to next message
marxello
Messages: 9
Registered: March 2007
Junior Member
Thanks for your interest on resolving my question.

I have dblink in 9i Version: Oracle9i Release 9.2.0.1.0 - Production
And the other Oracle is: Oracle8i Release 8.1.7.0.0 - Production

I can compile my form against Oracle 9. At first it was compiled against Oracle 8, but to check, I've compiled in Oracle 9 too, and it doesn't go well.

I don't know how to contact with Oracle's Support Matrix in Interconnectivity. Could you give me the link to do it, please?

Thanks,

Marxello
Re: ORA-03106 fatal two-task communication protocol error [message #227276 is a reply to message #226999] Tue, 27 March 2007 19:23 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
As usual I can't find the Oracle matrix for which I am looking but I will keep trying.

Please try one other thing for me. Open your Form in the Forms Builder and do a Compile All (Ctrl-Shft-K) and then generate (Ctrl-T). It is an annoying aspect of the Forms Builder since 4.5 that you have to do a Ctrl-Shft-K whenever something has changed in the environment because the 'good old' Ctrl-K Incremental Compile can't 'see' it.

David
Re: ORA-03106 fatal two-task communication protocol error [message #227480 is a reply to message #227276] Wed, 28 March 2007 06:18 Go to previous messageGo to next message
marxello
Messages: 9
Registered: March 2007
Junior Member
I would thank you for your help in this problem.

But I have just check your option with Ctrl+Shift+K and then Ctrl+T. All against the DB 9i where I'm checking this problem. And this option hasn't solved me the problem.

We will follow investigating. Thanks.

Marxello
Re: ORA-03106 fatal two-task communication protocol error [message #235018 is a reply to message #201646] Thu, 03 May 2007 14:23 Go to previous messageGo to next message
ishulz
Messages: 2
Registered: May 2007
Junior Member
Hello, marxello

did you resolved your problem. I'm looking for decisin in environment like this, but without any success.

DBD:Oracle compiled against oracle client 8.1.7 works fine with any our remote DB: Oracle 8, 9, 10

DBD:Oracle, compiled against oracle client 9 and 10, doesn't work with db-links (direct selects works fine) though these clients (sqlplus) don't have any problems with these db-link selects !!!

--Igor
Re: ORA-03106 fatal two-task communication protocol error [message #235105 is a reply to message #235018] Fri, 04 May 2007 01:39 Go to previous messageGo to next message
marxello
Messages: 9
Registered: March 2007
Junior Member
Sorry, but I haven't solved my problem yet.

I can't help you. Thanks,

Marxello
Re: ORA-03106 fatal two-task communication protocol error [message #235148 is a reply to message #201646] Fri, 04 May 2007 03:17 Go to previous messageGo to next message
ishulz
Messages: 2
Registered: May 2007
Junior Member
Yesss. It works !

export LD_ASSUME_KERNEL=2.4 resolved the problem
Re: ORA-03106 fatal two-task communication protocol error [message #235175 is a reply to message #235148] Fri, 04 May 2007 04:14 Go to previous messageGo to next message
marxello
Messages: 9
Registered: March 2007
Junior Member
It seems interesting...

But I don't understand what are you speaking about. It is only valid for Oracle uder Linux? and which could be the similar on Windows?

Thanks,

Marxello
icon7.gif  Re: ORA-03106 fatal two-task communication protocol error [message #263437 is a reply to message #235148] Thu, 30 August 2007 01:22 Go to previous messageGo to next message
spaniken2k
Messages: 7
Registered: August 2007
Location: Mauritius
Junior Member

Hi,
i am new to this forum...
Can you please let me know how you have solved this problem?
I am having problem to compile my program (in Forms builder 6i) when using database link. the program crashes
thanks
Jimmy
Re: ORA-03106 fatal two-task communication protocol error [message #263461 is a reply to message #263437] Thu, 30 August 2007 02:21 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is the version of Forms and database that you are using? What is the error code and the error message you are receiving? Does the userid you have used for your connection have the necessary privileges on the other database to do the necessary table accesses?

David
icon7.gif  Re: ORA-03106 fatal two-task communication protocol error [message #263475 is a reply to message #263461] Thu, 30 August 2007 02:39 Go to previous messageGo to next message
spaniken2k
Messages: 7
Registered: August 2007
Location: Mauritius
Junior Member

Hello, thanks for replying to my query
I am using Forms [32 Bit] Version 6.0.8.11.3 (Production)
and Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production.
i dont have any error code. the application exits suddenly by itself while compiling. if i remove the procedure which contains the database link then the compilation works fine.
I think the userid must be ok because i am able to select and update the table with that user id on sql navigator.

i think with Oracle 8.1.7 it will work because some of my friends have done it in their organization. the only exception is that i am using oracle 9i.

Thanks
jimmy
Re: ORA-03106 fatal two-task communication protocol error [message #263716 is a reply to message #263475] Thu, 30 August 2007 19:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please do a search of your 'C:' drive to determine how many copies of 'tnsnames.ora' you have on your machine.

Please do a Ctrl-Shft-K (Compile All) and Ctrl-T (generate) and see if that has any affect.

Just confirm that the database at the end of the DBLINK is Oracle 8i.

David
Re: ORA-03106 fatal two-task communication protocol error [message #263765 is a reply to message #201646] Fri, 31 August 2007 00:10 Go to previous messageGo to next message
spaniken2k
Messages: 7
Registered: August 2007
Location: Mauritius
Junior Member

Hi,

tnsnames.ora are located in C:\orant\Net80\ADMIN , C:\orant\Net80\TNSAPI , C:\orant\Net80\ADMIN\SAMPLE , C:\Oracle\ora92\network\ADMIN

Those in C:\orant\Net80\ADMIN and in C:\Oracle\ora92\network\ADMIN are the same...

When doing Ctrl-Shft-K (Compile All) the application crashes. it is the same problem with Ctrl-T (generate).

What do you mean by "Just confirm that the database at the end of the DBLINK is Oracle 8i." ??

Thanks
jimmy
Re: ORA-03106 fatal two-task communication protocol error [message #263777 is a reply to message #263765] Fri, 31 August 2007 00:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If the database at the end of the link is Oracle 7 then Oracle 8 can access it but Oracle 9 can not.

You might want to create an environment variable TNS_ADMIN and point it at the 'C:\orant\Net80\ADMIN' directory. That way, you only have to update the one tnsnames.ora file.

Are you saying that you can't open the Form in the Forms 6i Builder? This is not good.

David

[Updated on: Fri, 31 August 2007 01:48]

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #263798 is a reply to message #263777] Fri, 31 August 2007 01:35 Go to previous messageGo to next message
spaniken2k
Messages: 7
Registered: August 2007
Location: Mauritius
Junior Member

Hi,
i just confirm with the administrator and the oracle is 9.
Yes i cant open the form when using the DBLINK or a synonym inside. as i told you, if i remove the dblink and put any table within the same database then i am able to compile and run the program

thanks
Re: ORA-03106 fatal two-task communication protocol error [message #264287 is a reply to message #263798] Sun, 02 September 2007 21:04 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You say:
Quote:
Yes i cant open the form when using the DBLINK or a synonym inside. as i told you, if i remove the dblink and put any table within the same database then i am able to compile and run the program

Please acknowledge that you understand that there is a difference between opening the form in Form Builder and opening the form FROM Form Builder.

You said previously:
Quote:
When doing Ctrl-Shft-K (Compile All) the application crashes. it is the same problem with Ctrl-T (generate).

Are you calling the Form Builder an 'application' or is the 'application' the form running AFTER you have done the Compile All.

Please revisit my posts and reply using the same terms as I am not sure what you mean by 'application' and 'open the form'.

David
Re: ORA-03106 fatal two-task communication protocol error [message #264320 is a reply to message #264287] Mon, 03 September 2007 00:38 Go to previous messageGo to next message
spaniken2k
Messages: 7
Registered: August 2007
Location: Mauritius
Junior Member

Hi,
Let me explain clearly to you...

I built a program in forms builder which consists of Forms, triggers, alerts, data blocks, canvas, LOVs, Program units and so on...
Before i compile (ctrl+shift+k) i need to connect to a database.

In my Program Units, i have many procedures and one of the procedure i used either synonym or dblink...

after connecting to database successfully, i do a ctrl+shift+k, then the form builder crashed... everything is closed and i need to open the builder agains... however, if i dont used the dblink or synonym, i can compile and access the my forms which are opened in the forms runtime....

hope you understand

By application, i meant the program i developed, that is the forms and procedures i coded...

thanks
Re: ORA-03106 fatal two-task communication protocol error [message #264588 is a reply to message #264320] Mon, 03 September 2007 20:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Thank you for the explanation.

Do you have the database which is at the end of the dblink defined in your tnsnames.ora file? It has to match the dblink (have the same name and point to the same database) which exists in the database to which you are connected.

Eg. I connect to david/david@david and have a dblink called tstlnk to test/test@test. I have to have both 'david' and 'test' defined in 'tnsnames.ora'.

If this doesn't solve your problem, duplicate the entry for 'test' and name it 'tstlnk' and see if that works.

David

[Updated on: Mon, 03 September 2007 20:42]

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #265121 is a reply to message #264588] Wed, 05 September 2007 08:17 Go to previous messageGo to next message
spaniken2k
Messages: 7
Registered: August 2007
Location: Mauritius
Junior Member

Hi,

It seems that no one has got a solution for this program.
In fact, i am able to compile the program but not run it.

Can we update a view? if yes then i will create a view and use it in the procedure instead of using either database link or synonym.

regards
Jimmy
Re: ORA-03106 fatal two-task communication protocol error [message #266178 is a reply to message #265121] Mon, 10 September 2007 01:54 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You MAY be able to update an item via a view. Search this forum for 'update view'.

David
Re: ORA-03106 fatal two-task communication protocol error [message #266237 is a reply to message #266178] Mon, 10 September 2007 04:50 Go to previous message
spaniken2k
Messages: 7
Registered: August 2007
Location: Mauritius
Junior Member

Thanks Djmartin,

this is what i have done... but i am sure its definitely a compatible issue with the oracle versions...

Regards
Jimmy
Previous Topic: to print Database name on form
Next Topic: database option !
Goto Forum:
  


Current Time: Fri Dec 09 21:35:37 CST 2016

Total time taken to generate the page: 0.10914 seconds