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

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 

Oracle Enterprise Manager Cloud Control Installation Precheck(Oracle Linux)

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

Find oracle program version

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

Oracle TRM Resource

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

What do you do on your database?

A lot of companies are using Oracle database as their data storage.
Except the data storage, what do you do on the database?
In facts, the Oracle Database has a lot of feature, java, e-mail, all you need to do is survey and implement.
Remember to monitor your new application's impact, your database might be slow down.