ORACLE 多实例监听的配置

多实例监听的配置

三种情况：

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)    )  )

改完配置并启动。