| ORA-03106: fatal two-task communication protocol error [message #356060] |
Wed, 29 October 2008 04:32  |
sweetkhaliq
Messages: 200
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
