RE:DB Link

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Thu, 12 Feb 2004 09:29:27 -0600
Message-ID: <OF0F0030FF.EFCAB4F1-ON86256E38.0055113E@chase.com>

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_at_jpmorgan.com
baileyre_at_us.ibm.com

Forwarded by Reginald W. Bailey/JPMCHASE on 02/12/2004 09:31 AM -----

                    Reginald.W.Bailey_at_jp                                                                                             
                    morgan.com                 To:     oracle-l_at_freelists.org                                                        
                    Sent by:                   cc:                                                                                   
                    oracle-l-bounce_at_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

                    Michael.Milligan_at_in

                    genix.com                 To:
oracle-l_at_freelists.org
                    Sent by:                  cc:

                    oracle-l-bounce_at_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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Feb 12 2004 - 09:29:27 CST