Network Topology   «Prev 

Establishing Remote Connection in Oracle

The following images illustrate the flow between the client and the remote database in establishing a remote connection.

1) The SQL statement
select * from customer@rdb
specified rdb as a DATABASE LINK

2) The link name rdb is looked up in the Oracle dictionary DBA_DB_LINK table to get the remote USER ID, PASSWORD, and the TNS service name

3) The TNS service name is used as input to the tnsnames.ora.file. The tnsnames.ora file provides the PROTOCOL, the HOST_NAME, and the ORACLE_SID.

4) The HOST_NAME is used as input to the UNIX hosts file, where the IP_ADDRESS is collected.

5) The IP_ADDRESS, PROTOCOL, ORACLE_SID, USER_ID, PASSWORD are packaged and sent as a network packet to the remote Oracle listener