R3trans: CONNECT failed with sql error '12154'

Symptom

During SAP startup, you encountered below error (dev_w0) (all background work process in ended status)

OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154:
ORA-12154: TNS:could not resolve the connect identifier specified
*** ERROR => CONNECT failed with sql error '12154'

From R3trans -d

[    dbsloci.,00000]  *** ERROR => CONNECT failed with sql error '12154'
[     dev trc,00000]     set_ocica() -> SQL error code 12154
[     dev trc,00000]  -->oci_get_errmsg (con=0, rc=12154)
[     dev trc,00000]     OCIErrorGet -> SQL error code: 12154
[     dev trc,00000]     ORA-12154: TNS:could not resolve the connect
                         identifier specified