How to fix the Oracle error ORA-12162: TNS:net service name is incorrectly specified?

In this post, you’ll learn more about the Oracle ErrorORA-12162: TNS:net service name is incorrectly specified with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-12162: TNS:net service name is incorrectly specified

Reason for the Error ORA-12162: TNS:net service name is incorrectly specified

The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified.

How to fix the Error ORA-12162: TNS:net service name is incorrectly specified ?

You can fix this error in Oracle by following the below steps

If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If using directory naming check the information provided through the administration used for directory naming.