TNS issue with oracle adapter

Hi,

i I used the hotfix:http://support.microsoft.com/kb/959105 to solve the issue
of multiple runtimeagen.exe on Task Manger.
After I used the hot fix, I am getting the following error when I try to
connect to oracle from biztalk oracle adapter: Exception occurred: Error
Code: 12154 (0x2f7a) 08004 : [Oracle][ODBC][Ora]ORA-12154: TNS:could not
resolve the connect identifier specified
I could connect to oracle from SQLPLS and TOAD without any issue. When I
test the connection on System DNS, connection is successful. However when I
try to connect to oracle from Receiveport, I am getting above error. I
couldnt connect to oracle from biztalk adatper
when I do the below. Receive port -> Oracle adapter -> Configuration ->
provide oracle info and apply. When I open “Managing Events” window, it shows
OracleDB -> DEV . I dont see any table or anything under DEV. tnsname.ora and
sqlnet.ora are same as I had before. Nothing changed. It looks like some set
up between Oracle and BizTalk adapter has not been updated. Is there any
config, registry or any stuff I need to modify?

—
Thank you,

Siva