HELP! The Database Link is not active.
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