Re: Newbie question: Creating database link

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