Below are rough steps to apply patch on Oracle Finance. For detail information on how to applying patch please look elsewhere (Metalink is preferred place)

• Backup your Oracle Finance (DB and Apps)
• Make sure no user logged in (force them by shutdown-ing Concurrent Manager)
• Login as apps
• Download the patch, unzip it and go to unzipped folder
• Read the README.txt (VERY IMPORTANT), apply pre-req patch if any. (you are lucky if the patch not require other patch before applying this patch)
  
• Make sure env. for your server $APPL_TOP, $ORACLE_HOME and $ORACLE_SID
  
• Run adpatch
• Start patching in these order
  
• cXXX.drv = copy driver patch
  
• dXXX.drv = database driver patch
• gXXX.drv = generated driver patch
• uXXX.drv = unified driver patch, bundled of 3 type above patches (you are lucky if you see this file)
  
• Some important you should have
• SYSTEM password: manager
• APPS password: apps
• After patch complete see log at /erpp/erppappl/admin/erpp/log/adpatch.log or logfile you specify during patching
  

                                  
Below is another nice HowToForge.com's Articles. Just wonder is there any article with the same topic but using CentOS / Fedora:

• Setting Up Subversion And Trac As Virtual Hosts On An Ubuntu Server
• OpenLDAP + Samba Domain Controller On Ubuntu 7.10
• Build A HylaFax Server With AvantFax Frontend Using Debian Etch

Now these one is using CentOS / Fedora, so it simplify my learning curve:

• How To Set Up A Local Yum Repository On Fedora 8
• Network Management And Monitoring With Hyperic HQ On Fedora 8
• Sample Configuration of DRBD On CentOS 4.5

                                  
Nice Howtos (provided by Howtoforge.com )

• How To Set Up Database Replication In MySQL
• How To Set Up A Load-Balanced MySQL Cluster
• How To Set Up A Loadbalanced High-Availability Apache Cluster
• Setting Up A Highly Available NFS Server

Just too bad they all using Debian which I am not familiar with.

                                  
With Maatkit's mysql-table-sync / mk-table-sync, I can easily synchronize between 2 tables whether it's on same database, different database or even different hosts. Below command will do the trick:

mk-table-sync \
u=user1,p=pwd1,h=server1,D=rodin,t=data \
u=user2,p=pwd2,h=server2,D=rodin,t=dataarchives \
--verbose --debug --print --lock --onlydo ui --execute

The command above will compare table rodin.data on server1 (source) with rodin.dataarchives on server2 (destination). If you want to test comparison (say you are not trust the command) you can remove the --execute option. And if you are sure it's ok then you might want to remove options --verbose --debug --print.

The --onlydo ui option mean to tell mysql-table only do update and insert on destination table without delete any record(s). If you want completely synchronize table you might dont use it.

Now, if you try to sync table with different name, it will always prompt you like this.

"Source and destination table have different names.  Continue?  y/n:"

Annoying and you can run it in shell script. So what I do is remark line 782 until 788 of /usr/bin/mk-table-sync on Maatkit version 1316.

One thing still I dont know how is when I tried to uninstall maatkit, it displayed error:

----
Uninstall is unsafe and deprecated, the uninstallation was not performed.
We will show what would have been done.

no packlist file found:  at /usr/lib/perl5/5.8.5/ExtUtils/Install.pm line
318.
make: *** [uninstall_from_sitedirs] Error 2
----

I leave that open

                                  
This week (19-22 Nov, 2007) I take RHCE (RedHat Certified Engineer) training on IndoLinux. This training discuss mostly about network services that Redhat can provide and serve them correctly. And SELinux configuration. The trainer is the same trainer on my RHCT training, Andre Kusuma. Nice to be trained by him again.

RHCE Exam will be held next month. wait and see......
On Dec 17, 2007 I take exam
On Dec 18, 2008 I received email from RedHat that I pass the exam and get RHCE
Hooray......

                                  
nice to read and a good information for web server admin on how to read httpd log

How to read Apache log

                                  

If you have a mailserver, it may have mailinglists setup for your users/customers internal communication. Some of them/milis' owner/you may want to archive emails sent to mailinglists rather than each users keep the same email copy on their Email Client. (Ms. Outlook has data file limitation about 2GB you know - once as Technical Support I must the datafile with new one if it near 2GB)

