ORACLE 多实例监听的配置-CSDN博客

多实例监听的配置

三种情况：

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