Re: Strange Error in Database Links

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 Wed Nov 06 2002 - 05:36:40 CST