Re: Remote Database Link

"Mr. Lynn Moorhead" <lynncind_at_swbell.net> wrote in message news:<6N2_6.12$uN4.16374_at_nnrp2.sbc.net>...
> Sorry about the lack of info., but I was just trying to be brief as I
> realize most people are VERY busy.
> Running 8i Version 8.1.6 on all boxes concerned. It is not actually
> "giving" an error when creating the link, but when you use the GUI to create
> and then attempt to "test" the link with the "Test" button. The pop-up
> message is: "The database link is not Active."
>
> I can Tnsping the database, I can Ping the workstation, I can remote connect
> (i.e. connect user/password_at_dbname), and all of these function normally, but
> I need a Remote Database Link to create a synonym for a database on this NT
> 4.0 server for some other processes that require this type of connectivity.
>
> Thanks...
>
> Lynn :-)
>
> "TurkBear" <noone_at_nowhere.com> wrote in message
> news:3uchjtc6s9pb66cqq7l889i4i98sastdd2_at_4ax.com...
> >
> > It would help if you specified what you mean by 'I cannot accomplish
 this' --
> >
> > What error message(s)
> > What versions of the Database on each...
> >
> > More info please, the universe of possibilities is too large guess at...
> >
> >
> > "Mr. Lynn Moorhead" <lynncind_at_swbell.net> wrote:
> >
> > >My Question is simple: How do you MAKE a Windows NT 4.0 successfully
> > >"CREATE PUBLIC DATABASE LINK..." to a Windows 2000 machine? I can
> > >successfully connect from a Win2K box to NT 4.0 with a Remote Database
 Link,
> > >but I cannot accomplish this the other way around. Is it possible? If
 so,
> > >what am I missing?
> > >
> > >Thanks...
> > >Lynn :-)
> > >============================
> > >Mr. Lynn Moorhead
> > >Email: lynncind_at_swbell.net
> > >============================
> > >
> >
> >
> >
> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> >

Lynn, one of the most common problems I run into when I create a database link is that the tnsnames.ora file ON THE SERVER where the database link is created must have a tnsalias that corresponds exactly with the remote database alias that you specify when you create the database link. When Oracle resolves the location of the remote database specified in the create database link statement it uses the tnsnames.ora file on the server; no the tnsnames.ora file on the client machine. Even though you might have the CREATE DATABASE LINK privilege you might need your system administrator to edit the server's tnsnames.ora file to make the connection work.

Since you don't have access to the Oracle error code it's hard to isolate this problem further.

Dan Received on Tue Jun 26 2001 - 16:02:16 CDT