takraw's blog

Thursday, June 9, 2016

ORA-00845: MEMORY_TARGET not supported on this system

:Manual Mount tmpfs

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

:Auto Mount on fstab

tmpfs /dev/shm tmpfs size=12g 0 0

Size of tmpfs = MemorySize x 2

Wednesday, April 27, 2016

Fixing the Cyrus mailserver SQUAT failed error

# su - cyrus
$ cd /usr/lib/cyrus-imapd
./squatter
exit

Tuesday, April 26, 2016

Add static route gateway persistent

add static route gateway persistent

:windows

route -p add dest_network mask dest_netmask gateway

ex:
route -p add 192.168.1.0 mask 255.255.255.0 10.10.10.1

:solaris 10

route -p -net dest_network/24 -gateway gateway

ex:
route -p add 192.168.1.0/24 -gateway 10.10.10.1

:OracleLinux 6.5

# cd /etc/sysconfig/network-scripts
# cat route-eth2
# echo ‘10.11.18.0/24 via 10.10.18.4′ >> /etc/sysconfig/network-scripts/route-eth0

Tuesday, April 19, 2016

Clear Alert log /Trace file in Oracle 11g using adrci

adrci command line

:ON Database SID (alert log & trace file)
show home

set homepath diag/rdbms/db_sid/db_sid

show alert -tail
show tracefile -tail

PURGE -AGE 7200 -TYPE ALERT;

:ON Listener log (alertlog & tracefile)
show home
set home diag/tnslsnr/db_hostname/listener

show alert -tail
show tracefile -tail

PURGE -AGE 7200 -TYPE ALERT;

-age in sec

lock account/unlock account Office 365 user

To block a user account:
Set-MsolUser –UserPrincipalName user@yourdomain –blockcredential $true

To unlock a user accout:
Set-MsolUser -UserPrincipalName user@yourdomain –blockcredential $false

Tuesday, March 22, 2016

syslog-ng debug mode

edit syslog-ng.conf

syslog-ng -Fdve

Source.list mirror.ku.ac.th Ubuntu 15.10 wily warewolf

#####Main,Restriced Update#####

deb http://mirror1.ku.ac.th/ubuntu/ wily main restricted
deb http://mirror1.ku.ac.th/ubuntu/ wily-updates main restricted
deb http://mirror1.ku.ac.th/ubuntu-security/ wily-security main restricted

#####KU Multiverse,Universe Update(Optional)#####

deb http://mirror1.ku.ac.th/ubuntu/ wily multiverse universe
deb http://mirror1.ku.ac.th/ubuntu/ wily-updates multiverse universe
deb http://mirror1.ku.ac.th/ubuntu-security/ wily-security multiverse universe

#####Source File Main, Restriced (Optional)#####

deb-src http://mirror1.ku.ac.th/ubuntu/ wily main restricted
deb-src http://mirror1.ku.ac.th/ubuntu/ wily-updates main restricted
deb-src http://mirror1.ku.ac.th/ubuntu-security/ wily-security main restricted

#####Source File Multiverse,Universe (Optional)#####

deb-src http://mirror1.ku.ac.th/ubuntu/ wily multiverse universe
deb-src http://mirror1.ku.ac.th/ubuntu/ wily-updates multiverse universe
deb-src http://mirror1.ku.ac.th/ubuntu-security/ wily-security multiverse universe

OR

edit source.list

vi search and replace

:%s/soure_url/mirror_url

ex:

:%s/us.archive.ubuntu.com/mirror1.ku.ac.th