Friday, October 21, 2011

Install Oracle 10.2 on Centos 4

1.Install Centos 4 -> everything
2.Login as root on Centos
3.extract oracle db.zip ke /tmp

yum update -y
terus tunggu lama sekali utk update yum

sysctl -a | grep shm

utk ubah parameter:
#vi /etc/sysctl.conf
tambahkan:
kernel.shmmax=2147483648
kernel.sem=250 32000 100 128
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000

net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

groupadd dba # group of users to be granted SYSDBA system privilege
groupadd oinstall # group owner of Oracle files
useradd -c "Oracle software owner" -g oinstall -G dba oracle
passwd oracle

mkdir -p /u01/app/oracle
chown oracle.oinstall /u01/app/oracle

su - oracle
cat >> ~oracle/.bash_profile << EOF export ORACLE_BASE=/u01/app/oracle export ORACLE_SID=orcl EOF RESTART dan login dg user = oracle

PENTING !! = selalu RESTART dan login pertama dg oracle, bukan login dg root terus di terminal melakukan su oracle !

dg terminal, masuk ke folder /tmp/database, lakukan:
./runInstaller

NEXT NEXT NEXT

Tuesday, October 18, 2011

XEN VPS 64MB

Setting Up the VPS

After my order has been provisioned, I re-image the server with a Debian 5 “Lenny” image. I normally pick Debian or Ubuntu because apt-get uses much less memory than RedHat/Fedora’s equivalent, and it’s also my personal preference. I named my new VPS “endor” as I usually just name my boxes after Star Wars systems. Re-imaging a VPS is pretty fast — 2 minutes later I have my root password sent to my email address so I can ssh in to set up the new system.