A notepad of a Software Engineer

Using Wireless@SG in Changi airport

2011-12-15T23:25:00.000+08:00

Although I already have mobile number registered with Wireless@SG long time ago and I have been using it occasionally, I cannot login Wireless@SG in Changi airport.

Then I clicked the Forget Password link. An instruction pops out, asking me to approach information counter? Feeling quite strange, I walked to information counter and tell them I want access to Wireless@SG. The staff immediately gave me a paper with 4 hour validity random username and password.

Clever. Problem solved.

How to open chm file in Windows?

2011-11-30T16:14:00.001+08:00

For many years, I cannot open CHM file in Windows. I never knew why. I thought, the CHM file was old or outdated or generated with old compiler or wrong encoding.

Until one day I am so fed up, I search for solution. Surprisingly, there are some softwares offer to open CHM file, including a plug-in in Firefox to open CHM file. However, the Firefox plugin still cannot open some CHM file correctly, there are missing pages or images.

Finally, I come across this simple solution:

I read somewhere, for security reason, Windows cannot open downloaded CHM file automatically. We have to right click the file -> Properties -> General tab -> [Unblock] button.

native2ascii vs ascii2native

2011-08-23T16:00:00.001+08:00

In Java, to display Chinese character, we need to convert Chinese word to Unicode format.
e.g. 你好 becomes \u4F60\u597D.

We can use the following command to do conversion:
(Source: http://javaphoon.iteye.com/blog/148403)
native2ascii -encoding gb2312 test_native.properties > test_ascii.properties
native2ascii -reverse -encoding gb2312 test_ascii.properties > test_native2.properties

This is the online conversion tool:
http://code.cside.com/3rdpage/us/javaUnicode/converter.html

OCR = Optical Character Recognition, 文字扫描辨识软体

2011-07-15T00:00:00.006+08:00

A friend asked me, how to scan a Chinese print out into editable Word document?

I recall, some scanner software comes with OCR software, meaning the scanner can scan the graphic and directly covert the output into text.

However is there a way if the scanner doesn't provide OCR software?

After some information gathering and research...
http://fish.pixnet.net/blog/post/22621207
http://www.info-artist.net/2009/10/ocr.html

Good news is, Microsoft Office Document Imaging (exists inside All Programs -> Microsoft Office -> Microsoft Office Tools) is the OCR tool.

Bad news is, it doesn't seems to support Chinese right away. So need to install the language engine:
http://www.microsoft.com/downloads/zh-tw/confirmation.aspx?FamilyID=DD172063-9517-41D8-82AF-29C38F7437B6&displaylang=zh-tw

Then, I realize I cannot open graphic file (e.g. jpg, gif, etc) directly inside Microsoft Office Document Imaging. There is this software JOCR.exe which is able to make use of Microsoft libray to do conversion.
http://philtzki.pixnet.net/blog/post/5189840
http://download.cnet.com/JOCR/3000-2192_4-10768898.html

Updated 29-01-2012:
Or the easier method, use online free OCR service:
Google Keyword: ocr online chinese
http://free-online-ocr.com
http://www.sciweavers.org/free-online-ocr
http://googlesystem.blogspot.com/2009/09/google-docs-ocr.html

k-lite cannot play rm rmvb file RealAudio COOK

2010-11-27T12:14:00.002+08:00

When I install K-Lite Mega Codec Pack 6.5.0 on WinXP SP3, Windows Media Player and Media Player Classic can play rmvb/rm files smoothly.

After I install Real Player ver 14 Hexlix Powered, WMP and MPC failed to render rmvb/rm files. It shows the following errors:

C:\Downloads\Movie\movie.rmvb::Output 00 (Audio Stream)

Media Type 0:
--------------------------
Audio: RealAudio COOK 44100Hz stereo

AM_MEDIA_TYPE:
majortype: MEDIATYPE_Audio {73647561-0000-0010-8000-00AA00389B71}
subtype: Unknown GUID Name {4B4F4F43-0000-0010-8000-00AA00389B71}
formattype: FORMAT_WaveFormatEx {05589F81-C356-11CE-BF01-00AA0055595A}
bFixedSizeSamples: 1
bTemporalCompression: 1
lSampleSize: 14880
cbFormat: 112

WAVEFORMATEX:
wFormatTag: 0x2004
nChannels: 2
nSamplesPerSec: 44100
nAvgBytesPerSec: 0
nBlockAlign: 930
wBitsPerSample: 16
cbSize: 0 (extra bytes)

pbFormat:
0000: 04 20 02 00 44 ac 00 00 00 00 00 00 a2 03 10 00 . ..D¬......¢...
0010: 00 00|2e 72 61 fd 00 05 00 00 2e 72 61 35 00 00 ...raý.....ra5..
0020: 00 10 00 05 00 00 00 4e 00 18 00 00 03 a2 00 00 .......N.....¢..
0030: 00 00 00 07 55 67 00 00 00 00 00 10 03 a2 00 ba ....Ug.......¢.º
0040: 00 00 00 00 ac 44 00 00 ac 44 00 00 00 10 00 02 ....¬D..¬D......
0050: 67 65 6e 72 63 6f 6f 6b 01 07 00 00 00 00 00 10 genrcook........
0060: 01 00 00 03 08 00 00 25 00 00 00 00 00 06 00 05 .......%........

I un-install all. No matter how I change the installation steps, i.e. install RealPlay first then K-Lite, or install K-Lite first then RealPlayer, or install older version of K-Lite, or Real Alternative, the result is the same. Once RealPlayer is installed, K-Lite is broken.

Official FAQ says:
http://www.codecguide.com/faq_mpc.htm#item23

Q: RealMedia files (.rm .rmvb) freeze or play without sound

A: MPC is not fully compatible with RealPlayer 11 and 12.

or C:/Program Files/K-Lite Codec Pack/Info/faq_playback_issues.htm#item32

Q: RMVB files play without sound

A: You are probably missing a decoder for RealAudio COOK. You can install that by following these steps:

Download the Windows version of binary codec pack for MPlayer.
http://www.mplayerhq.hu/design7/dload.html#binary_codec
Extract these files from the .zip archive: cook.dll, pncrt.dll, sipr3260.dll, drv33260.dll, drv43260.dll
Put those files in this folder: C:\Windows

It seems redundant as K-Lite itself is the bundle of media libraries, why do we need to download additional binary from 3rd party? And the above steps are troublesome.

The easier way and solution is that:

1) Install K-Lite Mega Codec Pack (contains Real Alternative) or Real Alternative first. You'll see the following directory:
C:\Program Files\K-Lite Codec Pack\Real\Codecs

2) Save a copy of this [Codecs] directory. Because it'll somehow disappear when RealPlayer is installed, or you install K-Lite after RealPlayer, this folder won't exist (I don't remember clearly).

3) Then, install RealPlayer. As expected, WMP and MPC cannot play rmvb/rm properly (without sound, missing RealAudio COOK)

4) Go Control Panel -> System -> Advanced tab -> [Environment Variables] -> edit Path

Add the following path:
%path%;C:\Program Files\K-Lite Codec Pack\Real\Codecs

Adding the above path, [Codecs] folder is visiable to Windows. Now you try to play rmvb/rm with WMP and MPC, it will play smoothly again.

Search in Open Source

2010-10-25T18:32:00.001+08:00

Sometimes I find it is quite helpless/having good life/cheating being a software engineer myself. In the daily work, I rely so much on 3rd party library. A lot of implementations are already widely available in Internet. I don't really have to do anything from scratch.

However if I am required to do from scratch? In fact I don't know how. The theory and spec can be very thick... the basic implementation can be very complicated... the simple thing itself can be a PhD project.

... ...

Anyway, the summary is, not only to search the keyword in Google. There are great developers in Japan (http://sourceforge.jp/) and China. And maybe other non-English speaking countries too, such as Russia, just that I don't know.

IIS on Windows 7 / Vista / XP Pro

2010-09-13T16:23:00.000+08:00

A project may propose using Webservices. So here I find how easy it is to enable IIS on Windows.

For Windows 7 / Vista, it is a build-in feature:
http://learn.iis.net/page.aspx/28/installing-iis-7-on-windows-vista-and-windows-7/
http://www.howtogeek.com/howto/windows-vista/how-to-install-iis-on-windows-vista/

For Windows XP Pro, it can be installed free:
http://www.webwiz.co.uk/kb/asp_tutorials/installing_iis_winXP_pro.asp

How to install GCJ: GNU Compiler for Java?

2010-08-30T11:44:00.000+08:00

In Windows world, there is no single GCJ installation.exe that installs GCJ.

GCJ exists inside Cygwin. So we have to install Cygwin. Detailed Step here:
http://www.mcclean-cooper.com/valentino/cygwin_install/

Cygwin contains many components. It is not a good idea to install all and fill up the harddisk. How to decide which one to install?

My feeling is, choose only those components needed.

For example, I am clear that I want to use gcj ( GNU Compiler for Java ). So in the Cygwin-setup Search box, I type in “java” keyword. I choose only Devel/gcc-java.

The good thing is, when I click Next button, all the dependencies will be automatically chosen. Hence only the minimum set of components will be downloaded and installed.

When I am using gcj, along the way I’ll hit additional error, e.g. “cannot find…” missing libraries.

Error Message:
/usr/lib/gcc/i686-pc-cygwin/3.4.4/../../../../i686-pc-cygwin/bin/ld: cannot find -liconv
collect2: ld returned 1 exit status

Then, I’ll launch Cygwin-setup again to install the missing library.

Keyword to install:
libiconv

Detect Brower Javascript Version

2010-07-13T14:42:00.006+08:00

The following Javascript will show which version of Javacript the browser supports.
http://javascript.about.com/library/bljver.htm

Surprisingly, IE8 on Windows 7 only supports up to version 1.3. No wonder some Javascripts which work on Firefox (up to 1.8), Safari and Chrome (up to 1.7) do not work on IE8.

GIMP transparent background

2010-06-25T12:27:00.000+08:00

It is quite easy to do transparent background with GIMP.

Clear demo is here:
http://www.fabiovisentin.com/tutorial/GIMP_transparent_image/gimp_how_to_make_transparent_image.asp

Note: Save as GIF (transparent background capable)

Windows 7 and Java JDK 1.6 Timezone issue

2010-04-15T17:51:00.003+08:00

Same piece of Java program running on Windows 7 and JDK 1.6, the date time related routine returns TIME ZONE :Greenwich Mean Time, which is wrong.

Insteads of going into source code level to add in timezome "GMT+8" routine, we can alter the timezone properties at command line level.

java -Duser.timezone="GMT+8" .....
or
java -Duser.timezone="Asia/Singapore" .....

Reference:
http://bugs.sun.com/view_bug.do?bug_id=6456628

Free Audio Sound Card Recorder

2010-03-17T17:43:00.000+08:00

This software, is able to record input sound into computer with various formats.

http://www.freeaudiorecorder.net/Files/FreeAudioRecorderSetup.exe

Using tips:
1. To reduce noise, set the recording volume to 10.

Powepoint PPT to Video VCD / JPG JPEG convert conversion

2010-03-14T22:30:00.006+08:00

If we really have to go somewhere with TV but without projector and computer, to give the presentation, how to do?

1) Convert PPT to Video DVD

There are a few Powepoint PPT to Video DVD convert conversion software. However, it seems all of them need to pay.

http://www.mydigitallife.info/2007/10/09/how-to-convert-powerpoint-presentation-ppt-to-video-avimpeg-flash-and-cddvd/

I am using this one:
http://www.ppt-to-video-converter.com/downloads/smart-ppt-converter-setup.exe

Note: To maintain the quality, only DVD is accepted.

2) Convert PPT to picture JPEG

Most of the DVD players today can show JPEG file. So covert PPT to picture JPEG file will do also.

Note: name of JPEG file as
01.jpg
02.jpg
03.jpg
...
10.jpg

So that the sequence of the pictures will remain in order.

GFW 翻墙技术

2010-01-21T12:59:00.000+08:00

Hotspot Shield!
http://www.hotspotshield.com/

Linux Shortcuts and Commands

2009-12-18T03:23:00.000+08:00

http://linux.about.com/od/linux101/l/blnewbie5_1.htm
http://www.unixguide.net/linux/linuxshortcuts.shtml

GIMP Animated GIF

2009-09-01T16:51:00.002+08:00

It is not quite straight-forward to do animated gif.

The following is the solution with GIMP.
http://www.csb.yale.edu/userguides/image/moviemaker/anim_gif.html

职场“冷暴力”

2009-08-24T15:27:00.002+08:00

http://www.ftchinese.com/story.php?storyid=001028296

智联招聘网站近日公布一项逾万名职场人参与的调查结果：七成以上的职场人曾遭受过职场“冷暴力”。

在这个崇尚和谐的年代，玩勇斗狠的暴力路线不再时髦，但平静海面下“潜伏”的冷暴力现象，却像泰坦尼克号遇到的冰山一角，远远一瞥，足以令人不寒而栗。初入职场的新鲜人可能会瞪大眼睛抛出疑问——什么是职场冷暴力？

所谓职场“冷暴力”，通常是指上司或同事用非暴力的方式刺激对方，导致对方情绪受挫心灵受伤的行为。打个比方，从前被皇帝抛在脑后长期不理不睬的妃子，遭遇的便是职场冷暴力，如果该妃子甚至被派去打扫庭院端茶倒水，那就是相当严重的职场冷暴力。

我有位八零后闺蜜，自从怀孕之后骤然察觉职场冷暖，在她妊娠反应最严重的怀孕初期，她的老板不仅拒绝了她在家办公的申请，而且大张旗鼓地招聘新人接替她的工作。刚招到人没两天，便要求她抓紧完成工作交接，提前回家“享受”产假外的无薪长假——“不用着急，生孩子是大事，哺乳期结束再回来上班也来得及！”大肚子的闺蜜二话不说收拾东西乐颠颠回家，回过味儿来又忍不住碎碎念——他们这是为我好呢？还是想赶我走呢？

