Showing posts with label Linux. Show all posts
Showing posts with label Linux. Show all posts

Tuesday, February 25, 2020

Sunday, August 28, 2016

How to calculate the SHMALL and SHMMAX Value for Oracle.

SHMALL – is the maximum total amount of shared memory pages
SHMMAX – is the maximum size in bytes of a single shared memory segment

Total RAM: 15GB

calculate SHMALL as follows in case of 15GB RAM:

TOTAL RAM IN BYTES / PAGE_SIZE

echo "15 * 1024^3 / 4096" | bc

The calculation of SHMMAX, is as follows in case of 15GB RAM:

HALF OF TOTAL RAM IN BYTES

echo "15 * 1024^3 / 2" | bc


[root@sbldcdb01 ~]# echo "15 * 1024^3 / 4096" | bc
3932160
[root@sbldcdb01 ~]#
[root@sbldcdb01 ~]# echo "15 * 1024^3 / 2" | bc
8053063680

Thursday, May 12, 2016

WARNING: You are trying to use the MEMORY_TARGET feature.

WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 6442450944 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 4067700736 and used is 127700992 bytes. Ensure that the mount point is /dev/shm for this directory.
memory_target needs larger /dev/shm.

You can also face the following error.

ORA-00845: MEMORY_TARGET not supported on this system

Cause: This warning show cause of when we are trying to use Automatic Memory Management feature in Unix/Linux system the tmpfs should be big enough to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values.

Solution : Increase the tmpfs size.

1.
cp /etc/rc.d/rc.sysinit /etc/rc.d/rc.sysinit.orig

vi /etc/rc.d/rc.sysinit

edite this existing line and add new one from the file of /etc/rc.d/rc.sysinit

        #mount -f /dev/shm >/dev/null 2>&1
        mount /dev/shm >/dev/null 2>&1

2.
cp /etc/rc.local /etc/rc.local.orig
vi /etc/rc.local

Add the following line in the end of /etc/rc.local file.

mount -o remount tmpfs

3.
cp /etc/fstab /etc/fstab.orig

vi /etc/fstab

edite this existing line and add new one from the file of /etc/fstab

#tmpfs                   /dev/shm                tmpfs   defaults        0 0
tmpfs   /dev/shm        tmpfs   size=8g 0 0

4. Now check your system.

[root@sbdbdr01 ~]# df -k /dev/shm
Filesystem           1K-blocks      Used Available Use% Mounted on
tmpfs                  8388608    381216   8007392   5% /dev/shm

Log
-------------


[root@sbdbdr01 ~]# cp /etc/rc.d/rc.sysinit /etc/rc.d/rc.sysinit.orig
[root@sbdbdr01 ~]# vi /etc/rc.d/rc.sysinit
[root@sbdbdr01 ~]# cat /etc/rc.d/rc.sysinit
        mount -f /
        mount -f /proc >/dev/null 2>&1
        mount -f /sys >/dev/null 2>&1
        mount -f /dev/pts >/dev/null 2>&1
        #mount -f /dev/shm >/dev/null 2>&1
mount /dev/shm >/dev/null 2>&1
        mount -f /proc/bus/usb >/dev/null 2>&1
[root@sbdbdr01 ~]# cp /etc/rc.local /etc/rc.local.orig
[root@sbdbdr01 ~]# cat /etc/rc.local
#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local
[root@sbdbdr01 ~]# vi /etc/rc.local
[root@sbdbdr01 ~]# cat /etc/rc.local
#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local
mount -o remount tmpfs
[root@sbdbdr01 ~]# cp /etc/fstab /etc/fstab.orig
[root@sbdbdr01 ~]# cat /etc/fstab

#
# /etc/fstab
# Created by anaconda on Mon May  9 16:34:50 2016
#
# 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
#
UUID=3f2c16d3-6add-4a4d-89a2-824bd6090239 /                       ext4    defaults        1 1
UUID=4af12c05-0f8a-4082-bbeb-55d9e77931c3 /tmp                    ext4    defaults        1 2
UUID=2469b10b-3673-4b9b-8fcb-7d1465db42e9 swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
/dev/sdb1 /u01                   ext4    defaults        1 2
[root@sbdbdr01 ~]#
[root@sbdbdr01 ~]# vi /etc/fstab
[root@sbdbdr01 ~]# cat /etc/fstab
#
# /etc/fstab
# Created by anaconda on Mon May  9 16:34:50 2016
#
# 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
#
UUID=3f2c16d3-6add-4a4d-89a2-824bd6090239 /                       ext4    defaults        1 1
UUID=4af12c05-0f8a-4082-bbeb-55d9e77931c3 /tmp                    ext4    defaults        1 2
UUID=2469b10b-3673-4b9b-8fcb-7d1465db42e9 swap                    swap    defaults        0 0
#tmpfs                   /dev/shm                tmpfs   defaults        0 0
tmpfs   /dev/shm        tmpfs   size=8g 0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
/dev/sdb1 /u01                   ext4    defaults        1 2
[root@sbdbdr01 ~]# mount -o remount tmpfs
[root@sbdbdr01 ~]#
[root@sbdbdr01 ~]# df -k /dev/shm
Filesystem           1K-blocks      Used Available Use% Mounted on
tmpfs                  8388608    381216   8007392   5% /dev/shm
[root@sbdbdr01 ~]#
[root@sbdbdr01 ~]# reboot

