做网站视频图片加载不出来,沈阳百度推广哪家好,网站建设最重要的环节,佛山市品牌网站建设多少钱多实例监听的配置 三种情况#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))) 改完配置并启动。
