Oracle Net features

Oracle Net uses its own set of configuration files and processes to listen for and accept database connection requests. The process which listens for connect requests is the tnslsnr (Linux) or the OracleTNSListener service (Windows). Several listener processes may be configured on a system if required. The connect string used by an Oracle client to make a remote connection request uses a short alias to represent a larger collection of server connect information. This information is referred to as the connect descriptor. The following is an example of a connect descriptor on Linux: Copy test=(DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (COMMUNITY=IMANTCP) (PROTOCOL=TCP) (HOST=infosun32) (PORT=1521) ) ) (CONNECT_DATA= (SID=imandev) ) The following is an example of a connect descriptor on Windows: Copy test=(DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (COMMUNITY=TCP.world) (PROTOCOL=TCP) (HOST=infosun32) (PORT=1521) ) ) (CONNECT_DATA= (SID=test) ) ) test is the alias for this connect descriptor. Using the tcdba user as an example, the resulting connect string within Oracle would be: Copy tcdba/tcdba@test The community defined in the above descriptor indicates the group of nodes to which this system belongs. Communities are used by Oracle to indicate like groups of nodes for use with the Multi-Protocol Interchange, which allows nodes on different types of networks (for example, TCP/IP, SPX) to communicate.