I am using QMailToaster (QMT-ISO) as mailserver, the developers and members are very very helpfull (hello there Jake, Erik, Nick, AM, dnk, Jean-Paul and others...). With ezmlm as mailinglist manager, it has ezmlm-cgi to maintain the archive. But for me, it seems difficult and the interface not user-friendly. Yet there are many mailarchiving on the internet but finally I chose MhonArc (they said MailArchive is using it) and mharc. Once I asked Jake to include MhonArc install script on QMT-ISO, but his script is to plain simple

mharc installation itself very easy and explained straightforward on mharc's Installation instructions, so as my contribution back to community, I wrote install-mailarchive.sh script to ease installation. It's not an automatic installation script but rather a interactive script, this script need you to type-in some values. By default mharc only support MBOX format to read mail on MTA/MUA (qmailtoaster user Maildir format) but luckily Ben has create a patch to enable read Maildir format.

Enough talk lets start the installation...

[ more.. ]

                                  

A Global Address Book for your Domain account which available throughout WebMail (SquirrelMail)

Please see my scripts on Qmailtoaster Archive

Note:

1. Creation of address book is not automatic so you need to add the scripts on crontab
2. These scripts only create an address book only for 1 domain specified on the configuration.
3. It will create 1 file for 1 domain specified, so if use squirrelmail for multiple domain, it wont suits you. (later revision may available on next version)
4. Users can't update his information on Global Address book
5. For users who use Email client and want to access Global Address he can export Address book from SquirrelMail and import in on Outlook Express / Ms. Outlook (tested OK, no -mapping- changes need to make)

Simple installation how to:

# cd ~
# wget http://am3n.profusehost.net/files/sqweb_gabook.tar.gz
# tar xzvf sqweb_gabook.tar.gz
# cd scripts
# vi sqweb_gabook.sh (edit the variables there)
# vi sqweb_gabook.php (edit the variables there)
# crontab -e (weekly update, you can change if you want daily update)
0 12 * * 3 /root/scripts/sqweb_gabook.sh >/dev/null

                                  
did you know Apache virtual folder which created using Alias command is higher than a real folder with same name under a VirtualHost??

say you have a virtual folder "scripts" made using command
Alias /scripts/ /usr/share/toaster/htdocs/scripts/

then under your VirtualHost folder, there is the same folder "scripts"
<VirtualHost *:80>
    ServerAdmin pakogah@pala.bo-tak.info
    DocumentRoot /home/www/myweb
    ServerName www.myweb.com
    ErrorLog logs/www.myweb.com-error_log
    CustomLog logs/www.myweb.com-access_log common
</VirtualHost>

with full path /home/www/myweb/scripts, if you have a file named countdown.php under it. you won't able to access it via http://www.myweb.com/scripts/countdown.php because the folder scripts is pointed to virtual folder "Alias" scripts

so if you have create an Alias make sure it very unique, that no VirtualHost is using it, or if you already using it, then you have change the folder under your VirtualHost to another name to make it accessible.

I have learn my lesson, the hard way......

                                  

Setup your Web server with PHP engine plus MySQL database connection is pretty easy and straightforward. I have done this many times. Usually when I am installing server, I just choose apache, php and mysql and later CentOS installer (or YUM) will add requires additional packages like php-mysql, etc and you can add more PHP modules later.

But this time, I got asked by my colleague to provide apache that can execute Perl script. Actually this pretty easy if he got root access to put this perl script on /cgi-bin/ ScriptAlias which located on /var/www/cgi-bin/. But then he only has user access and I have implement mod_userdir on apache, no way he can put his script on /var/www/cgi-bin/

So what I need to do is configure each users has a cgi-bin folder on their public_html, then they can put perl script there and execute it.

This setup requires and make sure you install them (I am not to describe how to install each of them)

• Linux (I am still using CentOS - other distro should be fine)
• Apache (default webserver package in CentOS) - the httpd.conf will be tweaked
• perl (and its modules you need)
• mod_perl (dont you forget this)

Okay, let's start!!

[ more.. ]