OracleRAC验证以及Oracle11GR2启动与关闭
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了OracleRAC验证以及Oracle11GR2启动与关闭,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3669字,纯文字阅读大概需要6分钟。
内容图文
![OracleRAC验证以及Oracle11GR2启动与关闭](/upload/InfoBanner/zyjiaocheng/547/4c6fc4d9db5c409d8dd56ddfc62ab37c.jpg)
在前段时间已经安装完rac,那么安装完成后,要做的就是验证Rac是否是正确安装以及如何启动与关闭Rac。今天开始学习Rac,再次记录
在前段时间已经安装完rac,那么安装完成后,,要做的就是验证Rac是否是正确安装以及如何启动与关闭Rac。今天开始学习Rac,再次记录一下笔记!
第一:验证RAC:
验证监听:
node 1:
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.4.114)(PORT=1521))
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string rac-two-cluster-scan.grid.exam
ple.com:1521
SQL>
node 2:
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.4.113)(PORT=1521))
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
remote_listener string rac-two-cluster-scan.grid.exam
ple.com:1521
SQL>
ple.com:1521
SQL> !lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-FEB-2014 20:54:52
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 19-FEB-2014 20:03:17
Uptime 0 days 0 hr. 51 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/rac-one/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.111)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.113)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "Rac" has 1 instance(s).
Instance "Rac2", status READY, has 1 handler(s) for this service...
Service "RacXDB" has 1 instance(s).
Instance "Rac2", status READY, has 1 handler(s) for this service...
The command completed successfully
SQL>
注:
LOCAL_LISTENER
PropertyDescription
Parameter type String
Syntax LOCAL_LISTENER =network_name
Default value (ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521))wherehostnameis the network name of the local host.
Modifiable ALTER SYSTEM
Basic No
LOCAL_LISTENERspecifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are running on the same machine as this instance). The address or address list is specified in theTNSNAMES.ORAfile or other address repository as configured for your system.
REMOTE_LISTENER
PropertyDescription
Parameter type String
Syntax REMOTE_LISTENER =network_name
Default value There is no default value.
Modifiable ALTER SYSTEM
Basic Yes
REMOTE_LISTENERspecifies a network name that resolves to an address or address list of Oracle Net remote listeners (that is, listeners that are not running on the same machine as this instance). The address or address list is specified in theTNSNAMES.ORAfile or other address repository as configured for your system.
也就是说:local_listener是单主机服务器本地监听,remote_listener是oracle网络远程监听器也就是scan vip的监听参数。
内容总结
以上是互联网集市为您收集整理的OracleRAC验证以及Oracle11GR2启动与关闭全部内容,希望文章能够帮你解决OracleRAC验证以及Oracle11GR2启动与关闭所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。