Archive for May, 2018

Something Random About Suicide About The Love She Had For Me

May 29th, 2018, posted in Death Note, Scarface'S DIARY
Share

Something Random,How to dress,be ready,trutle gif,how to dress gid,gentle man gif,suicide gid,suicide note,simpsons suicide,simpsons suicide comic,funny,the girl who loves you,love you,i miss you,love you,thinking about you,

Something Random,How to dress,be ready,trutle gif,how to dress gid,gentle man gif,suicide gid,suicide note,simpsons suicide,simpsons suicide comic,funny,the girl who loves you,love you,i miss you,love you,thinking about you,

Something Random,How to dress,be ready,trutle gif,how to dress gid,gentle man gif,suicide gid,suicide note,simpsons suicide,simpsons suicide comic,funny,the girl who loves you,love you,i miss you,love you,thinking about you,friend,i miss you friend,

Something Random,How to dress,be ready,trutle gif,how to dress gid,gentle man gif,suicide gid,suicide note,simpsons suicide,simpsons suicide comic,funny,the girl who loves you,love you,i miss you,love you,thinking about you,friend,i miss you friend,

Something Random,How to dress,be ready,trutle gif,how to dress gid,gentle man gif,suicide gid,suicide note,simpsons suicide,simpsons suicide comic,funny,the girl who loves you,love you,i miss you,love you,thinking about you,friend,i miss you friend,

Something Random,How to dress,be ready,trutle gif,how to dress gid,gentle man gif,suicide gid,suicide note,simpsons suicide,simpsons suicide comic,funny,the girl who loves you,love you,i miss you,love you,thinking about you,friend,i miss you friend,

Share

Shared Memory Tuning: Startup database – ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device

May 22nd, 2018, posted in Linux OS, Oracle Queries, Uncategorized
Share
Oracle on linux,Oracle,linux,Oracle DBA,Apps DBA,sun linux 10,sun linux,Oracle Database dba,Oracle database,Oracle Application, Linux, linux, solaris administrator, sun linux,SGA/PGA sizes,solaris SGA/PGA ,linux SGA/PGA sizes, prtconf,ORA-27102,ORA-27101: shared memory realm does not exist,ORA-27101,shared memory realm does not exist,SVR4 Error: 2: No such file or directory,Oracle Linux,Linux Oracle 
SQL> startup
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
I have used RHEL X86_64 + memory (32GB) and setted sga_max_size=20G + sga_target=20G and …
$ cat /proc/sys/kernel/shmmax
26843545600
What wrong with my kernel tuning… So, I checked metalink (301830.1) and some recommend from RHEL
They told; set SHMALL to the total amount of physical RAM divided by page size.

SHMALL =>Total amount of shared memory available (bytes or pages)

then:
Check Page Size:
$ getconf PAGE_SIZE
4096
Determine the system wide maximum number of shared memory pages:
$ cat /proc/sys/kernel/shmall
2097152
My system 64bits with memory 32GB, then 1024 * 1024 * 1024 * 32 / 4096 = 8388608
So, change kernel.shmall = 8388608
$ su - root
# echo 8388608 > /proc/sys/kernel/shmall
Or modify /etc/sysctl.conf file:
kernel.shmall=8388608
and
# sysctl -p
After changed… check and startup database again:
$ cat /proc/sys/kernel/shmall
8388608
 
SQL> startup

.

.

.

--- NO ERROR ---
From this idea with memory 32GB
mem=$(free|grep Mem|awk '{print$2}')
totmem=$(echo "$mem*1024"|bc)
huge=$(grep Hugepagesize /proc/meminfo|awk '{print $2}')
max=$(echo "$totmem*75/100"|bc)
all=$(echo "$max/$huge"|bc)
echo "kernel.shmmax = $max"
echo "kernel.shmall = $all"
Result:
kernel.shmmax = 25213120512, kernel.shmall = 12311094
However, This case “ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device” , solved by set SHMALL = MemTotal(byte)/PAGE_SIZE
and …
I hope to hear your idea about kernel tuning with Oracle Database.
Share

Happy Birthday Hamza

May 20th, 2018, posted in DAtEs iN a YeAR, GiRLs, MESSAGEs
Share

Hamza, Hamza Happy Birthday, Happy Birthday, Happy Birthday Hamza

Share

Hazrat Ali To His Son

May 18th, 2018, posted in Islamic Teachings, MESSAGEs, Saying Of Hazrat Ali ( A.S )
Share

saying of imam Ali,Rajab,Month of Rajab,Islamic Teaching,Islamic Date,Do Not forget,teaching of islam,How to pray,supererogatory prayers,saying of Imam Ali,Quote of Imam Ali

saying of imam Ali,Rajab,Month of Rajab,Islamic Teaching,Islamic Date,Do Not forget,teaching of islam,How to pray,supererogatory prayers,saying of Imam Ali,Quote of Imam Ali

Share