oracle 配置ipv6 访问数据库

随着ipv6的推广使用，在Oracle中如何配置IPv6，并且通过IPv6来访问到数据库？下面简单写些IPv6在Oracle中的配置。

• 一. 监听配置

• 二. 测试连接数据库

• 三.参考文档

一. 监听配置

（1）listener.ora 配置

PROD@localhost  oracle/app/oracle/product/11.2.0/network/admin$ cat listener.ora

LISTENER =
 (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
      (ADDRESS = (PROTOCOL=tcp)(HOST=2400:a480:f:413:116:255:249:39)(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

（2）重启监听，查看状态

PROD@localhost  home/oracle$ lsnrctl stop
PROD@localhost  home/oracle$ lsnrctl start
PROD@localhost  home/oracle$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-DEC-2017 08:25:35

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                22-DEC-2017 08:22:03
Uptime                    0 days 0 hr. 3 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   oracle/app/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File         oracle/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2400:a480:f:413:116:255:249:39)(PORT=1521)))    ---- 监听到ipv6地址
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

（3）配置tnsnames.ora

PROD@localhost  oracle/app/oracle/product/11.2.0/network/admin$ vi tnsnames.ora
MYDB_ipv6 =
 (DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL=tcp)(HOST=2400:a480:f:413:116:255:249:39)(PORT=1521))    # 使用IPv6
   )
   (CONNECT_DATA =
     (SERVICE_NAME = PROD)
   )
 )

MYDB_ipv4 =
 (DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = PROD)
   )
 )

（4）测试

PROD@localhost  oracle/app/oracle/product/11.2.0/network/admin$ tnsping MYDB_ipv6

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 22-DEC-2017 08:29:16

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:
/oracle/app/oracle/product/11.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL=tcp)(HOST=2400:a480:f:413:116:255:249:39)(PORT=1521))) (CONNECT_DATA = (SERVICE_NAME = PROD)))
OK (0 msec)

PROD@localhost  oracle/app/oracle/product/11.2.0/network/admin$ tnsping MYDB_ipv4

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 22-DEC-2017 08:29:22

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:
/oracle/app/oracle/product/11.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) (CONNECT_DATA = (SERVICE_NAME = PROD)))
OK (0 msec)

二. 测试连接数据库

PROD@localhost  oracle/app/oracle/product/11.2.0/network/admin$ sqlplus nolog

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 22 08:29:47 2017

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

SQL>
SQL> conn scott/tiger@MYDB_ipv6
Connected.
SQL>
SQL> conn scott/tiger@MYDB_ipv4
Connected.
SQL>

三.参考文档：

• Enabling IPv6 on Oracle Database Enterprise Edition (文档 ID 783570.1)
• How to Configure a Listener for Both IPv6 and IPv4 Addresses (文档 ID 2027612.1)
• linux 配置ipv6参考：http://91304808.wiz03.com/share/s/2hc4w80EoA4h2-6T620FeVOx0l4vTn2wUkb_2fImsd1A37oI