using the easy connect naming method 簡單串連測試,connectnaming

來源:互聯網
上載者:User

using the easy connect naming method 簡單串連測試,connectnaming
  一直都不明白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



相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.