Linux
udev rules (for ASM) :
ENV{DM_VG_NAME}=="oradisksASM" ENV{DM_LV_NAME}=="DISK*" OWNER="oracle" GROUP="dba"
LVM :
lvdisplay --noheadings --units m -C -o Size /dev/db2vg/lv_RAW01
OpenSSL file encryption :
openssl aes-256-cbc -a -salt -in secrets.txt -out secrets.txt.enc
OpenSSL file decryption :
openssl aes-256-cbc -d -a -in secrets.txt.enc -out secrets.txt.new
Cluster
Install components [ALL NODES] :
yum -y install pcs pacemaker fence-agents-all
Set password of user hacluster [ALL NODES] :
passwd hacluster
Enable services [ALL NODES] :
systemctl start pcsd.service systemctl enable pcsd.service
Create authentication tokens [FROM PRIM. NODE] :
pcs cluster auth dbp04allx.unixguest.eu dbp26allx.unixguest.eu dbp05allx.unixguest.eu
Create cluster [FROM PRIM. NODE] :
pcs cluster setup --start --name HADR_ISM dbp04allx.unixguest.eu dbp26allx.unixguest.eu dbp05allx.unixguest.eu
Enable cluster services on boot [FROM PRIM. NODE] :
pcs cluster enable --all
List Services
You can list services in Linux as follows:
List services
[root@tain-cx-uatdb1 ~]# systemctl list-unit-files UNIT FILE STATE proc-sys-fs-binfmt_misc.automount static dev-hugepages.mount static dev-mqueue.mount static proc-fs-nfsd.mount static proc-sys-fs-binfmt_misc.mount static sys-fs-fuse-connections.mount static sys-kernel-config.mount static sys-kernel-debug.mount static tmp.mount disabled var-lib-nfs-rpc_pipefs.mount static brandbot.path enabled systemd-ask-password-console.path static systemd-ask-password-plymouth.path static systemd-ask-password-wall.path static session-1.scope static session-29975.scope static session-29979.scope static acpid.service enabled arp-ethers.service disabled auditd.service enabled auth-rpcgss-module.service static autofs.service disabled
Check process connections
We can check if a process is making connection from outside as follows:
Check process connections
[root@ag-se-tlcasdb1 ~]# lsof -i -a -p 4970 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME oracle 4970 oracle 16u IPv6 37827976 0t0 TCP ag-se-tlcasdb1.net.tain.com:ncube-lm->172.25.2.12:43612 (ESTABLISHED)
As we can see, that is very useful for oracle processes. When the connection HAS to create process also ON the local server.