Broadcast message from root@sbdbdr01
        (/dev/pts/0) at 12:33 ...

The system is going down for reboot NOW!
[root@sbdbdr01 ~]#

Monday, May 9, 2016

How to add mount point in Redhat Linux

[root@sbdbdr01 ~]# fdisk -l | grep '^Disk'
Disk /dev/sda: 42.9 GB, 42949672960 bytes
Disk identifier: 0x00021498
Disk /dev/sdb: 51.5 GB, 51539607552 bytes
Disk identifier: 0x0003bf53
Disk /dev/sdc: 51.5 GB, 51539607552 bytes
Disk identifier: 0x00056c3c
Disk /dev/sdd: 51.5 GB, 51539607552 bytes
Disk identifier: 0x000c3727
Disk /dev/sdf: 51.5 GB, 51539607552 bytes
Disk identifier: 0x000a83f6
Disk /dev/sde: 51.5 GB, 51539607552 bytes
Disk identifier: 0x000de7f7
Disk /dev/sdh: 24.7 GB, 24696061952 bytes
Disk identifier: 0x000a9203
Disk /dev/sdi: 24.7 GB, 24696061952 bytes
Disk identifier: 0x000c3e2d
Disk /dev/sdg: 51.5 GB, 51539607552 bytes
Disk identifier: 0x00006616
Disk /dev/sdj: 24.7 GB, 24696061952 bytes
Disk identifier: 0x000de89e
Disk /dev/sdk: 24.7 GB, 24696061952 bytes
Disk identifier: 0x00005510
Disk /dev/sdl: 24.7 GB, 24696061952 bytes
Disk identifier: 0x00071fbd
Disk /dev/sdm: 24.7 GB, 24696061952 bytes
Disk identifier: 0x0008e468
[root@sbdbdr01 ~]# fdisk /dev/sdb

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to
         sectors (command 'u').

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4):
Value out of range.
Partition number (1-4): 1
First cylinder (1-6266, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-6266, default 6266):
Using default value 6266

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@sbdbdr01 ~]#
[root@sbdbdr01 ~]# mkfs.ext4 /dev/sdb1
mke2fs 1.41.12 (17-May-2010)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
3145728 inodes, 12582903 blocks
629145 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
384 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
        32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
        4096000, 7962624, 11239424

Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 32 mounts or
180 days, whichever comes first.  Use tune2fs -c or -i to override.
[root@sbdbdr01 ~]# mkdir /u01
[root@sbdbdr01 ~]#
[root@sbdbdr01 ~]# mount /dev/sdb1 /u01
[root@sbdbdr01 ~]# cat /etc/fstab

#
# /etc/fstab
# Created by anaconda on Mon May  9 16:34:50 2016
#
# 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
#
UUID=3f2c16d3-6add-4a4d-89a2-824bd6090239 /                       ext4    defaults        1 1
UUID=4af12c05-0f8a-4082-bbeb-55d9e77931c3 /tmp                    ext4    defaults        1 2
UUID=2469b10b-3673-4b9b-8fcb-7d1465db42e9 swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults        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@sbdbdr01 ~]#
[root@sbdbdr01 u01]# vi /etc/fstab
[root@sbdbdr01 u01]#
[root@sbdbdr01 u01]# cat /etc/fstab

#
# /etc/fstab
# Created by anaconda on Mon May  9 16:34:50 2016
#
# 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
#
UUID=3f2c16d3-6add-4a4d-89a2-824bd6090239 /                       ext4    defaults        1 1
UUID=4af12c05-0f8a-4082-bbeb-55d9e77931c3 /tmp                    ext4    defaults        1 2
UUID=2469b10b-3673-4b9b-8fcb-7d1465db42e9 swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
/dev/sdb1 /u01                   ext4    defaults        1 2

Friday, September 18, 2015

How to Mount New Mount Point In Linux

[root@OEL64N2 ~]# mount -t ext4 /dev/sdb1 /u02
mount: wrong fs type, bad option, bad superblock on /dev/sdb1,
       missing codepage or helper program, or other error
       In some cases useful info is found in syslog - try
       dmesg | tail  or so

