Multiple choice technology platforms and products

ORA-12154: TNS: could not resolve the connect identifier specified.

  1. Restart the client machine alone

  2. Verify the parameters in the tnsnames.ora file. If required parameters are not present provide it, save it and just connect again

  3. Verify the parameters in the tnsnames.ora file. If required parameters are not present provide it, save it and just connect again.Then restart the forms server for the changes to get reflected.

  4. Only restart the forms server.

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ORA-12154 indicates the TNS listener cannot resolve the service name. The solution is to verify and correct the tnsnames.ora file parameters. Once corrected and saved, reconnecting is sufficient - restarting the client machine or forms server is unnecessary and excessive.