Re: problems with dblink in oracle 10.2.0.2

From: <genegurevich_at_discoverfinancial.com>
Date: Thu, 1 Feb 2007 15:56:11 -0600
Message-ID: <OF43C83DC2.0DBC8F04-ON86257275.00787671-86257275.00787F1E@discoverfinancial.com>

Didn't seem to help. I am still getting this error. Thanks for the info anyway

thank you

Gene Gurevich

                                                                           
             Rodd Holman                                                   
             <Rodd.Holman_at_gmai                                             
             l.com>                                                     To 
                                       genegurevich_at_discoverfinancial.com  
             02/01/2007 10:00                                           cc 
             AM                        oracle-l_at_freelists.org              
                                                                   Subject 
                                       Re: problems with dblink in oracle  
                                       10.2.0.2

Not sure if this relates to this specific issue. Do you have SQLNET.AUTHENTICATION_SERVICES = <something> in your sqlnet.ora file? If so set it to NONE. This is described in Note: 1021276.6 on metalink

genegurevich_at_discoverfinancial.com wrote:
> Hi all:
>
> I have spend 2 weeks trying to get help from Oracle support on this (time
> well wasted). Here is my issue.
> I am running oracle 10.2.0. on aix 5.3 on a local server and on a remote
> server. I have oracle id externally
> authenticated on both sides. I can connect as sqlplus / to local DB and
as
> sqlplus /@remoteDB.
> I have created a db link on a local database :
>
> create database link remoteDB using 'remoteDB'
>
> When I try to use it I get an error:
>
> desc user_tables_at_remoteDB
>
>

> ERROR:

> ORA-01017: invalid username/password; logon denied

> ORA-02063: preceding line from PCCS03 (this is my remote DB)

>
>
>
>
> The remote instance is up (I can tnsping id and connect via sqlplus).
What
> is the problem here. I have been using
> dblinks created this way in oracle 8 and 9 and never had this issue. Is
> there anything new in oracle 10 related to this?
> Does anyone know?
>
> TIA
>
> Gene Gurevich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 01 2007 - 15:56:11 CST