我说，都这么赤裸裸的职场冷暴力了，明摆着想把你扫地出门节约成本，你还看不穿！跟善于算牌的职场前辈相比，有些八零后职场人确实显得天真了那么一点点，别人都快要胡了，自己还傻傻在旁边准备点炮。

正是这类“很傻很天真”的年轻人，往往更容易遭遇所谓的“职场冷暴力”。调查显示，职场人遭受的“冷暴力”中，被打入冷宫“不受领导重用”以44.5%的比例排在第一位，其次是“拼命工作而升职、加薪总是轮不到自己”，比例为41.2%，排在第三位的是“领导时常给自己小鞋穿”，如安排根本不可能完成的任务，比例为29.2%。

刚入职的新人，常会抱怨主管给自己分配的工作技术含量低，公司里的前辈不把自己放在眼里，汇报工作时上司态度不冷不热不置可否，并将之简单归结为“职场冷暴力”，典型言论如下：“哎，成天干活那么辛苦没人体谅，白眼倒是没少捱，真不想在这种充满冷暴力的环境中继续呆下去了！”

其实仔细想想，以上种种算是真正的“职场冷暴力”吗？很多时候，让你做小事是为了奠定做大事的基础，不把你放在眼里是因为你什么都不会，汇报工作收效不佳是因为你没领会领导意图，而不是什么人成心跟你过不去。在这种情况下，与其抱怨遭遇“职场冷暴力”，不如以开放性的状态加强人际沟通和学习，努力提高自身能力和素养，尽快赢得别人的尊重和认可。

真正可怕的职场冷暴力，往往是针对强者的。因为你强，才会招致同事嫉妒，因此遭遇不动声色的联合抵制。在这种情况下，要想跳出受人摆布的境地，只有两件事可做：一是让自己变得更强，强到别人的冷暴力无法阻挡你前进的步伐。二是学会站队的艺术，选择和能够帮助自己的同事和上司站在一起，找到适合自己的位置才能立于不败之地。

所以，当传说中的职场冷暴力发生在你身上时，如果你是弱者，不要抱怨，你所要做的就是努力提高自己的战斗力；如果你是强者，不要惧怕冷暴力的袭击，因为这是你锻炼人际艺术的最佳实战机会，也是通往成功之路的必要考验。

Renew Singapore PR

2009-08-24T15:24:00.006+08:00

With SingPass and Credit Card,
Singapore PR can renew Re-Entry Permit and update new passport number via the following website:

http://www.ica.gov.sg/page.aspx?pageid=152&secid=150
https://erep.ica.gov.sg/erep/index.do

Fill in everything online. So convenient!!!!

Renew Malaysia Passport

Revelent website: http://www.imi.gov.my/index.php?option=com_content&view=article&id=47%3Apma&catid=34%3Apasport&Itemid=34&lang=en

Items to bring:
* Print out the form, 2 sided in 1 paper.
* 2 blue background head photo.
* 1 IC front/back copy in 1 page.
* RM300 for 5 years.

Steps:
1. Go to the queue number counter. The officer will give you form if you haven't prepared and verified your items. Then he will give you queue number.
2. Wait for calling. Submit Form, 2 blue background photo and 1 IC copy.
3. Wait for calling. Submit RM300 payment. You'll get a receipt. The receipt will tell you when the new Passport is ready.
4. Come back 1 hour later, to collect the new Passport.

China Travel Visa application

Revelent website: http://www.visaforchina.com.sg/SGP_EN/

Items to bring:
1. Fill in the ONLINE APPLICATION FORM. At the end it will produce PDF document. Print it out.
2. 1 white background head photo.
3. 1 passport copy.
4. 1 IC front/back copy.

Submit the above items to http://www.visaforchina.com.sg/SGP_EN/others/249388.shtml

Show / Extract content from HttpServlet request

2009-07-17T15:54:00.002+08:00

The following code will extract HttpServlet request content.

System.out.println("DUMP HttpServletRequest");
java.util.Enumeration parmNames = request.getParameterNames();
int index=1;
String tem, values[] ;
int temLen; // Length of the tem String array.
while (parmNames.hasMoreElements())
{
tem = (String)parmNames.nextElement();
values = request.getParameterValues(tem);
temLen = values.length;
System.out.print("[" + (index++) + "][" + tem + "][");
for (int i=0; i < temLen; i++)
{
if (i==0)
{
System.out.print(values[i]);
}
else
{
System.out.print(", " + values[i]);
}
}
System.out.println("]");
}

index=1;
System.out.println("DUMP HttpServletRequest Attribute");
java.util.Enumeration attrNames = request.getAttributeNames();
index=1;
while (attrNames.hasMoreElements())
{
tem = (String)attrNames.nextElement();
System.out.println("[" + (index++) + "][" + tem + "][" + request.getAttribute(tem).toString() + "]");
}

Loops in Shell

2009-06-22T15:03:00.000+08:00

http://www.softpanorama.org/Scripting/Shellorama/Control_structures/loops.shtml

Loops with PL/SQL

2009-06-22T14:55:00.002+08:00

http://www.adp-gmbh.ch/ora/plsql/loops.html

Running Firefox 2 and Firefox 3 in the same machine

2009-05-19T15:33:00.002+08:00

When doing website development, sometimes we need to see the page behaviour on both Firefox 2 and Firefox 3 for backward compatibility.

Refer to the following articles on how to setup both Firefox 2 and 3 running on the same machine.

http://blog.andreloker.de/post/2008/06/Firefox-2-and-3-side-by-side.aspx
http://www.command-tab.com/2008/06/18/how-to-run-firefox-2-and-3-simultaneously/

Open Citibank account in JB, Malaysia

2009-05-15T16:24:00.003+08:00

Citibank branch in Johor Bahru, Malaysia.
http://www.citibank.com/locations/ap/my/johor_bahru/johor_bahru/johor_bahru_br.htm

It opens on 2nd and 4th Saturday morning.

Saving account - RM20 deposit.
Current account (with cheque book) - RM500 deposit.

Bring:
1) IC.
2) Bank statement.
3) Working proof, e.g. employment letter.

TT:
Citibank charges RM46 commision.
Overseas bank charges RM20 commision.

Fatal error: Allowed memory size of xxx bytes exhausted

2009-03-27T15:38:00.002+08:00

Source: http://forum.mamboserver.com/showthread.php?p=56808#post56808

Fatal error: Allowed memory size of 8388608 bytes exhausted

1. Edit php.ini file and restarting Apache:

memory_limit = 32M (add the line if it is missing)

2. If you do not have access to php.ini but your webspace is able to handle ".htaccess" files. Edit .htaccess file

php_value memory_limit 32M

3. Put the following line into the PHP source file.

ini_set("memory_limit","24M");

Embed music into HTML

2009-03-01T06:23:00.002+08:00

《bgsound loop="infinite" src="http://www.sister.co.jp/pettybooka/mp3/ukulele_lady.mp3"》《/bgsound》

(Press Esc to stop the music.)

Setup Voice for Chatting Software - Microphone Boost

2009-02-05T22:31:00.005+08:00

When using Skype, MSN, etc voice chatting software, by default the sound is recorded softly and the opposite party has difficulty to listen clearly.

In Windows XP, we can enable Microphone Boost.

Go Control Panel -> Sounds and Audio Devices -> Audio tab -> [Volume] in Sound recording

Then, in Recording Control -> [Advance] -> tick [x]Microphone Boost

Enable this option will help the computer to boost up the voice. People will listen clearer.

In some of the Voice Chatting software such as Skype and VoipCheap, inside Tools -> Options -> Audio Settings.

There is a setting called "Let Skype adjust my audio settings". The feature will most likely disable the Microphone Boost which you have just set. So untick "Let Skype adjust my audio settings".

Online Chat Interface

2009-01-13T18:03:00.004+08:00

URL for creating Google Online Chat Badge
http://www.google.com/talk/service/badge/New

URL for creating MSN Online Chat Messenger
http://settings.messenger.live.com/applications/CreateHtml.aspx
(note: remember to "Allow anyone on the Internet to see my online status and send me messages")

Direct click-able link which will need client side software installed:
MSN: msnim:chat?contact=yangchengsoon@hotmail.com
Skype: skype:oraclesoon?call

Batch Convert UTF-8

2008-11-24T04:55:00.003+08:00

For i18n, multi-language web content, there is always confusion about text encoding standard, namely English(ISO-8859-1), Chinese(simplied chinese in GB2312 or traditional chinese in BIG5 format) and UTF-8.

At this point of time, I couldn't find a convinient tool to conviniently convert other encoding standards into UTF-8.

The following Unix command can do the job - iconv

To batch convert all files under the current directory, here's the combination:
find . -name "*.php" -exec iconv -f ISO-8859-1 -t utf-8 {} -o {}.new \;

Note the " \;" (that's _space_\; ... It's essential. )

Source: http://www.webmasterworld.com/forum40/1537.htm

Converting VCD to AUDIO

2008-09-22T22:33:00.005+08:00

1. Copy VCD/music.dat -> Harddisk/music.mpg
Note: Filename dat -> mpg

2. http://cn.ziddu.com/downloadfile/231937/TMPGEnc2.5.zip.html

- Top Left Pane: Load Audio source Harddisk/music.mpg
- Bottom Pane: Output file name: Harddisk/music.mp2

- Right Pane: select ES(Audio only)

- Click [Setting], select Stream type=MPEGII, Channel mode=Dual channel, click [OK]
- Then click "Start"

3. http://cn.ziddu.com/download/231933/audacity-win-1.2.6.zip.html

- File -> Open Harddisk/music.mp2

- Click on the location "AVSEQ11", select Split Stereo Track.
- Then you'll see the track seperated to left channel on top and right channel at the bottom.
- [Mute] the channel which you don't want.

- Highlight the portion of the track which you want to save - use mouse to click on the track and drag
- File -> Export Selection as MP3

4. Using Windows Media Player to play mp3 file.

Click Burn tab.

Online Radio Software

2008-08-22T12:59:00.001+08:00

3 online radio software:

龙卷风网络收音机
http://cradio.cn/

飞狐网签
http://www.nofox.com/

TapinRadio
http://www.raimersoft.com/tapinradio.aspx

Business Domain Knowledge

2008-08-08T11:32:00.002+08:00

Commercial Lending
+ Enterprise Loan
+ Pte Ltd Loan

Consumer Lending
+ Secured (10 years)
+ Unsecured (Payslip), e.g. GE Money

Consumer Banking - Credit card + Bank Account

Treasury - Speical Customer + Personal Banker

Capital Market - Share

Trade Finance - 交易，借钱，贸易, Trading Futures, Forex.

AVG8 Command line scanner

2008-07-21T12:40:00.000+08:00

avgscanx /HEUR /SCAN /ARC /RT /NOBREAK /NOBOOT /NOMEM /NOHIMEM target.file

System Tools

2008-07-15T18:00:00.002+08:00

View and Edit Startup programs:
http://cn.ziddu.com/downloadlink.php?uid=cK%2BbmZapba%2BZ4palaLKWlJuiaa%2BdmZ0%3D8

Process Explorer:
http://cn.ziddu.com/downloadlink.php?uid=Za6impqra66hluKnZKqhkZSsYauem52o4

Auslogics Disk Defrag:
http://www.auslogics.com/en/downloads/disk-defrag/disk-defrag-setup.exe

Joomla 中文化日期乱码

2008-04-18T11:23:00.004+08:00

中文化的Joomla版本，文章的日期显示乱码，例如 2008/04/18, ????

可能的解决方法是，

全局配置－>语言及时区－>国家代码:
输入zh_CN.UTF8

Default was en_GB

备注：
控制日期格式的设定在 JOOMLA_ROOT\language\(language).php

Keyword:
_DATE_FORMAT_LC

Joomla Template CSS Reference

2008-04-03T11:42:00.002+08:00

CSS Universal Selector

2008-03-14T12:39:00.000+08:00

* {
border: 1px solid black;
}

mosLoadModule style option

2008-03-11T11:09:00.002+08:00

mosLoadModule( ..., $style)

$style can be:

0: Modules are displayed in a table with a single row and column. This is the default setting, and you will never really need to use it.

1: Modules are displayed in a table with multiple column rows, giving it the effect of being displayed horizontally, rather than vertically like the default.

-1: Modules are displayed in plain text output, without title.

-2: Modules are displayed wrapped in a single < div > tag, with title in < h3 > header tag.

-3: Modules are displayed wrapped in several < div > tags with title in < h3 > header tag allowing more complex CSS styling to be applied, such as stretchable, rounded corners.

There is another way to control menu module output:

Module -> Site Modules -> Main Menu
Menu Style = Flat List

Example: Top Menu, Lastest News and Popular link menus are already using Flat List option.

Examples of web design company

2008-02-22T18:03:00.002+08:00

They are able to effectively use SEF and design Templates.

http://www.efusiontech.com/Portfolio.html
http://www.hyper3media.com/

iProber - PHP探针

2008-02-22T17:40:00.001+08:00

Source: http://www.joomlagate.com/component/option,com_smf/Itemid,31/topic,1524.msg6120/#msg6120

今天收到 Lunarpages 的通知，即日起他们的 Basic Plan 的虚拟主机空间增大到 1500GB（注意：没有小数点！），而价格还是 6.95美元/月！

Jaleo: 用探针看看服务器剩余空间就知道是不是真的

比如 anhosting主机“Many people get suspended when they try to use more than 30GB of storage on a overseller.”

硬盘一般为2*500GB 大多数共享主机都是这样的配置少数有2TB，一个用户给1500GB是不可能的，有些主机商提供的是无限制的空间和流量，是不是可以无限制的使用？
在国外大多数人都知道这是overselling，"an overseller is a host that offers more than they can offer. For example. A web host cannot provide each user with 50GB of storage let alone 500GB of storage."

