ORACLE监听的问题 如果我的oracle有两个实例,但是我在net configuration assistant建立监听服务的时候,并没有提示这个监听指定的是哪个实例,所以我想知道,监听和服务的对应关系,希望能给出详细的回答(我已经知道监听是监听客户端的连接请求)。我想知道监听和服务之间的对应关系,以及如何给两个服务分别建立监听,谢谢了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 listens.ora配置:orcl1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE=on) (FAILOVER=on) (INBOUND_CONNECT_TIMEOUT_orcl=0) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.120.***)(PORT = 1521)) ) ) )SID_LIST_orcl1 = (SID_LIST = (SID_DESC = (GLOBAL_NAME = orcl1) (SID_NAME = orcl1) (ORACLE_HOME = /opt/ora10g/product/10.2.0/db_1) ) )orcl2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE=on) (FAILOVER=on) (INBOUND_CONNECT_TIMEOUT_orcl=0) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.120.***)(PORT = 1621)) ) ) )SID_LIST_orcl2 = (SID_LIST = (SID_DESC = (GLOBAL_NAME = orcl2) (SID_NAME = orcl2) (ORACLE_HOME = /opt/ora10g/product/10.2.0/db_1) ) ) 你好 我用oracle db assistance 建立数据库的时候并没有选项来指定oracle实例的端口号,那我怎么区分哪个实例的端口号是什么?还是两个都是1521 用oracle db assistance 建立数据库的时候默认的oracle实例的端口号就是1521,有那个选项 请教些不常用的语句,谢谢大家。 Oracle中外部表支持的类型有哪些 一個正則 问一天sql语句.在线等............ oracleagent启动失败。怎么办? 求救:安装ora9i(win2003)时不能创建数据库,提示"invalid END header format" 超级菜鸟问题:请问在oracle中,如何像sql server2000那样直观地看到自己建立的数据表? 请教spl查询语句 ORACLE启动问题? 插入大字段的问题,一百分相送!!!!在线等待。 求推荐一本ORACLE学习书籍 oracle的client,db到底怎么回事?
orcl1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=on)
(FAILOVER=on)
(INBOUND_CONNECT_TIMEOUT_orcl=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.120.***)(PORT = 1521))
)
)
)SID_LIST_orcl1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_NAME = orcl1)
(SID_NAME = orcl1)
(ORACLE_HOME = /opt/ora10g/product/10.2.0/db_1)
)
)orcl2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=on)
(FAILOVER=on)
(INBOUND_CONNECT_TIMEOUT_orcl=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.120.***)(PORT = 1621))
)
)
)SID_LIST_orcl2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_NAME = orcl2)
(SID_NAME = orcl2)
(ORACLE_HOME = /opt/ora10g/product/10.2.0/db_1)
)
)
你好 我用oracle db assistance 建立数据库的时候并没有选项来指定oracle实例的端口号,那我怎么区分哪个实例的端口号是什么?还是两个都是1521