wgz7747147820的博客

exachk使用示例

exadata上无法归档的一个错误解决，原因是因为cellnode和compute node上的配置文件掩码不一致

cell nodes上的 opt oracle 文件系统没有足够空间时如何释放空间

disklist可以接受的几种格式普通linux cluster上1.整个disklist string 加单引号2.整个disklist加双引号3.不加引号4.单个磁盘加单引号5.单个磁盘加双引号asmca -silent -creatediskgroup -diskgroupname dg1 -disklist '/dev/asmdiskb4,/dev/asmdiskb5,/dev/asmdiskb6' -disksize 95300;asmca -silent -creatediskg

今天解决了一个exadata的cell node的cellsrv service无法启动的问题问题状况[root@slcm log]# date;cellcli -e 'alter cell startup services cellsrv'Sun Nov 7 11:48:06 MST 2021Starting CELLSRV services...The STARTUP of CELLSRV services was not successful.CELL-01547: CELLSRV

Infiniband网卡安装、使用总结https://blog.youkuaiyun.com/t1506376703/article/details/106911631

Exadata上flash卡的变迁http://www.cnxdug.org/?p=1385

查看计算节点能不能看到cell node上的磁盘，可以不安装GI就能看第一步，首先将grid的安装包拷贝到一个目录下，将之解压[crsusr@slcz01db04 bin]$ lsgrid_home.zip第二步 设置LD_LIBRARY_PATH和ORACLE_HOME[crsusr@slcz01db04 bin]$ export ORACLE_HOME=/u01/check_diskexport LD_LIBRARY_PATH=/u01/check_disk/lib第三步：检查看看

CellCLI> create flashlog all size=512mFlash log slcm05celadm01_FLASHLOG successfully createdCellCLI> create flashcache all;Flash cache slcm05celadm01_FLASHCACHE successfully created

[root@slcm05adm01 oracle.SupportTools]# ./CheckHWnFWProfile[SUCCESS] The hardware and firmware matches supported profile for server=SUN_FIRE_X4170_M3[root@slcm05adm01 oracle.SupportTools]# dmidecode -t 1 | grep Prod Product Name: SUN FIRE X4170 M3[root

https://blog.youkuaiyun.com/weixin_30242907/article/details/95527597?utm_medium=distribute.pc_relevant.none-task-blog-OPENSEARCH-4.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-OPENSEARCH-4.nonecase如何调整Exadata DB节点文件系统大小http://www.dbale

https://blog.youkuaiyun.com/itdba/article/details/43969075?utm_medium=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecaseE

在root.sh的log里发现了如下错误/u01/log/main1217_bak/crsdata/slcz01db03/crsconfig/rootcrs_slcz01db03_2019-12-25_00-58-17AM.log2019-12-25 01:01:55: ASM configuration failed with error 1, check asmca logs at /...

计算节点要想发现cellnode的磁盘，需要在计算节点配置两个文件，所有的计算节点都需要配置计算节点上的配置文件的子网掩码要和存储节点上的配置文件的子网掩码保持一致[root@slcz01db03 network-config]# pwd/etc/oracle/cell/network-configcellinit.ora里面记录计算节点的ip地址，和cellnode连接的infiniband 的ip地址，共四个或者8个不要都是ipaddress1，要分别为ipaddress1、2、3、4错

CellCLI> drop celldisk all force;CellDisk FD_00_slcc04cel07 successfully droppedCellDisk FD_01_slcc04cel07 successfully droppedCellDisk FD_02_slcc04cel07 successfully droppedCellDisk FD_03_slcc...

我这是测试环境，大家操作的时候一定要小心啊，CellCLI> alter cell restart services allStopping RS services...The SHUTDOWN of RS services was successful.Starting the RS services...Getting the state of RS services... ...

处于安全考虑，有些单位会禁止root访问或者ssh服务。在这种情况下就可以使用exacli来执行管理任务exacli与存储节点上MS进程的通讯使用HTTPS协议。首先需要在计算节点或者存储节点创建 role user等（cellcli或者dbmcli创建，不是操作系统用户）DBMCLI> create role r_wgz;Role r_wgz successfully creat...

