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

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question: Creating database link

Re: Newbie question: Creating database link

From: TurkBear <johng_at_mm.com>
Date: Wed, 26 Jan 2000 18:01:22 GMT
Message-ID: <38903598.75336458@204.181.81.99>


Hi,

The key to understanding this is remembering that a database link operates on the server to which you are connected not the local client; The tnsnames.ora file on the server is the one that needs the connect string specified in the connect by statement... -- so if you are connected to server A and use create database link blink connect to whoever identified by whatever using 'bserver' - the 'bserver' must be a tnsnames.ora entry ON server A ---

hth,
John Greco

Griffin <chengcs_at_my-deja.com> wrote:

>I want to create a database link on a Solaris Oracle (say A) thru
>another Solaris Oracle (B) connected from an NT client. If I just type:
>
>create database linke <whatsoever>
> connect to <userid> identified <passwd>
> using '<connect>'
>
>and <connect> is the string stored in local client tnsnames.ora to
>connect to server (A). This will raise an error "TNS cannot resolve
>service" when I try to exec a query.
>
>Or when <connect> is the same as string stored on the server (B) to
>connect to (A), an error ORA-02085 is rasied.
>
>Any help would be appreciated.
>
>
>Griffin.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Jan 26 2000 - 12:01:22 CST

Original text of this message

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