Oracle Solution for Error ora-12163

ORA-12163: TNS:connect descriptor is too long

What triggered the Error:

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.

What should we do to fix it:

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.