Re: Troubles with database link for local databases

Hi,

Make sure your TEST2 database is actually started. Try logging to TEST2 using SQLPlus. Also make sure that your TNS entries are configured properly. Try connecting to TEST2 using username/password_at_connect_string from SQLPlus. If all of the above works, but you still cannot connect using the dblink, I dont know what's wrong and I cannot give you an answer based on the very small amount of information you provided (no OS, version...)

Murali
http://www.dbaquest.com/

"??????? <wadym_at_email.com> wrote in message news:<a67v3o$24bl$1_at_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 - 14:16:55 CST