Doublecheck the entry in tnsnames.ora. Open a command prompt on the remedy
server and type: tnsping {entryname}
See if it returns OK
Is the alias for the db name or the db server? If it is for the server,
make sure you can ping the alias name. You may need to have your DNS
server updated as well.
On Tuesday, February 16, 2016 at 10:45:41 AM UTC-5, Remedy_Mark wrote:
>
> **
>
> Hi All
>
>
>
> On my dev environment, we moved an external oracle (non-Remedy) database
> to another subnet and then updated tnsnames.ora file with a new alias in
> the oracle client. As far as I know, that is all we needed to do but when I
> run a query using the alias I get ORA-02019: connection description for
> remote database not found. Is there something I am missing?
>
>
>
> ARS 7.6.04
>
> Oracle 11.2
>
>
>
> Thanks
>
> Mark
>
>
>
> *Mark Brittain*
>
> Sr. OSD Systems Engineer
>
> ITILv3 Foundation, Continual Service Improvement
>
> *NaviSite, Inc. – A Time Warner Cable Company*
>
> [email protected] <javascript:>
>
> Office: 315.634.9337
>
> Mobile: 315.882.5360
>
> [image: navsig]
>
>
>
> ------------------------------
>
> This E-mail and any of its attachments may contain Time Warner Cable
> proprietary information, which is privileged, confidential, or subject to
> copyright belonging to Time Warner Cable. This E-mail is intended solely
> for the use of the individual or entity to which it is addressed. If you
> are not the intended recipient of this E-mail, you are hereby notified that
> any dissemination, distribution, copying, or action taken in relation to
> the contents of and attachments to this E-mail is strictly prohibited and
> may be unlawful. If you have received this E-mail in error, please notify
> the sender immediately and permanently delete the original and any copy of
> this E-mail and any printout.
> _ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
