Re: problems with dblink in oracle 10.2.0.2

From: <genegurevich_at_discoverfinancial.com>
Date: Fri, 2 Feb 2007 10:22:21 -0600
Message-ID: <OF30534555.7E51F024-ON86257276.0059DCB2-86257276.0059EF33@discoverfinancial.com>

Yes, that is what I do. I have the same user existing on local and remote DB and I am creating the dblink the way
you have it

thank you

Gene Gurevich

                                                                           
             amonte                                                        
             <ax.mount_at_gmail.c                                             
             om>                                                        To 
                                       genegurevich_at_discoverfinancial.com  
             02/01/2007 05:10                                           cc 
             PM                        oracle-l_at_freelists.org              
                                                                   Subject 
                                       Re: problems with dblink in oracle  
                                       10.2.0.2

Dont tell me you are using remote os authentification?

Are you saying

server 1 has user ops$adm1
server 2 has user ops$adm1

and in server 1 as ops$adm1 you do

create database link xxx
using 'yyy'

On 2/1/07, genegurevich_at_discoverfinancial.com < 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 Fri Feb 02 2007 - 10:22:21 CST