RE:DB Link
- From: Reginald.W.Bailey@xxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 12 Feb 2004 09:29:27 -0600
============================================================================================================
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile)
reginald.w.bailey@xxxxxxxxxxxx
baileyre@xxxxxxxxxx
============================================================================================================
----- Forwarded by Reginald W. Bailey/JPMCHASE on 02/12/2004 09:31 AM -----
Reginald.W.Bailey@jp
morgan.com To: oracle-l@xxxxxxxxxxxxx
Sent by: cc:
oracle-l-bounce@free Subject: RE:DB Link
lists.org
02/11/2004 07:06 PM
Please respond to
oracle-l
Yes I have seen this before. First, turn on SQL Net tracing in the
sqlnet.ora file. Second, was the database link created on the server where
the database resides, or via the client? What version of Oracle are you
using? Also when you use the service name to connect, is it from a client ?
The database link from one database to another means that the parts
necessary for name resolution will need to be on the server where the
database link resides. This means that the hosts file needs to have the
server name and IP address of the target database server in it, or the
server is using some other name resolution like DNS. The database link
needs to be resolved from the server where the database link resides in the
database. Sure you can connect from a client.
RWB
============================================================================================================
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile)
reginald.w.bailey@xxxxxxxxxxxx
baileyre@xxxxxxxxxx
============================================================================================================
Michael.Milligan@in
genix.com To:
oracle-l@xxxxxxxxxxxxx
Sent by: cc:
oracle-l-bounce@fre Subject: RE: RE: JOINED
UPDATE
elists.org
02/11/2004 05:43 PM
Please respond to
oracle-l
Has anyone had trouble using a link created for just certain databases,
when
everything is set right. In other words, no reason can be seen why it
wouldn't work? We changed the global name, etc., etc. I can connect to the
database but when I create the link, then try to select from dual from
another database, it says "TNSNames cannot resolve service name". But using
the same service name, I immediately connect successfully to the database!
Driving us crazy. Any help would be greatly appreciated.
Thanks,
Mike
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by
replying
to this message and delete this e-mail immediately.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
