以Oracle Net看,数据库服务器可能也是客户端
因为tnsnames.ora可以有服务器的描述
也就是,只有监听器才会一直是服务器
实例:监听=n:m
㈠ 双监听器的好处:
① 客户端故障转移--CF
② 客户端负载均衡--CLB
㈡ 注意事项:
① 要保证1521端口可用,否则,OEM将不可用,须emca重配
② 非标端口使用静态注册是个比较好的实践
配置案例:
[oracle@localhost admin]$ cat listener.ora
think =
(DESCRIPTION =
(load_balance = on)
(failover = on)
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL = tcp)(HOST= 192.168.1.113)(PORT= 1521)
(ADDRESS=(PROTOCOL = tcp)(HOST= 192.168.1.113)(PORT= 1522)
)
)
)
SID_LIST_think =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = emrep.us.oracle.com)
(SID_NAME = emrep)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)))
water =
(DESCRIPTION =
(load_balance = on)
(failover = on)
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL = tcp)(HOST= 192.168.1.113)(PORT= 1521))
(ADDRESS=(PROTOCOL = tcp)(HOST= 192.168.1.113)(PORT= 1522))
)
)
)
SID_LIST_water =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = emrep.us.oracle.com)
(SID_NAME = emrep)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)))
[oracle@localhost admin]$ lsnrctl status water
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2012 21:47:22
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(load_balance=on)(failover=on)(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 10-DEC-2012 20:02:23
Uptime 0 days 1 hr. 44 min. 58 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "emrep.us.oracle.com" has 1 instance(s).
Instance "emrep", status READY, has 1 handler(s) for this service...
Service "emrep_XPT.us.oracle.com" has 1 instance(s).
Instance "emrep", status READY, has 1 handler(s) for this service...
The command completed successfully
如果1521和1522并存,在业务不繁忙时,listener进程只会使用1521
[oracle@localhost admin]$ lsnrctl status water
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2012 21:48:45
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(load_balance=on)(failover=on)(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias water
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 10-DEC-2012 21:24:17
Uptime 0 days 0 hr. 24 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/water.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=1522)))
Services Summary...
Service "emrep.us.oracle.com" has 1 instance(s).
Instance "emrep", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
㈢ 测试
① tnsping
[oracle@localhost admin]$ tnsping water
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2012 21:53:13
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS=(PROTOCOL= tcp)(HOST= 192.168.1.113)(PORT= 1522)) (CONNECT_DATA=(SERVICE_NAME= emrep.us.oracle.com)))
OK (10 msec)
② netstat
[oracle@localhost admin]$ netstat -lntp| grep :15
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 8524/tnslsnr
tcp 0 0 192.168.1.113:1522 0.0.0.0:* LISTEN 9826/tnslsnr
③ conn
sys@EMREP> conn u1/u1@water
Connected.
分享到:
相关推荐
6.2.2 SCAN监听器 6.2.3 SCAN解析 6.2.4 SCAN兼容性配置 6.2.5动态注册与负载均衡 6.2.6 SCAN配置信息 6.2.7 SCAN VIP与节点VIP 6.2.8 CLUSTER_INTERCONNECTS参数 6.2.9 HAIP高可用性内联接 6.3 Service资源...
说明 : 指定共享服务器的监听程序配置。监听程序进程需要一个监听地址, 以便处理系统所用的各个网络协议的连接请求。 除非 MTS_MULTIPLE_LISTENERS=TRUE, 否则每个条目都必须有一个独立的相邻值。此参数自 8.1.3 版...
linux下启动数据库监听的命令: lsnrctl start; "select id from s_emp where name = '"+name+"'"; table s_user( id , name, age) class User{ } //分别使用Statement对象和PreparedStatement对象实现 public ...
{13.3}连接Oracle数据库及操作}{192}{section.13.3} {13.4}批处理模式}{195}{section.13.4} {13.5}分页查询}{196}{section.13.5} {13.5.1}MySQL}{198}{subsection.13.5.1} {13.6}连接池}{199}{section.13.6} {...
Java生成密钥、保存密钥的实例源码,通过本源码可以了解到Java如何产生单钥加密的密钥(myKey)、产生双钥的密钥对(keyPair)、如何保存公钥的字节数组、保存私钥到文件privateKey.dat、如何用Java对象序列化保存私钥...
Java生成密钥、保存密钥的实例源码,通过本源码可以了解到Java如何产生单钥加密的密钥(myKey)、产生双钥的密钥对(keyPair)、如何保存公钥的字节数组、保存私钥到文件privateKey.dat、如何用Java对象序列化保存私钥...
13.2.3 实现窗口类——通过双缓冲技术 13.3 知识点扩展——画图的基础知识 13.3.1 画图的基础知识 13.3.2 各种类型对象的绘制 13.4 小结 第14章 指针时钟项目(Swing组件+时间算法) 14.1 指针时钟原理 14.1.1 项目...