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

In this post, you’ll learn more about the Oracle ErrorTNS-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

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

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

Cause: 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 TNS-12162: TNS:net service name is incorrectly specified ?

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

Action: 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.