国内大多数人都不理解，所以有误解，最终导致帐户被封。

Hostmonster 我用过半年，期间我试过占用了50GB空间，结果几个月后被警告，只得删除。

Hostony 我用了1年，我占的空间最大，有80GB（他们提供400GB的空间），但是服务器剩余空间只有可怜的4G，每次快用完的时候，服务器的cpanel就崩溃了，因为没有剩余空间了，管理员都会删除一些服务器上不用的文件，苦苦支撑了几个月后，实在没有办法，告诉我让我清理自己的空间，我只能删除了60GB，这个主机商算客气了，其它的主机商都是毫不客气的suspend。

PHP探针下载: http://depoch.net/download.htm

[Joomla] 英文版Joomla!支持中文的解决之道

2008-02-22T16:21:00.001+08:00

Source: http://www.pccto.com/bbs/t600/

1，前台中文化
2，UTF-8支持
3，后台英文，跟随官方升级
4，没有乱码

以最新稳定版Joomla 1.0.12 为例，下载最新官方版本。

英文版Joomla完美支持中文

来自Joomla之门的白建鹏为我们带来了这篇非常实用及时的文章，本站在更换系统时用的就是英文原版的Joomla加前台中文，不过并没有严格按照下述步骤进行改动，因为那时我们白老弟的这篇文章还没有写出来呢，不过现在好了，有这方面需求的朋友可以参考这篇文章了。

版权原站所有。原文地址：http://www.joomlagate.com/content/view/20/29/
按理来说，我们要支持中文，直接安装Joomla中文版就可以了。没有必要这么费神研究让英文版来完美支持中文。不过，确实存在这样一种需求：可能是合资公司，为了网站维护人员的方便，后台必须是英文界面，而前台要发布中文内容；或者管理员可能是Joomla发烧友，一心想得到最新的Joomla核心，那么安装英文版就能做到网站核心随时与官方核心同步。比如，我的两个网站，“杏林书香网”和本站即是如此。

当然了，这个方法的创始者并非我，而是我的好友AutoIt。我想大家对这个名字应该很熟悉，如果你是新手，那么一定要去AutoIt 大侠的网站去补补课，顺便表达一下对这位中国Joomla前驱者的尊敬。

言归正传，我下面简单介绍一下这个方法：

第一步：思路
我们知道，英文原版Joomla 1.0.x 版本只支持ISO-88590-1语言编码（1.5版本不适合或者不需要看本文，据说完美支持UTF-8编码）。如果有人说他也能输入中文，那是因为中文也以该编码输出了。我们的目的是支持UTF-8编码的中文。当然，偏爱GB2312编码的用户可以参考本文。

还有一个问题必须注意，就是在英文原版Joomla安装时，会询问是否载入示范数据，默认是载入，而且一般人都会选择载入。这样你才能看清楚Joomla的结构，对于新手来说很有必要这么做。但是，该“示范数据”的SQL文件本身就是ISO-88590-1编码的，因此也需要转换。

英文原版Joomla的前台也是英文界面。我们要汉化前台，必须使用中文语言包。这就需要“拿来主义”一下，我们选择台湾Joomla中文站的汉化版Joomla，从中提取中文前台语言包。

第二步：操作
注：此方法由AutoIt总结，白建鹏执笔记录。感谢AutoIt摸索出的先进经验！
1、下载 Joomla 1.0.11 英文版安装包，最好是 zip 格式；
2、安装一个 FTP 工具（如 FlashFXP 3.4 中文版）；
3、上传安装包到网站根目录并解压。如果没有解压权限可以请求管理员帮你解压。否则只能在本地解压后上传；
4、不要开始安装！先从中文版Joomla 1.0.11 版本中提取3个中文前台汉化文件
simplified_chinese.php
simplified_chinese.ignore.php
simplified_chinese.xml
这三个文件位于 /language 目录下面。
打开 simplified_chinese.php 文件并设置编码为 utf-8 。方法：
查找
/** templates/*.php */
DEFINE('_ISO','charset=UTF-8');
DEFINE('_DATE_FORMAT','Y-m-d'); //Uses PHP's DATE Command Format - Depreciated /**
这一段代码，将 charset 的值设置成为 utf-8 即可；
然后用FTP软件上传这三个文件到你网站的 /language 目录下面。
5、修改前台、后台模板，使其能够正确显示 utf-8 编码的中文。方法：
打开前台模板的 index.php 文件（位置 /templates/rhuk_solarflare_ii），找到
原始代码
<meta http-equiv="Content-Type" content="text/html; <?php echo _ISO; ?>" />
这一行代码，修改为
修改后代码<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
并移动到紧跟 <head>标签之后。
同样方法修改后台模板的 index.php 文件（位置：/administrator/templates/joomla_admin/
）。提醒：如果网站开通后下次更换模板，不论是前台还是后台，都要在上传之后立即按上述方法修改代码，使其接受 utf-8 编码，然后才能启用该模板。否则所有内容变成乱码！

6、修改joomla.php文件（位置 /includes）的1018行左右。
原始代码
if (!$username || !$passwd)
{ echo "<script> alert (\""._login_incomplete. "\"); ......
在 if 这行下面加：
修改后代码 header('content-type:text/html; Charset=UTF-8');
也可能在 function mosErrorAlert 这个函数里.
原始代码
function mosErrorAlert( $text, $action='window.history.go(-1);', $mode=1 ) {
$text = nl2br( $text );
$text = addslashes( $text );
$text = strip_tags( $text );
switch ( $mode ) {
case 2:
header('content-type:text/html; Charset=UTF-8');
echo "<script>$action</script> \n";
break;
case 1:
default:
header('content-type:text/html; Charset=UTF-8');
echo "<script>alert('$text'); $action</script> \n";

6、将 /installation/sql/下的 joomla.sql 及 sample_data.sql 转换为UTF-8编码格式。

7、申请一个 gmail 的信箱，这个信箱将成为网站管理员专用信箱，用来发送会员通知，收取访客反馈等等。建议使用网站域名作为信箱帐户。（如果你没有gmail信箱的注册邀请，可以到本站论坛发布申请，我们有大量邀请向会员发放，先到先得，呵呵）

8、在浏览器地址栏输入 http://www.yoursite.com （注意，这是举例，你需要替换为你自己的网站URL）即可看到安装画面，按照提示一步一步安装；安装完成后看看根目录下的 configuration.php 文件，如果不是 utf-8 编码，也要改成 utf-8 编码。然后进入后台开始安装其他组件。

为了方便大家体验，我已经把1～6的步骤几乎替你完成了，在本站下载栏目，你可以找到修改版的Joomla 1.0.11英文版，上述修改均已经做过。你只需要上传到你的网站，直接开始安装即可。当然，我制作的版本支持的是UTF-8编码，喜欢gb2312编码的用户只好自己按照上述步骤亲手打造了。

顺便说明一下，我提供的这个版本是根据最新的SVN打包的，实际上已经是 1.0.12 开发版了，因此喜欢尝鲜的朋友可以用，注重安全的还是不要采用，直接到官方网站下载1.0.11英文版，毕竟SVN版本经常会有一些漏洞。

Joomla 1.0.12 中文版安装，彻底解决乱码问题

摘自：苏武的BLOG http://zhangxueqing.blog.sohu.com/41701091.html
今天是个好日子，继刚刚发布的《Joomla_1.0.12安装手记》之后，本来想休息一下，再研究该安装手记中未解决的问题，即初始安装Joomla 1.0.12 中文版，彻底解决乱码问题，下午闲来无事，手痒，便决定趁热打铁，没想到很容易大功告成！
还是先说一下初始环境：
Windows平台+Apache2.0.55+php5.1.1+MySQL5.0.27+phpMyAdmin2.9.1.1+ZendOptimizer3.2.0+Joomla_1.0.12-RC1-Full_Package(Chinese).tar.gz
其中对于MySQL和phpMyAdmin的配置不再进行任何限制，而Joomla_1.0.12-RC1-Full_Package(Chinese).tar.gz文件可以到Joomla台湾站点去下载，这里提供一个链接：http://rt.openfoundry.org...l_Package(Chinese).tar.gz

下面说一下安装过程：
1、下载Joomla_1.0.12-RC1-Full_Package(Chinese).tar.gz文件，解压缩到站点的一个文件夹下，比如是joomla文件夹。

2、修改includes文件夹下的database.php文件，找到该行：
//@mysql_query("SET NAMES 'utf8'", $this->_resource);
在其下加入如下两行：
@mysql_query("SET NAMES 'utf8'", $this->_resource);
@mysql_query("SET CHARACTER SET UTF8", $this->_resource);
存盘，切记要用UltraEdit打开，且不要修改该文件的编码格式，以下的修改皆如此！

2、修改installation/sql/sql_simplified_chinese文件夹下的joomla.sql文件（假设joomla安装时选择的是简体中文，如果要选择其它语言安装，则同样的方式修改相应语言文件夹下的文件），寻找关键字#__poll_data，在其下大约是第六行，可以看到如下：
`text` text NOT NULL default ''，
把它修改为：
`text` text NOT NULL，
在该文件内进行以下全局替换，把：
TYPE=MyISAM
替换为：
TYPE=MyISAM CHARSET=utf8
寻找关键字#__core_acl_aro，修改以下行：
CREATE TABLE `#__core_acl_aro` (
`aro_id` int(11) NOT NULL auto_increment,
`section_value` varchar(240) NOT NULL default '0',
`value` varchar(240) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`aro_id`),
UNIQUE KEY `section_value_value_aro` (`section_value`,`value`),
UNIQUE KEY `#__gacl_section_value_value_aro` (`section_value`,`value`),
KEY `hidden_aro` (`hidden`),
KEY `#__gacl_hidden_aro` (`hidden`)
) TYPE=MyISAM CHARSET=utf8;
改为：
CREATE TABLE `#__core_acl_aro` (
`aro_id` int(11) NOT NULL auto_increment,
`section_value` varchar(240) NOT NULL default '0',
`value` varchar(240) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`aro_id`),
# UNIQUE KEY `section_value_value_aro` (`section_value`,`value`),
# UNIQUE KEY `#__gacl_section_value_value_aro` (`section_value`,`value`),
KEY `hidden_aro` (`hidden`),
KEY `#__gacl_hidden_aro` (`hidden`)
) TYPE=MyISAM CHARSET=utf8;
ALTER TABLE `#__core_acl_aro` CHANGE `section_value` `section_value` VARCHAR( 240 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '0';
ALTER TABLE `#__core_acl_aro` CHANGE `value` `value` VARCHAR( 240 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '';
ALTER TABLE `#__core_acl_aro` ADD UNIQUE `section_value_value_aro` ( `section_value` , `value` );
ALTER TABLE `#__core_acl_aro` ADD UNIQUE `#__gacl_section_value_value_aro` (`section_value`,`value`);
存盘！

3、修改installation/sql/sql_simplified_chinese文件夹下的sample_data.sql文件，查找关键字#__contact_details，找到该行：
INSERT INTO `#__contact_details` VALUES (1, '姓名', '职称', '住址', '市/镇', '省/市', '国家/地区', '邮递区号', '电话', '传真', '其它连络资讯', 'asterisk.png', 'top', 'email@email.com', 1, 1, 0, '0000-00-00 00:00:00', 1, '', 0, 12, 0);
改为：
INSERT INTO `#__contact_details` VALUES (1, '姓名', '职称', '住址', '市/镇', '省/市', '国家/地区', '区号', '电话', '传真', '其它连络资讯', 'asterisk.png', 'top', 'email@email.com', 1, 1, 0, '0000-00-00 00:00:00', 1, '', 0, 12, 0);
其实只是把其中的“邮递区号”改为“区号”！
存盘！

4、进入到phpMyAdmin中，建立一个数据库，比如是joomla，其中字元整理选择utf8_general_ci

5、开始安装Joomla，根据安装向导一步一步进行，当要选择数据库名称时，输入第4步建立的数据库名即可。

结束语：
安装joomla是一件闹心的过程，经过多次实践，终于完成，感谢在网上提供了很多文章和帮助的网友，自己的心得也不能独享，奉献给大家！
现在回想起来，其实都是MySQL和phpMyAdmin的字元校正闹的，按照以上步骤安装，joomla的数据库编码格式是utf8的，而且也不再用修改phpMyAdmin的配置，在phpMyAdmin下能够看到joomla数据能够正常显示，也可以用phpMyAdmin正常地导入和导出，joomla前台显示也完全正常！省去了以后的很多麻烦！

[Joomla] sef化后, 结尾增加.html 的方法

2008-02-22T15:14:00.001+08:00

Source: http://www.fticc.com/blog/?action_viewthread_tid_55.html

/includes/sef.php

18行左右:
$url_array = explode('/', $_SERVER['REQUEST_URI']);

替换为：
$url_array = explode('/', $_SERVER['REQUEST_URI']=str_replace(".html","",$_SERVER['REQUEST_URI']));

搜索下行代码第一个出现的地方[约在513行左右]
// allows SEF without mod_rewrite

在其上面增加
if(!strcasecmp(substr($string,-1),"/"))$string=substr($string,0,-1);
if($string!="")$string.=".html";

ok. 这样,你的也就有了这个 .html 的尾巴了...

不一定适合所有的组件. 如果你刚好碰到了可能要用下面的样子来替换上面的两行:
if (!eregi("com_docman",$string)){
if(!strcasecmp(substr($string,-1),"/"))$string=substr($string,0,-1);
if($string!="")$string.=".html";
}
注意: 上面代码里出现的 com_docman 就是在com_docman 里不加这个尾巴.你的看着改.

其实我用的是：
$string=substr($string,0,-1);
$string.=".html";
都没加判断...因为我用的东西也不多，使用过程没发现异常... ^_^

Changing Toplink connection

2008-01-29T15:22:00.000+08:00

When changing Toplink to talk to another database, the following 3 files need to be touched.

1) model\src\META-INF\TopLinkMap.xml
toplink:login xsi:type="toplink:database-login"

2) model\src\META-INF\sessions.xml
login

3) model\toplink\TopLinkMap\TopLinkMap.mwp
login-infos

