Oracle Your Life

Citrix Receiver

2017-10-22T23:45:00.003-07:00

Remember I mentioned Citrix On-Line Plug-in ?
Turns out the Citrix Receiver is a much much better solution.
All I need to do is install the Citrix Receiver instead.

To download the latest Citrix Receiver, you can download that from the official Citrix website or here .

During the installation, it will uninstall your previous Citrix On-Line Plug-in if you have installed previously.

After the installation, you may just do nothing (don't add any account or email address yet)

Go to http://hostname
The hostname is your Citrix server IP or domain name.

If it ask you to install the client or plug-in, just answer I have installed.

Then click any application, the Citrix Receiver will just launch the application for you.

(It might also download a lot of launch.ica, just use open always so you don't need to open them one by one)

Citrix On-Line Plug-In

2017-10-19T12:05:00.000-07:00

One of the common issue of the Citrix OnLine Plug-in is the printer missing issue.

Luckily Citrix provide a solution for this.

The latest Citrix plug-in can be downloaded here, if you cannot find you can also find it here or here

However, in the 12.3 Online Plug-In - Issues Fixed in This Release

It does resolve sort of the printer issue.

Will it work?

Let's wait and see.

如何在Windows 10 64Bit 安裝BI Publisher Desktop

2017-06-13T11:23:00.002-07:00

BI Publisher真的是難裝的要命的東西。
但幸好印度同胞還是很無私的分享了怎麼解決。

然而目前即使是在windows 10 64bit上但它還是最多只能支援到office 32bit的版本。
有人64bit有裝成功，請不吝讓小弟開開眼界。

重點是一個元件MSCOMCTL.OCX
很幸運地，它要嘛在C:\Windows\SysWow64下就有，要嘛你用搜尋的去硬碟翻箱倒櫃一番也是找得到。

確定你的MSCOMCTL.OCX在C:\Windows\SysWow64下。

然後以系統管理權限執行命令列視窗
切換目錄到C:\Windows\SysWow64
Regsvr32 MSCOMCTL.OCX
看一下回你的訊息，不要太快關掉呀。

再來你就可以把它丟下去執行，去倒杯咖啡再回來，它就應該安裝完成了。

圖片一樣有空再來加了。

如何在Windows 10 64bit上安裝Oracle Developer Suite 10G

2017-06-13T11:15:00.000-07:00

很多人跟我一樣對微軟這個新的Windows 10很愛，但應用程式的開發者跟不上作業系統更新的速度，於是有本小文的誕生。
三個重點

以相容模式Windows XP SP2執行。
命令列要記得下-ignoreSysPreReqs，所以會是setup -ignoreSysPreReqs
虛擬記憶體要設成手動，最小256，最大則看你的實體記憶體，Windows會建議你最大設多少。設自動Installer死都不承認你有虛擬記憶體，很壞吧。💀

圖片改天再來加。

開始中文的內容

2017-06-13T10:44:00.003-07:00

本小格（部落格）以往一直以為要用英文才是國際化才跟得上潮流。
隨著時代的潮流，全球化的競爭。
小弟自認為小格文章寫的沒印度同胞好，技術層級沒洋人寫的漂亮。
於是小弟今天起在本小格（部落格）開始出版中文的技術內容。
希望有更多的流量及造福更多有需要的人。

後記:實驗證明. 中文反而流量更少.

cpio

2014-06-19T21:24:00.001-07:00

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

cpio -idvm < cpio_file

Reference

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.

Connect Amazon Web Service EC2

2013-02-06T13:05:00.001-08:00

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.

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

Make your Chinese SRT file display correctly

2012-05-19T11:28:00.001-07:00

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

Solutions

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 < $1.srt > $1.utf8.srt

The content of the converted file.

Conclusion

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.

Making Oracle Database XE Available to Remote Clients

2012-03-24T00:53:00.001-07:00

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:

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

And it can be remote access now.

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

2012-03-18T00:55:00.000-07:00

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

https://forums.oracle.com/forums/thread.jspa?threadID=2131259

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:

cd $AD_TOP/bin, run admkappsutil.pl.

This will generate latest appsutil.zip under $INST_TOP/admin/out

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

unzip -o appsutil.zip

Run adautocfg.sh on $ORACLE_HOME.

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

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

Oracle E-Business Suite R12 OAF Rich User Interface Enhancement

2012-03-13T17:35:00.001-07:00

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

Summary

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.

VMWare Memory Setting

2012-02-05T00:22:00.000-08:00

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

Database parameter setting (Reference)

2012-02-05T00:07:00.000-08:00

alter system set processes=300 scope=spfile;
alter system set session_cached_cursors=200 scope=spfile;
alter system set sga_target=2G scope=spfile;
alter system set shared_pool_size=600M scope=spfile;
alter system set pga_aggregate_target=1G scope=spfile;
alter system set job_queue_processes=20 scope=spfile;

SOA Suite Installation on Oracle Linux 5.7

2012-02-04T12:37:00.001-08:00

Valentine's Day 2012 V
According to Oracle official web page currently the SOA Suite can be installed only on 32-bit JVM.
In this article, we will install WebLogic, RCU, SOA Suite and JDeveloper.

OS Package Installation

compat-db-4.1.25-9
sysstat-5.0.5-1

Kernel Parameters OS Resource Limitation

/etc/security/limits.conf
* hard nofile 4096
* soft nofile 4096

Install WebLogic

In the Welcome windows, Next

Select Create a new Middleware Home, and give the Middleware Home Directory, then Next

opt out I wish to receive security updates via My Oracle Support, then Next

Choose Typical as Install type, this will install WebLogic Server & Oracle Coherence, then Next

Specify the directory of WebLogic Server and Oracle Coherence, then Next

Review the Installation Summary, if no problem, then Next

Installing

opt out the Run Quickstart then Done

Install RCU DB Schemas

In Welcome window, Next

Choose Create, then Next

Give the database connection information, then Next

After the check, then OK

Accept the default new Prefix DEV, opt-in the SOA and BPM Infrastructure, this will automatically opt-in Metadata Services under AS Common Schemas, then Next

After the check again, then OK

Give the password for all schemas, then Next

Review the Tablespaces, then Next

Because we do not have any tablespaces in previous review, so OK

Tablespaces created, then OK

Review the Summary, then Create

Repository created, then Close

Install SOA Suite

Give the JDK location under previous WebLogic Middleware Home

Accepted the default. You should have a group named oinstall already. Then OK

Need root privileges to run the createCentralInventory.sh

Logon as root and go to the directory previous dialog specified run the createCentralInventory.sh

Go back to the previous dialog, then OK

In Welcome screen, Next

Choose Skip Software Updates, then Next

Make sure the Prerequisite Checks are all passed, then Next

Specify the Oracle Middleware Home and accept the default name for Oracle Home Directory (this will be our DOMAIN_HOME), then Next

Accept the WebLogic Server as Application Server, then Next

Review the Installation Summary, then Install

Installing

Completed, then Next

Installation Complete, Finish

Configure SOA Suite

Under $DOMAIN_HOME/common/bin
./config.sh

Choose Create a new WebLogic domain, then Next

Check the following products, then Next

Give the Domain name, Domain location, and Application location, then Next

Give weblogic password, then Next

Choose Development Mode and Sun SDK, then Next

Check all the Component Schema, give the password (Created in RCU), and connection information, then Next

All the Component Schema tested, then Next

Check only Administration Server, then Next

Use default value for Administration Server, then Next

Review Configuration Summary then Create

Creating New Domain

Done

Install JDeveloper

In the Welcome window, Next

Choose Create a new Middleware Home, and give a new directory for JDeveloper, then Next

Choose Complete as Install Type, then Next

Confirm the directories are all right, then Next

Review the Installation Summary, then Next

JDeveloper installing...

uncheck the Run Quickstart, then Done

Install SOA Extension on JDeveloper

Choose Default Role when you first time run the JDeveloper, then OK

Depends on you want to report your usuage to Oracle or not, then OK

In menu Help > Check for Updates

In Welcome window, Next

Check Oracle Fusion Middleware Products and Official Oracle Extensions and Updates, then Next

Check Oracle BPM Studio 11g and Oracle SOA Composite Editor, then Next

The update is downloading...

Extension installed, Finish

Yes and restart the JDeveloper

Appendix

cd $DOMAIN_HOME/bin
./startWebLogic.sh to start the SOA Platform
We will see the SOA Platform is running and accepting requests to know the server is ready.

Browse yoursoaserverip:7001/console

Logon as weblogic and password you specified previously, then Login

We will see the server is ready, Yay!

Reference Oracle SOA Suite 11g Installations Document

Oracle Database 11gR2 Installation (Oracle Linux 5.7)

2012-01-31T01:27:00.001-08:00

Memory Requirement

Minimum: 1 GB of RAM
Recommended: 2 GB of RAM or more
To determine the RAM size, enter the following command:

# grep MemTotal /proc/meminfo

Available RAM	Swap Space Required
Between 1 GB and 2 GB	1.5 times the size of the RAM
Between 2 GB and 16 GB	Equal to the size of the RAM
More than 16 GB	16 GB

# grep SwapTotal /proc/meminfo

Package Requirment

The following or later version of packages for Asianux 3, Oracle Linux 5, and Red Hat Enterprise Linux 5 must be installed:

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
sysstat-7.0.2

Oracle ODBC Drivers

On Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5:

unixODBC-2.2.11 (32-bit) or later
unixODBC-devel-2.2.11 (64-bit) or later
unixODBC-2.2.11 (64-bit) or later

Create Required Operating System Groups and Users

The following local operating system groups and users are required if you are installing Oracle Database:

The Oracle Inventory group (typically, oinstall)
The OSDBA group (typically, dba)
The Oracle software owner (typically, oracle)
The OSOPER group (optional. Typically, oper)

To determine whether these groups and users exist, and if necessary, to create them, follow these steps:

To determine whether the oinstall group exists, enter the following command:
```
# more /etc/oraInst.loc
```
If the output of this command shows the oinstall group name, then the group exists.
If the oraInst.loc file exists, then the output from this command is similar to the following:
```
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
```
The inst_group parameter shows the name of the Oracle Inventory group, oinstall.
To determine whether the dba group exists, enter the following command:
```
# grep dba /etc/group
```
If the output from this commands shows the dba group name, then the group exists.
If necessary, enter the following commands to create the oinstall and dba groups:
```
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
```
To determine whether the oracle user exists and belongs to the correct groups, enter the following command:
```
# id oracle
```
If the oracle user exists, then this command displays information about the groups to which the user belongs. The output should be similar to the following, indicating that oinstall is the primary group and dba is a secondary group:
```
uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)
```
If necessary, complete one of the following actions:
- If the oracle user exists, but its primary group is not oinstall or it is not a member of the dba group, then enter the following command:
```
# /usr/sbin/usermod -g oinstall -G dba oracle
```
- If the oracle user does not exist, enter the following command to create it:
```
# /usr/sbin/useradd -g oinstall -G dba oracle
```
  This command creates the oracle user and specifies oinstall as the primary group and dba as the secondary group.
Enter the following command to set the password of the oracle user:
```
# passwd oracle
```

Configuring Kernel Parameters

Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit lines similar to the following:
Note:
Include lines only for the kernel parameter values to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the minimum value, then specify the larger value.

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586

sysctl –p

Check Resource Limits for the Oracle Software Installation Users

If necessary, update the resource limits in the /etc/security/limits.conf configuration file for the installation owner. For example, add the following lines to the /etc/security/limits.conf file:

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536
oracle              soft    stack   10240

Creating Required Directories

# mkdir -p /u01/app/
# chown -R oracle:oinstall /u01/app/
# chmod -R 775 /u01/app/

Installation

./runInstaller

uncheck the checkbox, then Next

Yes

Create and configure a database, then Next

Choose Server Class, then Next

Choose Single instance database installation, then Next

Choose Typical install, then Next

Give Global database name, and Administrative password, note that there are some restrictions about the password, then Next

Give the oracle inventory directory and specify the oraInventory Group Name to oinstall, then Next

This part is weired, I cannot pass it, so I choose Ignore All, then Next

We're ready to install the database software, Finish

dbca is running

to keep use the same administrator password click OK

when the installer prompt you the instruction logon as root and run the script in specified directories

orainstRoot.sh

root.sh

The prompt screen, after finish previous two steps, then OK

The database in installed, enterprise manager can be accessed via https://yourhostname:1158/em

Appendix

5.2.8 Enabling and Disabling Database Options

When you install Oracle Database, some options are enabled and others are disabled. To enable or disable a particular database feature for an Oracle home, shut down the database and use the chopt tool. See Example 5-1.
The chopt tool is a command-line utility that is located in the ORACLE_HOME/bin directory. The syntax for chopt is:

chopt [ enable | disable] db_option

The possible values for db_option are described in the following table:

Value	Description
`dm`	Oracle Data Mining RDBMS Files
`dv`	Oracle Database Vault
`lbac`	Oracle Label Security
`olap`	Oracle OLAP
`partitioning`	Oracle Partitioning
`rat`	Oracle Real Application Testing
`ode_net`	Oracle Database Extensions for .NET 1.x
`ode_net_2`	Oracle Database Extensions for .NET 2.0

Example 5-1 Complete Example of Running the Chopt Tool
To enable the Oracle Label Security option in your Oracle binary files, use the following command:

cd %ORACLE_HOME%
srvctl stop database -d myDb
chopt enable lbac
srvctl start database -d myDb

Oracle Enterprise Manager Cloud Control Installation(Oracle Linux)

2012-01-31T00:22:00.001-08:00

The installation begins…

We've done the previously prerequisite check
opt-out the option of security update via My Oracle Support if you don't have a Oracle Support account, then Next

Yes

Skip the Software Updates, then Next

Next

We'll install a Simple Enterprise Manager System, and Middleware Home Location is the where you want to install the software (binary), Next

Input the Administrator Password twice and give the repository database connection information, then Next

Because my default Oracle 11g R2 database will install Database Control automatically, we need to follow the instruction to remove that Database Control on repository database.

Do the following instruction
cd $ORACLE_HOME/bin
emca -deconfig dbcontrol db -repos drop -SYS_PWD <sys_password> -SYSMAN_PWD <sysman_password>

Answer Yes

These are something need to be set on repository database, we can do this later, OK

We're ready to install the Enterprise Manager Cloud Control 12c, Install

After few hours installation (mine is 5 hours, slow machines!)

logon as root cd to the directory that installer told you and run allroot.sh

Back to the screen and press OK

https://ol57ap.telus.net:7102/console

After login

Oracle Database 11g Release 2(11.2) Express Edition Installation(Oracle Linux)

2012-01-28T10:51:00.001-08:00

Package Requirements

glibc should be greater than or equal to 2.3.4-2.41
make should be greater than or equal to 3.80
binutils should be greater than or equal to 2.16.91.0.5
gcc should be greater than or equal to 4.1.2
libaio should be greater than or equal to 0.3.104

Kernel Parameter Requirements

Table 2 Kernel Parameter Settings Required for Oracle Database XE

Kernel Parameter	Setting
`semmsl`	250
`semmns`	32000
`semopm`	100
`semmni`	128
`shmmax`	4294967295
`shmmni`	4096
`shmall`	2097152
`file-max`	6815744
`VERSION`	2.4.21
`ip_local_port_range`	9000–65500

Installation

rpm -ivh downloads/oracle-xe-11.2.0-1.0.x86_64.rpm

Configuration

A valid HTTP port for the Oracle Application Express (the default is 8080)
A valid port for the Oracle database listener (the default is 1521)
A password for the SYS and SYSTEM administrative user accounts
Confirm password for SYS and SYSTEM administrative user accounts
Whether you want the database to start automatically when the computer starts (next reboot)

Usuage

To start the database manually, run this command as root user:

# /etc/init.d/oracle-xe start

To stop the database manually, run the following command as root user:

# /etc/init.d/oracle-xe stop

Referenced from Oracle

Expand existing disk on VM Oracle Linux

2012-01-27T16:13:00.001-08:00

VMWare Client Setting

Change the Hard Disk by double click

Utilities > Expand

Change the Maximum disk size to desired size, and Expand

Oracle Linux Setting

Turn on your Oracle Linux, type fdisk /dev/sda
p to see current partion status
n for new partition
give 3 to use next partition number, currently is 2
we use the whole increased space so accept the default cylinder parameter
and w to write the partition table to disk and exit

The result message want us to do a reboot, so do it.

After reboot still logon as root
pvcreate /dev/sda3
to create a physical volume

vgextend VolGroup00 /dev/sda3
to add the physical volume to volume group

vgdisplay
to see current Volume Group

We have 20G free to add volume group
lvextend -L+20G /dev/VolGroup00/LogVol00

resize2fs /dev/VolGroup00/LogVol00

Congratulation! You’ve sucessfully increase new space and can be used in your Oracle Linux on VMWare

Reference url
http://www.techotopia.com/index.php/Adding_a_New_Disk_to_an_RHEL_5_Volume_Group_and_Logical_Volume
http://echenh.blogspot.com/2010/04/how-to-extend-lvm-on-vmware-guest-os.html

RPM Usuage

2012-01-27T11:25:00.001-08:00

To remove a rpm package
rpm -e <package name>

To install a rpm package
rpm -ivh <package name>

To query a rpm name
rpm -qa <part of package name> Valentine's Day 2012 V

Oracle Enterprise Manager Cloud Control Installation Precheck(Oracle Linux)

2012-01-27T00:10:00.001-08:00

OS Library

For example, if you run the command on a 32-bit system, you should see something similar to the following:

glibc-devel-2.3.4-2.43(i386)
glibc-headers-2.3.4-2.43(i386)
glibc-2.3.4-2.43(i686)
compat-glibc-headers-2.3.2-95.30(i386)
glibc-profile-2.3.4-2.43(i386)
glibc-utils-2.3.4-2.43(i386)
glibc-kernheaders-2.4-9.1.103.EL(i386)
glibc-common-2.3.4-2.43(i386)
compat-glibc-2.3.2-95.30(i386)

For example, if you run the command on a 64-bit system, you should see something similar to the following:

glibc-common-2.3.4-2.43(x86_64)
glibc-devel-2.3.4-2.43(x86_64)
glibc-profile-2.3.4-2.43(x86_64)
glibc-headers-2.3.4-2.43(x86_64)
glibc-utils-2.3.4-2.43(x86_64)
glibc-2.3.4-2.43(x86_64)

And sysstat-5.0.5

Kernel Parameter Requirements

For installing an OMS or a Management Agent on Unix operating systems (32-bit or 64-bit), set the kernel.shmmax parameter to a value 1 byte less than 4 GB or 4294967295.
Oracle recommends this value to avoid lack of memory issues for other applications and to enable a complete and successful core file generation under any and all circumstances.
To verify the value assigned to kernel.shmmax parameter, run the following command:
cat /proc/sys/kernel/shmmax
To set the value for kernel.shmmax parameter, run the following command:
sysctl -w kernel.shmmax=<new value>

Reference from Oracle Document

unzip Issue

But I could not install it via runInstaller at all.

After some research there is a solution for this

EM Cloud Control 12c RunInstaller Command Fails Before Launching Installer GUI With java.lang.NullPointerException In oraInstall_xxx.err File [ID 1369904.1]
The "unzip" binary provided by Oracle is in fact not able to correctly unzip the provided zip files for the Cloud Control installation.
Another release of the unzip should be downloaded from here: https://updates.oracle.com/unzips/unzips.html
The following version is needed:
# LINUX Intel (32bit and 64bit - Large file support)
Once this utility has been downloaded, proceed as described below :
oracle@vmtestoraem12c:/u01/app/software/em12c/ [rdbms1120] gzip -d unzip60_lnx.Z
oracle@vmtestoraem12c:/u01/app/software/em12c/ [rdbms1120] chmod u+x unzip60_lnx
oracle@vmtestoraem12c:/u01/app/software/em12c/ [rdbms1120] ./unzip60_lnx em12_linux64_disk1of2

Thanks to Yann Neuhaus, he recorded the detail of this.

Other notice

unzip the em12_linux64_disk1of2.zip & em12_linux64_disk2of2.zip into the same folder

How to change UI Language on Ubuntu 11.10

2011-10-15T09:51:00.000-07:00

After using the fancy login and Unity, I found one problem for different language user.
How do I change the UI to different language?
There is no Language option for me to choose.

Here comes the solution
In the System Settings

User Accounts

Language

And pick the Language you're going to use.
And login again.
Now you're using your language UI. Enjoy...

By the way, if you got better idea of how to change this in an easier way, please kindly let me know.
Thanks.

Ubuntu 11.10 Released

2011-10-14T00:40:00.000-07:00

Upgraded my 11.04 to 11.10.
The new login screen is cool.

And the Unity feature now is supported even on my virtual machine.

Anyone who likes Ubuntu should try this then.

Find oracle program version

2011-08-24T08:40:00.000-07:00

Sometimes you'll need to find out which version of your Oracle program is.
Maybe for patching purpose or bug issue.
Try this

strings | grep Header
adident Header

I personally like adident, much easier. =P

Reference

How to do a MD5 checksum on Ubuntu

2011-05-08T18:20:00.000-07:00

$md5sum

should be the same as the one you saw on the original source web page

Oracle TRM Resource

2011-04-01T10:08:00.000-07:00

Most of the eTRM didn't get the detail information of the tables
In my opinion, I can get those information from the db myself why do I need a paid eTRM?

I found this useful link including the traditional TRM with PDF format.
http://download.oracle.com/docs/cd/A88418_01/html/trmdoc.html

Share with you

Oracle Your Life

Citrix Receiver

Citrix On-Line Plug-In

如何在Windows 10 64Bit 安裝BI Publisher Desktop

如何在Windows 10 64bit上安裝Oracle Developer Suite 10G

開始中文的內容

cpio

Connect Amazon Web Service EC2

Make your Chinese SRT file display correctly

Problem Description

Solutions

Conclusion

Making Oracle Database XE Available to Remote Clients

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

Apply Patch 9239089

Apply Patch 9239090

Apply Patch 9239095

Post-Updates Steps

Update Code Level

Oracle E-Business Suite R12 OAF Rich User Interface Enhancement

Summary

VMWare Memory Setting

Database parameter setting (Reference)

SOA Suite Installation on Oracle Linux 5.7

OS Package Installation

Kernel Parameters OS Resource Limitation

Install WebLogic

Install RCU DB Schemas

Install SOA Suite

Configure SOA Suite

Install JDeveloper

Install SOA Extension on JDeveloper

Appendix

Oracle Database 11gR2 Installation (Oracle Linux 5.7)

Memory Requirement

Package Requirment

Oracle ODBC Drivers

Create Required Operating System Groups and Users

Configuring Kernel Parameters

Creating Required Directories

Installation

Recommended Postinstallation Tasks

Appendix

5.2.8 Enabling and Disabling Database Options

Oracle Enterprise Manager Cloud Control Installation(Oracle Linux)

The installation begins…

Oracle Database 11g Release 2(11.2) Express Edition Installation(Oracle Linux)

Package Requirements

Kernel Parameter Requirements

Installation

Configuration

Usuage

Expand existing disk on VM Oracle Linux

VMWare Client Setting

Oracle Linux Setting

RPM Usuage

Oracle Enterprise Manager Cloud Control Installation Precheck(Oracle Linux)

OS Library

Kernel Parameter Requirements

unzip Issue

Other notice

How to change UI Language on Ubuntu 11.10

Ubuntu 11.10 Released

Find oracle program version

How to do a MD5 checksum on Ubuntu

Oracle TRM Resource