hi,
actually after doing the Stream Admin set-up on both the db1(pdsource) and db2(uii.world), i wanted to test the dblink thru OEM, where i am getting this.
but Nir, one thing i want to mention here - don't know whether it is relevant or not.
i have set up the db "pdsource" in my pc yes'day thru the OEM - the TNS entry for this comes like

PDSOURCE.TCSKOLKATA.CO.IN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TCS031301)(PORT = 1521))
)
(CONNECT_DATA =
(SID= PDSOURCE)
(SERVER = DEDICATED)
)
)

(cudn't undstand why this TCSKOLKATA part came - is it bcos of some network settings???????)

but for db2 (uii.world) - the TNS entry is like this

UII.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.34.133)(PORT = 1521))
)
(CONNECT_DATA =
(SID = UII)
(SERVER = DEDICATED)
)
)

anything to do with this???

thanks and regards,
Prasenjit