VIP 如何才能正确使用？

Talmud · 发表于 2006-6-13 12:04

# listener.ora.grid2 Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora.grid2
# Generated by Oracle configuration tools.

LISTENER_GRID2 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
#    (ADDRESS = (PROTOCOL = TCP)(HOST = grid2-vip)(PORT = 1521)(IP = FIRST))
#    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.203.42)(PORT = 1521)(IP = FIRST))
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)(IP = FIRST))
)
  )

SID_LIST_LISTENER_GRID2 =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
   (PROGRAM = extproc)
)
  )
这样修改了在10.2.0.1中测试通过。
biti上面有提到了这种方法。

请问biti10.2.0.2中有什么不同，为什么这种方法不行了呢。我没有
10.2.0.2的环境。

biti_rainy · 发表于 2006-6-13 12:32

最初由 Talmud 发布
[B]# listener.ora.grid2 Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora.grid2
# Generated by Oracle configuration tools.

LISTENER_GRID2 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
#    (ADDRESS = (PROTOCOL = TCP)(HOST = grid2-vip)(PORT = 1521)(IP = FIRST))
#    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.203.42)(PORT = 1521)(IP = FIRST))
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)(IP = FIRST))
)
  )

SID_LIST_LISTENER_GRID2 =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
   (PROGRAM = extproc)
)
  )
这样修改了在10.2.0.1中测试通过。
biti上面有提到了这种方法。

请问biti10.2.0.2中有什么不同，为什么这种方法不行了呢。我没有
10.2.0.2的环境。 [/B]

可能是oracle 基于安全的考虑而如此处理的

9i从 oracle 9.2.0.6 开始，10g 是 10.2.0.2 ，都无法通过localhost 对本地所有地址进行监听。这个问题同事说在metalink有说明，但我没亲自去查过。看起来早先都是可以通过localhost来对所有地址监听的，然后到某个时期出的版本就禁止了。