RE: db link

  • From: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
  • To: Jack van Zanen <jack@xxxxxxxxxxxx>
  • Date: Thu, 29 Oct 2009 19:22:53 -0400

As I suspected, the database I was trying to link to had a different sqlnet.ora 
than the old server and it didn't match the sqlnet I had on my server.  Once we 
included the hostname and oname in the names.directory_path of the sqlnet, it 
worked.

________________________________
From: jack.van.zanen@xxxxxxxxx [jack.van.zanen@xxxxxxxxx] On Behalf Of Jack van 
Zanen [jack@xxxxxxxxxxxx]
Sent: Thursday, October 29, 2009 6:50 PM
To: Zelli, Brian
Cc: ORACLE-L
Subject: Re: db link

post your tnsnames.ora entry as well. (obscure names if need to)

Do you have multiple oracle homes? are they all the same as far as sqlnet.ora 
and tnsnames.ora are concerned?
do you have a tnsadmin variable set?
Have you tried creating the link with the fully qualified database name as 
perviously suggested?

Try answering to the suggestions with the suggestion as a quote and preferably 
with a cut and paste of the output of the error. Makes it easier for all of us 
to understand what you are answering.

Jack

2009/10/30 Zelli, Brian 
<Brian.Zelli@xxxxxxxxxxxxxxx<mailto:Brian.Zelli@xxxxxxxxxxxxxxx>>
After having tried every combination from my end, I'm thinking that it could be 
the database that I am trying to link to.  Does the sqlnet.ora's have to match 
on both servers?  The new server I am trying to connect to is different than 
the old server.

New server:
SQLNET.ORA
==========
NAMES.DEFAULT_DOMAIN = roswellpark.org<http://roswellpark.org/>

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)


Old server:
SQLNET.ORA
==========
NAMES.DEFAULT_DOMAIN = roswellpark.org<http://roswellpark.org/>

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


Again, I was able to connect to the old server.

This email message may contain legally privileged and/or confidential 
information.  If you are not the intended recipient(s), or the employee or 
agent responsible for the delivery of this message to the intended 
recipient(s), you are hereby notified that any disclosure, copying, 
distribution, or use of this email message is prohibited.  If you have received 
this message in error, please notify the sender immediately by e-mail and 
delete this email message from your computer. Thank you.
--
//www.freelists.org/webpage/oracle-l





--
Jack van Zanen

-------------------------
This e-mail and any attachments may contain confidential material for the sole 
use of the intended recipient. If you are not the intended recipient, please be 
aware that any disclosure, copying, distribution or use of this e-mail or any 
attachment is prohibited. If you have received this e-mail in error, please 
contact the sender and delete all copies.
Thank you for your cooperation


This email message may contain legally privileged and/or confidential 
information.  If you are not the intended recipient(s), or the employee or 
agent responsible for the delivery of this message to the intended 
recipient(s), you are hereby notified that any disclosure, copying, 
distribution, or use of this email message is prohibited.  If you have received 
this message in error, please notify the sender immediately by e-mail and 
delete this email message from your computer. Thank you.
--
//www.freelists.org/webpage/oracle-l
  • Follow-Ups:

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2009