Oracle Error ORA-12214: TNS:missing local communities entry in TNSNAV.ORA

Oracle Error Message

ORA-12214: TNS:missing local communities entry in TNSNAV.ORA

Reason for the Error

There is no LOCAL_COMMUNITIES entry in TNSNAV.ORA.

Solution

Define the LOCAL_COMMUNITIES for this node in the TNSNAV.ORA file.