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

Oracle Error Message

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

Reason for 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.

Solution

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