[20190306]Disabled EZCONNECT.txt

https://connor-mcdonald.com/2019/03/06/disabled-ezconnect/

--//链接里面提到:

NAMES.DIRECTORY_PATH= (TNSNAMES)

In such a scenario, you need to explicitly allow for EZCONNECT method to allow the connection to work.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

--//在以上的情况下,必须显示的加入EZCONNECT.但是

If you have never touched your sqlnet.ora, it probably looks like this:

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

but there is no need to panic. Those default values allow EZCONNECT as well.

--//测试看看:

1.环境:

SCOTT@book> @ ver1

PORT_STRING                    VERSION        BANNER

------------------------------ -------------- --------------------------------------------------------------------------------

x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.测试:

--//我客户端机器安装有12cR2(windows 64bit).

--//修改sqlnet.ora如下:

NAMES.DIRECTORY_PATH= (TNSNAMES)

--//测试EZCONNECT:

R:\>sqlplus -l scott/book@192.168.100.78:1521/book

SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 8 09:03:06 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

--//如果修改sqlnet.ora如下:

NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

R:\>sqlplus -l scott/book@192.168.100.78:1521/book

SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 8 09:03:46 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SCOTT@192.168.100.78:1521/book>

--//成功连上!!

3.如果修改如下:

--//修改sqlnet.ora如下:

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

R:\>sqlplus -l scott/book@192.168.100.78:1521/book

SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 8 09:05:59 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

4.我测试各种情况:

NAMES.DIRECTORY_PATH= (TNSNAMES)           =>失败

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)   =>失败

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME) =>成功

NAMES.DIRECTORY_PATH= (HOSTNAME)           =>成功

--//视乎只要存在HOSTNAME,EZCONNECT就可以通过.有时候想想oracle设计太奇怪了.