Oracle数据库 监听配置

配置监听文件：C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN
需要修改的文件：listener和tnsnames

多台服务器一个端口号
listenner中：

listener.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\listener.ora

Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = “EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll”)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
(SID_NAME = ORCL)

)
  (SID_DESC =
  (GLOBAL_DBNAME = TESTD