多实例多监听如何配置 一台服务器有两个实例gd和pc,gd为默认实例,现想使两个实例同时运行,请问如何配置监听和本地Net服务名配置初识oracle,请说祥细点,谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我试过了,一个为1521,一个为1522,但在本地net服务名配置时,总是有一个不通 LISTENER_YPTK = (ADDRESS = (PROTOCOL = TCP)(HOST = csea-xiao)(PORT = 1521))DTBJ = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.7.58)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME =DTBJ) ) )YPCOST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = ypcost) ) )LISTENER_YPCOST = (ADDRESS = (PROTOCOL = TCP)(HOST = csea-xiao)(PORT = 1522))YPTK = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME =yptk) ) ) 同一机器多个实例其实只需要配置动态监听器就行了,使用相同的端口号是可以的。实例的服务将是动态注册的,并且客户端可以同时连接!listener.ora内容如下:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.32.191.101)(PORT = 1521)) ) ) 为什么我的物化视图经常失效? proc中查询oracle库提示ORA-01036: illegal name/number 请各位大侠帮忙解决一下,oracle数据库打开成功,但是关闭失败 如何将执行动态sql选出来的数据通过游标返回 我想返回存储过程的结果集 谁有ORACLE816从安装到配置的培训文件,不胜感激!! sql文 哪位知道oracle9i数据库中drsys表空间是做什么用的?谢谢 数据库转换,急,在线等!!! 请问Oracle 8i和9i如何卸载???谢谢! Oracle-索引问题-如何确定小数据量的表 安装完express后SQL Plus出现乱码咋办呀?急
(ADDRESS = (PROTOCOL = TCP)(HOST = csea-xiao)(PORT = 1521))DTBJ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.7.58)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =DTBJ)
)
)
YPCOST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ypcost)
)
)LISTENER_YPCOST =
(ADDRESS = (PROTOCOL = TCP)(HOST = csea-xiao)(PORT = 1522))
YPTK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME =yptk)
)
)
实例的服务将是动态注册的,并且客户端可以同时连接!
listener.ora内容如下:LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.32.191.101)(PORT = 1521))
)
)