远程的10g客户端无法通过Linux 上10g的监听连上10g数据库？

melonliu

在listener.ora的SID_LIST中加入
(SID_DESC =
  (GLOBAL_DBNAME = [I]GLOBAL_DBNAME(eg. test.melon.com)[/I] )
  (ORACLE_HOME = [I]ORACLE_HOME[/I] )
  (SID_NAME = [I]ORACLE_SID(eg. test)[/I])
)

所有本机地址改为本机IP

yyhll

直接将(HOST = 机器名)改为(HOST = IP地址)就可以了.

yyhll

又试了一下,虽然直接改IP可以用tnsping来测试监听,但还是无法连接数据库,又重新配了下listener.ora,这是配置的信息:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/product/10.1.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = U10)
      (ORACLE_HOME = /home/oracle/product/10.1.0)
      (SID_NAME = U10)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.45)(PORT = 1521))
      )
    )

yyhll

不过有个问题,当我的服务器配有不同网段的IP时,如何保证各个网段的客户端能够访问到数据库?

melonliu

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.45)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 另一个网段的IP)(PORT = 1521))
)
)

yyhll

虽然没试过,不过楼上提供的方法应该可以.

sdtols

修改/etc/hosts文件，其它什么都不用改。

lakher

netca重建LISTENER