Thursday, June 19, 2014


This is just for my own note.
To exact .cpio file on linux

cpio -idvm < cpio_file


I just remembered I was using the cpio incorrectly.
And the installer ran with status ok, but eventually failed because of unknown reason. 
Hope this work for my new tasks. 

Wednesday, February 6, 2013

Connect Amazon Web Service EC2

Recently, I'm trying to setup a AWS EC2.
The connection problem caused me a headache.
Luckily still a lot of bloggers are sharing their knowledge and saved my time.

  1. Make sure you've downloaded your key pair in the folder you're accessible.
  2. Use the following command to connect to your server
    ssh -i keypair_name.pem username@hostname_or_ip
  3. Then you're ready to go!

Saturday, May 19, 2012

Make your Chinese SRT file display correctly

Recently I just upgraded my Ubuntu Desktop from 11.04 to 12.04 LTS. And of course a lot new problems came to me.

And one of the problem is the SRT file.

Actually, this is not a new problem to me, but I was always choosing the workaround way.

This time, no more workaround. I'll present you the correct way.

Until now I still don't have a clue for the root cause of this problem yet, but in chunghe's blog I found this is really nice and easy way to solve the problem.

Problem Description

The original contain of the SRT is like this.

I still can see the numbers, which means the file is somewhat correct, but the Chinese word didn't display correctly.


In gEdit, I tried to open it with UTF-8 encoding


There are errors




For chunghe's blogpost, he introduced an utility called enca.

Usage1 show file information  : enca <filename>


This will display the information of the file content. For my file here it shows

It's Big5(Is this the reason I cannot see the font correctly?) , with CRLF line terminators.


Usage 2 convert file to desired format : enca –x <encoding>

I wrote an scritp to do this. The content is :

enca -x UTF-8 < $ > $

The content of the converted file.




This way is much easier and more straight and forward.

Before this, I have to copy the file to Windows environment and open notepad++ to convert it to UTF-8.

Now everything can be done under Ubuntu. 微笑

Saturday, March 24, 2012

Making Oracle Database XE Available to Remote Clients

I installed one Oracle Database XE for testing purpose.

And found that it won't be accessable from different client.

And finally I found the answer in Oracle Document

Here is the copied sentence...


Start SQL*Plus and log in as SYSTEM:

SYSTEM_DRIVE:\> sqlplus system
Enter password: SYSTEM_password

Or, if you are logging in remotely:

SYSTEM_DRIVE:\> sqlplus system@xe_server_host_name
Enter password: SYSTEM_password

At the SQL prompt, enter the following command:

And it can be remote access now. 微笑

Sunday, March 18, 2012

Upgrade Oracle E-Business Suite R12.1.1 to R12.1.3 on Oracle Linux


Reference from Oracle Support DocId : 1080973.1


My EBS on my Oracle Linux is 12.1.1. I want to upgrade it to 12.1.3 to experience the new OAF Rich UI.

Here are my steps, the issues I encountered and the solutions.


Apply Patch 9239089

This one is easy.

Download the patch 9239089.

Unzip it.

Apply patch.


Apply Patch 9239090

This patch is big. It is seperated into 6 files, but still the same steps.

Download the patch 9239090.

Unzip them.

Apply the patch.

It spends a lot of time to apply this patch. And during applying the patch, there are several issues come to my server.

One is EGOSILDU.sql issue, which can be solved by DocId. 847687.1. But I don't use "Advanced Product Catalog" which I can ignore this issue by using adctrl and press 8.

And I also encountered another issue which is some form objects could not be compiled correctly.

au resource ASTACLIB.pll
au resource ASTCORE.pll
au resource ASTCUREL.pll
au resource ASTLSLIB.pll
au resource ASTCPREP.pll
au resource ASTOPLIB.pll
au resource IEXCORE.pll
au resource ASTRCALL.pll
au resource OKSSRVAV.pll
au resource ASTSLLIB.pll
au resource ASTCULIB.pll
au resource CSCUTILS.pll

And in this document

Just recompile the db package AS_API_RECORDS_PKG and recompile the previous pll files to plx would solve this issue.


Apply Patch 9239095

This one is easy, too.

Download the patch 9239095

Unzip the patch

Apply the patch


Post-Updates Steps

Finally the patches of Oracle E-Business Suite R12.1.3 is done.I also need to apply patches 9817770 & 9966055, otherwise my responsibilities won't appear.

Update Code Level

To keep application tier and database tier the correct code level,  do the following steps:

Login as application os user, cd $ADMIN_SCRIPTS_HOME, run to generate the context file.

cd $AD_TOP/bin, run

This will generate latest under $INST_TOP/admin/out

Then login as database os user, cd $ORACLE_HOME, ftp or copy the (which is created by application os user) to current folder.

unzip -o


then run dbTier using database user, and appsTier using application user.

Now everything is ready, you may startup your Oracle E-Business Suite 12.1.3 now!




Tuesday, March 13, 2012

Oracle E-Business Suite R12 OAF Rich User Interface Enhancement

Reference from Oracle
There are some new enhancements since Oracle EBS R12.1.2 was introduced, especially the OAF Rich UI.
I think Oracle is getting better and better now. I'm going to upgrade my R12.1.1 on my Oracle Linux later on.
Now let's give it a glance.

I just captured the picture from the document. All the copyright of the picture belong to Oracle.

Now we have new navigator in the left
You can put some embedded content, see the right
You can have Drop-Down Navigator Menu. I love this function myself.
The Drop-Down Favorites. I love this one too.
This one is even better! The Inline, look-ahead LOV window.
The Inline View Attachment Window
Inline Popup Window
Embedded OBIEE Analytic Contents. Every boss asked about this!
Embedded Custom Rich Content
Function after R12.1.3
Exceptions as Popups.
AutoVue Integration.
View Object Creation.
Create your own Dynamic View Object
Copy & Undo funtion


I think Oracle is really trying hard to get Oracle E-Business Suite better and better. Though it's not fast enough, but I think I still love these new functions introduced.
Keep visiting my blog, I might have a chance to share my process of upgrade from R12.1.1 to R12.1.3.
See you soon.

Sunday, February 5, 2012

VMWare Memory Setting

Just want to keep this for I sufferred from the physical memory not enough error for one day.

In Additional memory part the 3rd option : Allow most virtual machine memory to be swapped.


It was the 2nd option : Allow some virtual machine memory to be swapped. And notice that the Reserved memory is 4545 MB.

I got available memory  more than 4GB, VMWare still complaint I do not have enough memory for my 4G VM.

Though this option(3rd option) sacrificed the performance of the guest machine. At least I can have a slow but workable environment.

Valentine's Day 2012 V