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

    今天是2014-02-19，在前段时间已经安装完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

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_LISTENER specifies a netw