Oracle Tnsnames.ora parameter meaning

Today in the local configuration of the Oracle client, once again need to link the service side of the LAN machine, the estimated need to configure the tnsnames.ora file, make a record, prevent the next use, once again search configuration method:

The following is a configured personal tnsnames.ora file content:

    

# Tnsnames.ora Network Configuration file:f:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora# Generated by Oracle configuration Tools. MES = (  DESCRIPTION = (    address_list = (      ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.6.6) (PORT = 1521    )) (Connect_data =      (service_name = ORCL)    )  )

The meanings of each of these parameters are as follows:

MES: That's your local name. Address: Server protocol: protocol used, here is TCP port: server's Listening port number service_name: Server service Name

Oracle Tnsnames.ora parameter meaning