Premature end of script headers

2007-12-17T14:32:00.002+08:00

Sometimes we upload the whole PHP web application folder onto the share hosting environment, e.g. /xxx/public_html/phpapp.

However, when we access http://www.xxx.com/phpapp, there is 402 or 500 Internal Error.

Checking the backend log, the error message is:
"Premature end of script headers"

Solution: we need to chmod the whole phpapp directory recursively to the following read write access.

Command Line: chmod 745 -R /xxx/public_html/phpapp

HTML Color Code

2007-12-05T15:33:00.000+08:00

Reference: http://www.w3.org/MarkUp/Guide/Style

FFF

FFF

CCC

CCC

999

999

666

666

333

333

000

000

FFC

C00

FF9

900

FF6

600

FF3

300

99C

C00

CC9

900

FFC

C33

FFC

C66

FF9

966

FF6

633

CC3

300

CC0

033

CCF

F00

CCF

F33

333

300

666

600

999

900

CCC

C00

FFF

F00

CC9

933

CC6

633

330

000

660

000

990

000

CC0

000

FF0

000

FF3

366

FF0

033

99F

F00

CCF

F66

99C

C33

666

633

999

933

CCC

C33

FFF

F33

996

600

993

300

663

333

993

333

CC3

333

FF3

333

CC3

366

FF6

699

FF0

066

66F

F00

99F

F66

66C

C33

669

900

999

966

CCC

C66

FFF

F66

996

633

663

300

996

666

CC6

666

FF6

666

990

033

CC3

399

FF6

6CC

FF0

099

33F

F00

66F

F33

339

900

66C

C00

99F

F33

CCC

C99

FFF

F99

CC9

966

CC6

600

CC9

999

FF9

999

FF3

399

CC0

066

990

066

FF3

3CC

FF0

0CC

00C

C00

33C

C00

336

600

669

933

99C

C66

CCF

F99

FFF

FCC

FFC

C99

FF9

933

FFC

CCC

FF9

9CC

CC6

699

993

366

660

033

CC0

099

330

033

33C

C33

66C

C66

00F

F00

33F

F33

66F

F66

99F

F99

CCF

FCC

CC9

9CC

996

699

993

399

990

099

663

366

660

066

006

600

336

633

009

900

339

933

669

966

99C

C99

FFC

CFF

FF9

9FF

FF6

6FF

FF3

3FF

FF0

0FF

CC6

6CC

CC3

3CC

003

300

00C

C33

006

633

339

966

66C

C99

99F

FCC

CCF

FFF

339

9FF

99C

CFF

CCC

CFF

CC9

9FF

996

6CC

663

399

330

066

990

0CC

CC0

0CC

00F

F33

33F

F66

009

933

00C

C66

33F

F99

99F

FFF

99C

CCC

006

6CC

669

9CC

999

9FF

999

9CC

993

3FF

660

0CC

660

099

CC3

3FF

CC0

0FF

00F

F66

66F

F99

33C

C66

009

966

66F

FFF

66C

CCC

669

999

003

366

336

699

666

6FF

666

6CC

666

699

330

099

993

3CC

CC6

6FF

990

0FF

00F

F99

66F

FCC

33C

C99

33F

FFF

33C

CCC

339

999

336

666

006

699

003

399

333

3FF

333

3CC

333

399

333

366

663

3CC

996

6FF

660

0FF

00F

FCC

33F

FCC

00F

FFF

00C

CCC

009

999

006

666

003

333

339

9CC

336

6CC

000

0FF

000

0CC

000

099

000

066

000

033

663

3FF

330

0FF

00C

C99

009

9CC

33C

CFF

66C

CFF

669

9FF

336

6FF

003

3CC

330

0CC

00C

CFF

009

9FF

006

6FF

003

3FF

Color swatches for the browser safe palette are available free for many popular graphics packages, from www.visibone.com.

Firefox extension

2007-12-04T16:47:00.005+08:00

Windows Resizer
https://addons.mozilla.org/en-US/firefox/addon/1985

Firebug
https://addons.mozilla.org/en-US/firefox/addon/1843

HttpFox: An HTTP analyzer addon for Firefox
https://addons.mozilla.org/en-US/firefox/addon/6647

CSSViewer
https://addons.mozilla.org/en-US/firefox/addon/2104

Web Developer
https://addons.mozilla.org/en-US/firefox/addon/60

NoScript
https://addons.mozilla.org/en-US/firefox/addon/722

ScribeFire Blog + HTML Editor
https://addons.mozilla.org/en-US/firefox/addon/1730

FireShot
http://screenshot-program.com/fireshot/

Oracle AS Startup & Shutdown script

2007-12-04T13:55:00.000+08:00

Reference: http://terrencemiao.com/Webmail/msg00898.html

Environment File: infraenv
export ORACLE_SID=if
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/Infra101202
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:/lib:/usr/lib:/usr/local/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:
$ORACLE_HOME/network/jlib
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:
$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin

Start Script:
[oracle@host]$ cat start1012.sh
#1. Start Infra DB.
source infraenv
$ORACLE_HOME/bin/lsnrctl start

SQLDBA="$ORACLE_HOME/bin/sqlplus /nolog"
$SQLDBA <connect / as sysdba
startup
EOF

#2. Start Infra AS.
$ORACLE_HOME/opmn/bin/opmnctl start
$ORACLE_HOME/opmn/bin/opmnctl startproc
$ORACLE_HOME/bin/emctl startifdown iasconsole

#3. Start Midtier
source asenv
$ORACLE_HOME/opmn/bin/opmnctl start
$ORACLE_HOME/opmn/bin/opmnctl startproc
$ORACLE_HOME/bin/emctl startifdown iasconsole

Stop Script:
[oracle@host]$ cat stop1012.sh
#1. Stop Midtier
source asenv
$ORACLE_HOME/bin/emctl stop iasconsole
$ORACLE_HOME/opmn/bin/opmnctl stopproc
$ORACLE_HOME/opmn/bin/opmnctl shutdown

#2. Stop Infra AS
source infraenv
$ORACLE_HOME/bin/emctl stop iasconsole
$ORACLE_HOME/opmn/bin/opmnctl stopproc
$ORACLE_HOME/opmn/bin/opmnctl shutdown

#3. Stop DB.
SQLDBA="$ORACLE_HOME/bin/sqlplus /nolog"
$SQLDBA <connect / as sysdba
shutdown immediate
EOF

$ORACLE_HOME/bin/lsnrctl stop

折信纸

2007-11-28T18:02:00.000+08:00

难得手写了一封信，想折美美送。上网google"折信纸"，想不到折信纸法不只很难找，而且很复杂啊～不只信纸可能会让我折烂，对方在打开时撕破了怎么办？

http://www.wen8.net/html/969.htm
http://tw.myblog.yahoo.com/f0931115850/article?mid=36
http://www.hsm.com.cn/news/2005/1227/68/10858.shtml
http://www.ghh.com/elf/

我还是简单点两边对折就好了... ...

Create user in MySQL

2007-11-22T15:08:00.000+08:00

