hi,
checked the sqlnet.ora
NAMES.DEFAULT_DOMAIN = tcskolkata.co.in
SQL> create database link UII.WORLD
2 connect to strmadmin
3 identified by strmadminpd
4 using '(DESCRIPTION =
5 (ADDRESS_LIST =
6 (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.34.133)(PORT = 1521))
7 )
8 (CONNECT_DATA =(SERVICE_NAME=UII.WORLD))
9 )';

Database link created.

SQL> select * from [email protected]d;
select * from [email protected]d
*
ERROR at line 1:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor


this is what i am getting.

thanks and regards.