Saturday, April 18, 2009

Menginstall Oracle 10g di Slackware

,
Create Oracle user and install and management groups (as root):
groupadd dba
groupadd oinstall
adduser oracle #make the initial group oinstall, and additional groups dba,users

Download (this may not work, in which case you will have to go to http://www.oracle.com to get the download):
wget http://download.oracle.com/otn/linux/oracle10g/ship.db.cpio.gz

unpack:
gunzip ship.db.cpio.gz
cpio -idmv < ship.db.cpio

If your swapdisk is less than a 1GB, then;
dd if=/dev/zero of=/directory/with/much/free/space/tempswap bs=1k count=1000000
chmod 600 tempswap
mke2fs tempswap
mkswap tempswap
swapon tempswap

Next, check required system memory, run this:
sysctl -a

And check those values against these:
Needed Check with
shmmax = 2147483648 cat /proc/sys/kernel/shmmax
shmmni = 4096 cat /proc/sys/kernel/shmmni
shmall = 2097152 cat /proc/sys/kernel/shmall
shmmin = 1 ipcs -lm |grep "min seg size"
semmsl = 250 cat /proc/sys/kernel/sem | awk '{print $1}'
semmns = 32000 cat /proc/sys/kernel/sem | awk '{print $2}'
semopm = 100 cat /proc/sys/kernel/sem | awk '{print $3}'
semmni = 128 cat /proc/sys/kernel/sem | awk '{print $4}'
file-max = 65536 cat /proc/sys/fs/file-max
ip_local_port_range = 1024 65000 cat /proc/sys/net/ipv4/ip_local_port_range

Note: Don't change the value of any kernel parameter on a system where it is already higher than listed as Needed.
If they are found lacking, modify /etc/sysctl.conf:
# Kernel Parameters for Oracle 10.1.0
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

Then, to make these values effective immediately (without a reboot), run:
sysctl -p
Read more →

Friday, April 17, 2009

Mengasosiasikan Wireless Chipset RaLink ke AP di Linux

,
Jika Anda mempunyai laptop yang ber-OS Linux dan mempunyai wireless berchipset RaLink, ada kemungkinan Anda mengalami hal yang sama seperti saya. Wireless di laptop saya terdeteksi sebagai RaLink RT2860(node ra0). Driver untuk wireless ini bisa didownload di http://www.ralinktech.com/ralink/Home/Support/Linux.html. Setelah diinstall dengan mengikuti petunjuk dari README driver tersebut, akhirnya wireless saya bisa terdeteksi dengan baik. Namun, ketika dicoba diasosiaskan ke access point menggunakan perintah iwconfig, ssid selalu lenyap entah ke mana. Setelah diteliti, ternyata dapat disimpulkan bahwa jika mengasosiaskan ke access point yang berpassword atau mempunyai key, ssid akan selalu hilang. Waw.. serasa agak menyesal membeli laptop ini.. Namun setelah membaca README drivernya sekali lagi, ternyata di situ terdapat tulisan bahwa driver ini tidak support command iwconfig yang mengisikan key menggunakan keyword key restricted. di README tersebut, dituliskan bahwa cara mengasosiasi wireless dengan AP menggunakan driver ini adalah menggunakan perintah iwpriv. Berikut detailnya :

a> Config STA to link with AP which is OPEN/NONE(Authentication/Encryption)
1. iwpriv ra0 set NetworkType=Infra
2. iwpriv ra0 set AuthMode=OPEN
3. iwpriv ra0 set EncrypType=NONE
4. iwpriv ra0 set SSID="AP's SSID"

b> Config STA to link with AP which is SHARED/WEP(Authentication/Encryption)
1. iwpriv ra0 set NetworkType=Infra
2. iwpriv ra0 set AuthMode=SHARED
3. iwpriv ra0 set EncrypType=WEP
4. iwpriv ra0 set DefaultKeyID=1
5. iwpriv ra0 set Key1="AP's wep key"
6. iwpriv ra0 set SSID="AP's SSID"

c> Config STA to link with AP which is WPAPSK/TKIP(Authentication/Encryption)
1. iwpriv ra0 set NetworkType=Infra
2. iwpriv ra0 set AuthMode=WPAPSK
3. iwpriv ra0 set EncrypType=TKIP
4. iwpriv ra0 set SSID="AP's SSID"
5. iwpriv ra0 set WPAPSK="AP's wpa-preshared key"
6. iwpriv ra0 set SSID="AP's SSID"

d> Config STA to link with AP which is WPAPSK/AES(Authentication/Encryption)
1. iwpriv ra0 set NetworkType=Infra
2. iwpriv ra0 set AuthMode=WPAPSK
3. iwpriv ra0 set EncrypType=AES
4. iwpriv ra0 set SSID="AP's SSID"
5. iwpriv ra0 set WPAPSK="AP's wpa-preshared key"
6. iwpriv ra0 set SSID="AP's SSID"

e> Config STA to link with AP which is WPA2PSK/TKIP(Authentication/Encryption)
1. iwpriv ra0 set NetworkType=Infra
2. iwpriv ra0 set AuthMode=WPA2PSK
3. iwpriv ra0 set EncrypType=TKIP
4. iwpriv ra0 set SSID="AP's SSID"
5. iwpriv ra0 set WPAPSK=12345678
6. iwpriv ra0 set SSID="AP's SSID"

f> Config STA to create/link as adhoc mode, which is OPEN/NONE(Authentication/Encryption)
1. iwpriv ra0 set NetworkType=Adhoc
2. iwpriv ra0 set AuthMode=OPEN
3. iwpriv ra0 set EncrypType=NONE
4. iwpriv ra0 set SSID="Adhoc's SSID"

g> Config STA to create/link as adhoc mode, which is WPANONE/TKIP(Authentication/Encryption)
1. iwpriv ra0 set NetworkType=Adhoc
2. iwpriv ra0 set AuthMode=WPANONE
3. iwpriv ra0 set EncrypType=TKIP
4. iwpriv ra0 set SSID="AP's SSID"
5. iwpriv ra0 set WPAPSK=12345678
6. iwpriv ra0 set SSID="AP's SSID"

h> Get site survey
usage: iwpriv ra0 get_site_survey

i> Get Statistics
usage: iwpriv ra0 stat ; read statistic counter
iwpriv ra0 set ResetCounter=0 ; reset statistic counter

j> Link with an AP which is the largest strength ; set ANY SSID (ssidLen=0)
usage: iwconfig ra0 essid ""
or
usage: iwpriv ra0 set SSID=""

Dari percobaan saya, perintah tersebut harus ditulis urut dan satu per satu. Agak aneh memang, tapi baru bisa connect dengan cara begitu..
Nah, semoga tulisan saya ini dapat membantu Anda yang mempunyai masalah yang sama dengan saya.... :D
Read more →