create database link with out editing tnsnames.ora

create database link a_dblink

  connect to system identified by password

 using

 '(DESCRIPTION=

   (ADDRESS=

     (PROTOCOL=TCP)

    (HOST=192.168.12.152)

    (PORT=1521))

   (CONNECT_DATA=

    (SID=my_sid)))';