aix

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:27+00:00

User management Account unlock chsec -f /etc/security/lastlog -a "unsuccessful_login_count=0" -s 'myuser' pwdadm -c /*Clear ADMCHG flag*/ Sendmail # show sendmail status lssrc -c sendmail startsrc -s sendmail -a "-bd -q30m" proctree 8196 ps -fk | grep wait vmstat -v 5505024 memory pages 5331905 lruable pages 41883 free pages 1 memory pools 1302902 pinned pages 80.0 maxpin percentage …

bash

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:23+00:00

Snippets of Shell code. Show every second line of a file awk 'NR % 2 == 0' filename for server in `cat server.list` do echo -e "Server: "$server ssh -T $server "iperf3 -s -D"; for client in `cat server.list` do echo -e "Client: "$client ssh -T $client <

cloudera_hadoop

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:27+00:00

Cloudera SCM Agent doesn't respect ulimits defined in /etc/security/limits.conf: sudo /etc/init.d/cloudera-scm-agent hard_stop # Edit parameter in /usr/sbin/cmf-agent script. sudo /etc/init.d/cloudera-scm-agent start

exadata

Anonymous (anonymous@undisclosed.example.com) — 2021-01-02T13:04:14+00:00

cellcli Show alerthistory for cell dcli -g cell_group -l root cellcli -e list alerthistory Show disk caching for griddisk disks dcli -g cell_group -l root cellcli -e list griddisk attributes name,cachingpolicy,cachedBy Disable caching of griddisk

ext4

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:29+00:00

The correct number of ext4-dio-unwrit processes on a server is one ext4-dio-unwrit process per CPU per ext4 filesystem.

flexera

Anonymous (anonymous@undisclosed.example.com) — 2021-04-23T07:45:00+00:00

While working through database log files looking for issues I came across numerous instances of the following error: 2019-11-07T03:57:00.623733+02:00 Errors in file /u01/app/oracle/admin/diag/rdbms/dev/dev1/trace/dev1_ora_8142.trc (incident=1313939): ORA-00603: ORACLE server session terminated by fatal error ORA-27515: inadequate memlock limit or driver settings Incident details in: /u01/app/oracle/admin/diag/rdbms/dev/dev1/incident/incdir_1313939/dev1_ora_8142_i1313939.trc

hp_storage_controller

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:23+00:00

hpssacli raid array commands Logical Drives hpssacli controller slot=0 ld all show status /* show status */ hpssacli controller slot=0 ld 5 modify reenable /* reenable logical drive */ hpssacli controller slot=0 ld 5 delete /* delete logical drive */ hpssacli ctrl slot=0 create type=ld drives=1I:1:8 raid=0 stripsize=1024 /* create RAID-0 ld using single disk */ hpssacli controller slot=0 ld 4 modify raid=1 /* change raid level on logical drive */

identify_and_add_failed_exadata_disks_back_into_asm

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:26+00:00

Add Failed Exadata ASM Disks back into ASM Identify the Failed Grid Disk # dcli -g cell_group -l root “cellcli -e list griddisk attributes name,asmmodestatus” | grep -v ‘ONLINE’ tuxcel06: DATA_CD_08_tuxcel06 UNKNOWN <<<< SQL> SELECT * FROM V$ASM_DISK where LABEL like ‘%DATA_CD_08_TUXCEL06%’ ORDER BY GROUP_NUMBER,DISK_NUMBER; ——————————————————————————————————————————– GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS MODE_ST TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB …

infinibork

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:23+00:00

This morning we receive an email from the ILOM of a Sun Oracle X3-2L server: The suspect component: /SYS/SP has defect.ilom.fs.full A full filesystem on an ILOM? Well I never... So I log into the ILOM to have a quick poke around, both on the CLI and web interface, but there's no directly accessible filesystem and shell to do any changes to the ILO 'filesystem' (without deep dropping into the ILOM's boot sector - but that's a write-up for another day) so I figure it's just some log file that is…

kvm

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:22+00:00

Convert OVA to KVM(qcow2) format tar -xvf image.ova gunzip *.gz qemu-img convert -O qcow2 image-disk1.vmdk image.qcow2 vi image.ovf /* edit metafile content */

linux

Anonymous (anonymous@undisclosed.example.com) — 2020-03-06T13:53:36+00:00

Memory Identify memory usage of TIME_WAIT sockets slabtop -o | grep -E '(^ OBJS|tw_sock_TCP|tcp_bind_bucket)' OBJS ACTIVE USE OBJ SIZE SLABS OBJ/SLAB CACHE SIZE NAME 13104 5813 44% 0.03K 117 112 468K tcp_bind_bucket 6900 6408 92% 0.19K 345 20 1380K tw_sock_TCP

lsi_logic_symbios_megaraid

Anonymous (anonymous@undisclosed.example.com) — 2020-01-22T08:57:52+00:00

