Oracle Error ORA-06114: NETTCP: SID lookup failure

Oracle Error Message

ORA-06114: NETTCP: SID lookup failure

Reason for the Error

From the remote host’s SQL*Net TCP/IP server: the database SID, specified in the login (connect) string, was not recognized.

Solution

Add the appropriate SID entry to the CONFIG.ORA file on the remote host (and restart the SQL*Net TCP/IP server).