Focal Point
at my wits end with oracle connection problem

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/2391098331

September 19, 2005, 05:18 PM
<Siees>
at my wits end with oracle connection problem
Has anyone come across the following? I can connect to two other databases on the same UNIX box fine, I can sqlplus to the database in question.

(FOC1400) SQLCODE IS 12514 (HEX: 000030E2)
(FOC1394) CONNECT FAILURE
: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
: descriptor
(FOC1405) SQL PREPARE ERROR.
September 19, 2005, 08:57 PM
codermonkey
For this kind of thing, your best bet is probably to open a case with tech support. They'll probably ask you to verify that the TNSNAMES.ORA file has an entry for the instance you are adding and that you've tested SQL*PLUS from the same machine as the iWay/WF server.
October 14, 2005, 03:09 PM
<toby mills>
Can you TNSPING you server?

-Toby
April 06, 2006, 08:19 AM
Justin
You say you can sqlplus to the database which Focus receives the error for?

Is the sqlplus session from the same machine as the focus server?

Additionally - there may be multiple installations of oracle on the server - do a search for tnsnames.ora and verify that the entry for this database is in all copies (and is correct).

HTH - Justin