[root@OEL64N2 ~]#
[root@OEL64N2 ~]#
[root@OEL64N2 ~]# df -H
Filesystem             Size   Used  Avail Use% Mounted on
/dev/sda5               11G   3.3G   6.9G  33% /
tmpfs                  1.2G    91k   1.2G   1% /dev/shm
/dev/sda2              4.3G   143M   3.9G   4% /tmp
/dev/sda1               13G    12G   345k 100% /u01
[root@OEL64N2 ~]#
[root@OEL64N2 ~]#
[root@OEL64N2 ~]#
[root@OEL64N2 ~]#  mkfs.ext3 /dev/sdb1 2>/dev/null
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
1638400 inodes, 6552504 blocks
327625 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
200 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
        32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
        4096000

Writing inode tables: done
Creating journal (32768 blocks):
done
Writing superblocks and filesystem accounting information:
done

This filesystem will be automatically checked every 30 mounts or
180 days, whichever comes first.  Use tune2fs -c or -i to override.
[root@OEL64N2 ~]#
[root@OEL64N2 ~]#
[root@OEL64N2 ~]#
[root@OEL64N2 ~]#  mount -t ext4 /dev/sdb1 /u02
[root@OEL64N2 ~]#
[root@OEL64N2 ~]# df -H
Filesystem             Size   Used  Avail Use% Mounted on
/dev/sda5               11G   3.3G   6.9G  33% /
tmpfs                  1.2G    91k   1.2G   1% /dev/shm
/dev/sda2              4.3G   143M   3.9G   4% /tmp
/dev/sda1               13G    12G   345k 100% /u01
/dev/sdb1               27G   181M    25G   1% /u02
[root@OEL64N2 ~]#

Friday, August 14, 2015

ORA-00845: MEMORY_TARGET not supported on this system

Cause : This error comes up because of  Automatic Memory Management (AMM) feature of Oracle 11g R2 seems that shared memory file system (shmfs) is not big enough.

Solution : Increase the size of that file system by issuing the following command.

mount -t tmpfs shmfs -o size=12g /dev/shm

[oracle@OEL64N2 workshops]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 15 01:04:51 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
Disconnected
[oracle@OEL64N2 workshops]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda5             9.9G  3.1G  6.4G  33% /
tmpfs                 1.2G  695M  434M  62% /dev/shm
/dev/sda2             4.0G  139M  3.7G   4% /tmp
/dev/sda1              12G  6.4G  4.9G  57% /u01
[oracle@OEL64N2 workshops]$ mount -t tmpfs shmfs -o size=12g /dev/shm
mount: only root can do that
[oracle@OEL64N2 workshops]$ su root
Password:
[root@OEL64N2 workshops]#
[root@OEL64N2 workshops]#
[root@OEL64N2 workshops]# mount -t tmpfs shmfs -o size=12g /dev/shm
[root@OEL64N2 workshops]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda5             9.9G  3.1G  6.4G  33% /
tmpfs                  12G     0   12G   0% /dev/shm
/dev/sda2             4.0G  139M  3.7G   4% /tmp
/dev/sda1              12G  6.4G  4.9G  57% /u01
shmfs                  12G     0   12G   0% /dev/shm
[root@OEL64N2 workshops]# su oracle
[oracle@OEL64N2 workshops]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 15 01:08:30 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area  835104768 bytes
Fixed Size                  2232960 bytes
Variable Size             805309824 bytes
Database Buffers           25165824 bytes
Redo Buffers                2396160 bytes
Database mounted.
Database opened.
SQL>

Thursday, May 28, 2015

Instantiating disk: failed

Cause :

1. Shell Linux Not Disabled.
2. ASM is not loaded.

Action :

1. Ensure your SELINUX=disabled from vi /etc/selinux/config.

2. Perform the following ..

[root@OEL5RACN2 ~]# oracleasm createdisk CRS_FILES_01 /dev/sdb1
Writing disk header: done
Instantiating disk: failed
Clearing disk header: done
[root@OEL5RACN2 ~]# oracleasm status
Checking if ASM is loaded: no
Checking if /dev/oracleasm is mounted: no

Reboot your System.

[root@OEL5RACN1 ~]# oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes
[root@OEL5RACN1 ~]# oracleasm createdisk CRS_FILES_01 /dev/sdb1
Writing disk header: done
Instantiating disk: done

[root@OEL5RACN1 ~]#

Sunday, August 3, 2014

Copy file to another host using Linux/Unix System.

