Re: Connection Problem

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: 1998/09/02
Message-ID: <6sl71e$mif@sjx-ixn5.ix.netcom.com>#1/1

First thing, check the tnsnames.ora file in machine C.. make sure that the name of 'A' appear in the machine C. If the name is not there, database C will NOT see database 'A'.

Secondly, make sure that machine C can connect to machine A.

My guess is that the name of the database 'A' does not appear in the tnsnames.ora on machine C

Good luck

Winnie

Tansel Ozkan wrote in message <35EDCED1.5FE8_at_openix.com>...
>Hello all,
>
>This is the situation:
>
>I dial into a database server (A) from a machine (B) in our local
>network. I would like to copy data using sql*plus copy command
>from the database on A to another database which resides on a
>machine (C) in our local network.
>So, B can see both A and C. There is no database on B. If I create
>a database link on C, it is not going to work since C physically can
>not see A.
>
>Any suggestions??
>
>Normally, I would of course use Import/Export, however we are getting
>some incompatability errors, which Oracle is not able to help us with.
>
>Thanks..
>
>Tansel
Received on Wed Sep 02 1998 - 00:00:00 CDT