Troubles with database link for local databases

From: Ãèðêàëî Âàäèì <wadym_at_email.com>
Date: Thu, 7 Mar 2002 16:58:54 +0200
Message-ID: <a67v3o$24bl$1@volcano.apex.dp.ua>

Hi all !

I runing 2 databases (Oracle 8.1.6) on my PC - Test1 and Test2. I created DATABASE LINK (CREATE DATABASE LINK TEST2 CONNECT TO username IDENTIFIED BY userpwd USING 'test2') on Test1 for connection to Test2. Any SELECT * FROM table_at_test2 on Test1 return error: ORA-02068: following severe error from Test2 and ORA-03114: not connected to ORACLE. Other database links to remote databases is working. SqlPlus connect to Test1 and Test2 is ok. Why ?

Thanks for any help.

Good luck. Vadim Received on Thu Mar 07 2002 - 08:58:54 CST