| DATA BASE LINK (Fatal Two-Task Communication Protocol Error, Oracle 8i) [message #67206] |
Sun, 08 February 2004 21:39 |
André ALIMBA
Messages: 16
Registered: April 2002
|
Junior Member |
|
|
HI, Oracle Experts !
DATA BASE LINK (Fatal Two-Task Communication Protocol Error, Oracle 8i)
You’re going to excuse me because my english is not good. I’m french man.
I’ve have a problem to exploit my database link solution.
In the detail my problem is :
I’ve two databases (Oracle 8i)
The principal database. The name is bandoro
and the other database (the distant database). The name is kossi
My development platform is a Toshiba Satellite Pro, Pentium IV, Windows XP with principal local database.
My application is building on PowerBuilder 7.0.3.
The distant (or remote) database is on HP-9000 (Unix 10, HP-UX 10).
If I use my application to attack the local database (on the Toshiba), I’ve the possibility to read and update the distant database installed on the HP-Unix Server.
My solution is OK on the development Platform (database on window XP and database on HP Unix server).
The real platform (Platform of production) is :
The two databases are on the HP-Unix server.
If I try to use my solution on the real platform, I’ve not the possibility to read and update the data on the distant database (remote database).
My application show this message :
ORA-3106 : Fatal two-task Communication protocol error
ORA-2063 : Preceding line from kossi
IF I use SQLPLUS or Database Painter Environment of PowerBuilder, I’ve not problem. From my active database (bandoro) I can Select or Update the data of the distant database.
Now I’m going to give you my solution and some example :
Creating the database link
===================
CREATE PUBLIC DATABASE LINK kossi
CONNECT TO kossi IDENTIFIED BY bangui
USING 'kossi' ;
Creating the synonym
================
CREATE PUBLIC SYNONYM table052 for table052@kossi;
Table052 belong to the distant database kossi
So From bandoro database , the principal database of my application, I can access to the data of kossi database by :
SELECT col1
INTO :s_var
FROM table052
WHERE ……..
USING SQLCA;
or
UPDATE table052
SET col1 = :s_var
WHERE ………
USING SQLCA;
This solution is OK on the first platform (window XP an Unix HP)
Bur
Is not OK on the real platform (The two-database are on the some server HP-UX)
André ALIMBA
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
