剖析Oracle的网络结构轻松解决连接问题

listener.ora、sqlnet.ora、tnsnames.ora  
（注释：都放在$ORACLE_HOME\network\admin目录下）

sqlplus sys/oracle@orcl

SQLNET.AUTHENTICATION_SERVICES= (NTS) 
NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME)

NAMES.DIRECTORY_PATH= (TNSNAMES)

ORCL = 
  (DESCRIPTION = 
(ADDRESS_LIST = 
#下面是这个TNSNAME对应的主机，端口，协议 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) 
    ) 
(CONNECT_DATA =

#使用专用服务器模式去连接需要跟服务器的模式匹配，
如果没有就根据服务器的模式 
#自动调节 
(SERVER = DEDICATED) 
#对应service_name，SQLPLUS>;show parameter service_name; 
#进行查看 
      (SERVICE_NAME = orcl) 
    ) 
  ) 
#下面这个类似 
SALES = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.188.219)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = sales) 
    ) 
  ) 


#---------------------- 
客户端完了我们来看服务器端 
listener.ora------listener监听器进程的配置文件