|
查看存储节点状态
[root@localhost ~]# cellcli CellCLI: Release 11.2.3.2.0 - Production on Mon Mar 16 16:52:31 CST 2015
Copyright (c) 2007, 2012, Oracle. All rights reserved.
Cell Efficiency Ratio: 2,169
CellCLI> list cell detail
name: localhost
bbuTempThreshold: 60
bbuChargeThreshold: 800
bmcType: absent
cellVersion: OSS_11.2.3.2.0_LINUX.X64_120713
cpuCount: 1
diagHistoryDays: 7
fanCount: 1/1
fanStatus: normal
flashCacheMode: WriteThrough
id: 029e8a73-bcc2-4759-bed1-c596778dbca8
interconnectCount: 1
iormBoost: 0.0
ipaddress1: 192.168.175.138/24
kernelVersion: 2.6.18-274.el5
makeModel: Fake hardware
metricHistoryDays: 7
offloadEfficiency: 2,168.6
powerCount: 1/1
powerStatus: normal
releaseVersion: 11.2.3.2.0
releaseTrackingBug: 14212264
status: online
temperatureReading: 0.0
temperatureStatus: normal
upTime: 0 days, 2:10
cellsrvStatus: running
msStatus: running
rsStatus: running
CellCLI>
CellCLI> list griddisk
date_CD_disk01_localhost active
date_CD_disk02_localhost active
date_CD_disk03_localhost active
date_CD_disk04_localhost active
date_CD_disk05_localhost active
date_CD_disk06_localhost active
CellCLI>
[grid@localhost ~]$ asmcmd
ASMCMD> lsdsk
Path
/dev/oracleasm/disks/VOL3
o/192.168.175.138/date_CD_disk04_localhost
o/192.168.175.138/date_CD_disk05_localhost
o/192.168.175.138/date_CD_disk06_localhost
ASMCMD>
查看计算节点状态，关闭影响的实例
[grid@localhost ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 16 19:37:46 2015
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 Automatic Storage Management option
SQL> select path from v$asm_disk;
PATH
--------------------------------------------------------------------------------
o/192.168.175.138/date_CD_disk01_localhost
o/192.168.175.138/date_CD_disk02_localhost
o/192.168.175.138/date_CD_disk03_localhost
/dev/oracleasm/disks/VOL3
o/192.168.175.138/date_CD_disk05_localhost
o/192.168.175.138/date_CD_disk04_localhost
o/192.168.175.138/date_CD_disk06_localhost
7 rows selected.
SQL>
SQL> select dg.name,a.value from v$asm_diskgroup dg, v$asm_attribute a
2 where dg.group_number=a.group_number and a.name='disk_repair_time';
NAME
------------------------------
VALUE
--------------------------------------------------------------------------------
DG00
3.6h
DG1
3.6h
SQL> shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL>
配置信任关系
[root@localhost ~]# dcli -g cell_group -l root 'hostname -i'
Address 192.168.175.138 maps to localhost, but this does not map back to the address - POSSIBLE BREAK-IN ATTEMPT!
192.168.175.138: 127.0.0.1
[root@localhost ~]#
ssh-keygen -t rsa
dcli -g cell_group -l root -k [root@localhost ~]# dcli -g cell_group -l root "cellcli -e alter cell shutdown services all"
Address 192.168.175.138 maps to localhost, but this does not map back to the address - POSSIBLE BREAK-IN ATTEMPT!
192.168.175.138:
192.168.175.138: Stopping the RS, CELLSRV, and MS services...
192.168.175.138: The SHUTDOWN of services was successful.
[root@localhost ~]# ps -ef|grep cell
root 5073 3218 0 15:00 pts/1 00:00:00 /bin/bash /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellcli
root 5081 5073 0 15: |