Oracle Network

1-oracle network file
2-location of network file
3-Tool to configure oracle network
4-Database link
5-dba_db_links
6-Testing Oracle Net Connectivity
-------------------

1-oracle network file

oracle network files:
listener.ora,tnsnames.ora,sqlnet.ora
1-listener.ora -->store network infor for server side (it is at server)
2-tnsnames.ora -->store network infor for client side (it is at client)
tns-->transparent Names Substrate
3-sqlnet.ora   -->store network infor for client side (it is at client)

when client connect to server
1-it uses sqlnet.ora to validate user name
2-use tnsnames.ora to send the connection request
3-use listner.ora to recieve the connection request

2-location of network file
<oracle_home>/network/admin

3-Tool to configure oracle network

•Enterprise Manager Net Services Administration page

•Oracle Net Manager

•Oracle Net Configuration Assistant

•Command line

 4-Database link

5-Show database link
select * from dba_db_links;
 

 6-Testing Oracle Net Connectivity

tnsping db.us.oracle.com:1521/dba11g

tnsping orcl