RE: problems with dblink in oracle 10.2.0.2

Yep,

I am doing just that and getting this error:

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

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

when issuing this command: desc user_tables_at_remoteDB

thank you

Gene Gurevich

                                                                           
             "MacGregor, Ian                                               
             A."                                                           
             <ian_at_slac.stanfor                                          To 
             d.edu>                    <genegurevich_at_discoverfinancial.com 


                                       >, <oracle-l_at_freelists.org>         

             02/01/2007 04:01                                           cc 
             PM                                                            
                                                                   Subject 
                                       RE: problems with dblink in oracle  
                                       10.2.0.2                            
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           

If you use the same oracle account on both sides of the link and they have the same password, you can use

Create database link <link_name>
Using '<HOST>';

No password will be stored for the link.

Ian MacGregor
Stanford Linear Accelerator Center

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discoverfinancial.com Sent: Thursday, February 01, 2007 1:52 PM To: oracle-l_at_freelists.org
Subject: RE: problems with dblink in oracle 10.2.0.2

Fadi,

I don't want to use that syntax so that my password is not written anywhere in the dba_tables

thank you

Gene Gurevich

             "Fadi Hasweh"
             <fhasweh_at_umniah.c
             om>                                                        To
                                       <genegurevich_at_discoverfinancial.com
             02/01/2007 09:51          >, <oracle-l_at_freelists.org>
             AM                                                         cc

                                                                   Subject
                                       RE: problems with dblink in oracle
                                       10.2.0.2

Cann't you use
Create database link db_link_name connect to user_name identified by password using 'tns_entry' and try

fadi hasweh
http://oracle-magic.blogspot.com/
Oracle is not Magic, it just takes years of experience -----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discoverfinancial.com
Sent: Thursday, February 01, 2007 5:32 PM To: oracle-l_at_freelists.org
Subject: problems with dblink in oracle 10.2.0.2

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


"This email is intended for the above named addressee (s) only and may
contain confidential and/or privilege information and should not be used by
anyone who is not the original intended recipient(s). Any review, print,
copy, reliance or distribution by others or forwarding without express
permission is strictly prohibited  If you have received this email in
error, kindly notify the sender immediately by reply email and delete this
email and any attachments from your mailbox or any other storage mechanism.
Thank you.
Email transmission cannot be guaranteed to be secured or error free, as
information could be intercepted, corrupted, lost, destroyed, received late
or incomplete, or could contain viruses. The sender therefore does not
accept liability for any error or omission in the contents of this message,
which arises as a result of email transmission. Opinions, conclusions and
other information in this message that do not relate to the official
business of Umniah Mobile Company and is not its responsibility shall be
understood as neither given nor endorsed by the organization."





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






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