(Ref: http://dev.mysql.com/doc/mysql/en/default-privileges.html)

1. Secure root user account
shell> mysql –u root
mysql> SET PASSWORD FOR 'root'@localhost=PASSWORD('mypass');

2. Create app database and user.
shell> mysql --user=root --password=mypass mysql
mysql> create database mydb;
mysql> GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'localhost' IDENTIFIED BY 'mypass2' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' IDENTIFIED BY 'mypass2' WITH GRANT OPTION;

3. Backup database.
mysqldump -u root -pmypass --complete-insert=TRUE -x mydb > mydb.sql

斗嘴

2007-11-20T17:48:00.000+08:00

编程的过程单调平淡，所以故意找个题目去找公司里资深的软体设计师斗嘴。公说公有理，婆说婆有理，其实讨论并没有所谓的对错。。。　或许是我没理，或许设计师先生觉得我很无聊，老咬着一个主题不放，平常温文尔雅的先生竟然突然提高声量来驳斥我，令我顿愕。

状况使人成长。对于这个事件我有很多联想：
1. 如果说资深是权威，那么有些权威是不喜欢被挑战的。
2. 因为他是长辈，或许还有优越感，所以他会对小辈大声驳斥。
3. 公司的管理层都是长辈和优越者呀，所以指令才会由上而下一面倒。

这里有没有存在谁对谁道歉的问题？我觉得由于理由１和２，所以他不会道歉。而且他可能本来就是故意大声教训我，让我闭嘴。而我是就事论事，我也不存在道歉的动机。所以我们两个人都不会道歉的。

不过错肯定是在我，因为我本来就不应该带着斗嘴的目的去忽悠别人，那怕我是就事论事。

我觉得我很不成熟，同时不明白人情世故，太过自以为是了。

真正成功的讨论，是使用言语达到目的，而不使对方恼怒。

Change Rename hostname for Oracle Application Server Midtier

2007-06-18T16:39:00.000+08:00

Reference: http://download-west.oracle.com/docs/cd/B25221_03/core.1013/b25209/host.htm#sthref485

It is ok to change / rename hostname for Oracle Application Server Infrastructure and Midtier. However documentation says it does not support Oracle AS with Metadata Repository.

Simply execute the following command to change hostname for Midtier.
% $ORACLE_HOME/chgip/scripts/chgiphost.sh -mid

The script is clever enough to pick up the host information. So you just need to accept the default prompt 4 times, that's it.

Oracle SQL command to create user

2007-06-07T14:22:00.000+08:00

Since everytime I'll forget the exact commands, I shall record it here.

The following is the simplest way to create an Oracle user:

-- 1. Create Tablespace "MYDB"
CREATE TABLESPACE "MYDB"
LOGGING DATAFILE '/u02/oradata/ora10gdb/mydb.dbf'
SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

-- 2. If temporary table space is needed, script to create temporary table space.
CREATE TEMPORARY TABLESPACE "TEMPORARY"
TEMPFILE '/u02/oradata/ora10gdb/TEMPORARY.dbf'
SIZE 50M
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 10M;

-- 3. Create User "MYDB"
CREATE USER "MYDB" PROFILE "DEFAULT" IDENTIFIED BY "MYDB"
DEFAULT TABLESPACE "MYDB" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "MYDB";
GRANT "RESOURCE" TO "MYDB";

Upgrade OracleDB

2007-04-18T19:18:00.000+08:00

In a project I was requested to install Oracle SOA Suite 10g (10.1.3.1.0).

It is interesting that my colleagues simply knew I need to upgrade an existing OracleDB to higher version. But when I asked where do I find the documentation regarding the upgrade, they replied they hit an error before and they solved it but they didn't remember where's the documentation.

Anyway, the summary is, documentation does exist. You may go http://otn.oracle.com/ -> Documentation -> Oracle Application Server -> etc. Please reference the following link for the corresponding OracleDB that is required by SOA Suite 10g installation:
http://download-uk.oracle.com/docs/cd/B31019_01/install.1013/install/reqs.htm#CHDEAICG

% sqlplus sys/password as sysdba
SQL> select version from product_component_version where product like 'Oracle%9i%' or product like 'Oracle%Database%';

The existing OracleDB is 10.1.0.4. How do I upgrade it to 10.1.0.5?

Steps to find patch for upgrading OracleDB:

1. Login http://metalink.oracle.com
2. Go to [Patches & Upgrades] tab.
3. Select "Advanced Search".
4. Search with the following options:

* Product Family: RDBMS Server
* Release: Oracle 10.1.0.4, 10.1.0.5

5. Then, a list of related items are returned.

I want to upgrade OracleDB 10.1.0.4 to 10.1.0.5, which one is the right one? Siva simply suggested me to use "4505133 - Oracle Database Family: Patchset 10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER". I asked him, how do you know is this one? He replied, you click the readme file, then you'll know everything. Magic. Anyway, I trust him, so I just simply download patch 4505133.

Here you go. Upgrade patch is bundled in OUI (Oracle Universal Installer) format. So we simply shutdown all database processes and execute "./runInstaller". OracleDB will be upgraded beautifully.

YAH Batch 3 Anniversary

2007-04-14T22:44:00.000+08:00

April 14, Saturday was a busy day. Today was the opening day of YAH Community College Batch 6 at Center for Seniors in Bishan Junction 8. Started from 8am, volunteers and facilitators had started to prepare and welcome students.

Reception

Student coming.

12 April 2006 was the day all the Batch 3 facilitators got together. So we decided to have an anniversary gathering on same day 14 April 2007. After lunch in Junction 8 food court, Bao Xuan drove May Ying and me together to East Coast Park Island Resort.

Inside chalet

While we were waiting for the rest to arrive in the evening, we have an informative chat. I learned 2 tips to become good boyfriend/husband from Bao Xuan, haha...

Around 6:30pm, more people and food arrived. The buffet was ordered by May Ying. The presentation looked good and the food was tasty. Yue Feng had also prepared Mo Mo Cha Cha dessert.

This was a rare gathering. We had some new friends, husband and wife coming. Everybody ate ate and chat chat. Then, it was ice-breaking cum team-building game time. Soon prepared 3 games, they were (1) Guess who am I? (2) Phoenix Hall of Fame and (3) Memorized Puzzle.

Game1: Guess who am I?

Game2: Phoenix Hall of Fame

Game3: Memorized Puzzle

Aiyo... it was not easy to control the crowd. Players started to act before Soon finished explaining. They argued with the rules or they refused to accept the “prizes”. Haha... quite messy.

Refuse to accept the Prize

As we were facilitators, we had the debrief session after the activities. Somehow somebody had opinions and somehow ended up Soon went on stage to sing. Bee Yew the potential future facilitator was involved also.

After game debrief

Bee Yew and Soon sang on the stage

Finally, the event was ended. Hopefully everybody had a happy and memorable night.

For the complete photo album, visit here:
http://picasaweb.google.com/yangchengsoon/070414YAHBatch3Anniversary

2 tips to become good boyfriend/husband

2007-04-14T16:16:00.000+08:00

Tips # 1: 了解和让着她。不是讲讲而已，是真的了解那种。

由于本人性格比较随和，多数事情不太计较。有一次出国旅行找旅店的时候，有朋友十分小心翼翼的审查睡床表面干不干净，窗口对那边，地板脏不脏，房间整体的色调好不好，之类的。我看了简直不可思议，“ 喂，我们不是买房子，只是住旅店一晚，你没有必要如此斤斤计较吧？” 言下之意，就是将就一点。

我一直都不觉得自己这样有什么问题。然而，和一个女性朋友聊天之后，我才明白自己这样是太不体谅别人的性格和习惯了。

那个女性朋友天生就是一个爱干净，爱选择美观的东西，的人。如果床不舒服，冲凉房不干净，她就是睡不着，不愿洗澡，或者干脆不住进去的那种。我心里就想，哎哟，如果我带这样的一个女朋友出门真麻烦。可是！她的先生是怎样反应的？我听了感触良深。

当她和朋友要在外面过夜，她的先生听到是什么地方的时候，他十分预知的告诉她，你在那边是睡不着的啦，还是回家休息吧。哇，太了解自己的妻子了。

而且，如果他们夫妇旅行的时候，她的老公一定花费多一点，住星级旅店。哇，太体谅自己的妻子了。

这个可以学一学。

Tips # 2: 老婆是拿来疼的，不是当家里的佣人。

有时聊天谈论到找对象的时候，有时候有人会提到说，希望自己的妻子能够做家务和照顾老人小孩。

然而我的女性朋友回到丈夫婆家吃饭的时候，她的先生反而会叫他的妹妹洗碗收拾，我的女性朋友是不用动手的。先生的家里人当然会抗议嘛。她的先生就说，老婆是拿来疼的，不是当家里的佣人。

这个例子有点极端，不过做丈夫的想法却很超越。想一想，如果一个男孩子还没有结婚，到处去跟人家说希望他的妻子能够做家务，那么肯定把女孩子吓跑了嘛。难怪有人找不到女朋友了。

这一条可以参考参考。

Shell script execution - command not found, syntax error near unexpected token

2007-03-30T21:30:00.000+08:00

When we edit shell script in Windows machine, and ftp it to Linux for execution, sometimes we hit the following error:

“command not foundh” line xxx
“command not foundne” line xxx: syntax error near unexpected token `

This is due to the newline characters used on both systems. We need to replace all occurances of "\r\n" with "\n".

In vi, do the following:

// Change from (DOS) to just (Unix):
:set fileformat=unix
:w

// change back to Carriage Return + Line Feed for DOS
:set fileformat=dos
:w

// writing for apple computers:
:set fileformat=mac
:w

// remove multiple (repeated) Carriage Returns using search and replace
:%s/[^M]$//
:w

年长者的失眠症

2007-01-25T17:49:00.000+08:00

有一位年长者缺席了一堂课。我打电话去慰问她什么原因没来。她提到她有失眠问题，星期六早上觉得头晕，怕走路跌到，又不想麻烦女儿早起载她上学，所以便没来了。

我和她聊了很久，针对她的问题我给了我的意见。最后她反应道，“你的意见很新奇，我没有想过。”

因为聊了很多，她大概也记不了。所以我把重点写出来，印在纸上给她看。

问题: 白天不敢午睡，怕晚上会睡不着。常常小睡十五分钟就起身。
建议: 如果白天能够入睡，就应该敢敢睡久久。如果晚上睡不着了，就起身做事。反正都已经退休了，时间都是自己的，不用怕白天和晚上的生理时钟颠倒了。最重要的是睡的足够，睡到自然醒，睡足比药补好。

问题: 可是白天忙於做家务，不能午睡太久。
建议: 把家务事分开来。累时睡觉休息，醒了之后，就算在晚上也可以继续做家务。

问题: 晚上失眠，想看书看杂志，可是又不敢开灯，怕打扰到家人。
建议: 可以去客厅，去厨房，去厕所看书。

问题: 早上调闹钟，准时起来为家人准备早餐。
建议: 老娘今天不想早起做家务，你们自己吃面包。你不是女佣嘛，不需要做家务24小时。

问题: 已经习惯坐在书桌上看书，坐久会腰痛。躺下就会舒缓舒服。
建议: 做人不要让自己的习惯绑死，可以尝试洒脱的躺在床上看书。如果累了，书一丢，可以马上在床上睡着。

OracleAS rewrite/redirect URL to internal machine hostname

2007-01-13T02:14:00.000+08:00

Usually when we setup a machine, we’ll simply give a hostname for the machine. Then we install OracleAS on it.

When it goes live, we’ll assign a new Domain Name to point to this machine. Hence, this machine has 2 names. Internally it is machine_hostname.domain.com and externally it is host.internet.com.

From Internet when we access this machine, here comes a strange behaviour: when we login OracleAS EM (Enterprise Manager) or perform JSP/Struct/JSF Redirect in our web application, the internal machine hostname is shown up in browser. Hence the browser shows “Page cannot be displayed”.

Amazing. What’s wrong? What happens inside JSP/Struct/JSF Redirect?

Here is the culprit:

“vi $ORACLE_HOME/Apache/Apache/conf/httpd.conf”.

You see the following information:

…
ServerName machine_hostname.domain.com
…

# UseCanonicalName: (new for 1.3) With this setting turned on, whenever
# Apache needs to construct a self-referencing URL (a URL that refers back
# to the server the response is coming from) it will use ServerName and
# Port to form a "canonical" name. With this setting off, Apache will
# use the hostname:port that the client supplied, when possible. This
# also affects SERVER_NAME and SERVER_PORT in CGI scripts.
UseCanonicalName On

Observation is,
1) ServerName is hardcoded with internal machine hostname.
2) Read the explanation of UseCanonicalName, Apache use ServerName to construct a self-referencing URL.

So, we need to set UseCanonicalName off, then Apache will use the hostname:port that the client supplied.

Problem solved. Mission accomplished.

What happens inside JSP/Struct/JSF Redirect?

2007-01-13T02:05:00.000+08:00

Let’s use the following servlet to demo a redirect.

public class RedirectServlet extends HttpServlet
{
  public void service(HttpServletRequest req,
                      HttpServletResponse resp)
  {
    String contextPath = req.getContextPath();
    String redirectStr = contextPath +
                         "/nextpage.jsp?param1=value1";
    // Use encodeRedirectURL so that session id can be
    // included in browser which doesn't support cookies.
    resp.sendRedirect(resp.encodeRedirectURL(redirectStr));
  }
}

Then, we use Telnet to access this servlet:
% telnet machine_hostname 8080

Manually enter:
GET /servlet/RedirectServlet HTTP/1.0

You will get the reply:
HTTP1.1 302 Moved Temporarily
Location: http://machine_hostname:8080/webapp/nextpage.jsp?param1=value1
DATE: ...
Server: ...
Connection: ...

What to observe is that,
1) Redirect in fact is a 302 response from webserver.
2) The complete URL and Port are written out fully in the Location.

This is the reason why the internal machine hostname will be shown up in browser, when we login OracleAS EM (Enterprise Manager) or perform a JSP/Struct/JSF Redirect in our web application.

Please check how to let EM and Redirect return URL as expected-ly.

Run OHS at port 80 (HTTP) and port 443 (HTTPS)

2007-01-13T01:39:00.000+08:00

By default, OracleAS HTTP Server runs at port 7777 for HTTP and port 4443 for HTTPS.

In Linux, only root user can use port less than 1024. So, in order to have OHS runs at port 80 and HTTPS runs at port 443, we need to do the following steps:

1. As oracle user,
"cd $ORACLE_HOME/Apache/Apache/conf"

2. Edit httpd.conf
"vi httpd.conf"

Search for 7777 by ":/7777"
You see:
# This port is used when starting without SSL
Port 7777
Listen 7777

Change them to:
# This port is used when starting without SSL
Port 80
Listen 80

3. Edit ssl.conf
"vi ssl.conf"

Replace all occurance of 4443 with 443.
":1,$ s/4443/443/g" or ":%s/4443/443/g"

4. As root user, "cd $ORACLE_HOME/Apache/Apache/bin". Execute:
# chmod 777 apachectl
# chown root .apachectl
# chmod 6750 .apachectl

You'll see the following:
# ll apachectl
-rwxrwxrwx 1 oracle dba 11909 Dec 8 15:11 apachectl
# ll .apachectl
-rwsr-s--- 1 root dba 1703684 Jan 16 2006 .apachectl

Ok, done.

As oracle user, you can startup OracleAS with "opmnctl startall"
Also, you can view the status with "opmnctl status -l"

22 Dec 2006 Christmas for Folks的活动报告

2006-12-31T14:56:00.000+08:00

(懒了很久。今天心情好，赶快写一个活动报告…)

上次我自告奋勇说要加入策划服务中心的活动，22 Dec的 Christmas for Folks就是第一个。

不过后来也没有什么策划到。活动的大概一个星期前，我去服务中心找 Seow Hong 开会，Seow Hong 已经把流程都安排好了。11am布置，12 - 2pm活动。

Seow Hong说，我负责游戏就可以了。惨，我要想给年长者的游戏。年长者的行动迟缓，游戏要慢，不用移动，大家都能玩的。难过，怎样想? 而且我最怕用脑想了。幸好 Seow Hong 提议了传东西的概念，我们激荡讨论了之后，出了两个游戏。

所以活动的细节如下:
5-10分钟  牧师讲圣诞节的故事
15分钟   传气球游戏 (1)
1小时   吃午饭
15分钟   唱圣诞歌
15分钟   用吸水管传胶圈游戏 (2) (Optional)
10分钟   交换礼物

(1) 年长者随着音乐传气球。音乐停止，谁手上有气球，牧师就发问。问题来自之前讲的圣诞节故事。

(2) 分组竞争用吸水管传胶圈。(后来发现，给年长者分组其实很麻烦。不过我已经设计出一个适合团体围圆圈玩游戏的阵法。改天才写。)

过了一个平静的礼拜，活动当天，刚好也是冬至。那天风很大，布置圣诞节的饰物有点麻烦。当年长者和食物(很多食物，包括汤圆) 陆陆续续到达之后，活动开始。Seow Hong 直接把麦克风交给我，说你去主持吧。我傻眼，我几时是主持人了? 还有，牧师勒? Seow Hong 说没有牧师，直接玩传气球游戏。

要命，我没有主持经验。但说什么我都是受过 YAH 培训的催化员，所以我二话不说，就跳出去假装一下。所以之后讲话含糊不清，没有条理，中英并用，到底合不合格? 我不知道，只有 Tricia 知道。

没有牧师讲故事在先，我不知道要如何处罚年长者，要罚他们讲圣诞节故事吗? 幸好这些年长者有些是 K 歌和舞蹈高手，请他们上来唱歌跳舞，还行。主持过程中，脑里面我回忆陈树承如何主持普威之夜，所以后来我第一个问题就问他们的名字，那里来，怎样来。不然，空空洞洞的，冷场，我不知道要和年长者讲什么。

除了开头的这个意外，其他的吃午饭，唱圣诞歌，传胶圈游戏，交换礼物的流程就如计划进行。当然，进程颠簸，不过还可以。

照片:
http://picasaweb.google.com/yangchengsoon

回馈:
1. 饭，应该不要淋太多汤汁，因为纸盘都软了。
2. 如果有行动不便或记忆力不好的年长者，我们可以请义工特别盯住他们。

OracleAS1012 vs OracleAS1013

2006-12-12T10:23:00.000+08:00

A minor version difference between the number 1012 and 1013, however the underlying mechanisms and libraries have huge changes.

	AS1012	AS1013
JDK Version	1.4.2	1.5
JDBC Version	classes12.jar	ojdbc14.jar
Corresponding JDeveloper Version	JDeveloper 1012	JDeveloper 1013
Clustering	Manual joining server farm via EM	Dynamic Discovery with broadcasting address in opmn.xml
JSF Support	Need extra tweaking	Supported
WEB-INF/web.xml	(plain)	Define namespace such as xmlns:xsi, xsi:schemaLocation, etc, which is not compatible with AS1012
Misc Java libraries	Working with JDK1.4.2	Working with JDK1.5. Not completely compatible with AS1012.
Startup	opmnctl and emctl	opmnctl
Enterprise Manager	http://machine:1810	http://machine/em

The above are the list of difference I have encountered.

What it means is that, at this point of time when you develop web application, you need to explicitly synchronize Oracle AS version and environment.

For example, you use JDeveloper 1013 to develop web application and deploy it into OracleAS1013 only. If you try to deploy it into AS1012, it is very problematic. You need to manually edit web.xml and bundle older underlying libraries (such as classes12.jar) into your EAR file.

Burning CD for Linux and in Linux

2006-12-08T19:15:00.000+08:00

Reference:
1. http://linuxlab.dk/tipsntricks/cdburning
2. http://sourceforge.net/projects/jcdwriter/

Burning CD/DVD for Linux and in Linux is quite a challenging experience.

Oracle softwares are downloaded in cpio format and come in multiple disks. It is disk space and time consuming to extract each cpio each time. So, my idea is to create 1 DVD to consist of all multiple CDs, hence save the trouble to swap disks.

For example, DVD_ROOT:
+ AS1012
+ Disk1
+ Disk2
+ Disk3
+ Disk4
+ AS1013
+ Disk1

Intuitively I simply extracted cpio in Linux, ftp the extracted files to Windows, then use Roxio CD Creator to burn DVD.

Problem: Windows-burned DVD has lost the ownership and execution privilege of all files. I cannot simply “runInstaller” off the DVD. The DVD is useless.

Hence, the next plan is to burn DVD directly on Linux and hope that Linux will keep the correct execution privilege.

By default, Linux has already come with 2 command line utilities to produce CD/DVD:
1. mkisofs - create the iso image of the files.
2. cdrecord - burn CD from iso image.

There are 3 steps to produce CD in Linux:

1. Produce ISO image.

% mkisofs -graft-point -R -J -l -D -o /tmp/filename.iso /AS1012/=/tmp/OracleAS/AS1012/ /AS1013/=/tmp/OracleAS/AS1013/

... where,
-J : Generate Joliet directory records in addition to regular iso9660 file names. This is primarily useful when the discs are to be used on Windows-NT or Windows-95 machines. The Joliet filenames are specified in Unicode and each path component can be up to 64 Unicode characters long.

-l: Allow full 31 character filenames.

-D: Do not use deep directory relocation, and instead just pack them in the way we see them.

The above 3 arguments are necessary. Otherwise default Linux-burned CD will have seriously messed-up filename (capitalized and truncated) and directory structure (relocated deep directory).

2. Detect the CD-Writer.

% cdrecord -scanbus
Cdrecord-Clone 2.01-dvd (i686-pc-linux-gnu) Copyright (C) 1995-2004 JÃrg Schilling
Note: This version is an unofficial (modified) version with DVD support
scsibus2:
2,0,0 200) '_NEC ' 'DVD_RW ND-1300A ' '1.0B' Removable CD-ROM
2,1,0 201) *
2,2,0 202) *
2,3,0 203) *
2,4,0 204) *
2,5,0 205) *
2,6,0 206) *
2,7,0 207) *

3. Burn CD from ISO image.

% cdrecord -v dev=2,0,0 speed=2 --eject /tmp/filename.iso

... where
dev=devicename:scsibus,target,lun is the id of the CD-Writer scanned from step 2.
--eject: Eject after burned CD.

Run AutoConfig to change hostname for E-Business Suite

2006-11-30T18:41:00.000+08:00

Oracle E-Business Suite is dependent on hostname. User can easily change the IP of the machine, but user cannot anyhow change the hostname of the machine. To change the hostname, we need to run AutoConfig on E-Business Suite.

First, startup dbTier. AppTier is not required at all in the whole process.

FOR DATABASE TIER:
Note:338003.1 How to change the hostname and/or port of the Database Tier using AutoConfig

1. Login as oracle user.

2. De-register the current database server.
perl $ORACLE_HOME/appsutil/bin/adgentns.pl appspass=apps contextfile=$CONTEXT_FILE -removeserver

3. Update AutoConfig Context file with new host information. Edit $CONTEXT_FILE directly.
* Copy $CONTEXT_FILE to a new context file.
cp /opt/oracle/product/10.1.0/db/appsutil/PROD_<oldhost>.xml
/opt/oracle/product/10.1.0/db/appsutil/PROD_<newhost>.xml
* Edit /opt/oracle/product/10.1.0/db/appsutil/PROD_<newhost>.xml directly.
- Replace all <oldhost> to <newhost>
- Replace all <olddomain.com> to <newdomain.com>

4. Change hostname.
- Execute "system-config-network" to change the new hostname for the machine.
- Edit /etc/hosts with "newhost.newdomain.com ip newhost".

(After changing hostname, you'll not be able to startup any graphical application such as xclock due to "Xlib: connection to :0.0 refused by server". You can press "ctrl + alt + backspace" to kill x server.)

5. Execute AutoConfig for dbTier.
cd $ORACLE_HOME/appsutil/bin/
./adconfig.sh contextfile=$ORACLE_HOME/appsutil/PROD_<newhost>.xml

FOR APPS TIER:
Note:341322.1 How to change the hostname of an Applications Tier using AutoConfig

1. Login as applmgr user.

2. De-register the current apps server.
perl $AD_TOP/bin/adgentns.pl appspass=apps contextfile=$CONTEXT_FILE -removeserver

3. Update AutoConfig Context file with new host information. It is easier to edit $CONTEXT_FILE directly.
* Copy $CONTEXT_FILE to a new context file.
cp /opt/oracle/apps/prodappl/admin/PROD_<oldhost>.xml
/opt/oracle/apps/prodappl/admin/PROD_<newhost>.xml
* Edit /opt/oracle/apps/prodappl/admin/PROD_<newhost>.xml directly.
- Replace all <oldhost> to <newhost>
- Replace all <olddomain.com> to <newdomain.com>

4. Execute AutoConfig for appTier.
cd $AD_TOP/bin
./adconfig.sh contextfile=/opt/oracle/apps/prodappl/admin/PROD_<newhost>.xml appspass=apps

FINISHING TASK:

AutoConfig doesn't convert E-Business Suite completely. Some settings may remain unchanged or reset to default. So, it is required to go check the configuration as described in Cloning Guide.

Identified steps are:

1. As applmgr, vi /opt/oracle/apps/prodappl/admin/adgetlnxver.sh to ensure ctxfile is pointing to correct PROD_<newhost>.xml file.
ctxfile="/opt/oracle/apps/prodappl/admin/PROD_htb.xml"

2. As applmgr user, vi $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties to ensure:
wrapper.bin.parameters=-Djava.awt.headless=true
wrapper.bin.parameters=-DAdaptorCatalog=/opt/oracle/apps/prodappl/au/11.5.0/java/catalog.xml
wrapper.bin.parameters=-DClientMode=local

3. As oracle user, do the following:
$ sqlplus apps/apps
sql> update icx_parameters set session_cookie_domain='newdomain.com';
sql> conn applsys/apps
sql> select profile_option_value from fnd_profile_option_values where profile_option_value like '%oldhost%';
sql> update fnd_profile_option_values set profile_option_value='/opt/oracle/db/proddb/9.2.0/appsutil/outbound/PROD_newhost' where profile_option_value like '%oldhost%';
3 rows will be updated.
sql> exit;

Done. You can startup AppTier now and access E-Business Suite login page at http://newhost.newdomain.com:8000.

Ask VMWare to generate unique id (UUID)

2006-11-21T15:49:00.000+08:00

Last month, the company updated the physical network configuration. The VMWare instance experienced a mysterious problem - VMWare instance could access the outside world, but outside world could not ping it.

I have tested static IP, DHCP, configured this VMWare instance to use valid IP of other machine (while shutting that machine down), extracted the old backup version of this VMWare instance, etc. A colleague told me he encountered this issue before. What to do is, while this VMWare instance executes "ping ..." to outside world, then outside world can ping it but with 50% packet lost. This is still mysterious and not acceptable.

I recalled, when VMWare starts up the vm instance, it would ask whether to generate unique id (universally unique identifier) for the vmware instance. This step gives the virtual machine's Ethernet card a new MAC address, to prevent address conflicts with other people using this virtual machine.

However I have chosen the option to always keep the uuid, how do I ask VMWare to ask me to create the uuid again?

Reference: http://www.vmware.com/support/gsx3/doc/manage_uuid_gsx.html

1. In the folder that contains VMWare files, look for .vmx file. It is a plain text file that contains setting of the vm instance.
2. Copy .vmx to other name, e.g. file2.vmx.
3. Edit file2.vmx to remove the line, which contains “uuid.action”.Start VMWare to load file2.vmx, VMWare will ask you to create uuid again.

SSL-enabled AS1013

2006-11-15T22:52:00.000+08:00

By default, AS1013 is already SSL-enabled with dummy certificate. And it is listening port 4443.
So you can access your web application via https://HOST:4443. Click the bottom right hand side lock icon in IE to view the certificate is dummy.

In Linux, reference http://download-west.oracle.com/docs/cd/B25221_04/web.1013/b25211/ssl.htm to properly generate a valid SSL certificate via Oracle Wallet Manager (owm).

However, the document stops at successfully installation of certificate only. It doesn't explain how to access the web application simply via httpS://HOST (without specifying port).

We need to do the following:

1. Edit AS/Apache/Apache/conf/ssl.conf to load the correct certificate. For example,
SSLWallet = (where you install the SSL certificate) e.g /etc/ORACLE/WALLETS/oracle

2. Redirection 4443 to 443.
In Linux, ports below 1024 need to be executed by root priviledge. The simplest way is to use iptables command to redirect uncommon 4443 to common SSL port 443.

Edit /etc/rc.d/rc.local to include the following:
iptables -t nat -A PREROUTING -p tcp --dport 443 -i eth0 -j REDIRECT --to-port 4443

3. If you want to force the web server to always serve https. Meaning, when user access http://HOST/anything, they will be routed to httpS://HOST/anything automatically.
(Reference:http://forums.oracle.com/forums/thread.jspa?messageID=1430117?)

Edit AS/Apache/Apache/conf/httpd.conf to include the following:
RewriteEngine On
RewriteCond %{SERVER_PORT} !^443$
RewriteRule ^/(.*) https://%{SERVER_NAME}/$1 [L,R]

Oracle AS class loading sequence

2006-11-03T18:06:00.000+08:00

We use a simple JSP page to show the classpath in Application Server.
<html>
<body>
<p>Show CLASSPATH: [<%= System.getProperty("java.class.path") %>]</p>
</body>
</html>

Show CLASSPATH: [oc4j.jar:
/opt/oracle/AS1012/j2ee/home/lib/ejb.jar:
/opt/oracle/AS1012/j2ee/home/lib/servlet.jar:
/opt/oracle/AS1012/j2ee/home/lib/ojsp.jar:
/opt/oracle/AS1012/j2ee/home/lib/jndi.jar:
/opt/oracle/AS1012/j2ee/home/lib/jdbc.jar:
/opt/oracle/AS1012/j2ee/home/iiop.jar:
/opt/oracle/AS1012/j2ee/home/iiop_gen_bin.jar:
/opt/oracle/AS1012/j2ee/home/lib/jms.jar:
/opt/oracle/AS1012/j2ee/home/lib/jta.jar:
/opt/oracle/AS1012/j2ee/home/lib/jmxri.jar:
/opt/oracle/AS1012/j2ee/home/lib/javax77.jar:
/opt/oracle/AS1012/j2ee/home/lib/javax88.jar:
/opt/oracle/AS1012/j2ee/home/../../opmn/lib/ons.jar:
/opt/oracle/AS1012/j2ee/home/../../opmn/lib/optic.jar:
/opt/oracle/AS1012/j2ee/home/../../lib/dms.jar:
/opt/oracle/AS1012/j2ee/home/../../dms/lib/dms.jar:
/opt/oracle/AS1012/j2ee/home/../../diagnostics/lib/ojdl.jar:
/opt/oracle/AS1012/j2ee/home/../../dms/diagnostics/lib/ojdl.jar:
/opt/oracle/AS1012/j2ee/home/lib/connector.jar:
/opt/oracle/AS1012/j2ee/home/lib/bcel.jar:
/opt/oracle/AS1012/j2ee/home/lib/cos.jar:
/opt/oracle/AS1012/j2ee/home/lib/jsse.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/lib/jsse.jar:
/opt/oracle/AS1012/j2ee/home/lib/jnet.jar:
/opt/oracle/AS1012/j2ee/home/lib/jcert.jar:
/opt/oracle/AS1012/j2ee/home/lib/activation.jar:
/opt/oracle/AS1012/j2ee/home/lib/mail.jar:
/opt/oracle/AS1012/j2ee/home/../../javavm/lib/jasper.zip:
/opt/oracle/AS1012/j2ee/home/../../lib/xmlparserv2.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/lib/xmlparserv2.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/orai18n.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/orai18n.jar:
/opt/oracle/AS1012/j2ee/home/lib/jaxp.jar:
/opt/oracle/AS1012/j2ee/home/lib/jaas.jar:
/opt/oracle/AS1012/j2ee/home/jazn.jar:
/opt/oracle/AS1012/j2ee/home/../../jdbc/lib/classes12dms.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jdbc/lib/classes12dms.jar:
/opt/oracle/AS1012/j2ee/home/../../jdbc/lib/nls_charset12.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jdbc/lib/nls_charset12.jar:
/opt/oracle/AS1012/j2ee/home/jaxb-rt-1.0-ea.jar:
/opt/oracle/AS1012/j2ee/home/../../soap/lib/soap.jar:
/opt/oracle/AS1012/j2ee/home/../../webservices/lib/wsserver.jar:
/opt/oracle/AS1012/j2ee/home/../../webservices/lib/wsdl.jar:
/opt/oracle/AS1012/j2ee/home/../../rdbms/jlib/aqapi.jar:
/opt/oracle/AS1012/j2ee/home/lib/jem.jar:
/opt/oracle/AS1012/j2ee/home/../../javacache/lib/cache.jar:
/opt/oracle/AS1012/j2ee/home/lib/http_client.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/jssl-1_1.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/jssl-1_1.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/repository.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/repository.jar:
/opt/oracle/AS1012/j2ee/home/lib/jaasmodules.jar:
/opt/oracle/AS1012/j2ee/home/../../sqlj/lib/runtime12ee.jar:
/opt/oracle/AS1012/j2ee/home/../../sqlj/lib/translator.jar:
/opt/oracle/AS1012/j2ee/home/lib/crimson.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpcs.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpcs.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpcp.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpcp.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpse.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpse.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpsmime.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpsmime.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpcms.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpcms.jar::
/opt/oracle/AS1012/j2ee/home/applib:
/opt/oracle/AS1012/jdbc/lib/classes12dms.jar:
/opt/oracle/AS1012/diagnostics/lib/ojdl.jar:
/opt/oracle/AS1012/jlib/oraclepki.jar:
/opt/oracle/AS1012/jlib/ojpse.jar:
/opt/oracle/AS1012/jlib/ldapjclnt10.jar:
/opt/oracle/AS1012/jlib/netcfg.jar:
/opt/oracle/AS1012/jlib/jssl-1_1.jar:
/opt/oracle/AS1012/jlib/javax-ssl-1_1.jar:
/opt/oracle/AS1012/jlib/orai18n.jar:
/opt/oracle/AS1012/owm/jlib/owm-3_0.jar:
/opt/oracle/apps/prodcomn/java:
/opt/oracle/apps/prodcomn/java/xmlparserv2.zip:
/opt/oracle/apps/prodcomn/java/ieoservers.zip:
/opt/oracle/apps/prodcomn/java/jbojdbcpatch.zip:
/opt/oracle/apps/prodcomn/java/cache.zip:
/opt/oracle/apps/prodcomn/java/bc4jdatum817.zip:
/opt/oracle/apps/prodcomn/java/jdev-rt.zip:
/opt/oracle/apps/prodcomn/java/fndoam.zip:
/opt/oracle/apps/prodcomn/java/nls_charset11.zip:
/opt/oracle/apps/prodcomn/java/jbodatum111.jar:
/opt/oracle/apps/prodcomn/java/aqapi.zip:
/opt/oracle/apps/prodcomn/java/ieoall.zip:
/opt/oracle/apps/prodcomn/java/xdoparser.zip:
/opt/oracle/apps/prodcomn/java/sax2.zip:
/opt/oracle/apps/prodcomn/java/appsborg.zip:
/opt/oracle/apps/prodcomn/java/F1J7Swing.jar:
/opt/oracle/apps/prodcomn/java/bipres.zip:
/opt/oracle/apps/prodcomn/java/jdbc14.zip:
/opt/oracle/apps/prodcomn/java/servlet.zip:
/opt/oracle/apps/prodcomn/java/ojdigsig.zip:
/opt/oracle/apps/prodcomn/java/loadjava.zip:
/opt/oracle/apps/prodcomn/java/jdbc12.zip:
/opt/oracle/apps/prodcomn/java/graphbuilder.zip:
/opt/oracle/apps/prodcomn/java/appsborg2.zip:
/opt/oracle/apps/prodcomn/java/xmlparserv2-904.zip:
/opt/oracle/apps/prodcomn/java/fwkToolbox.zip:
/opt/oracle/apps/prodcomn/java/nls_charset12.zip:
/opt/oracle/apps/prodcomn/java/owa.zip:
/opt/oracle/apps/prodcomn/java/HTBGateway.zip:
/opt/oracle/apps/prodcomn/java/jdbc111.zip:
/opt/oracle/apps/prodcomn/java/jmscommon.zip:
/opt/oracle/AS1012/BC4J/lib:
/opt/oracle/AS1012/BC4J/lib/collections.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jdomorcl.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jimdomains.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jmt.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jct.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jmtejb.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jctejb.jar:
/opt/oracle/AS1012/BC4J/lib/adfm.jar:
/opt/oracle/AS1012/BC4J/lib/adfmtl.jar:
/opt/oracle/AS1012/BC4J/lib/adfmweb.jar:
/opt/oracle/AS1012/jlib/ojmisc.jar:
/opt/oracle/AS1012/ord/jlib/ordim.jar:
/opt/oracle/AS1012/ord/jlib/ordhttp.jar:
/opt/oracle/AS1012/jlib/jdev-cm.jar:
/opt/oracle/AS1012/lib/dsv2.jar:
/opt/oracle/AS1012/lib/xsu12.jar::
/opt/oracle/AS1012/j2ee/home/applications/SessionTest/sessiontest/WEB-INF/classes:
/opt/oracle/AS1012/j2ee/home/applications/SessionTest/sessiontest/WEB-INF/lib/htbclnt.jar]

... in fact, how do you feel? I feel very bad about so many irrelevant libaries were loaded in AS by default. No wonder AS has huge memory requirement. And next bad thing is, my application (SessionTest) libraries only appear at the end of the CLASSPATH.

This has caused one major problem. For example, if my application needs a particular version of classes12dms.zip JDBC library (because Oracle has released so many version of JDBC drivers, I have problem with RMI Serialization), AS will never be able to load my needed classes12dms.zip because there are so many JDBC libraries existing ahead.

So, I need to force AS to load my application libraries (in classes and lib folder).

In JDeveloper1012, we'll go New->General->Deployment Descriptors->orion-web.xml. Update the file with:
<orion-web-app servlet-webdir="/">
<web-app-class-loader search-local-classes-first="true"/>
</orion-web-app>

Then, deploy the application again. And we'll see what happens to the class loading sequence:

Show CLASSPATH: [:
/opt/oracle/AS1012/j2ee/home/applications/SessionTest/sessiontest/WEB-INF/classes:
/opt/oracle/AS1012/j2ee/home/applications/SessionTest/sessiontest/WEB-INF/lib/htbclnt.jar:
oc4j.jar:/opt/oracle/AS1012/j2ee/home/lib/ejb.jar:
/opt/oracle/AS1012/j2ee/home/lib/servlet.jar:
/opt/oracle/AS1012/j2ee/home/lib/ojsp.jar:
/opt/oracle/AS1012/j2ee/home/lib/jndi.jar:
/opt/oracle/AS1012/j2ee/home/lib/jdbc.jar:
/opt/oracle/AS1012/j2ee/home/iiop.jar:
/opt/oracle/AS1012/j2ee/home/iiop_gen_bin.jar:
/opt/oracle/AS1012/j2ee/home/lib/jms.jar:
/opt/oracle/AS1012/j2ee/home/lib/jta.jar:
/opt/oracle/AS1012/j2ee/home/lib/jmxri.jar:
/opt/oracle/AS1012/j2ee/home/lib/javax77.jar:
/opt/oracle/AS1012/j2ee/home/lib/javax88.jar:
/opt/oracle/AS1012/j2ee/home/../../opmn/lib/ons.jar:
/opt/oracle/AS1012/j2ee/home/../../opmn/lib/optic.jar:
/opt/oracle/AS1012/j2ee/home/../../lib/dms.jar:
/opt/oracle/AS1012/j2ee/home/../../dms/lib/dms.jar:
/opt/oracle/AS1012/j2ee/home/../../diagnostics/lib/ojdl.jar:
/opt/oracle/AS1012/j2ee/home/../../dms/diagnostics/lib/ojdl.jar:
/opt/oracle/AS1012/j2ee/home/lib/connector.jar:
/opt/oracle/AS1012/j2ee/home/lib/bcel.jar:
/opt/oracle/AS1012/j2ee/home/lib/cos.jar:
/opt/oracle/AS1012/j2ee/home/lib/jsse.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/lib/jsse.jar:
/opt/oracle/AS1012/j2ee/home/lib/jnet.jar:
/opt/oracle/AS1012/j2ee/home/lib/jcert.jar:
/opt/oracle/AS1012/j2ee/home/lib/activation.jar:
/opt/oracle/AS1012/j2ee/home/lib/mail.jar:
/opt/oracle/AS1012/j2ee/home/../../javavm/lib/jasper.zip:
/opt/oracle/AS1012/j2ee/home/../../lib/xmlparserv2.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/lib/xmlparserv2.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/orai18n.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/orai18n.jar:
/opt/oracle/AS1012/j2ee/home/lib/jaxp.jar:
/opt/oracle/AS1012/j2ee/home/lib/jaas.jar:
/opt/oracle/AS1012/j2ee/home/jazn.jar:
/opt/oracle/AS1012/j2ee/home/../../jdbc/lib/classes12dms.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jdbc/lib/classes12dms.jar:
/opt/oracle/AS1012/j2ee/home/../../jdbc/lib/nls_charset12.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jdbc/lib/nls_charset12.jar:
/opt/oracle/AS1012/j2ee/home/jaxb-rt-1.0-ea.jar:
/opt/oracle/AS1012/j2ee/home/../../soap/lib/soap.jar:
/opt/oracle/AS1012/j2ee/home/../../webservices/lib/wsserver.jar:
/opt/oracle/AS1012/j2ee/home/../../webservices/lib/wsdl.jar:
/opt/oracle/AS1012/j2ee/home/../../rdbms/jlib/aqapi.jar:
/opt/oracle/AS1012/j2ee/home/lib/jem.jar:
/opt/oracle/AS1012/j2ee/home/../../javacache/lib/cache.jar:
/opt/oracle/AS1012/j2ee/home/lib/http_client.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/jssl-1_1.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/jssl-1_1.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/repository.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/repository.jar:
/opt/oracle/AS1012/j2ee/home/lib/jaasmodules.jar:
/opt/oracle/AS1012/j2ee/home/../../sqlj/lib/runtime12ee.jar:
/opt/oracle/AS1012/j2ee/home/../../sqlj/lib/translator.jar:
/opt/oracle/AS1012/j2ee/home/lib/crimson.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpcs.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpcs.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpcp.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpcp.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpse.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpse.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpsmime.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpsmime.jar:
/opt/oracle/AS1012/j2ee/home/../../jlib/ojpcms.jar:
/opt/oracle/AS1012/j2ee/home/../../oracle/jlib/ojpcms.jar::
/opt/oracle/AS1012/j2ee/home/applib:
/opt/oracle/AS1012/jdbc/lib/classes12dms.jar:
/opt/oracle/AS1012/diagnostics/lib/ojdl.jar:
/opt/oracle/AS1012/jlib/oraclepki.jar:
/opt/oracle/AS1012/jlib/ojpse.jar:
/opt/oracle/AS1012/jlib/ldapjclnt10.jar:
/opt/oracle/AS1012/jlib/netcfg.jar:
/opt/oracle/AS1012/jlib/jssl-1_1.jar:
/opt/oracle/AS1012/jlib/javax-ssl-1_1.jar:
/opt/oracle/AS1012/jlib/orai18n.jar:
/opt/oracle/AS1012/owm/jlib/owm-3_0.jar:
/opt/oracle/apps/prodcomn/java:
/opt/oracle/apps/prodcomn/java/xmlparserv2.zip:
/opt/oracle/apps/prodcomn/java/ieoservers.zip:
/opt/oracle/apps/prodcomn/java/jbojdbcpatch.zip:
/opt/oracle/apps/prodcomn/java/cache.zip:
/opt/oracle/apps/prodcomn/java/bc4jdatum817.zip:
/opt/oracle/apps/prodcomn/java/jdev-rt.zip:
/opt/oracle/apps/prodcomn/java/fndoam.zip:
/opt/oracle/apps/prodcomn/java/nls_charset11.zip:
/opt/oracle/apps/prodcomn/java/jbodatum111.jar:
/opt/oracle/apps/prodcomn/java/aqapi.zip:
/opt/oracle/apps/prodcomn/java/ieoall.zip:
/opt/oracle/apps/prodcomn/java/xdoparser.zip:
/opt/oracle/apps/prodcomn/java/sax2.zip:
/opt/oracle/apps/prodcomn/java/appsborg.zip:
/opt/oracle/apps/prodcomn/java/F1J7Swing.jar:
/opt/oracle/apps/prodcomn/java/bipres.zip:
/opt/oracle/apps/prodcomn/java/jdbc14.zip:
/opt/oracle/apps/prodcomn/java/servlet.zip:
/opt/oracle/apps/prodcomn/java/ojdigsig.zip:
/opt/oracle/apps/prodcomn/java/loadjava.zip:
/opt/oracle/apps/prodcomn/java/jdbc12.zip:
/opt/oracle/apps/prodcomn/java/graphbuilder.zip:
/opt/oracle/apps/prodcomn/java/appsborg2.zip:
/opt/oracle/apps/prodcomn/java/xmlparserv2-904.zip:
/opt/oracle/apps/prodcomn/java/fwkToolbox.zip:
/opt/oracle/apps/prodcomn/java/nls_charset12.zip:
/opt/oracle/apps/prodcomn/java/owa.zip:
/opt/oracle/apps/prodcomn/java/HTBGateway.zip:
/opt/oracle/apps/prodcomn/java/jdbc111.zip:
/opt/oracle/apps/prodcomn/java/jmscommon.zip:
/opt/oracle/AS1012/BC4J/lib:
/opt/oracle/AS1012/BC4J/lib/collections.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jdomorcl.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jimdomains.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jmt.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jct.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jmtejb.jar:
/opt/oracle/AS1012/BC4J/lib/bc4jctejb.jar:
/opt/oracle/AS1012/BC4J/lib/adfm.jar:
/opt/oracle/AS1012/BC4J/lib/adfmtl.jar:
/opt/oracle/AS1012/BC4J/lib/adfmweb.jar:
/opt/oracle/AS1012/jlib/ojmisc.jar:
/opt/oracle/AS1012/ord/jlib/ordim.jar:
/opt/oracle/AS1012/ord/jlib/ordhttp.jar:
/opt/oracle/AS1012/jlib/jdev-cm.jar:
/opt/oracle/AS1012/lib/dsv2.jar:
/opt/oracle/AS1012/lib/xsu12.jar:]

Yes. Mission accomplished. AS is loading my application libraries first.

Oracle AS101202 Installation Step on RHEL4

2006-10-30T14:16:00.000+08:00

Oracle AS 1012.02 installation step on RHEL4 is summarized from Reference: Oracle® Application Server Quick Installation Guide 10g Release 2 (10.1.2) for Linux x86
http://download-west.oracle.com/docs/cd/B14099_19/linux.1012/quickinstall.1012/quickinstall/toc.htm

1) System hardware requirement.
Skip. No need to check, the runInstaller script will check for you.

2) Software dependency. Cut and paste the following command.
$ rpm -q glibc glibc-common binutils gcc gcc-c++ libstdc++ libstdc++-devel openmotif21 pdksh setarch make gnome-libs sysstat compat-db control-center xscreensaver
$ rpm -qa grep compat-libstdc++

3) Edit Kernel Parameters.

Execute $ ulimit -Hn
If the value is less than 65536, edit /etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 2048
* hard nofile 65536

Edit /etc/sysctl.conf to include the following:
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 256 32000 100 142
fs.file-max = 131072
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65535

4) Edit /etc/hosts such that the machine has a proper domain name.
Eg. 10.206.100.76 as1012.domain.com as1012

5) As root, add oracle user and oinstall group.
# /usr/sbin/groupadd oinstall
# /usr/sbin/useradd -g oinstall oracle

Set password for newly created user,
# passwd oracle

6) As root user, execute xhost + to enable any user to startup graphical interface.

7) As oracle user, execute /media/cdrom/disk1/runInstaller

Oracle AS - Clustering and remove clustering for AS1013

2006-10-28T22:08:00.000+08:00

Enable Clustering
Reference: http://www.oracle.com/technology/products/ias/hi_av/Dynamic%20Routing.htm

In AS1013 we do not need to explicitly select multiple nodes via EM to join them into a cluster. However we configure a broadcasting address to opmn.xml of different nodes, different nodes will discover each other automatically and join as a cluster.

E.g. Running the following command for each node.
$ opmnctl config topology update discover "*225.0.0.20:8001"
$ opmnctl reload

The above command will update AS1013/opmn/conf/opmn.xml file with the following entry:

<topology>
<discover list="*225.0.0.20:8001">
</topology>

To see the cluster status in terminal,
$ opmnctl @cluster status -l

To see the individual application status,
$ opmnctl status -l -app

To see more usage of opmnctl command,
$ opmnctl usage config

When you login EM, at some point it will prompt you that only 1 EM should exist to rule the rest of AS instances.

Remove Clustering
To remove the instance from cluster, we'll execute the following command in that instance.
$ opmnctl config topology delete discover "*225.0.0.20:8001"
$ opmnctl reload
(Note: obtain the discover broadcasting value from AS1013/opmn/conf/opmn.xml)

Immediately it'll be out from the cluster.

As a stand-alone instance, it'll need to have EM running so that we can manage it easily. To explicitly startup EM, execute the following:
$ opmnctl startproc ias-component=OC4J application=ascontrol

VNC related

2006-08-10T12:25:00.000+08:00

Changing VNC Password
Reference: http://www.die.net/doc/linux/man/man1/vncpasswd.1.html

It is very easy to update VNC Password.
% /usr/bin/vncpasswd

Incapable management

2006-07-27T18:22:00.000+08:00

Reference: http://www.ftchinese.com/sc/story.jsp?id=001005847

张庆洲的报告文学《唐山警示录——七·二八大地震漏报始末》
... ...
经过七年的不懈的调查，张庆洲吃惊的发现，那场造成超过24万人死亡的唐山地震，在发生前早已被不同地震监测者的预报出来，从开滦马家沟矿的工程师马希融，唐山地震办公室的杨友寰，乐亭红卫中学的观测点，到国家地震局的科学家汪成民，关于唐山即将发生大地震的预测在7月28日之前，一直不断被确认着，直到地震发生前的9个小时，马希融还在向上级单位作出强震临震的预报。

所有的警告都在向上传递的过程中都被漠视了，而没有来自上级的批准，任何行动都又是被禁止的，以至于为了召开一次一拖再拖的震情讨论会，汪成民不得不在7月22日将一张大字报贴到了国家地震局局长办公室的门上...

This article shows how severe it is, if the management is incapable:
1. Incapable management will ignore problem.
2. Incapable management will delay and prevent capable people from working effectively.
3. Without management approval and support, regardless how people shouting and jumping, nothing is gonna work.

BiZ - 商业计划书 Business Plan

2006-07-27T11:31:00.000+08:00

Reference: http://chn.blogbeta.com/170.html

Be it as big as a business plan, or as small as starting an IT project, the questions we need to answer are similar.

下面是那些应该解答的问题：
1) 你的眼光是什么？
* 你的远见是什么？
* 你要解决什么问题？对象是谁？
* 你将来想要成为什么样的人？
2) 你的市场机会是什么？市场有多大？
* 您目标的市场有多大？发展有多快？
* 这个市场有多成熟，或多不成熟？
* 你是否有资本成为这个市场前两三位？
3) 介绍你的产品和服务
* 你的产品或服务是什么？
* 解决了用户的什么问题？
* 你的产品或服务有什么特别之处？
4) 你的用户是谁？
* 谁是现在的用户？
* 谁是目标的用户？
* 理想的用户是什么样的？
* 谁会付费？
* 介绍一下某个具体用户的例子
5) 你的价值主张是什么？
* 你给用户提供了什么价值？
* 使用／买你的产品，用户的投资回收率是什么？
* 你解决了什么问题？
* 你是销售维他命，阿司匹林，还是消炎药？（奢侈品，有益的东西，还是必需品？）
6) 你如何销售？
* 销售程序是什么？周期有多长？
* 你的销售和市场方针是什么？
* 你当前的销售链是什么？
7) 你怎么吸引客户？
* 争取每个用户要花费多少钱？
* 在不同时期这个费用是否不同？为什么？
* 用户的永久价值什么？
8) 你的管理团队有谁？
* 你的管理团队有谁？
* 他们有什么经验？
* 欠缺那些环节？有什么计划去弥补？
9) 你的收入模式是什么?
* 如何赚钱
* 你的收入模式
* 需要怎样才能盈利？
10) 你现在进展到哪一步？
* 你现在进展到哪一步了？技术／产品？团队？财务／营收？
* 现在进展情况如何？现状和前景是否更清晰了？
* 你将来的计划是什么？
11) 你的融资计划是什么？
* 已经得到了什么投资？
* 希望得到多少投资？比例如何？
* 资金用在什么地方？
* 资金可以支持多久？到那时公司是否可以发展到一个重要里程碑？
* 你还打算吸引多少资金？什么时候？
12) 你的竞争对手是谁？
* 谁是你当前和潜在的竞争对手？
* 谁有可能和你竞争，谁有可能和你合作？
* 你的优势和弱点？
* 你有什么特殊之处？
13) 你有什么合作伙伴？
* 谁是你的销售或技术合作伙伴？当前？未来？
* 这些合作伙伴有多可靠？
14) 为什么适合有意的投资者？
* 和投资者的方向，经验吻合？
* 与投资者现有的投资组合有什么互补，或竞争？
15) 其它
* 成功的条件里有什么还只是假设？
* 有什么突然因素有可能一夜之间改变你的生意？新科技，新市场成员，规则法规的变化？
* 你公司的薄弱环节是什么？

Online Proxy

2006-07-23T01:36:00.000+08:00

Access Blogspot.com
- To access Blogspot.com which is blocked in India, Pakistan, Iran or China, access http://blogname.blogspot.com via http://www.pkblogs.com/blogname

Eat - 火鍋 Fondu Steamboat

2006-07-22T22:28:00.000+08:00

Recording purpose. Sounds good. I shall suggest to try it in next classmate gathering.

Source: http://www.zaobao.com.sg/fk/fk060722_512.html

　　这家相信是本地首家香港火锅店的食店——富临渔港海鲜·火锅，就开在甘榜格南的一条横街里，注重汤底和配料丰富是香港火锅的两大特色。富临备有7种汤锅、7种汤底和50多种配料供顾客选择，其中沙爹汤底和木瓜玉米鲜鱼汤底最特别。

南洋风味的汤底

　　沙爹汤底在香港非常受欢迎，那是用沙爹酱、花生末和峇拉煎等材料制作的汤底，带点辣味，很有南洋风味。因为汤味浓而微浊，用来烫配料可以增加配料的滋味。

　　木瓜玉米鲜鱼汤底是用木瓜、玉米、红枣、鲨鱼骨和石斑鱼骨熬煮4个小时而成。罗家光说，这汤并没下盐调味，完全是食材的自然滋味。

　　个人建议不妨来一个鸳鸯锅，一边为沙爹汤，主要用来烫配料；一边为木瓜玉米鲜鱼汤，主要当汤喝。沙爹汤6元，木瓜玉米鲜鱼汤8元。

餐馆：富临渔港海鲜·火锅地址：阿里哇路（Aliwal Street）14号
营业时间：下午5时30分至凌晨3时30分电话：6745-2632

FT - 中国的不合理

2006-07-20T16:03:00.000+08:00

Source: http://www.ftchinese.com/sc/story.jsp?id=001005201
人才不只是“高学历”
读者：sukenny 2006年6月28日星期三

... 现在中国的很多企业招聘要求非常不合理，他们认为有高学历的人才是人才，这严重的制约了人才的发展。于是就出现了很多人去造假；出现了很多人为了找一份好工作，不惜一切去读书，拿高学历；出现了因为没有学历而找不到工作，永远都生活在社会低层的人。那样中国什么时候才可以摆脱落后的困境呢？

我国的农民占全国的3分之2，如果每个人都去读大学，那样中国要开多少所大学才可以把9亿多的人安置去读大学呢？现在工作招聘要求最低的是大专以上的学历，这个问题是非常严峻的。

很多北方的人都去南方工作，以为广东就是好挣钱的地方，来了才知道——广东很多的工厂的工资都超不过600块钱。你想一下，出来打工的都想挣钱回家，钱挣不到，就开始“偷”和“抢”... 又出现了另外的社会问题。其实有很多事情，不如你们所想的那么美好。国际的人都看到中国每年的GDP增长8%到9%，可是真正实惠的有几个人呢？每每看到学者们说中国的好，心里都有点酸酸的感觉，可惜的是，没有地方可以去发泄不满。

中国是一个极为严重的贫富悬殊的地方，有钱的人更有钱，很多人一辈子都是为了一间房子去奋斗，但到死的那天也没有把房子供完，那又是一种什么现象呢？

Source: http://www.ftchinese.com/sc/story.jsp?id=001005842
贫富悬殊还得讲常识
读者铁山杰迪
2006年7月27日星期四

薛兆丰先生在《劫富济贫有何不妥》一文中的看法是不妥的，犯了若干常识错误。

首先，他用自己身边的微观例子，来否定宏观社会学意义基尼系数的准确性，属于以偏概全。对个体而言，洗手次数多不代表手一定干净。但就人群来说，10000个人而言，洗手多的5000个，干净程度必定超过洗手少的5000个。

其次，他忽视了贫富悬殊带来的社会震荡，巨大的社会成本。世事无绝对，一定的贫富悬殊可以带来更为快速的资本积累，可以产生资本家，往更大了说，文化也和贫富悬殊息息相关，金子塔就是法老占有巨额财富而奴隶不占有财富的前提下才可能修建。但是，贫富悬殊过度会造成的问题也是很可怕的。始皇的财富被项羽毁灭，八百里的阿房宫化为灰烬。朱门酒肉臭，路有冻死骨。杜甫之后，便是唐末的大混乱和倒退。

第三，不能因为个体的慈善否认制度的力量。不可否认，比尔盖兹和巴菲特捐出了他们的财富，这样的做法可以缓和矛盾。但是，慈善之所以高尚，乃是因为稀缺。为富不仁，不肯把金钱捐出来的富人还是多数。须知，从群体意义上说，不贪财的人是很难发财的。制度本身是妥协的产物，不能让富人丧失创造财富的欲望，也不能让穷人穷得起来造反，所以需要再次分配，所以才有税收和福利体系。诚然，政府分配效率必定会有损耗，但是，不能因噎废食，什么样的再分配会没有损耗呢？没有。

第四，穷人没有劫富，富人却在劫贫。现在哪里有什么劫富济贫，对农民土地的占有，对民工的残酷剥削，国内福利保障体系的不完善，对国有资产的疯狂侵吞，都是富有阶层才能做的事情。现在的问题，根本不是穷人在打劫富人，而是有产阶层太不人道，把穷人饭碗里的最后几粒米拿走，这才是活生生的现实。现在提保护富人实在言之过早，太过滑稽。

经济学还不是一门严谨的科学，经济学的很多问题，需要很多其他领域的知识，政治、历史、社会、文化，乃至自然地理等等等等，才可能得出一个正确的结论。薛兆丰先生用简单的加减乘除来解释经济学问题是不妥当的。

Oracle Business Rules - 1. Getting Started

2006-07-14T18:44:00.000+08:00

It is a mystery that, even in OTN Oracle Business Rules the webpage itself, I couldn't find "Getting Started" guide. I read somewhere mentioning Application Server 10.1.3 comes free with Oracle Business Rules. But after installing 10gAS Release 3, where is Oracle Business Rules?

Searching Google high and low also couldn't find the layman instruction. Finally, while solving other problem, I found it! It is hiding inside 10gAS R3 Installation Guide.

The steps are as follows:

Access the Oracle Enterprise Manager 10g Application Server Control Console using the following URL: http://hostname:port/em
In the Groups section of the page, click on the AS Instance.
Select the Applications tab.
Click [Deploy] button.
In Deploy: Select Archive page, you see Archive section on top and Deployment Plan section at bottom.
* For Archive, select "Archive is already present on the server". Then, enter the absolute path to point to $ORACLE_HOME/rules/webapps/ruleauthor.ear file, e.g. "/opt/oracle/AS1013/rules/webapps/ruleauthor.ear".
* For Deployment Plan, select "Automatically create a new deployment plan".
Enter the name of the application as ruleauthor.
Nothing to change. Click [Deploy] button.

To deploy the online help for Oracle Business Rules Rule Author, the step is similar to above. The absolute path to the ear file is "/opt/oracle/AS1013/rules/webapps/rulehelp.ear".

Preface

2006-07-14T15:23:00.000+08:00

In my daily work, I keep records of the information that I learned. Because I involve in various projects, I keep a log book for each project.

The new problem is, there is no better way to organize information.

When I wanted to look for the particular information, sometimes I cannot remember where I have recorded the step-by-step guide in which project log book. That's terrible and frustrating.

I realize a possible solution. Why not I write everything inside a blog? Then, any information that I want to look for, the website has the "search" feature for me to search by keyword.

That seems a good idea. So let's try this idea out today.