最近碰到一个古怪的问题，使用TNSNAMES适配器来连接数据库的时候，一样的net servie名，在Windows上连接成功，在Linux上连接失败，搞得挺惨的，原因就是IPv6两头有俩方括号，Windows上要，Linux上不要。
在Linux上，使用EZCONNECT适配器的话，是可以连接的，使用过TNSNAMES的话，报标题ORA-12545错误，提示主机无法识别。
<EZCONNECT适配器>
tnsping [2001:cf6:0:6d1:3:0:a2a2:1b1b]:1521/SID001
※[2001:cf6:0:6d1:3:0:a2a2:1b1b]是一个假想的IPv6地址
返回消息：
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-10月-2020 11:09:28
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/opt/oracle/product/11.2.0/client_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=SID001))(ADDRESS=(PROTOCOL=TCP)(HOST=2001:cf6:0:6d1:3:0:a2a2:1b1b)(PORT=1521)))
OK (10 msec)
<TNSNAMES适配器>
tnsping TEST001
返回消息：
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-10月-2020 10:37:11
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/opt/oracle/product/11.2.0/client_1/network/admin/sqlnet.ora
Used TNSNAMES Tadapter to resolve the alias Attempting to contact
(DESCRIPTION = (ADDRESS_LIST= (LOAD_BALANCE=on) (FAILOVER=on) (ADDRESS = (PROTOCOL = TCP)(HOST = [2001:cf6:0:6d1:3:0:a2a2:1b1b])(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SID001)))
TNS-12545: Connect failed because target host or object does not exist
<这是TNSNAMES.ora定义>
TEST001 =
(DESCRIPTION =
(ADDRESS_LIST=
(LOAD_BALANCE=on)
(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = [2001:cf6:0:6d1:3:0:a2a2:1b1b])(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID001)
)
)
问题就在这个红字儿的括号上面，Linux上不需要，所以Linux下删掉就可以了。Windows上需要，要加上。
如果你两个操作系统都用的时候，兴许你也会被绊个跟头，希望有帮助！