using the easy connect naming method 简单连接测试

ゞ浴缸里的玫瑰 2022-08-05 02:45 61阅读 0赞

一直都不明白sqlnet.ora中的NAMES.DIRECTORY\_PATH= (TNSNAMES, EZCONNECT)是什么意思，今天看到一篇文档，就是登陆选用的方式，做一个测试：  
**tnsnames.ora **  
10.10.32.119 =  
  (DESCRIPTION =  
    (ADDRESS\_LIST =  
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.32.119)(PORT = 1521))  
    )  
    (CONNECT\_DATA =  
      (SERVICE\_NAME = orcl11g)  
    )  
  )  
    
**sqlnet.ora    
NAMES.DIRECTORY\_PATH= (TNSNAMES)  
C:\\Users\\Administrator>sqlplus test/test@10.10.32.119**  
SQL\*Plus: Release 11.2.0.1.0 Production on 星期二 6月 2 18:50:57 2015  
Copyright (c) 1982, 2010, Oracle.  All rights reserved.  
连接到:  
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options  
SQL> 从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开  
  
**C:\\Users\\Administrator>sqlplus test/test@10.10.32.119/orcl11g**  
SQL\*Plus: Release 11.2.0.1.0 Production on 星期二 6月 2 18:55:06 2015  
Copyright (c) 1982, 2010, Oracle.  All rights reserved.  
ERROR:  
ORA-12154: TNS: 无法解析指定的连接标识符  
请输入用户名:  
  
**sqlnet.ora    
NAMES.DIRECTORY\_PATH= (TNSNAMES)**  
**C:\\Users\\Administrator>sqlplus test/test@10.10.32.119**  
SQL\*Plus: Release 11.2.0.1.0 Production on 星期二 6月 2 18:56:47 2015  
Copyright (c) 1982, 2010, Oracle.  All rights reserved.  
ERROR:  
ORA-12504: TNS: 监听程序在 CONNECT\_DATA 中未获得 SERVICE\_NAME  
请输入用户名:  
  
**C:\\Users\\Administrator>sqlplus test/test@10.10.32.119/orcl11g**  
SQL\*Plus: Release 11.2.0.1.0 Production on 星期二 6月 2 18:57:03 2015  
Copyright (c) 1982, 2010, Oracle.  All rights reserved.  
连接到:  
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options