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

example:

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

reference: https://www.realvnc.com/products/vnc/documentation/5.0/installing-removing/redhat

Advertisements

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

http://stackoverflow.com/questions/17807188/how-to-authenticate-oracle-login-using-encrypted-password (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: , , ,

COMPRESS

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 : http://www.linux.com/learn/tutorials/760276-how-to-manage-file-and-folder-permissions-in-linux

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

Note:

  • 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 : http://www.if-not-true-then-false.com/2010/install-adobe-flash-player-10-on-fedora-centos-red-hat-rhel/

1. Log on root user

2. ## Adobe Repository 32-bit x86 ##
rpm -ivh http://linuxdownload.adobe.com/adobe-release/adobe-release-i386-1.0-1.noarch.rpm
rpm –import /etc/pki/rpm-gpg/RPM-GPG-KEY-adobe-linux
or
## Adobe Repository 64-bit x86_64 ##
rpm -ivh http://linuxdownload.adobe.com/adobe-release/adobe-release-x86_64-1.0-1.noarch.rpm
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
or
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
Tags:

Beforeclear_cached1

Syntax to clear cache memory:

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

clear_cached2a

reference : http://ttux.net/post/clear-memory-cache-linux/

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

Xterm

/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

Dtterm

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

CDE

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

 

Next Page »

Create a free website or blog at WordPress.com.

Learning is not a spectator sport

Connor McDonald's Oracle blog

Teknologi Pendidikan

Just another WordPress.com weblog

KATAKAMI

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

arihdyacaesar

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

neinframe

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 --

DRK™

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

TuanSUFI

Manajemen Sholat, renungan spiritual, Teknologi Informasi

Pelangi di khatulistiwa....

Mari berbagi kebaikan, pengalaman dan senyum denganku

Angkasa13

Ceritanya saya, Pikirannya saya, Hatinya saya

sikathabis

sikathabis semua informasi disini