HELP! The Database Link is not active.

From: Roger Sprague <cpn1rws_at_ecrmail.ups.com>
Date: Fri, 14 Aug 1998 19:21:14 -0400
Message-ID: <6r2gp9$s7n2_at_biko.telecom.ups.com>



How do you successfully create database links between Oracle 8 and Oracle 8? How do you successfully create database links between Oracle 7.3.3 and Oracle 8?

I have just created a database link to a service name. LINK NAME: ORACLE8
SERVICE NAME: DBTEST I test the service name and the test succeeds. I query the database on the service name and the query succeeds.

"SQL> CONNECT SYSTEM/MANAGER_at_DBTEST;
Connected.
SQL> SELECT OWNER, TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'SCOTT';

OWNER                          TABLE_NAME
------------------------------ ------------------------------
SCOTT                          BONUS
SCOTT                          DEPT
SCOTT                          EMP
SCOTT                          SALGRADE "

I test the database link in the Schema Manager and I recieve the error message.
"The Database Link is not active."

I try to run a query against the link and I recieve the message -

"SQL> CONNECT SYSTEM/MANAGER;

Connected.
SQL> SELECT OWNER, TABLE_NAME FROM ALL_TABLES_at_ORACLE8; SELECT OWNER, TABLE_NAME FROM ALL_TABLES_at_ORACLE8

                                         *
ERROR at line 1:
ORA-02085: database link ORACLE8.WORLD connects to ORACLE.WORLD"

Both databases are Oracle 8.
One database resides on my pc and the other resides on a development server. Both databases were setup using the install program thus giving them the same name and same sid.
I am using TCP/IP to connect to the remote database. I have tried both fixed user and connected user link options.

Thank you for your help. Received on Sat Aug 15 1998 - 01:21:14 CEST

Original text of this message