**
Thanks for the offers. I managed to work out that the problem was caused by
the aradmin unix account was not set up with the ORACLEHOME directory.
(remedy was previously installed, but the database was overwritten by a copy
from another server)
Thanks again,
Karen
-----Original Message-----
From: Michael Worts [mailto:Michael.Worts@NTL.COM]
Sent: 11 April 2002 11:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: ARS 4.5.2 and Oracle 8i
**
Hmm. If you can run the SQLPlus command from the Remedy server then there
should be no problems running it from Remedy. I have a number of DBLinks
from Remedy to a remote Oracle database using the string:
SELECT * FROM table@dblink;
The DBLink name should be in your TNSNAMES.ORA file on the Remedy server but
it sounds like you already have it (as you can use SQLPlus).
Can you do a TNSPing of your remote database?
When you test your DBLink - does it test active?
Can you send us an example of the SQL command you are using?
Mike.
--------------------------------------------
Michael Worts
Remedy Consultant
IBM Global Services:
michael.worts@ntl.com
--------------------------------------------
Remedy v4.52 Patch 1017
RS/6000 - AIX 4.3
Oracle 8.1.6
--------------------------------------------
-----Original Message-----
From: Karen Thorn [mailto:karen.thorn@BT.COM]
Sent: 11 April 2002 10:42
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: ARS 4.5.2 and Oracle 8i
**
Hi all,
I am hainvg great difficulties getting ARS to talk to a remote oracle
database. The Customer inventories are stored on a single oracle database
and ARS interogates this data to fault report.
I have setup the DB link and the TNSNAMES.Ora file, and if I try through
SQL*Plus on the server, I can do the same queries as remedy and they work
fine. If I try the same through remedy, it gives the error message:
ORA-12154 - TNS: could not resolve service name.
Please Help!
Thanks,
Karen
To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com You may also control your subscription
options, including UNSUBSCRIBE, at www.ARSLIST.org
The contents of this email and any attachments are sent for the personal
attention of the addressee(s) only and may be confidential. If you are not
the intended addressee, any use, disclosure or copying of this email and any
attachments is unauthorised - please notify the sender by return and delete
the message. Any representations or commitments expressed in this email are
subject to contract.
ntl Group Limited
To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com You may also control your subscription
options, including UNSUBSCRIBE, at www.ARSLIST.org
Previous Topic
Index