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
codermonkeyFor 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
JustinYou 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