总结下Oracle的network配置

一，listener:主要用于配置网络端口的，配置文件如下

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = unicode)
      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = unicode)
    )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-TUDVH1ULGJM)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-TUDVH1ULGJM)(PORT = 1522))
    )
  )

注意PORT端口就行

二，tnsname:相当于本库指向其它库的路标，配置如下

UNICODE_NEW =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-TUDVH1ULGJM)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = unicode)
    )
  )

说明:第一行是路标名，HOST可以是hostname也可以是IP，PORT是listener的端口号，service_NAME是库名

查看配置是否成功使用命令：tnsping 路标名