CellCLI> list cell attributes hardDiskScrubFollowupIntervalInDays 7

默认情况下 cellnode的iormplan的objective为basic，表示minimally enabled，是默认值。如果需要启用iormplan，需要将其修改为其他值。在资源比较紧张的情况下，会有限保障share值高的io请求。单个数据库的share值可设置位1-32之间。CellCLI> alter iormplan objective=auto;IORMPLAN su...

CellCLI> create flashlog all size=512MFlash log slcc04cel07_FLASHLOG successfully createdCellCLI> list flashlog slcc04cel07_FLASHLOG normal

CellCLI> list cell detail ... flashCacheMode: WriteThrough ...CellCLI> drop flashcache;Flash cache slcc04cel07_FLASHCACHE successfully droppedCellCLI> alter cell flashcache...

可以cache在cell flash cache的对象类型（表 索引 分区 lob字段）SQL> select owner,table_name,cell_flash_cache from dba_tables where table_name='MY_OBJS';OWNER TABLE_NAME CELL_FL-------------------- -------...

SQL> create table my_objs_query_low compress for query low as select * from my_objs;Table created.SQL> create table my_objs_query_high compress for query high as select * from my_objs;Tabl...

参考https://docs.oracle.com/cd/E26926_01/html/E25884/gjwwf.html

计算节点上的地址bondib0: flags=5187<UP,BROADCAST,RUNNING,MASTER,MULTICAST> mtu 9000 inet 192.168.64.100 netmask 255.255.248.0 broadcast 192.168.71.255cellnode上的地址bondib0: flags=5187<U...

/opt/oracle.SupportTools/ibdiagtools# ./verify-topology -v [ DB Machine Infiniband Cabling Topology Verification Tool. ][INFO] All the switches on the fabric[INFO] Name :: slcc04sw-...

[root@slcc04sw-ib2 ~]# showunhealthyOK - No unhealthy sensors[root@slcc04sw-ib2 ~]# env_testEnvironment test started:Starting Environment Daemon test:Environment daemon runningEnvironment Daemo...

[root@slcc04sw-ib2 /]# ibqueryerrors.plErrors for 0x002128469562a0a0 "SUN DCS 36P QDR slcc04sw-ib2 10.242.64.214" GUID 0x002128469562a0a0 port 1: [XmtDiscards == 44] [RcvSwRelayErrors == 65535] ...

https://10.1.10.131/iPages/i_login.asp

CellCLI> create griddisk dwgz_CD_11_slcc04cel07 celldisk=CD_11_slcc04cel07, size=20G, virtualsize=200GCELL-02868: Failed to create sparse grid disk because sparse grid disk creation is not allowe...

CellCLI> list cell detail name: *** accessLevelPerm: remoteLoginEnabled bbuStatus: normal cellVersion: OSS_PT.EXANVM2_LINUX.X64_180806 cpu...

CellCLI> list alerthistory...137 2019-05-06T22:42:59-06:00 critical "ORA-700 [Offload issue job timed out] [Failed to find a package with matching versions] [CDB1] [196196] [slcz01db03.us....

升级Exadata的cell的image可以使用在线的方式进行也可以使用离线的方式进行，在线升级的好处是无需停止数据库服务，但是通常单个cell节点image升级的时间接近三个小时，如果一台满配的Exadata，升级完所有cell的image所需要花费的时间为14×3=52个小时，这还不包括检查，如果出现意外情况的troubleshooting的时间。实际上在线升级完一台满配的Exadata的ce...

CellCLI> alter cell shutdown services all;Stopping the RS, CELLSRV, and MS services...The SHUTDOWN of services was successful.

http://www.360doc.com/content/18/0626/22/40289485_765654441.shtml参考一下

创建griddiskCellCLI> create griddisk all harddisk prefix=dwgz,size=450gGridDisk dwgz_CD_00_slcc04cel08 successfully createdGridDisk dwgz_CD_01_slcc04cel08 successfully createdGridDisk dwgz_CD_02...

https://blog.youkuaiyun.com/lixora/article/details/8937586