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
(FOC1405) SQL PREPARE ERROR.
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.
Can you TNSPING you server?
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
|Powered by Social Strata|