RE: problems with dblink in oracle 10.2.0.2
- From: "Fadi Hasweh" <fhasweh@xxxxxxxxxx>
- To: <genegurevich@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Feb 2007 17:51:28 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
genegurevich@xxxxxxxxxxxxxxxxxxxxx
Sent: Thursday, February 01, 2007 5:32 PM
To: oracle-l@xxxxxxxxxxxxx
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@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
--
//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."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
