Re: db link

From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
To: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
Date: Thu, 29 Oct 2009 13:26:16 -0500
Did you try putting it in quotes and in upper case?

On Thu, Oct 29, 2009 at 1:21 PM, Zelli, Brian
<Brian.Zelli@xxxxxxxxxxxxxxx>wrote:

>  Tried that too.  Still the same.....
>
>
> ciao,
>
> Brian
>
>
>
> *Brian J. Zelli,* Ed.M.
>
> Sr. Database Administrator
>
> Enterprise Application/Systems Integration
>
> Information Technology - Roswell Park Cancer Institute
>
> phone: (716) 845-4460 email: brian.zelli@xxxxxxxxxxxxxxx
>
>
>
>  ------------------------------
> *From:* Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
> *Sent:* Thursday, October 29, 2009 2:12 PM
> *To:* mnavickas@xxxxxxxxx
> *Cc:* Zelli, Brian; oracle-l@xxxxxxxxxxxxx
> *Subject:* Re: db link
>
> If you actually used "LIMS_TO_ERT" to create the link, try putting the
> @lims_to_ert in capital letters.
>
> On Thu, Oct 29, 2009 at 12:50 PM, Mindaugas Navickas 
> <mnavickas@xxxxxxxxx>wrote:
>
>>  Brian,
>>
>> I would try to create a DBlink with full TNS definition - to see if it's
>> working - e.g.
>>
>> Create public database link "LIMS_TO_ERT" connect to "XXX"  identified by
>> "XXXXX"
>> using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL =
>> TCP)(HOST=xxxxxxx)(PORT = 1521))) (CONNECT_DATA= (SID=dbsid) ) )'
>>
>> I know, it doesn't answer your question - why tns address is not read from
>> tnsnames.ora, however above can serve as a workaround.
>>
>> Regards
>> Mike Navickas
>> Oracle&DB2 DBA
>>
>>  ------------------------------
>> *From:* "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
>> *To:* "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
>> *Sent:* Thu, October 29, 2009 12:35:09 PM
>> *Subject:* db link
>>
>> I'm creating a link:
>>
>>   1  Create public database link "LIMS_TO_ERT" connect to "XXX"
>>   2  identified by "XXXXX"
>>   3  using 'PRODERT.ROSWELLPARK.ORG'
>>
>> it tells me the link is created, yet when I try and access thru the link I
>> get:
>>
>> SQL> desc rpci.ert_lims_iface@lims_to_ert;
>> ERROR:
>> ORA-12154: TNS:could not resolve the connect identifier specified
>>
>> I have the PRODERT.ROSWELLPARK.ORG in my tnsnames and I can connect with
>> sqlplus to that db.  So what's wrong?  All we did was move the database to a
>> new server.
>>
>>
>> ciao,
>>
>> Brian
>>
>>
>>
>> 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.
>>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
> 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.
>



-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'
References:
- db link
  - From: Zelli, Brian
- Re: db link
  - From: Mindaugas Navickas
- Re: db link
  - From: Andrew Kerber
- RE: db link
  - From: Zelli, Brian
Re: db link

Other related posts:
