How to create Database Link without editing tnsnames.ora file

01	system@TEST11> select * from v$version;

02

03

BANNER

04	--------------------------------------------------------------------------------

05	Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

06	PL/SQL Release 11.1.0.7.0 - Production

07	CORE    11.1.0.7.0      Production

08	TNS for Linux: Version 11.1.0.7.0 - Production

09	NLSRTL Version 11.1.0.7.0 - Production

10

11	5 rows selected.

12

13

14	system@TEST11> select * from dba_db_links;

15

16	1. no rows selected

Create database link testlink_db2 using full tns entry:

01	system@TEST11> create database link testlink_db2

02	2  connect to system identified by oracle

03

3  using

04	4  '(DESCRIPTION=

05	5    (ADDRESS=

06	6     (PROTOCOL=TCP)

07	7     (HOST=10.2.10.18)

08	8     (PORT=1525))

09	9    (CONNECT_DATA=

10	10     (SID=test10)))'

11

11  /

12

13	Database link created.

Now little check and cleanout:

view sourceprint?

01	system@TEST11> select * from v$version@testlink_db2;

02

03

BANNER

04	----------------------------------------------------------------

05	Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod

06	PL/SQL Release 10.2.0.4.0 - Production

07	CORE    10.2.0.4.0      Production

08	TNS for Linux: Version 10.2.0.4.0 - Production

09	NLSRTL Version 10.2.0.4.0 - Production

10

11	5 rows selected.

12

13	-- cleanout

14	system@TEST11> drop database link testlink_db2;

15

16	Database link dropped.