Collect all diag info for controller into hostname tar /opt/MegaRAID/storcli/storcli64 -ShowSummary -aAll > ShowSummary.txt /opt/MegaRAID/storcli/storcli64 -AdpAllInfo -aALL > AdpAllInfo.txt /opt/MegaRAID/storcli/storcli64 -CfgDsply -aALL > CfgDsply.txt /opt/MegaRAID/storcli/storcli64 -PDList -aALL > PDList.txt /opt/MegaRAID/storcli/storcli64 -adpbbucmd -aALL > adpbbucmd.txt /opt/MegaRAID/storcli/storcli64 -FwTermLog -dsply -aALL > FwTermLog.txt /opt/MegaRAID/storcli/storcli64 -PhyErrorCounter…

netbackup

Anonymous (anonymous@undisclosed.example.com) — 2020-08-11T08:58:32+00:00

Custom scripts Disk performance benchmark /usr/openv/netbackup/bin/support/nbperfchk -i zero: -o ./nbperfchk.tmp -s 150g Drive down checker #!/bin/ksh #---------------------------------------------------------------------- # Check drives, bring drive up if down, email # If drives are up, do not create a report, runs from cron #---------------------------------------------------------------------- # Add interested parties below: alert_mail=mail@mydomain.co.za /usr/openv/volmgr/bin/vmoprcmd…

oracle

Anonymous (anonymous@undisclosed.example.com) — 2021-04-23T07:54:33+00:00

Oracle Database Size /* Get total size allocated */ select sum(bytes)/1024/1024 size_in_mb from dba_data_files; /* Get total space used */ select sum(bytes)/1024/1024 size_in_mb from dba_segments; /* Break down size usage by user */ select owner, sum(bytes)/1024/1024 Size_MB from dba_segments group by owner;

oracle_enterprise_linux

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:28+00:00

Installing Oracle UEK Infiniband Support #enable UEKR4 repository in repo file #enable OFED for UEKR4 repository in repo file yum -y remove 'ibacm*' 'ib-bonding*' 'ibutils*' 'infiniband-diags*' 'libibcm*' 'libibmad*' 'libibumad*' 'libibverbs*' 'libmlx4*' 'librdmacm*' 'libsdp*' 'mstflint*' 'ofed-docs*' 'ofed-scripts*' 'opensm*' 'perftest*' 'qperf*' 'sdpnetstat*' 'rdma-*' 'rds-tools*' yum clean all yum install oracle-ofed-release chkconfig rdma on

oracle_goldengate

Anonymous (anonymous@undisclosed.example.com) — 2021-04-23T07:57:55+00:00

Oracle GoldenGate Cache Memory Usage ./ggsci dblogin USERIDALIAS ggadmin SEND EXTRACT ext_mr CACHEMGR CACHESTATS SEND REPLICAT rep_file CACHEMGR CACHESTATS Statistics ./ggsci STATS REPLICAT rep_mr, TOTALSONLY *.*, REPORTRATE MIN STATS EXTRACT ext_mr, TOTALSONLY *.*, REPORTRATE MIN

oracle_ilom

Anonymous (anonymous@undisclosed.example.com) — 2020-01-23T08:33:43+00:00

Set alert emails from CLI ipmitool sunoem cli "set /SP/alertmgmt/rules/2 type=email destination=me@email.com level=critical" Showing faulted hardware ssh root@ilom - Default password: changeme # Show faultmgmt info --> show /SP/faultmgmt # Show faulty component --> show faulty # Show event log with errors --> show /SP/logs/event/list # Clear the hardware fault from the logs --> show /SP/logs/event/ clear=true # Clear the error. --> set /SYS/MB/CPU0 clear_fault_action=true # Show all …

postgresql

Anonymous (anonymous@undisclosed.example.com) — 2020-09-22T12:15:21+00:00

Installing PostgreSQL 12 UnixODBC Driver wget https://download.postgresql.org/pub/repos/yum/reporpms/EL-6-x86_64/pgdg-redhat-repo-latest.noarch.rpm rpm -i pgdg-redhat-repo-latest.noarch.rpm yum install unixODBC yum install postgresql12-odbc

powerpath

Anonymous (anonymous@undisclosed.example.com) — 2020-07-29T10:12:56+00:00

Non Destructive Upgrade For Powerpath 6.5 and higher export PP_NDU_ENABLE=1 rpm -Uvh DellEMCPower.LINUX-7.1.0.00.00-075.OL6.x86_64.rpm

python

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:30+00:00