$ pwd
/u01/SBS_REP
$ scp -r /u01/SBS_REP/* root@10.11.201.200:/u02/SBS/
The authenticity of host '10.11.201.200 (10.11.201.200)' can't be established.
RSA key fingerprint is 59:3e:a0:5f:17:3d:61:fc:fb:30:6a:91:71:57:0f:d3.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '10.11.201.200' (RSA) to the list of known hosts.
root@10.40.40.41's password:
1040_SBS-2_03082014105501.txt                                                                                                         100% 1455KB   1.4MB/s   00:00
1057_SBS-2_03082014105507.txt                                                                                                         100% 1313KB   1.3MB/s   00:00
1107_SBS-2_03082014105513.txt                                                                                                         100% 1623KB   1.6MB/s   00:00
1123_SBS-2_03082014105519.txt                                                                                                         100% 1688KB   1.7MB/s   00:00
1164_SBS-2_03082014105526.txt                                                                                                         100% 1633KB   1.6MB/s   00:00
1172_SBS-2_03082014105533.txt                                                                                                         100% 1477KB   1.4MB/s   00:00
1206_SBS-2_03082014105539.txt                                                                                                         100% 3731KB   3.6MB/s   00:00
1214_SBS-2_03082014105550.txt                                                                                                         100% 2330KB   2.3MB/s   00:00
1230_SBS-2_03082014105558.txt                                                                                                         100% 1082KB   1.1MB/s   00:00
1297_SBS-2_03082014105604.txt                                                                                                         100% 3902KB   3.8MB/s   00:00
1305_SBS-2_03082014105616.txt                                                                                                         100% 1282KB   1.3MB/s   00:00
16014_SBS-2_03082014105622.txt                                                                                                        100% 1321KB   1.3MB/s   00:00
16048_SBS-2_03082014105628.txt                                                                                                        100% 2414KB   2.4MB/s   00:00
16071_SBS-2_03082014105636.txt                                                                                                        100% 1612KB   1.6MB/s   00:00
16121_SBS-2_03082014105642.txt                                                                                                        100% 1732KB   1.7MB/s   00:00
16162_SBS-2_03082014105650.txt                                                                                                        100% 3786KB   3.7MB/s   00:01
16204_SBS-2_03082014105701.txt                                                                                                        100% 5304KB   5.2MB/s   00:00
16212_SBS-2_03082014105716.txt                                                                                                        100% 1225KB   1.2MB/s   00:00
16220_SBS-2_03082014105722.txt                                                                                                        100% 1895KB   1.9MB/s   00:00
16238_SBS-2_03082014105729.txt                                                                                                        100% 2078KB   2.0MB/s   00:00
16295_SBS-2_03082014105737.txt                                                                                                        100% 2149KB   2.1MB/s   00:00
16345_SBS-2_03082014105744.txt                                                                                                        100% 1562KB   1.5MB/s   00:00
16352_SBS-2_03082014105750.txt                                                                                                        100% 2504KB   2.5MB/s   00:00
44107_SBS-2_03082014105759.txt                                                                                                        100% 3611KB   3.5MB/s   00:00
44123_SBS-2_03082014105810.txt                                                                                                        100% 3597KB   3.5MB/s   00:00
44164_SBS-2_03082014105821.txt                                                                                                        100% 4605KB   4.5MB/s   00:01
44206_SBS-2_03082014105835.txt                                                                                                        100% 7741KB   7.6MB/s   00:00
44297_SBS-2_03082014105857.txt                                                                                                        100% 3663KB   3.6MB/s   00:00
44321_SBS-2_03082014105908.txt                                                                                                        100% 2144KB   2.1MB/s   00:00
44347_SBS-2_03082014105916.txt                                                                                                        100%  819KB 819.3KB/s   00:00
44396_SBS-2_03082014105920.txt                                                                                                        100% 3769KB   3.7MB/s   00:00
44412_SBS-2_03082014105932.txt                                                                                                        100% 1417KB   1.4MB/s   00:00
55020_SBS-2_03082014105937.txt                                                                                                        100%  500KB 499.9KB/s   00:00
55046_SBS-2_03082014105941.txt                                                                                                        100%  385KB 385.0KB/s   00:00
55079_SBS-2_03082014105945.txt                                                                                                        100% 2402KB   2.4MB/s   00:00
55087_SBS-2_03082014105953.txt                                                                                                        100% 3373KB   3.3MB/s   00:00
55194_SBS-2_03082014110003.txt                                                                                                        100%  493KB 492.8KB/s   00:00
55202_SBS-2_03082014110007.txt                                                                                                        100% 1721KB   1.7MB/s   00:00
55228_SBS-2_03082014110013.txt                                                                                                        100%  988KB 987.6KB/s   00:00
55236_SBS-2_03082014110018.txt                                                                                                        100% 1306KB   1.3MB/s   00:00
55244_SBS-2_03082014110024.txt                                                                                                        100%  727KB 727.3KB/s   00:00
55319_SBS-2_03082014110028.txt                                                                                                        100%  939KB 938.8KB/s   00:00
55343_SBS-2_03082014110033.txt                                                                                                        100% 1468KB   1.4MB/s   00:00
55376_SBS-2_03082014110039.txt                                                                                                        100%   19KB  19.4KB/s   00:00
$