Re: select from remote db

I am sorry to say that the two systems that I got this working on are on their way to Canada, so I cannot tell you for sure.

I believe when I did this, I created a physical database link, just like I had in my 6.0 database.

CREATE DATABASE LINK db2 CONNECT TO user IDENTIFIED BY password USING 'db2:sid';

I am not 100% sure on my connection parameters. (On 6.0, it was T:host:sid, for a TCP/IP connection.) I know I did something like this on 8.1.5, and I believe it was required to make it work, but I am not 100% certain what I did. (I hoped it was a one-time-only thing!)

Terry Steyaert
steyaert_at_my-deja.com

In article <876f3p$3ebo0$1_at_fu-berlin.de>,   "Kathinka Diehl" <kathinka_at_rrr.de> wrote:
>
> Sybrand Bakker <postmaster_at_sybrandb.demon.nl> schrieb:
> > the tnsnames.ora on the server for db1. It doesn't have an entry
for db2.
> > Database links are used by the server only.
>
> No, sorry, this could not be the problem. There are entries for all
dbs in
> the tnsnames.ora, I have no problems to connect.
>
> Connect user2/password2_at_db2 works fine.
>
> TNSNAMES.ORA:
>
> DB1.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = DB1-Server)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = DB1-Server)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = DB1)
> )
> )
> DB2.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = DB2-Server)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = DB2-Server)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = DB2)
> )
> )
>
> There must be another place to write a discribtion for the remote
user.
>
> Kathinka
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 03 2000 - 09:09:26 CST