檢查 RAC 狀態(tài)

$ srvctl config database -d rac
Database unique name: rac
Database name: rac
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: /u01/oradata/rac/spfilerac.ora
Domain: localdomain
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: rac
Database instances: rac1,rac2
Disk Groups: 
Services: 
Database is administrator managed
$
$ srvctl status database -d rac
Instance rac1 is running on node rac1
Instance rac2 is running on node rac2
$
V$ACTIVE_INSTANCES視圖還可以顯示當(dāng)前狀態(tài)的實(shí)例。
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 26 19:04:19 2009
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> SELECT inst_name FROM v$active_instances;
INST_NAME
--------------------------------------------------------------------------------
rac1.localdomain:rac1
rac2.localdomain:rac2
SQL>

檢查創(chuàng)建的數(shù)據(jù)庫(kù)

srvctl 工具可以顯示當(dāng)前的 RAC 數(shù)據(jù)庫(kù)配置和狀態(tài)。

顯示 AKA 群集數(shù)據(jù)庫(kù)的配置信息：

 oracle@RAC1> srvctl config database -d AKA

所有實(shí)例和服務(wù)的狀態(tài)：

  oracle@RAC1> srvctl status database -d AKA

某個(gè)特定節(jié)點(diǎn)上應(yīng)用程序狀態(tài)：

oracle@RAC1> srvctl status nodeapps -n gentic

顯示節(jié)點(diǎn)應(yīng)用程序配置信息（VIP，GSD，ONS，監(jiān)聽器）

 oracle@RAC1> srvctl config nodeapps -n gentic -a -g -s -l
VIP exists.: /gentic-vip/192.168.138.130/255.255.255.0/eth0
GSD exists.
ONS daemon exists.
Listener exists.

群集中運(yùn)行的所有實(shí)例：

 sqlplus system/manager@AKA1
SELECT inst_id,
instance_number,
instance_name,
parallel,
status,
database_status,
active_state,
host_name host
FROM gv$instance
ORDER BY inst_id;

視圖 V$ACTIVE_INSTANCES 也可以顯示當(dāng)前實(shí)例的狀態(tài)：

SELECT * FROM v$active_instances;

最后，GV$ 允許你顯示整個(gè) RAC 的全局信息：

SELECT inst_id, username, sid, serial#
FROM gv$session
WHERE username IS NOT NULL;

啟動(dòng)企業(yè)管理器控制臺(tái)

企業(yè)管理控制臺(tái)是整個(gè)群集共享的，在我們的例子中它在 https://rac1:1158/em 上監(jiān)聽。

http://wiki.jikexueyuan.com/project/oraclecluster/images/58.png" alt="" />