db link help needed

From: Aric Rosenbaum <aricr_at_arconsultinginc.com>
Date: Tue, 13 Oct 1998 16:46:06 -0400
Message-ID: <3623BC0E.A5C976C@arconsultinginc.com>

I'm trying to setup a database link between two O7.3 servers by issuing the following:

CREATE DATABASE LINK AspenOracle7 CONNECT TO scott IDENTIFIED BY tiger USING 'AspenOracle7';

However, when I'm logged into another the "other" server and issue a query such as:

SELECT * FROM scott.dept_at_aspenoracle7;

I get the following error message:

ORA-02085: database link ASPENORACLE7.WORLD connects to ORACLE.WORLD

FYI - The two servers are named ASPEN and CHAMONIX w/ TNS names setup for AspenOracle7 and ChamonixOracle7. Both instances have a SID of ORCL. How can I get this to work? Thanks in advance.

Aric

Received on Tue Oct 13 1998 - 15:46:06 CDT