A user is getting the following error when attempting to connect to an Oracle database through an Oracle Forms app. I also get the same error when I try to connect from their computer using sqlplus.
ORA-12514: Message 12514 not found; product=RDBMS73; facility=ORA
There are two Oracle clients on the machine, one for 8 and the other for 10g. The forms runtime is installed in the Oracle 8 client's path. I've set the path to include only Oracle 8 in the path, and the ORACLE_HOME is set to 8's home. The connection details in the tnsnames.ora (both of them) are correct.
When I try tnsping, that returns successfully.
Any ideas?
Best Answer
Your error is: "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor". In practice that means that the client is able to connect the server, but server's listener does not know the SID you are trying to use. You get a different message telling that the client is unable the locate the actual error text.
There are few possibilities for the error: