Oracle Dblink Creation

1 environment

Locally (win7) the database where the DB1 is logged on through SQL developer, and then Dblink is created on the DB1, allowing direct access to the corresponding table on DB2

DB1 machine: 10.196.9.72 "China intranet"

Tns:zh_testapp2= of DB1 (description= (address= (protocol=tcp) (host=10.196.9.72) (port=1521)) (Connect_data= (SERVICE_ Name=ebs) (Instance_name=ebs)))

DB2 machine: 103.46.128.47 "public network"

TNS:LISTENER_ORCL = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 103.46.128.47) (PORT = 29380)) (DB2)) (CO Nnect_data = (service_name = ORCL)))

Note: Because the local (Win7) is located in the DB1 intranet, so can log in DB1, and DB2 in the public network, so can also be directly logged on by the local client

2 Network

Note: The following operations are performed under the local (Win7) command window

1) Check the network problems to see if you can ping

cmd------Ping ip

2) Check to see if the DB2 firewall is not off

CMD-----tnsping IP Port

Oracle Dblink Creation