Home » RDBMS Server » Server Administration » ORA-03106: fatal two-task communication protocol error (Oracle 9.2.0.1.0)
ORA-03106: fatal two-task communication protocol error [message #356060] Wed, 29 October 2008 04:32 Go to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Dear Group members

I have installed Oracle 9.2.0.1.0 database on two computers.
First is db1 and second is db2. I want to access objects of db2 from db1 throgh sql. So i have made db link named "hr01". I have made neccessary addition in db1's tnsname file. Now i am able to connect to db2 on db1 computer.

Problem is that i try to access db2 database from db1 throgh sql qyery so i have used this query
--> select emp_code from emp@hr01;
this query successfully runs and shows results.
then i run this query
--> select emp_code,emp_name,emp_desg from emp@hr01;
then it give error ORA-03106: fatal two-task communication protocol error.
then i run this query
--> select * from emp@hr01;
then it give error ORA-01455: converting column overflows integer datatype

Dear members tell me what is the problem. If i can access some columns of db2. Why not all columns or more columns are not accessable.

quick response will be much appriciated.

Thanks and regards

Re: ORA-03106: fatal two-task communication protocol error [message #356131 is a reply to message #356060] Wed, 29 October 2008 13:02 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Refer Metalink Document ID 1012295.102

Babu
Re: ORA-03106: fatal two-task communication protocol error [message #356194 is a reply to message #356131] Wed, 29 October 2008 22:17 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Thanks for reply
But i have no metalink account. Please provide me any other source to solve this problem.

thanks & regards
Re: ORA-03106: fatal two-task communication protocol error [message #356202 is a reply to message #356194] Wed, 29 October 2008 23:42 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Brief:
Quote:

[Edit MC: Remove Metalink note content, it is illegal to post Metalink materials, please don't do this]

[Updated on: Thu, 30 October 2008 00:38] by Moderator

Report message to a moderator

Previous Topic: USERS01.dbf file size
Next Topic: Problem creation TABLESPACE
Goto Forum:
  


Current Time: Thu Dec 08 14:26:21 CST 2016

Total time taken to generate the page: 0.12166 seconds