Re: Strange Error in Database Links

From: Henk Hultink <hhu_at_stopspam.stoas.nl>
Date: Thu, 7 Nov 2002 15:26:41 +0100
Message-ID: <3dca781d$1@news.wau.nl>

Hi,

I'm not sure whether you should use NTS authentication services, as the password of user SH is entered in the creation of the DB-link. Try removing (or commenting with #) this line in SQLNET.ORA. Not sure if this helps, but no harm done.

HTH, Henk

"Marco Costa" <mcosta_at_criticalsoftware.com> wrote in message news:d62b0292.0211060336.3c7fbd1a_at_posting.google.com...
> After some tries I removed the default domain and the sqlnet.ora files
> as only the following:
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> Even more strange,
> When I connect to my DB in machine1 using SQLPlus and try to access
> the DB in machine2 using DBLINK1 I got the error "ORA-12631Username
> retrieval failed"... BUT if someone in machine2 connects to my
> database using SQLPlus, and uses the same Database Link I used
> (DBLINK1) it works fine!!!
>
>
> The same is true in the other direction: if I log into a remote
> database I'm able to access mine through a dblink, if someone logs
> localy in the db I've logged remotely and uses the same dblink I used,
> he's not able to see my database.
>
> Thanks
> Marco
>
> TurkBear <john.greco_at_dot.state.mn.us> wrote in message
news:<543gsukp7cgq7h2t849kr98a7lctbtluqp_at_4ax.com>...
> > Check the sqlnet.ora files on the server from which you are issuing the
query ( and on the target server as well)
> > and be sure that the authentication parameter is not what is causing
the problem..This is an authentication service error:
>
> --------------------------------------------------------------------------

---

---

> > ORA-12631
> >
> > ORA-12631Username retrieval failed
> >
> > Cause:The authentication service failed to retrieve the name of a user.
> >
> > Action:Enable tracing to determine which routine is failing.
>
> --------------------------------------------------------------------------

---

-
> > hth
> >
> > mcosta_at_criticalsoftware.com (Marco Costa) wrote:
> >
> > >Hi,
> > >I have two Oracle 9i intallations in two Win2000 machines.
> > >In both I have a database named "dbname".
> > >I defined a net service for the remote database - servremote.
> > >
> > >This connection is working fine and I can access the remote database
> > >with the SQLPlus with the following information:
> > > user: sh
> > > pass: mypass
> > > service: servremote
> > >
> > >The Global_Name parameter is set to FALSE;
> > >
> > >I then log in to the local database and to create the Database link I
> > >do the following:
> > >CREATE DATABASE LINK mydblink
> > >CONNECT TO sh IDENTIFIED BY mypass
> > >USING "servremote";
> > >
> > >When selecting from the remote database I get the following error:
> > >?> select * from sales_at_mydblink;
> > >
> > >ORA-12631: Username retrieval failed
> > >
> > >I really appreciate any help.
> > >Marco Costa
> >
> >
> >
> > -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> > http://www.newsfeed.com The #1 Newsgroup Service in the World!
> > -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Thu Nov 07 2002 - 08:26:41 CST