Oracle DBA, How To, Error, Cause and Action

ORA-06114: NETTCP: SID lookup failure

ORA-06114: NETTCP: SID lookup failure




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




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