ORA-12154: TNS:could not resolve the connect identifier happened to 64 bit BizTalk Host

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> NOTE: This article is migrated from Blog AsiaTech Date: 2009-3-31 6:43 PM Orignal URL: http://blogs.msdn.com/b/asiatech/archive/2009/03/31/ora-12154-tns-could-not-resolve-the-connect-identifier-specified.aspx <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Last Friday, Xiao Dong, Bryan and Wei worked out one interesting Biztalk issue, which got resolved by workaround one Oracle client software limitation.   ORA-12154: TNS:could not resolve the connect identifier specified when calling System.Data.OracleClient.OracleConnection.Open() in an orchestration which…