[root@erpcel03 ~]# cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome
DATA_ERP_CD_00_erpcel03 ONLINE Yes
DATA_ERP_CD_01_erpcel03 ONLINE Yes
DATA_ERP_CD_02_erpcel03 ONLINE Yes
RECO_ERP_CD_00_erpcel03ONLINE Yes
RECO_ERP_CD_01_erpcel03ONLINE Yes
RECO_ERP_CD_02_erpcel03ONLINE Yes
RECO_ERP_CD_03_erpcel03ONLINE Yes
RECO_ERP_CD_04_erpcel03ONLINE Yes
RECO_ERP_CD_05_erpcel03ONLINE Yes
[root@erpcel03 ~]#
[root@erpdb01 ~]# su - grid
[grid@erpdb01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 20 11:07:08 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> col path for a50
SQL> col name for a30
SQL> set linesize 200
SQL> select group_number,path,header_status,mount_status,mode_status,name from v$asm_disk;
GROUP_NUMBER PATH HEADER_STATU MOUNT_S MODE_ST NAME
------------ -------------------------------------------------- ------------ ------- ------- ------------------------------
2 o/192.168.10.5/DBFS_DG_CD_02_erpcel03 MEMBER CACHED ONLINE DBFS_DG_CD_02_ERPCEL03
3 o/192.168.10.5/RECO_ERP_CD_05_erpcel03 MEMBER CACHED ONLINE RECO_ERP_CD_05_ERPCEL03
1 o/192.168.10.5/DATA_ERP_CD_02_erpcel03 MEMBER CACHED ONLINE DATA_ERP_CD_02_ERPCEL03
3 o/192.168.10.5/RECO_ERP_CD_01_erpcel03 MEMBER CACHED ONLINE RECO_ERP_CD_01_ERPCEL03
48 rows selected.
SQL>
概述:
CellCLI是一体机存储管理工具,在某种程度上,每个 Exadata 单元中的操作系统和存储服务独立于所有其他 Exadata Storage Server 运行。与该自治相对应的是,每个单元都是单独管理的。使用 Exadata 单元命令行界面 (cell command-line interface, CellCLI) 可执行大多数管理功能。CellCLI 只能用来从某个单元中管理该单元。不过,通过 dcli 实用程序,您可以在多个单元上远程运行相同的 CellCLI 命令。
每个存储节点上的cellsrv 进程收集了有点存储节点及各个组件(如CPU,闪存模块,节点盘,网格盘,等等)的当前状态这类重要信息。管理服务(MS)进程接受这些存储节点指标,并每隔一个小时把这些存储节点指标写入到自动诊断信息存储库(ADR)中。
CellCli功能:
to start and stop the cell
to manage cell configuration information
to enable or disable cells
to manage objects in the cell environment
Cellcli命令预装在Oracle Exadata Storage Server,以下是cellcli描述:
如何开始一个CellCLI命令:
你可以远程或者直接用操作系统命令开始一个一个cellcli语句,语法如下:
cellcli [port_number] [-n] [-m] [-xml] [-v | -vv | -vvv] [-x] [-e command]port_number是指定执行命令的端口号,当然也可以不加,不加的话就使用
cellinit.ora
文件中的HTTP_PORT
值
/opt/oracle/cell12.1.1.1.2_LINUX.X64_150411/cellsrv/deploy/config/cellinit.ora
/opt/oracle/cell12.1.1.1.2_LINUX.X64_150511/cellsrv/deploy/config/cellinit.ora
[root@erpcel03 ~]# more /opt/oracle/cell12.1.1.1.2_LINUX.X64_150411/cellsrv/deploy/config/cellinit.ora
#CELL Initialization Parameters
version=0.0
HTTP_PORT=8888
bbuChargeThreshold=800
SSL_PORT=23943
RMI_PORT=23791
ipaddress1=192.168.10.5/22
bbuTempThreshold=60
DEPLOYED=TRUE
JMS_PORT=9127
BMC_SNMP_PORT=162
[root@erpcel03 ~]#
-v
, -vv
, and -vvv:设置日志输出的精细度,依次递增
-e:运行指定的CellCLI命令,命令运行完后退出cellcli
CellCLI没有登录参数或者连接命令,用系统认证,cellcli的默认目录是登录是的系统目录(spool或start)
理解CellCLI命令的语法和操作:
{admin-command | object-command object} [options] ;admin-command 是管理命令
ABORT | ACTIVE |
ACTIVEREQUEST | ALERTDEFINITION |
ALERTHISTORY | ALL |
ALTER | ASSIGN |
BBU | BMC |
CALIBRATE | CATPLAN |
CELL | CONFIGUREBMC |
CREATE | DBPLAN |
DESCRIBE | DETAIL |
DROP | EXPORT |
FLASHCACHE | FLASHCACHECONTENT |
FOR REPLACEMENT | FORCE |
GRIDDISK | IGNORE REDUNDANCY |
IMPORT | INACTIVE |
IORMPLAN | KEY |
LED | LIST |
LUN | MAIL |
MEMORY | METRICDEFINITION |
METRICCURRENT | METRICHISTORY |
MS | NULL |
OFF | ON |
PHYSICALDISK | PRIVILEGE |
REALM | RESTART |
RS | RULE |
SHUTDOWN | SNMP |
STARTUP | THRESHOLD |
USER | VALIDATE |
CellCLI命令的输入输出选项:
$ cellcli < command-script-in > results-out以上示例中command-script-in的命令结果会输出到results-out
CellCLI的管理命令:
The following CellCLI administration commands are described in this section:
注:每台 Exadata Storage Server 配置了三个操作系统用户:root、celladmin 和 cellmonitor。在使用 OneCommand 实用程序初始配置 Database Machine 之后,会为操作系统用户帐户设置初始密码。root 的默认初始密码为 welcome1。cellmonitor 和 celladmin 用户的默认初始密码为 welcome。建议在初始配置完成后将所有用户帐户的初始密码更改为更安全的密码。
1.root 用户:
编辑配置文件(如 cellinit.ora 和 cellip.ora)
更改网络配置设置
运行位于 /opt/oracle.SupportTools 目录下的支持和
诊断实用程序
运行 CellCLI CALIBRATE 命令
执行 celladmin 用户可以执行的所有任务
2.celladmin 用户: The celladmin
user should be used to run all services on the cell.
使用 CellCLI 实用程序执行管理任务(CREATE、DROP、ALTER,等等)
使用 adrci 实用程序为 Oracle 支持对事件进行打包
3.cellmonitor 用户:The cellmonitor
user is for monitoring purposes.
使用 CellCLI 实用程序只能查看 (LIST) Exadata 单元对象
The cellmonitor user can run the following commands:
-
DESCRIBE
-
EXIT
-
HELP
-
LIST
-
REMARK
-
SET
-
START
EXIT
HELP
QUIT
SET
sets parameter options in the CellCLI environment.
SET DATEFORMAT {LOCAL | STANDARD} SET ECHO [ON | OFF]
SET DATEFORMAT
控制显示日期的个格式. standard选项支持的local也支持,但standard对区域等不适很敏感
SET ECHO
决定是否执行一个脚本用@
或 START
.ON
选项会在屏幕上显示命令.OFF
选项不显示. SET ECHO
不会影响交互或者操作系统的命令显示.
SPOOL
这个是输出执行结果到指定文件,用法如下:SPO[OL] [file_name [ CRE[ATE] | REP[LACE] | APP[END] ] | OFF]
如果你只指定了file_name但没指定后面的选项,默认的是REP[LACE];
START and @
执行指定的cellcli脚本STA[RT] file_name @file_name
CellCLI 对象命令objects:
参考: http://write.blog.csdn.net/postedit?ref=toolbarCellCLI 对象类型Object Types:
LIST:
[root@erpcel03 ~]# cellcli
CellCLI: Release 12.1.1.1.2 - Production on Wed Jan 20 11:01:16 CST 2016
Copyright (c) 2007, 2013, Oracle. All rights reserved.
Cell Efficiency Ratio: 1,293
CellCLI> help list
Enter HELP LIST <object_type> for specific help syntax.
<object_type>: {ACTIVEREQUEST | ALERTHISTORY | ALERTDEFINITION | CELL
| CELLDISK | DATABASE | FLASHCACHE | FLASHLOG | FLASHCACHECONTENT
| GRIDDISK | IBPORT | IORMPLAN | KEY | LUN
| METRICCURRENT | METRICDEFINITION | METRICHISTORY
| PHYSICALDISK | QUARANTINE | THRESHOLD }
CellCLI>