Python Install Python 3.6 Software Collection $ sudo yum install rh-python36 $ scl enable rh-python36 bash PyPi Mirroring - Devpi Server $ mkdir /srv/www/devpi/ && mkdir /srv/www/devpi/data/ && cd /srv/www/devpi $ virtualenv env $ ./env/bin/pip install -q -U devpi-server $ devpi-server --port 4040 --serverdir ./data/ --gen-config $ cp gen-config/devpi.service /etc/systemd/system/. $ mkdir /etc/systemd/system/devpi.service.d $ cat </etc/systemd/system/devpi.service.d/custom.conf […

qlogic_fc_adapter

Anonymous (anonymous@undisclosed.example.com) — 2019-11-19T08:06:12+00:00

Replacing a disk in predictive failure safely # Identify disks with failures /opt/MegaRAID/storcli/storcli64 /c0/eALL/sALL show all | grep -e 'State :' -e "Predictive Failure Count" Drive /c0/e8/s24 State : Predictive Failure Count = 1 /opt/MegaRAID/storcli/storcli64 /c0 /eall /sall show # Set locate beacon for ease of replacement /opt/MegaRAID/storcli/storcli64 /c0/e8/s24 start locate # Set disk offline and spundown /opt/MegaRAID/storcli/storcli64 /c0/e8/s24 set offline /opt/MegaRAID/sto…

rac_node_grid_system_cpu

Anonymous (anonymous@undisclosed.example.com) — 2021-04-23T07:46:41+00:00

Oracle Gateway for msql showing high %system CPU usage for the "grid" user On one of our 3-node RAC Exadata systems, after configuring monitoring using Netdata, Prometheus and Grafana, I noticed that one of the nodes had a much higher CPU %System time than the other two nodes. This %system time was attributed to the Grid user.

recovery

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:24+00:00

rebuild initrd for all installed kernels rpm -qa | grep kernel | grep -v headers | grep -v tools | sed ’s/^kernel\-//g‘ | xargs -i dracut -v -f /boot/initramfs-{}.img {} rsync directories or partitions in backup or restore rsync -avP --numeric-ids --exclude='/dev' --exclude='/proc' --exclude='/sys' root@remote.ip.address:/remote/file/location /local/backup/destination/

sidebar

Anonymous (anonymous@undisclosed.example.com) — 2021-01-07T08:03:35+00:00

Operating Systems * Solaris * Linux * AIX * HPUX Database Servers * Oracle * MySQL * Postgresql Middleware * Oracle GoldenGate Big Data * Cloudera Hadoop Virtualization * KVM * VirtualBox Backup * Netbackup * ZFS Storage * PowerPath Appliances * Exadata Hardware * Oracle ILOM * HP Storage Controller * QLogic FC Adapter * LSI Logic/Symbios MegaRAID Coding * Bash * Vim * Python Rabbit holes

solaris

Anonymous (anonymous@undisclosed.example.com) — 2021-04-23T07:48:54+00:00

Networking Retrieve the ports used by a specific process with the pfiles command. pfiles `ptree | awk '{print $1}'` | egrep '^[0-9]|port:' Example output: 24168: ssh server2 sockname: AF_INET 10.0.0.1 port: 34820 peername: AF_INET 10.0.0.4 port: 22 4376: /usr/lib/ssh/sshd sockname: AF_INET 10.0.0.1 port: 22 peername: AF_INET 10.0.0.4 port: 57907 4377: /usr/lib/ssh/sshd sockname: AF_INET 10.0.0.1 port: 22 peername: AF_INET 10.0.0.4…

start

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:25+00:00

Shaun's Wiki I actually started this years ago, I just didn't know I did... :-) A collection of random stuff that seems important to remember and not always so easy to find.

tape_drives_from_hell

Anonymous (anonymous@undisclosed.example.com) — 2020-08-13T09:43:51+00:00

On master01, media02, media03, media04 and media5 servers we have 9 shared tape drives for the SLPs. Most of the time only 3 or 4 would be working. Every day I would start in the evening with 8 or 9 working tape drives and wake up in the morning to 2 or 3 working drives.

vim

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:29+00:00

VI I love vi :-D Display hidden characters :set list Conceal hidden characters :set nolist

virtualbox

Anonymous (anonymous@undisclosed.example.com) — 2021-01-07T08:06:13+00:00

Keyboard Auto-Repeat Consoles inside slow VMs often result in duplicate characters being displayed on typing. The solution is to run the following command: setterm -repeat off Place the command in your ~/.bashrc or similar to execute on login.

xfs

Anonymous (anonymous@undisclosed.example.com) — 2019-09-16T16:09:28+00:00

Mount by xfs Disk Labels xfs_admin -L "VideoRecords" /dev/sdb /etc/fstab: LABEL=VideoRecords /mountpoint .....

zfs

Anonymous (anonymous@undisclosed.example.com) — 2020-02-17T12:37:36+00:00

ZFS Tuning zfs set logbias=throughput zfs_pool_name/zfs_fs zfs set compression=lzjb zfs_pool_name/zfs_fs Testing echo "metaslab_unload_delay/D" | mdb -k echo "metaslab_unload_delay/W0t300" | mdb -kw Keep loaded metaslabs loaded for longer without unloading