Search Blog
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
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 ~]#
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
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 ~]#
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>
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 ~]#
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
$
/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
$
Subscribe to:
Posts (Atom)