Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: create database link not active

Re: create database link not active

From: Steve . <syarbrou_at_nospam.enteract.com>
Date: 2000/06/13
Message-ID: <7tkcks0cbn3mqf1ratl7iku7n46maohd2b@4ax.com>#1/1

One other thing, does you run the sql scripts on the original database or the one being replicated to? Or both? Thanks.

STeve

On Tue, 13 Jun 2000 10:12:52 -0500, Steve . <syarbrou_at_nospam.enteract.com> wrote:

>I have Global Names turned off.
>
>Have not run those scripts. Do I need to run the ones in:
>./u01/app/oracle/product/8.1.5/rdbms/admin/catrep.sql
>
>or
>
>./manager/rdbms/admin/catrep.sql
>
>or doesn't it matter?
>
>TNSPING of machine fine.
>
>Steve
>
>
>On Tue, 13 Jun 2000 08:24:42 +0100, Chris Mac
><chris_mac_at_youdon'twanttoknow.net> wrote:
>
>>"Steve ." wrote:
>>>
>>> I am setting up a replication of an Oracle 8i database to another one
>>> on Solaris. Went into the console and created a database link. When
>>> I click on test, it says the Database Link is not Active. What have I
>>> done wrong? Thanks.
>>>
>>
>>What have you done right?
>>
>>Global names enabled?
>>catrep.sql, catproc.sql executed properly (no invalid objects)?
>>tnsping ok?
>>Defined master sites?
Received on Tue Jun 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US