dincosman’s gists

dincosman / stopanddisable_crs_res.txt

Created March 6, 2022 21:44

Commands to stop and disable crs resource

	[oracle@bltdb01 ~]$ /u01/app/19/grid/bin/srvctl stop cvu
	[oracle@bltdb01 ~]$ /u01/app/19/grid/bin/srvctl disable cvu

dincosman / iostat.dat

Created March 6, 2022 22:00

Output of iostat command at problem time.

	zzz ***Tue Feb 22 13:28:17 +03 2022
	avg-cpu: %user %nice %system %iowait %steal %idle
	13.06 0.00 5.39 64.53 0.00 17.02

	Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util
	sda 7.00 0.00 912.00 6.00 62180.00 48.00 135.57 55.75 64.85 65.27 0.00 1.09 100.00
	sdb 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
	..
	dm-0 0.00 0.00 940.00 6.00 61092.00 48.00 129.26 54.33 60.48 60.87 0.00 1.06 100.00
	dm-1 0.00 0.00 1.00 0.00 4.00 0.00 8.00 0.00 0.00 0.00 0.00 0.00 0.00

dincosman / top_cpu_consumers.txt

Created March 6, 2022 22:06

Top cpu consumers at problem times.

	Tue Feb 22 13:24:52 EET 2022 28479 oracle 197.00 1/app/19/grid/jlib/jackson-databind.jar -DCV_DESTLOC=/tmp -DCV_HOME=/u01/app/19/grid -DRUNNING.MODE=cvuresource -DCV_LOG_LOCATION=/u01/app/oracle/crsdata/bltdb02/cvu/cvulog -DCV_PID_FILE=/u01/app/oracle/crsdata/bltdb02/cvu/init/cvu.pid -DCV_TRACELOC=/u01/app/oracle/crsdata/bltdb02/cvu/cvutrc -Xmx2048m oracle.ops.verification.client.CluvfyDriver comp healthcheck -mandatory -_format -_check_type partial
	...
	Tue Feb 22 13:27:22 EET 2022 8313 oracle 374.00 1/app/19/grid/OPatch/jlib/oracle.opatch.classpath.jar -DCV_HOME=/u01/app/19/grid -DGI_HOME=/u01/app/19/grid -DCV_TRACELOC=/u01/app/oracle/crsdata/bltdb02/cvu/cvutrc oracle.ops.verification.helper.helper19.CVUHelper19 -getOraclePatchList /u01/app/19/grid

dincosman / list_physicaldisk.txt

Created September 25, 2022 12:10

list physicaldisk command output

	CellCLI> list physicaldisk
	20:0 XXXXXX normal
	20:1 XXXXXX normal
	20:2 XXXXXX normal
	20:3 XXXXXX failed ---> Failed Disk
	20:4 XXXXXX normal
	20:5 XXXXXX normal
	20:6 XXXXXX normal
	20:7 XXXXXX import failure ---> Import Failure
	20:8 XXXXXX normal

dincosman / list_griddisk.txt

Last active October 7, 2023 06:29

list griddisk command output

	CellCLI> list griddisk attributes name,size,offset,asmdeactivationoutcome,status
	DATA_CD_00_exacel13 423G 32M Yes cacheContentLost
	DATA_CD_01_exacel13 423G 32M Yes active
	DATA_CD_02_exacel13 423G 32M Yes active
	DATA_CD_03_exacel13 423G 32M Yes not present
	DATA_CD_04_exacel13 423G 32M Yes active
	DATA_CD_05_exacel13 423G 32M Yes active
	DATA_CD_06_exacel13 423G 32M Yes active
	DATA_CD_07_exacel13 423G 32M Yes not present
	DATA_CD_08_exacel13 423G 32M Yes active

dincosman / drop&recreate_grid_disk_command.txt

Created September 25, 2022 16:34

Drop and recreate commans for grid disks.

	CellCLI> drop griddisk DATA_CD_00_exacel13
	CellCLI> drop griddisk RECO_CD_00_exacel13
	CellCLI> create griddisk DATA_CD_00_exacel13 CELLDISK=CD_00_exaybsmcel13,size=423G,offset=32M
	CellCLI> create griddisk RECO_CD_00_exacel13 CELLDISK=CD_00_exaybsmcel13,size=105.6875G,offset=423.046875G

	SYS@+ASM1> alter diskgroup DATA add disk 'o/192.168.31.21/DATA_CD_00_exacel13' rebalance power 10;
	SYS@+ASM1> alter diskgroup RECO add disk 'o/192.168.31.21/RECO_CD_00_exacel13' rebalance power 10;

	CellCLI> drop griddisk DATA_CD_11_exacel13
	CellCLI> drop griddisk RECO_CD_11_exacel13

dincosman / Megacli_check_commands.txt

Last active October 7, 2023 06:30

Megacli Harddisk configuration check commands

	[root@exacel13 trace]# /opt/MegaRAID/MegaCli/MegaCli64 -pdlist -a0 \|egrep 'Slot Number\|Firmware state'
	...
	Slot Number: 7
	Firmware state: Unconfigured(good), Spun Up
	...

dincosman / Clear_and_confraid.txt

Last active October 7, 2023 06:30

Commands to clear foreign state of harddisk and configuring raid 0.

	[root@exacel13 trace]# /opt/MegaRAID/MegaCli/MegaCli64 -CfgForeign -Clear -a0
	Foreign configuration 0 is cleared on controller 0.

	[root@exacel13 trace]# /opt/MegaRAID/MegaCli/MegaCli64 -CfgLdAdd -R0 [20:7] WB NORA Direct NoCachedBadBBU -strpsz1024 -a0
	Adapter 0: Created VD 14
	Adapter 0: Configured the Adapter!!

dincosman / Reenable_command.txt

Created September 25, 2022 17:59

Drop harddisk for replacement and reenable it.

	CellCLI> alter physicaldisk 20:7 drop for replacement
	Physical disk 20:7 was dropped for replacement.

	CellCLI> alter physicaldisk 20:7 reenable
	Physical disk 20:7 was reenabled.

dincosman / asm_startup_output.txt

Created September 27, 2022 13:45

Manaul asm startup and command output

	SYS@+ASM1> startup
	ASM instance started

	Total System Global Area 3213349952 bytes
	Fixed Size 8901696 bytes
	Variable Size 3170893824 bytes
	ASM Cache 33554432 bytes
	ORA-15032: not all alterations performed
	ORA-15040: diskgroup is incomplete
	ORA-15066: offlining disk "73" in group "DATA" may result in a data loss

Osman DINC dincosman