How to fix the Oracle error ORA-06420: NETCMN: SID lookup failure?

In this post, you’ll learn more about the Oracle ErrorORA-06420: NETCMN: SID lookup failure with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-06420: NETCMN: SID lookup failure

Reason for the Error ORA-06420: NETCMN: SID lookup failure

From the remote host’s server: the database SID, specified in the login (connect) string, was not recognized.

How to fix the Error ORA-06420: NETCMN: SID lookup failure ?

You can fix this error in Oracle by following the below steps

Add the appropriate SID entry to the CONFIG.ORA or oratab file on the remote host (restarting the remote server may be needed).