Oracle RAC 验证以及Oracle 11G R2 启动与关闭

在前段时间已经安装完rac，那么安装完成后，要做的就是验证Rac是否是正确安装以及如何启动与关闭Rac。今天开始学习Rac，再次记录一下笔记！第一：验证RAC：验证监听：node 1：SQL> show parameter local_listenerNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string （ADDRESS=（PROTOCOL=TCP）（HOST=
192.168.4.114）（PORT=1521））
SQL> show parameter remote_listenerNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string rac-two-cluster-scan.grid.exam
ple.com:1521
SQL> node 2：SQL> show parameter local_listenerNAME TYPE VALUE
------------------------------------ ---------- ------------------------------
local_listener string （ADDRESS=（PROTOCOL=TCP）（HOST=
192.168.4.113）（PORT=1521））
SQL> show parameter remote_listenerNAME TYPE VALUE
------------------------------------ ---------- ------------------------------
remote_listener string rac-two-cluster-scan.grid.exam
ple.com:1521
SQL> ple.com:1521
SQL> ！lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-FEB-2014 20:54:52Copyright （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 successfullySQL>注： LOCAL_LISTENER

Property	Description
Parameter type	String
Syntax	`LOCAL_LISTENER =network_name`
Default value	`（ADDRESS = （PROTOCOL=TCP）（HOST=hostname）（PORT=1521））`where`hostname`is 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

Property	Description
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的监听参数。

安装MongoDB配置Replica SetMongoDB数据库设置初始化脚本相关资讯 Oracle 11g R2

CentOS 5.10安装Oracle 11G R2 （01月22日）
Oracle Linux 6.4安装Oracle 11g （12/04/2015 08:30:35）
Oracle 11g R2（GI）启动过程（10/10/2014 17:31:49）

Oracle Linux 5.5 （64bit）安装（12/04/2015 08:46:12）
在Red Hat Enterprise Linux 7.0 （01/05/2015 07:56:38）
CentOS 5.10 下静默安装Oracle 11g （10/10/2014 17:17:39）

本文评论查看全部评论（0）