Re: Remote Database Link

Lynn,

What happens when you sign on to SQL*Plus and issue the following:   SELECT SYSDATE FROM DUAL_at_linkname;
What error message do your receive? There are a couple of things that could be wrong here.

HTH,
Brian

"Mr. Lynn Moorhead" wrote:
>
> 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! =-----
> >
Received on Wed Jun 27 2001 - 08:05:37 CDT