多实例监听的配置
创新互联建站服务项目包括大柴旦网站建设、大柴旦网站制作、大柴旦网页制作以及大柴旦网络营销策划等。多年来，我们专注于互联网行业，利用自身积累的技术优势、行业经验、深度合作伙伴关系等，向广大中小型企业、政府机构等提供互联网行业的解决方案，大柴旦网站推广取得了明显的社会效益与经济效益。目前，我们服务的客户以成都为中心已经辐射到大柴旦省份的部分城市，未来相信会继续扩大服务区域并继续获得客户的支持与信任！
三种情况：
1、一个监听在一个IP一个端口上监听多个实例
2、一个监听在一个IP不同端口上监听多个实例
3、多个监听监听多个实例
情况1：
listener.ora文件：
# listener.ora Network Configuration File: E:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. SID_LIST_ORCL = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (SID_NAME = ORCL) ) (SID_DESC = (GLOBAL_DBNAME = NHL) (SID_NAME = NHL) ) ) ORCL = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) )
tnsnames.ora文件：
# tnsnames.ora Network Configuration File: E:\app\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. NHL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NHL) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
情况2：
listener.ora文件：
# listener.ora Network Configuration File: E:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. SID_LIST_ORCL = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (SID_NAME = ORCL) ) (SID_DESC = (GLOBAL_DBNAME = NHL) (SID_NAME = NHL) ) ) ORCL = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1522)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) )
tnsnames.ora文件：
# tnsnames.ora Network Configuration File: E:\app\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. NHL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NHL) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
情况3：
listener.ora文件：
# listener.ora Network Configuration File: E:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. SID_LIST_ORCL = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (SID_NAME = ORCL) ) (SID_DESC = (GLOBAL_DBNAME = NHL) (SID_NAME = NHL) ) ) SID_LIST_TEST = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = TEST) (SID_NAME = TEST) ) ） ORCL = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1523)) )
tnsnames.ora文件：
# tnsnames.ora Network Configuration File: E:\app\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. NHL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NHL) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1523)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test) ) )
改完配置并启动。
