做城通网盘资源网站的源码,wordpress高亮插件,360建筑网app下载,做招商如何选择网站多实例监听的配置 三种情况#xff1a;
1、一个监听在一个IP一个端口上监听多个实例
2、一个监听在一个IP不同端口上监听多个实例
3、多个监听监听多个实例 情况1#xff1a;
listener.ora文件#xff1a;
# listener.ora Network Configuration File: E:\app\…多实例监听的配置 三种情况
1、一个监听在一个IP一个端口上监听多个实例
2、一个监听在一个IP不同端口上监听多个实例
3、多个监听监听多个实例 情况1
listener.ora文件
# listener.ora Network Configuration File: E:\app\product.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.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.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.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.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.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))) 改完配置并启动。
