oracle数据库服务器 多监听端口

[list=1]
[*] [b]第一种方法 通过服务器端应用程序配置 打开 Net Manager[/b]
[img]http://dl2.iteye.com/upload/attachment/0091/2969/592b1b7a-c2fa-3569-a8eb-1c3ad7634a89.png[/img]

☆ [b]那个为什么要填写 “计算机名”[/b]

[*] [b]第二种方法 在listener.ora 文件里配置[/b]

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.62)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    ###################################################################
    ### 配置新的端口
    ###################################################################
   (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-A9RDKSKKVET)(PORT = 1522))
    )
  )

[*] [b]远程pl/sql客户端的连接,由于我这里使用的是免安装的oracle客户端，所以只能直接去配置文件里配置 在 tnsnames.ora 文件里[/b]

net_1522 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

☆ 上文中 xxx.xxx.xxx.xxx 代表要连接的远程服务器的ip地址
[/list]