Install and configure Oracle 11g R2 in Redhat Enterprise Linux 5.4

1. Preparations for configuration in Linux

Environment: Linux: RedHat Enterprise 5.4, DB: Oracle 11g R2 X64, Oracle installed in the/home/oralce_11 directory.

The configuration process is as follows: (most of the content is online, and individuals follow the online steps)

1) Check the basic requirements (this must meet the requirements for the awesome server and can be skipped)

Memory size

Grep MemTotal/proc/meminfo

Swap partition size

Grep SwapTotal/proc/meminfo

Add swap Partition

Create a partition file such as/home/swap. The file size is 5120000 blocks. Generally, 1 block is 1 K, so the space here is 5 GB.

Dd if =/dev/zero of =/home/swap bs = 1024 count = 5120000

Then convert the partition into a swap partition.

Mkswap/home/swap

Then add it to fstab.

Echo "/home/swap defaults 0 0">/etc/fstab

2) Check the software requirements and install the software without yum install.

Rpm-q binutils compat-libstdc ++-33 elfutils-libelf-devel glibc-common glibc-devel gcc-c ++ libaio-devel libaliblibgcc libstdc + + libstdc ++-devel make sysstat unixODBC-devel pdksh

(If there is no installation, put the Linux CD into www.bkjia.com, enter the Server folder, find the corresponding RPM package, and run the RPM command to install it. If you like the graphic interface, you can also double-click the corresponding RPM package on the image interface to install the package. Note that when the libaio-devel unixODBC-devel software package is installed, in addition to the X64 package, the i386 package should also be installed, not because it is an X64 system, I will not install the i386 package. )

3) configure the kernel.

Edit/etc/sysctl. conf.

Add the following content to the file

# Kernel paramaters required by Oracle 11gR1

Fs. file-max = 6815744

Fs. aio-max-nr = 1048576

Kernel. shmall = 2097152

Kernel. shmmax = 2147483648

Kernel. shmmni = 4096

Kernel. sem = 250 32000 100 128

Net. ipv4.ip _ local_port_range = 9000 65500

Net. core. rmem_default = 4194304

Net. core. rmem_max = 4194304

Net. core. wmem_default = 262144

Net. core. wmem_max = 1048576

4) to make the/etc/sysctl. conf change take effect immediately, run the following command.

Sysctl-p

5) edit/etc/security/limits. conf.

Add the following lines:

Oracle soft nproc 2047

Hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

6) edit/etc/pam. d/login.

Add the following lines:

Session required/lib/security/pam_limits.so

Session required pam_limits.so

[Note: For X64 systems, use/lib64/security/pam_limits.so. Otherwise, the system may not be able to log on to the server !]

7) edit/etc/profile.

Add the following lines:

If [$ USER = "oracle"]; then

If [$ SHELL = "/bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

8) Create an operating system user as the owner of the software installation and support group.

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba oracle

Passwd oracle

9) create a software installation directory.

Mkdir-p/home/oracle_11/app/

Chown-R oracle. oinstall/home/oracle_11/

Chmod-R 755/home/oracle_11/

10) edit/home/oracle/. bash_profile.

Add the following lines:

Umask 022

ORACLE_BASE =/home/oracle_11/app

ORACLE_HOME = $ ORACLE_BASE/oracle/product/11.2.0/db_1

ORACLE_SID = MYTEST -- Instance name, which can be modified as needed

PATH = $ PATH

HOME/bin

ORACLE_HOME/bin

LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib

LANG = C -- set this parameter to avoid garbled characters during installation.

Export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH LANG

11) open another terminal window as root in the GUI (local operation or remote operation through VNC)

-- This step is critical. If you do not run this step, the graph-based installation interface cannot be started when the oracle user runs #./runInstaller.

# Xhost +

# Xhost + localhost

12) decompress the downloaded Oracle Installation File to Linux, and then install the database.

# Su-oracle

Cd database/

./RunInstaller

13) Next, a graphical Installation Wizard will appear. Follow the wizard step by step, which is the same as the wizard for installing Oracle in Windows. There is no big difference until the installation is complete.

1 2 3 Next Page