Believe in yourself.

oracle11G 同时支持IPV4和IPV6配置

1、修改listener.ora文件

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.80.92)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = FEC0::3)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/oracle

2、修改tnsnames.ora文件

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.80.92)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = FEC0::3)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

3、重启监听

lsnrctl restart

4、用tnsping命令测试

 

posted @ 2018-11-26 16:37  eastonliu  阅读(4082)  评论(1编辑  收藏  举报