一:检查资源状态,是否online
(/u01/11.2.0.3/grid/bin/crsctl status resource –t
#crs_stat –t
#crs_stat –t –v
#crsctl status res –t 是第一条命令简写
PS:crs_ 即将废弃,用crsctl代替
)
eg:
[root@rac01 ~]# /u01/11.2.0.3/grid/bin/crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRSDG.dg
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.DATADG.dg
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.LISTENER.lsnr
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.asm
ONLINE ONLINE rac01 Started
ONLINE ONLINE rac02 Started
ora.gsd ---gsd没有开启这里offline正常
OFFLINE OFFLINE rac01
OFFLINE OFFLINE rac02
ora.net1.network
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.ons
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.registry.acfs
ONLINE ONLINE rac01
ONLINE ONLINE rac02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac02
ora.cvu
1 ONLINE ONLINE rac02
ora.oc4j
1 ONLINE ONLINE rac02
ora.rac01.vip
1 ONLINE ONLINE rac01
ora.rac02.vip
1 ONLINE ONLINE rac02
ora.racdb.db
1 ONLINE ONLINE rac01 Open
2 ONLINE ONLINE rac02 Open
ora.scan1.vip
1 ONLINE ONLINE rac02
二:检查ASM / listener / nodeapps
olsnodes –n ...查看有几个节点
srvctl status listener ...查看监听
srvctl status scan_listener ...查看scan监听
srvctl status asm –a
srvctl status nodeapps ...查看节点状态
srvctl status nodeapps -n rac01
...config... ...查看配置
...start... ...启动...
数据库中查看listener信息:
grid和oracle用户登入数据库查看
show parameter local_l
select instance_name,status from v$instance;
eg:
grid登入数据库
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.
168.1.222)(PORT=1521))))
remote_listener string
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
+ASM1 STARTED
[root@rac01 ~]# su - oracle
[oracle@rac01 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 6 11:15:06 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL>
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
racdb1 OPEN
[grid@rac01 ~]$ olsnodes -n
rac01 1
rac02 2
[grid@rac01 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac02,rac01
[grid@rac01 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac02
[grid@rac01 ~]$ srvctl status asm -a
ASM is running on rac02,rac01
ASM is enabled.
[grid@rac01 ~]$ srvctl status nodeapps
VIP rac01-vip is enabled
VIP rac01-vip is running on node: rac01
VIP rac02-vip is enabled
VIP rac02-vip is running on node: rac02
Network is enabled
Network is running on node: rac01
Network is running on node: rac02
GSD is disabled
GSD is not running on node: rac01
GSD is not running on node: rac02
ONS is enabled
ONS daemon is running on node: rac01
ONS daemon is running on node: rac02
[grid@rac01 ~]$ srvctl config asm -a
ASM home: /u01/11.2.0.3/grid
ASM listener: LISTENER
ASM is enabled.
[grid@rac01 ~]$ srvctl config listener
Name: LISTENER
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1521
[grid@rac01 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
[grid@rac01 ~]$ srvctl config scan
SCAN name: rac-scan, Network: 1/192.168.1.0/255.255.255.0/eth1
SCAN VIP name: scan1, IP: /rac-scan/192.168.1.225
[grid@rac01 ~]$ srvctl config nodeapps
Network exists: 1/192.168.1.0/255.255.255.0/eth1, type static
VIP exists: /rac01-vip/192.168.1.222/192.168.1.0/255.255.255.0/eth1, hosting node rac01
VIP exists: /rac02-vip/192.168.1.223/192.168.1.0/255.255.255.0/eth1, hosting node rac02
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
三:检查数据库状态和配置、实例数据库状态
srvctl status database -d racdb ---检查数据库状态
srvctl config database -d racdb –a ---查看数据库配置
srvctl status instance -d racdb -n rac01 ---检查数据库实例状态
srvctl status instance -d racdb -i racdb1 ---同上
eg:
[grid@rac01 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac01
Instance racdb2 is running on node rac02
[grid@rac01 ~]$ srvctl config database -d racdb -a
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0.3/db_1
Oracle user: oracle
Spfile: +DATADG/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups: DATADG
Mount point paths:
Services:
Type: RAC
Database is enabled
Database is administrator managed
[grid@rac01 ~]$ srvctl status instance -d racdb -n rac01
Instance racdb1 is running on node rac01
[grid@rac01 ~]$ srvctl status instance -d racdb -i racdb1
Instance racdb1 is running on node rac01
四:查看ora/ASM进程
ps -ef|grep ASM
ps –ef | grep ora_
eg:
[grid@rac01 ~]$ ps -ef | grep ora_
oracle 16984 1 0 01:19 ? 00:00:00 ora_pmon_racdb1
oracle 16988 1 0 01:19 ? 00:00:00 ora_psp0_racdb1
oracle 16992 1 0 01:19 ? 00:00:00 ora_vktm_racdb1
oracle 16998 1 0 01:19 ? 00:00:00 ora_gen0_racdb1
oracle 17002 1 0 01:19 ? 00:00:00 ora_diag_racdb1
oracle 17006 1 0 01:19 ? 00:00:00 ora_dbrm_racdb1
oracle 17010 1 0 01:19 ? 00:00:00 ora_ping_racdb1
oracle 17014 1 0 01:19 ? 00:00:00 ora_acms_racdb1
oracle 17018 1 0 01:19 ? 00:02:15 ora_dia0_racdb1
oracle 17022 1 0 01:19 ? 00:00:22 ora_lmon_racdb1
oracle 17026 1 0 01:19 ? 00:00:07 ora_lmd0_racdb1
oracle 17030 1 0 01:19 ? 00:00:04 ora_lms0_racdb1
oracle 17036 1 0 01:19 ? 00:00:00 ora_rms0_racdb1
oracle 17040 1 0 01:19 ? 00:00:00 ora_lmhb_racdb1
oracle 17044 1 0 01:19 ? 00:00:01 ora_mman_racdb1
oracle 17048 1 0 01:19 ? 00:00:00 ora_dbw0_racdb1
oracle 17052 1 0 01:19 ? 00:00:00 ora_lgwr_racdb1
oracle 17056 1 0 01:19 ? 00:00:05 ora_ckpt_racdb1
oracle 17060 1 0 01:19 ? 00:00:01 ora_smon_racdb1
oracle 17064 1 0 01:19 ? 00:00:00 ora_reco_racdb1
oracle 17068 1 0 01:19 ? 00:00:00 ora_rbal_racdb1
oracle 17072 1 0 01:19 ? 00:00:00 ora_asmb_racdb1
oracle 17076 1 0 01:19 ? 00:00:10 ora_mmon_racdb1
oracle 17080 1 0 01:19 ? 00:00:40 ora_mmnl_racdb1
oracle 17088 1 0 01:19 ? 00:00:00 ora_mark_racdb1
oracle 17107 1 0 01:19 ? 00:00:07 ora_lck0_racdb1
oracle 17111 1 0 01:19 ? 00:00:00 ora_rsmn_racdb1
oracle 17228 1 0 01:19 ? 00:00:00 ora_gtx0_racdb1
oracle 17232 1 0 01:19 ? 00:00:00 ora_rcbg_racdb1
oracle 17240 1 0 01:19 ? 00:00:00 ora_qmnc_racdb1
oracle 17284 1 0 01:19 ? 00:00:03 ora_cjq0_racdb1
oracle 17293 1 0 01:19 ? 00:00:00 ora_q000_racdb1
oracle 17337 1 0 01:20 ? 00:00:00 ora_gcr0_racdb1
oracle 17884 1 0 01:24 ? 00:00:00 ora_smco_racdb1
oracle 29329 1 0 10:25 ? 00:00:00 ora_w000_racdb1
oracle 29992 1 0 10:28 ? 00:00:00 ora_j000_racdb1
oracle 29996 1 0 10:28 ? 00:00:00 ora_j001_racdb1
grid 30031 27622 0 10:28 pts/1 00:00:00 grep ora_
oracle 32459 1 0 02:28 ? 00:00:00 ora_q002_racdb1
[grid@rac01 ~]$ ps -ef | grep ASM
grid 16472 1 0 01:18 ? 00:00:00 asm_pmon_+ASM1
grid 16476 1 0 01:18 ? 00:00:00 asm_psp0_+ASM1
grid 16481 1 0 01:18 ? 00:00:00 asm_vktm_+ASM1
grid 16487 1 0 01:18 ? 00:00:00 asm_gen0_+ASM1
grid 16491 1 0 01:18 ? 00:00:00 asm_diag_+ASM1
grid 16495 1 0 01:18 ? 00:00:00 asm_ping_+ASM1
grid 16499 1 0 01:18 ? 00:00:07 asm_dia0_+ASM1
grid 16503 1 0 01:18 ? 00:00:03 asm_lmon_+ASM1
grid 16507 1 0 01:18 ? 00:00:04 asm_lmd0_+ASM1
grid 16511 1 0 01:18 ? 00:00:00 asm_lms0_+ASM1
grid 16517 1 0 01:18 ? 00:00:00 asm_lmhb_+ASM1
grid 16521 1 0 01:18 ? 00:00:00 asm_mman_+ASM1
grid 16525 1 0 01:18 ? 00:00:00 asm_dbw0_+ASM1
grid 16529 1 0 01:18 ? 00:00:00 asm_lgwr_+ASM1
grid 16533 1 0 01:18 ? 00:00:00 asm_ckpt_+ASM1
grid 16537 1 0 01:18 ? 00:00:00 asm_smon_+ASM1
grid 16541 1 0 01:18 ? 00:00:03 asm_rbal_+ASM1
grid 16545 1 0 01:18 ? 00:00:00 asm_gmon_+ASM1
grid 16549 1 0 01:18 ? 00:00:00 asm_mmon_+ASM1
grid 16553 1 0 01:18 ? 00:00:00 asm_mmnl_+ASM1
grid 16559 1 0 01:18 ? 00:00:00 asm_lck0_+ASM1
grid 16565 1 0 01:18 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 16599 1 0 01:18 ? 00:00:00 oracle+ASM1_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 16603 1 0 01:18 ? 00:00:00 asm_asmb_+ASM1
grid 16607 1 0 01:18 ? 00:00:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 16794 1 0 01:18 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 16803 1 0 01:18 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 17082 1 0 01:19 ? 00:00:00 oracle+ASM1_asmb_racdb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 30271 27622 0 10:28 pts/1 00:00:00 grep ASM
五:查看监听器LISTENER
ps -ef | grep lsnr|grep -v 'grep'| grep -v 'ocfs'|awk '{print $9}'
eg:
[root@rac01 ~]# ps -ef | grep lsnr|grep -v 'grep'| grep -v 'ocfs'|awk '{print $9}'
LISTENER_SCAN1
LISTENER
六:检查OCR/ctss/CRS/css votedisk
ocrcheck ----查看集群注册表盘信息
crsctl check crs ----(包括OHAS、CRS、CSS、EVM)
crsctl check ctss/evm
#./crsctl start crs ----启动crs
crsctl query css votedisk ----查看表决磁盘(仲裁盘)信息
eg:
[root@rac01 ~]# /u01/11.2.0.3/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3016
Available space (kbytes) : 259104
ID : 733791620
Device/File Name : +CRSDG
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[grid@rac01 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@rac01 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 342cc748105e4f43bfbd883bda497bfb (ORCL:CRS_DISK01) [CRSDG]
Located 1 voting disk(s).
七:检查时间同步
cluvfy comp clocksync –verbose
eg:
[grid@rac01 ~]$ cluvfy comp clocksync -verbose
Verifying Clock Synchronization across the cluster nodes
Checking if Clusterware is installed on all nodes...
Check of Clusterware install passed
Checking if CTSS Resource is running on all nodes...
Check: CTSS Resource running on all nodes
Node Name Status
------------------------------------ ------------------------
rac01 passed
Result: CTSS resource check passed
Querying CTSS for time offset on all nodes...
Result: Query of CTSS for time offset passed
Check CTSS state started...
Check: CTSS state
Node Name State
------------------------------------ ------------------------
rac01 Observer
CTSS is in Observer state. Switching over to clock synchronization checks using NTP
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
The NTP configuration file "/etc/ntp.conf" is available on all nodes
NTP Configuration file check passed
Checking daemon liveness...
Check: Liveness for "ntpd"
Node Name Running?
------------------------------------ ------------------------
rac01 yes
Result: Liveness check passed for "ntpd"
Check for NTP daemon or service alive passed on all nodes
Checking NTP daemon command line for slewing option "-x"
Check: NTP daemon command line
Node Name Slewing Option Set?
------------------------------------ ------------------------
rac01 no
Result:
NTP daemon slewing option check failed on some nodes
PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "-x"
Result: Clock synchronization check using Network Time Protocol(NTP) failed
PRVF-9652 : Cluster Time Synchronization Services check failed
Verification of Clock Synchronization across the cluster nodes was unsuccessful on all the specified nodes.
八:检查SSH
rac01:
ssh rac02 date;date
ssh rac-scan date;date
ssh rac02-vip date;date
ssh rac02-priv date;date
rac02:
ssh rac01 date;date
ssh rac-scan date;date
ssh rac01-vip date;date
ssh rac01-priv date;date
九:查看节点VIP和scan ip
srvctl config nodeapps -----查看节点vip
srvctl config scan -----查看san ip
eg:
[grid@rac01 ~]$ srvctl config nodeapps
Network exists: 1/192.168.1.0/255.255.255.0/eth1, type static
VIP exists: /rac01-vip/192.168.1.222/192.168.1.0/255.255.255.0/eth1, hosting node rac01
VIP exists: /rac02-vip/192.168.1.223/192.168.1.0/255.255.255.0/eth1, hosting node rac02
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
[grid@rac01 ~]$ srvctl config scan
SCAN name: rac-scan, Network: 1/192.168.1.0/255.255.255.0/eth1
SCAN VIP name: scan1, IP: /rac-scan/192.168.1.225
十:查看磁盘、扫描磁盘、重启oracleasm服务
oracleasm listdisks ----查看磁盘
oracleasm scandisks ----用于扫描磁盘
#oracleasm init ----初始化磁盘
/etc/init.d/oracleasm restart ----重启oracleasm服务
eg:
[root@rac01 ~]# oracleasm listdisks
CRS_DISK01
CRS_DISK02
DATA_DISK01
DATA_DISK02
十一:查看监听状态和listener.ora/tnsnames.ora配置
[grid@rac01 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 06-JAN-2015 11:07:35
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 06-JAN-2015 01:19:02
Uptime 0 days 9 hr. 48 min. 33 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/11.2.0.3/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/rac01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.5)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.222)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "racdb" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac01 ~]$ cat /u01/11.2.0.3/grid/network/admin/listener.ora
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
[grid@rac01 ~]$ cat /u01/app/oracle/product/11.2.0.3/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.3/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RACDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521)) ###ps:连接数据库用scan ip
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)
ASM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(ORACLE_SID = +ASM1)
)
)
RMAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = RMAN_SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RMAN)
)
)
十二.查看集群名:
cemutlo -n
eg:
[grid@rac01 ~]$ cemutlo -n
rac-cluster
---end---