Oracle RAC 驗證以及Oracle 11G R2 啟動與關閉

在前段時間已經安裝完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))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

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的監聽參數。

1 2 下一頁