Oracle Solution for Error ora-12219

ORA-12219: TNS:missing community name from address in ADDRESS_LIST

What triggered the Error:

This error occurs when an ADDRESS_LIST has some ADDRESSes in it that have no COMMUNITY component and others that do have a COMMUNITY component.

What should we do to fix it:

Check that in the connect descriptors you are using either all the ADDRESSes have a COMMUNITY component or all do not.