Down to Earth

Adding new Hard Drive to an LVM

2010-03-25T12:53:00.002+07:00

Adding new Hard Drive to an LVM1. Create the partition table[root@repository ~]# fdisk /dev/sdaDevice contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabelBuilding a new DOS disklabel. Changes will remain in memory only,until you decide to write them. After that, of course, the previouscontent won't be recoverable.The number of cylinders for this disk is set to 60801.There

Oracle move table to another Tablespace

2010-03-10T16:52:00.002+07:00

If you move a table from one table to another tablespaces, you need to rebuild the Index1. Checking Index for the tablesSQL> SELECT INDEX_NAME,TABLE_NAME,STATUSFROM ALL_INDEXESWHERE TABLE_NAME='IB_ARC_SI_BILL_PAYMENT';INDEX_NAME TABLE_NAME STATUS------------------------------ ------------------------------ --------SYS_C003164

Auditing database on Oracle 9i

2010-02-25T09:40:00.000+07:00

Information that can be audited:- Operating system login user name- User name- Session identifier- Terminal identifier- Name of the schema object accessed- Operation performed or attempted- Completion code of the operation- Date and time stampStep for activating auditing:1. Activate auditing in initialization paramaters (DB or OS)audit_trail = DB2. Activate auditing optionAUDIT SELECT TABLE,

How to add new hard drive to existing LVM volume

2010-02-08T09:42:00.002+07:00

Sometimes your server running out of space, but if your server configured using LVM Volume, it will not be a problem anymore. Plug your new hard drive and let's configure1. Creat an LVM partition[root@oracledev ~]# fdisk /dev/sdapress n for creating new partitionpress t for partition type and choose 8e for LVMpress w to write any changes2. Create LVM physical volume[root@oracledev ~]# lvmlvm>

Oracle 9i Startup Script on CentOS 4.4

2008-09-17T10:56:00.002+07:00

Here is startup script for oracle 9i release 2 on centos 4.41. Save this script on /etc/init.d/oracle#!/bin/sh# 15 September 2008# Created by Johannes Sitorus# description: Oracle auto start-stop script.ORA_HOME=/data/oracle/9.2.0ORA_OWNER=oracleif [ ! -f $ORA_HOME/bin/dbstart ]then echo "Oracle startup: cannot start" exitficase "$1" in 'start') # Start the Oracle databases:

Apache security

2008-08-12T11:22:00.002+07:00

Maybe we need to build up a super secure web server. It's can be done through many steps. There's so many article on Internet, how to secure your web server. One of the step is using modsecurity.1. Make sure you have mod_unique_id installed2. Install the latest version of libxml2, if it isn't already installed on the server3. Stop Apache httpd4. Unpack modsecurity package if you are using

iptables Packet Route

2008-06-12T16:24:00.004+07:00

This picture will show how packet processed on firewallSource :http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch14_:_Linux_Firewalls_Using_iptables

[OOT] Speedy

2008-05-22T16:09:00.002+07:00

Quiet amaze with speedy, this afternoon my speedy connection was down. Then I log in to router console, disconnect my speedy and then reconnect.My office using speedy (Office package 384 Kbps). I was shocked seeing download rate on web interface, it show 1029 Kbps. And then I tested the connection through www.speedtest.net and I was amaze to see this ;)

Recompile Kernel on CentOS 4.6

2008-05-16T11:45:00.003+07:00

1. Download the latest kernel source from kernel.org2. Copy kernel source to /usr/src/kernel/ and unpack it[root@appdev kernels]tar jxvf linux-2.6.25.3.tar.bz23. Copy config files from original kernel[root@appdev kernels]# cd linux-2.6.25.3[root@appdev linux-2.6.25.3]# cp /boot/config-2.6.9-67.0.15.ELsmp .config[root@appdev linux-2.6.25.3]# make menuconfigand then exit4. Rebuild RPM package[root@

Masquerade on sendmail and SMTP Route

2008-05-07T15:07:00.002+07:00

add this line to /etc/mail/sendmail.mc for masquerading# vi /etc/mail/sendmail.mcMASQUERADE_AS(gudangsms.com)dnlFEATURE(masquerade_envelope)dnlFEATURE(masquerade_entire_domain)dnlMASQUERADE_DOMAIN(gudangsms.com)dnladd this line to /etc/mail/sendmail.mc for SMTP Routedefine(`SMART_HOST',`smtp.gudangsms.com')compile configuration files# m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cfrestart

Recreate TEMP tablespace

2008-05-06T14:23:00.002+07:00

1. Create another temp tablespaceSQL> CREATE TEMPORARY TABLESPACE temp2 2 TEMPFILE '/u02/oradata/TESTDB/temp2_01.dbf' SIZE 5M REUSE 3 AUTOEXTEND ON NEXT 1M MAXSIZE unlimited 4 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;2. Move default temporary tablespace on every userSQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;3. Drop default tablespaceSQL> DROP TABLESPACE temp INCLUDING CONTENTS AND

Installing perl modules using CPAN on Linux

2008-04-28T14:50:00.001+07:00

Go to terminal console as root#perl -MCPAN -e 'shell'cpan> install Net::DNSThat's all ;)

