From: ghubert@skillspoint.com (Gene Hubert)
Subject: Re: need help creating a database link
Date: 2000/06/06
Message-ID: <393cf27d.603404399@news.interpath.net>#1/1
References: <O8U_4.1160$Hs5.142580@dfiatx1-snr1.gtei.net>
Organization: Interpath Communications, Inc.
Newsgroups: comp.databases.oracle.server


There are some complexities to consider if both db's have the same
sid.  Take a look at the GLOBAL_NAMES parameter in your init.ora file.

Gene Hubert
http://www.skillspoint.com - Where Smart People Buy Training!


On Mon, 05 Jun 2000 20:33:50 GMT, "Rob Freeman"
<rfreeman@authentica.com> wrote:

>Goal:  To set up Oracle replication between two Oracle servers.  I have the
>syntax for an hourly snapshot of the master database, however, I can't get
>the database link to work.
>
>What I have done:
>
>On both machines I have the user pvmaster identified by donetsk.  Locally I
>can do:
>
>SQL>connect pvmaster/donetsk
>connected
>
>Remotely:
>
>SQL>connect pvmaster/donetsk@icicle
>connected
>
>I have granted "create database link" to the local pvmaster account.
>
>So I create the database link like this:
>
>SQL>create database link pvmaster
>2  connect to pvmaster identified by donetsk
>using icicle;
>
>link created
>
>There is a table, pv_instance_data on the remote database, and it belongs to
>pvmaster.  I can log on remotely and select pv_key from pv_instance_data and
>view the contents of the pv_key column.
>
>however, when I try:
>
>SQL> select pv_key from pv_instance_data@pvmaster;
>
>I get the error:
>
>Error at line 1 database link PVMASTER connects to ORACLE
>
>Thanks for the help!
>
>Sincerely,
>
>Rob Freeman
>rfreeman@authentica.com
>
>