Wednesday, January 23, 2019

Increase tmpfs filesystem space on linux

Increase tmpfs filesystem space  on linux


run time increase using below command:-

mount -t tmpfs tmpfs -o size=3g /dev/shm




[root@rac1 ctssd]# cat /etc/fstab

#
# /etc/fstab
# Created by anaconda on Tue Nov 27 15:48:22 2018
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/vg_rac1-lv_root /                       ext4    defaults        1 1
UUID=1b52ef29-f02f-48e3-9908-6ed29c02ce5a /boot                   ext4    defaults        1 2
/dev/mapper/vg_rac1-lv_home /home                   ext4    defaults        1 2
/dev/mapper/vg_rac1-lv_swap swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults,size=3G        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
[root@rac1 ctssd]#



Need reboot



[root@rac1 ctssd]# df -h
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/vg_rac1-lv_root   50G   34G   14G  71% /
tmpfs                        3.0G  1.1G  2.0G  37% /dev/shm
/dev/sda1                    477M   56M  397M  13% /boot
/dev/mapper/vg_rac1-lv_home   26G   47M   24G   1% /home
[root@rac1 ctssd]#

[root@rac1 ctssd]#

Thursday, January 17, 2019

UDEV SCSI Rules Configuration In Oracle Linux 6


UDEV SCSI Rules Configuration In Oracle Linux 6 




[root@rac1 ~]# ls /dev/sd*
/dev/sda  /dev/sda1  /dev/sda2  /dev/sdb  /dev/sdc  /dev/sdd  /dev/sdd1
[root@rac1 ~]#



[root@rac1 dev]# /sbin/scsi_id -g -u -d /dev/sdb
1ATA_VBOX_HARDDISK_VB6673148e-70a3b8f4
[root@rac1 dev]# /sbin/scsi_id -g -u -d /dev/sdc
1ATA_VBOX_HARDDISK_VBc778fc49-01bbefbb
[root@rac1 dev]#
[root@rac1 ~]# /sbin/scsi_id -g -u -d /dev/sdd
1ATA_VBOX_HARDDISK_VBf8c61d16-a391798e
[root@rac1 ~]#


/sbin/scsi_id -g -u -d /dev/sdd

[root@rac2 dev]#
[root@rac2 dev]# /sbin/scsi_id -g -u -d /dev/sdb
1ATA_VBOX_HARDDISK_VB6673148e-70a3b8f4
[root@rac2 dev]# /sbin/scsi_id -g -u -d /dev/sdc
1ATA_VBOX_HARDDISK_VBc778fc49-01bbefbb
[root@rac2 dev]#
[root@rac2 ~]# /sbin/scsi_id -g -u -d /dev/sdd
1ATA_VBOX_HARDDISK_VBf8c61d16-a391798e
[root@rac2 ~]#




/etc/udev/rules.d/99-oracle-asmdevices.rules

For Oracle Linux 6


KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB6673148e-70a3b8f4", NAME="DISK1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBc778fc49-01bbefbb", NAME="DISK2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBf8c61d16-a391798e", NAME="DISK3", OWNER="grid", GROUP="asmadmin", MODE="0660"


/sbin/udevadm test /block/sdb/sdb1

/sbin/udevadm test /block/sdc/sdc1

/sbin/udevadm test /block/sdd/sdd1





https://oracle-base.com/articles/linux/udev-scsi-rules-configuration-in-oracle-linux

CRS-4404: The following nodes did not reply within the allotted time


CRS-4404: The following nodes did not reply within the allotted time



[grid@rac1 bin]$ ./crsctl check cluster -all
**************************************************************
rac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
CRS-4404: The following nodes did not reply within the allotted time:
rac2


After reboot second node ,  again ran same command its working fine .


[grid@rac1 bin]$ ./crsctl check cluster -all
**************************************************************
rac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@rac1 bin]$

Complex Oracle 19c to PostgreSQL 15 Database Migration

Production-oriented migration approach for a complex Oracle 19c to PostgreSQL 15 workload , covering assessment, schema and code conversion,...