How to fix the Oracle error TNS-12163: TNS:connect descriptor is too long?

In this post, you’ll learn more about the Oracle ErrorTNS-12163: TNS:connect descriptor is too long with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

TNS-12163: TNS:connect descriptor is too long

Reason for the Error TNS-12163: TNS:connect descriptor is too long

Cause: The connect descriptor corresponding to the net service name specified as the connect identifier is too long. The maximum length for a connect descriptor is 512 bytes and this limit has been exceeded.

How to fix the Error TNS-12163: TNS:connect descriptor is too long ?

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

Action: Check the net service name’s connect descriptor in the local naming file (TNSNAMES.ORA) or in the directory server (Oracle Internet Directory). Use a smaller connect descriptor. If this is not possible, contact Worldwide Customer Support.