====== 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: [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: [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.