OraFAQ Forum: Forms » ORA-03106 fatal two-task communication protocol error

Home » Developer & Programmer » Forms » ORA-03106 fatal two-task communication protocol error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-03106 fatal two-task communication protocol error [message #201646]

Mon, 06 November 2006 03:28

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?

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #201805 is a reply to message #201646]

Mon, 06 November 2006 19:46

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #201823 is a reply to message #201805]

Mon, 06 November 2006 23:06

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #201846 is a reply to message #201823]

Tue, 07 November 2006 01:10

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #203047 is a reply to message #201646]

Mon, 13 November 2006 12:44

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #226000 is a reply to message #201823]

Thu, 22 March 2007 04:16

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #226212 is a reply to message #226000]

Thu, 22 March 2007 20:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you verified that you have the same NLS_LANG setting on both machines?

David

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #226267 is a reply to message #226212]

Fri, 23 March 2007 02:19

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #226886 is a reply to message #226267]

Mon, 26 March 2007 18:24

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #226999 is a reply to message #226886]

Tue, 27 March 2007 01:46

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #227276 is a reply to message #226999]

Tue, 27 March 2007 19:23

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #227480 is a reply to message #227276]

Wed, 28 March 2007 06:18

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #235018 is a reply to message #201646]

Thu, 03 May 2007 14:23

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #235105 is a reply to message #235018]

Fri, 04 May 2007 01:39

marxello
Messages: 9
Registered: March 2007

Junior Member

Sorry, but I haven't solved my problem yet.

I can't help you. Thanks,

Marxello

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #235148 is a reply to message #201646]

Fri, 04 May 2007 03:17

ishulz
Messages: 2
Registered: May 2007

Junior Member

Yesss. It works !

export LD_ASSUME_KERNEL=2.4 resolved the problem

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #235175 is a reply to message #235148]

Fri, 04 May 2007 04:14

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #263437 is a reply to message #235148]

Thu, 30 August 2007 01:22

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #263461 is a reply to message #263437]

Thu, 30 August 2007 02:21

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #263475 is a reply to message #263461]

Thu, 30 August 2007 02:39

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #263716 is a reply to message #263475]

Thu, 30 August 2007 19:44

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #263765 is a reply to message #201646]

Fri, 31 August 2007 00:10

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #263777 is a reply to message #263765]

Fri, 31 August 2007 00:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #264287 is a reply to message #263798]

Sun, 02 September 2007 21:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #264320 is a reply to message #264287]

Mon, 03 September 2007 00:38

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #264588 is a reply to message #264320]

Mon, 03 September 2007 20:42

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

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

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #266178 is a reply to message #265121]

Mon, 10 September 2007 01:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You MAY be able to update an item via a view. Search this forum for 'update view'.

David

Report message to a moderator

Re: ORA-03106 fatal two-task communication protocol error [message #266237 is a reply to message #266178]

Mon, 10 September 2007 04:50

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

Report message to a moderator

Previous Topic:	to print Database name on form
Next Topic:	database option !

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:36:38 CDT 2024