Make Self signed certificate

2008-04-02T10:36:00.002+07:00

We can make self signed certificate for development or UAT env:1. Create server keyumask 77/usr/bin/openssl genrsa -des3 1024 > server.keyThis will ask you passphrase, and this passphrase will be asked each time apache restarted. If you dont want this passphrase being asked, use this command instead.umask 77/usr/bin/openssl genrsa 1024 > server.key2. Create server certificate/usr/bin/openssl req

Showing Spam and Virus graph with qmailmrtg

2008-03-31T15:31:00.003+07:00

Maybe some of you already use qmailmrtg to view your mail server statistics, such as spam, virus, queue, etc. But there must be some problem with displaying spam and virus graph.This is happens because qmailmrtg7 only support multilog log files. To accomodate it, we need to change our spamd and clamav behaviour.For spamd:1. Add spamd directorymkdir -p /var/qmail/supervise/spamd/log2. Create spamd

Killing Oracle Session

2008-03-19T08:55:00.002+07:00

We can kill user session using 31. The SQL Plus approachSELECT s.sid, s.serial#, s.osuser, s.programFROM v$session s; SID SERIAL# OSUSER PROGRAM---------- ---------- ------------------------------ --------------- 1 1 SYSTEM ORACLE.EXE 2 1 SYSTEM ORACLE.EXE 3

Default Homepage Settings on Internet Explorer

2008-03-11T18:03:00.002+07:00

You can set a registry entry to lock your IE homepage.1. Go to:HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Control Panel2. Create an DWORD entry of Homepage with a value of 1That should lock it up for you (depending on your OS - though it works for Win2K)You can also create a new Key under1. HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Restriction2. Then

Iptables as Linux main Firewall

2008-03-06T10:12:00.002+07:00

Some of us maybe already familiar with this tools (iptables) as a firewall machine. Here is post iptables script that I always used on my server.I always set the default policy to Drop any packet, and then allow any port that i'm using.Here is the example of iptables script on my oracle database (using port 8550)#/bin/bashiptables -Ziptables -F -t filteriptables -F -t natiptables -F -t

Update Clamav Antivirus on Fedora Core 3

2008-03-06T09:41:00.002+07:00

Here is some steps to update your clamav Antivirus instalation, you can download the latest clamav engine from official site (www.clamav.net)1. Stop service freshclam dan clamd#service clamd stop#service freshclam stop2. Remove any library used in previous clamav instalation#rm -f /usr/local/lib/*clam*3. Install clamav intself, usually i'm using tar ball package and install it on default location

Linux Dial in Server Setup

2008-03-03T15:19:00.004+07:00

Here is tutorial for build a dial in server with Linux machine:1. Build you network plan configuration[dial in server : 192.169.169.1]<-- PSTN Tel Line-->[Client 192.169.169.2]2. Create an account to in dial in serverHost : 192.169.169.1Account : dialinPassword/Secret : dialin3. Setup dial in server as a gateway[root@server]# echo 1 > /proc/sys/net/ipv4/ip_forward[root@server]# ipchains -A

Linux TCP load balancing

2008-02-22T16:07:00.002+07:00

Maybe some of us need to balance TCP connection through several server. This is a simple way to do so.1. Download the packagewget http://www.inlab.de/balance-3.40.tar.gz2. Extract, compile and install:tar zxvf balance-3.40.tar.gzcd balance-3.40vi MakefileChange this line of code: MANDIR=${BINDIR}/../man/man1For Ubuntu users : MANDIR=/usr/share/man/man1For RedHat users: MANDIR=/usr/local/share/man

Simscan Instalation on QmailRocks

2008-02-19T11:22:00.002+07:00

Here is some steps for installing simscan on Linux with QmailRocks Installed:1. Edit configuration option based on your machine configuration, here is mine./configure \ --enable-user=qscand \ --enable-clamav \ --enable-clamdscan=/usr/local/bin/clamdscan \ --enable-custom-smtp-reject=y \ --enable-per-domain=y \ --enable-attach=y \ --enable-dropmsg=n \ --enable-spam=y \ --enable-spam-hits=5 \ --

Monitoring Oracle tablespace usage

2008-02-14T19:44:00.001+07:00

Maybe some of us need to monitor Oracle tablespace usage on our DB Server. Here is some script that give a report about tablespace usage.column "Tablespace" format a13column "Used MB" format 99,999,999column "Free MB" format 99,999,999colimn "Total MB" format 99,999,999selectfs.tablespace_name "Tablespace",(df.totalspace - fs.freespace) "Used MB",fs.freespace "Free MB",df.totalspace "Total MB",

Oracle 9i instalation on CentOS 4.4 Final Release

2008-02-14T19:42:00.000+07:00

Here I post a quick tutorial to install Oracle 9i Release 2 on CentOS 4.4 (RHEL 4.4 Clone). You can download oracle 9i from Oracle Website (download.oracle.com) and for the Linux you can download it from official website www.centos.org or from local mirror (centos.cbn.net.id)Before you can install Oracle, you need to check packets installed on your computer.- CD 1xorg-x11-deprecated-libs-6.8.2-1.