Re: Creating a Database Link

From: L120bj <l120bj_at_aol.com>
Date: 1997/02/23
Message-ID: <19970223130900.IAA20628@ladder02.news.aol.com>#1/1

This is a bug within ORACLE 7.3.2.2 in that an ORACLE 7.3.2.2 database cannot be linked to another 7.3.2.2 database, but it can be linked to a different version, eg 7.3.2.1 - good eh? ORACLE have a patch for the problem so you need to get in touch with them to see if its available on your platform

Subject: Creating a Database Link
From: David Kent <david.kent_at_istar.ca>
Date: 12 Feb 1997 16:30:16 GMT
Message-ID: <5dsr6o$qng_at_news.istar.ca>

Hi,

I am having a small problem with database links. I have 2 databases on separate machines (Oracle Workgroup Server 7.3.2.2.0) running SQL*Net v2. I have set up my /var/opt/oracle/tnsnames.ora file such that I can access the other database. ie.

sqlplus system/manager_at_otherhost

works on both machines.

I have modified by init.ora file to add the statement 'OPEN_LINKS = 4'.

I have an account on each machine '...david identified by kent' which I have granted connect, resource and dba privileges.

When I log on to machine 1 as david/kent, I created a db link as follows:

create database link REMOTE_CONNECT
using 'otherhost';

This command works fine.

I then try the following command:

select * from junk_at_REMOTE_CONNECT;

The machine hangs for a minute or 2, then I get back to the Unix promt and I have a core dump. (I have created a table named junk on machine 2.)

When I log onto sqlplus, I do get the message:

   Connected to:
   Oracle7 Server Release 7.3.2.2.0 - Production Release    With the distributed option
   PL/SQL Release 2.3.2.2.0 - Production

If anyone knows if this is a Workgroup server problem, or if I am doing something wrong (or missing something in my init.ora file), I would appreciate some help.

Thnaks very much,

David Kent
Senior Systems Analyst
iSTAR internet inc.
Ottawa, Ontario, Canada Received on Sun Feb 23 1997 - 00:00:00 CST