一台服务器有两个实例gd和pc,gd为默认实例,现想使两个实例同时运行,请问如何配置监听和本地Net服务名配置
初识oracle,请说祥细点,谢谢
初识oracle,请说祥细点,谢谢
解决方案 »
- 控制文件损坏导致的ora-600 急,在线等
- 请教大家一个问题,在线等。谢谢了。!!!
- 能用一条SQL解决不?
- 有个很难搞的问题
- oracle data guard 配置tns/Listener??
- ▲如何解除外键约束(或其他的约束)
- 我已经快疯了:一个查询SQL语句在查询时只有一条记录,但放在函数中调试时总提示"ORA-01422: 实际返回的行数超出请求的行数"错误,详情内
- 关于C#连接Oracle的问题?高手请赐教
- 请专家帮忙解决一个小问题
- TO_DATE('2002-AUG-22','YYYY-MON-DD')为什么说月份不对?
- 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))
)
)