Re: Strange Error in Database Links

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Tue, 05 Nov 2002 12:27:58 -0600
Message-ID: <543gsukp7cgq7h2t849kr98a7lctbtluqp@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 Tue Nov 05 2002 - 12:27:58 CST