Oracle, Web, Script, SQLserver, Tips & Trick

April 5, 2016

How to add license vnc server linux

Filed under: linux — sikathabis @ 8:22 am
Tags: , ,

Connect linux using putty or others application using root user


vnclicense -add ABCD1-EFGH2-IJKL3-MNOP4-QRST5


August 10, 2015

How to hide password login to oracle in CMD

Filed under: linux,oracle,windows — sikathabis @ 10:14 am
Tags: , ,

I have application for backup database, in the application I’ve created, can generate user password, without other user know what the password is. Other user use that application which can see the content of .bat file where my application whom creating that file, the trouble is, other user can see password from login “user/password@tnsnames” . There are many solution to hide the password from Mbah Google, but there’s one reference very usefull (first comment)

example: echo generatepassword | exp username@tnsnames file=backup.dmp owner=scott

“Echo generatepassword |” is created on the application, and “exp username@tnsnames file=backup.dmp owner=scott” is .bat file which can other user see or using it.

September 22, 2014

How to compress and extract on unix/linux using tar (gzip)

Filed under: linux,server,server:ibm — sikathabis @ 7:54 pm
Tags: , , ,


tar -zcvf filename.tar.gz fileordirectory

EXTRACT to current directory

tar -zxvf filename.tar.gz

July 24, 2014

Cara merubah hak akses Folder pada linux

Filed under: linux — sikathabis @ 9:41 am

Cara merubah hak akses Folder pada linux agar bisa dipakai oleh semua user (read+write)

chmod -R ugo+rw /folder

Referensi :

October 10, 2013

Cara Testing Performance memakai IoStat dan Vmstat pada linux/solaris/aix

Filed under: linux,server,server:ibm,solaris — sikathabis @ 3:06 am
Tags: , , , ,

Jalankan via putty atau mobaXterm ke server yang dituju

Untuk 3 tahap ini buka 3 putty (putty pertama untuk jalanin create file, putty kedua untuk capture iostat, putty ketiga untuk capture vmstat). Dalam contoh kasus dibawah ini testing create file pada lokasi /oradata , lokasi ini dapat disesuaikan sesuai dengan kebutuhan anda.

Putty 1:

dd if=/dev/zero of=/oradata/testfile bs=1000000 count=89999

Putty 2:

iostat -xtnz 1 300 > /tmp/oradataiostat.log

Putty 3:

vmstat -xtnz 1 300 > /tmp/oradatavmstat.log


  • Setelah 5 menit di ctrl-c putty pertama, untuk putty kedua dan ketiga akan berhenti jika sudah 5 menit.
    Performance yang bagus dari pengecekan IoStat (oradataiostat.log) dan VMStat (oradatavmstat.log) adalah:
  1. Penggunaan CPU < 50%
  2. Service time  <=10 ms
  3. iops  <= 2400
  4. throughput  <= 200 MBps

Referensi: Ujang Jaenudin

September 12, 2013

Script untuk looping command pada linux/aix

Filed under: linux — sikathabis @ 11:05 am
Tags: ,

Contoh: menjalankan perintah sqlplus untuk menampilkan query sm2.sql

while true; do sqlplus strmadmin/oracle @sm2.sql; sleep 10; done

August 13, 2013

How to set adobe flash player on centos

Filed under: linux,linux:centos — sikathabis @ 2:32 am

reference :

1. Log on root user

2. ## Adobe Repository 32-bit x86 ##
rpm -ivh
rpm –import /etc/pki/rpm-gpg/RPM-GPG-KEY-adobe-linux
## Adobe Repository 64-bit x86_64 ##
rpm -ivh
rpm –import /etc/pki/rpm-gpg/RPM-GPG-KEY-adobe-linux

3. Centos 5.x

yum groupinstall "Sound and Video"
yum install flash-plugin nspluginwrapper curl
Centos 6.x
yum install flash-plugin nspluginwrapper alsa-plugins-pulseaudio libcurl

July 25, 2013

How to clear cached memory on linux

Filed under: linux — sikathabis @ 3:35 am


Syntax to clear cache memory:

sync; echo 3 > /proc/sys/vm/drop_caches


reference :

July 14, 2013

How to del / erase pth0 pth1 on linux

Filed under: centos,linux,network — sikathabis @ 6:42 am
Tags: ,

/etc/xen/scripts/network-bridge stop

April 27, 2013

Shortcut to show desktop (remote desktop) on linux, solaris, unix

Filed under: linux,solaris — sikathabis @ 9:08 am
Tags: , , ,

Display GNOME

/usr/bin/gnome-session --display $DISPLAY


/usr/bin/X11/xterm -ls -display $DISPLAY

Xterm (Linux: Type 1)

/usr/X11R6/bin/xterm -ls -display $DISPLAY

Xterm (Linux: Type 2)

/usr/bin/xterm -ls -display $DISPLAY

Xterm (Solaris)

/usr/openwin/bin/xterm -ls -display $DISPLAY


/usr/dt/bin/dtterm -ls -display $DISPLAY


sh -c "LANG=C; DISPLAY=$DISPLAY; export LANG DISPLAY; /usr/dt/bin/Xsession"


Next Page »

Blog at

Teknologi Pendidikan

Just another weblog


Jurnalisme Yang Dapat Dipercaya

Qey050489's Blog

Ayo Bangkit sobat..!!!!!

B. S. Totoraharjo

Orang Bodoh Yang Tak Kunjung Pandai

culturekitchen foodlab

New Food and Art in Yogyakarta

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server


"A distance is getting far if your heart is impatient" -ean-


Street Photography is like a box of a chocolates, you're never know what you're gonna get - Thomas Leuthard -

Keluarga Andrivito

-- Andrivito's Journal --


This site is about Latest NEWS, Articles, Videos, Books, Course, Presentations, Tips & Tricks related to I.T Pro's

Gaurav Saxena

|| तत् त्वम् असि ||

Be a good Moeslim

Menuju Pribadi Muslim Sejati yang Bertaqwa


Manajemen Sholat, renungan spiritual, Teknologi Informasi

Pelangi di khatulistiwa....

Mari berbagi kebaikan, pengalaman dan senyum denganku


Ceritanya saya, Pikirannya saya, Hatinya saya


sikathabis semua informasi disini

Don Charisma

because anything is possible with Charisma