Originally posted by prasen999
yes , that is true that in sqlnet.ora the default domain in the 2 servers are different - so does changing the sqlnet.ora default domain to be the same in both the dbs solve the issue?

thanks and regards
considering you're not going to touch global_names.
I will give you a work around just to simplify my view and to work things out.

omit the value of default_domain in SQLNET.ORA in both servers, or might as well rename SQLNET.ORA to SQLNET.BAK
edit the tnsnames of both servers(please post which server did you create your dblink).
1st server: tnsnames.ora(also include tnsnames of 2nd server)
PDSOURCE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TCS031301)(PORT = 1521))
)
(CONNECT_DATA =
(SID= PDSOURCE)
(SERVER = DEDICATED)
)
)

2nd server: tnsnames.ora tnsnames.ora(also include tnsnames of 1nd server)
UII =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.34.133)(PORT = 1521))
)
(CONNECT_DATA =
(SID = UII)
(SERVER = DEDICATED)
)
)

Then recreate your db link like(assuming you are creating db link from 2nd server):
create database link YOURDBLINK_UII
connect to strmadmin
identified by strmadminpd
using PDSOURCE