Help with Database Link

(Sorry I posted this separately to comp.databases.oracle.misc, But I just realized that that was not the appropriate newsgroup.)

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 Wed Feb 12 1997 - 00:00:00 CST