Linux installs Oracle 11G process (test not finished)

First, Introduction

The importance of Oracle databases in system operations is self-evident, and the knowledge of operating systems and databases is deepened through familiarity with the installation of Oracle. Linux installation Oracle early modification of Linux kernel parameters is very important, in fact, Linux under the configuration of the Oracle database process. (very important, how not to configure completely in the post-installation process will be an error)

The installation test environment is as follows:

Operating system: CentOS 6.5 X64

Database: Oracledatabase 11g Release 2 (11.2.0.1.0) for Linux x86-64

Simple process:

1. Install the required RPM package for the best yum installation

2. Modify the Linux kernel file/etc/sysctl.conf

3. Creating Oracle Users and installation groups

4. Modify User Restrictions/etc/security/limits.conf

5. Modify user authentication Options/etc/pam.d/login

6. Modify the user profile/etc/profile

7. Change user login su-oracle and then change bash shell

8. Log in to Linux with the Oracle user to copy the installation files or unzip the installation files.

9. Installation

Second, Oracle needs the RPM package: (recommended to install with Yum, you can remove the required dependency package)

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
gcc-4.1.2
gcc-c++-4.1.2
Glibc-2.5-24
glibc-common-2.5
glibc-devel-2.5
glibc-headers-2.5
kernel-headers-2.6.18
ksh-20060214
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.2
libgomp-4.1.2
libstdc++-4.1.2
libstdc++-devel-4.1.2
make-3.81
sysstat-7.0.2
unixODBC-2.2.11
unixodbc-devel-2.2.11

Third, modify the Linux kernel file/etc/sysctl.conf to the next parameter

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

Four. Create an Oracle user and installation group (note that the directory is customized)

1) Create the relevant users and groups as the owner of the software installation and Support group.

To create an Oracle user and password, enter the command:

useradd  -g oinstall -g dba -m oracle  passwd  oracle

Then will let you enter the password, the password any input 2 times, but must be consistent, enter the confirmation.

2) Create database software directory and data file directory, directory location, according to their own situation, pay attention to disk space, here I put it under the Oracle user, for example:

Enter the command:

mkdir /home/oracle/app mkdir /home/oracle/app/oracle mkdir /home/oracle/app/oradata mkdir /home/oracle/app/oracle/product3) Change directory owner is owned by Oracle user, enter command: chown -R oracle:oinstall  /home/oracle/appFive. Modify user Restrictions/etc/security/limits.conf 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 = 1048576Six. Modify user authentication Options/etc/pam.d/login session required /lib/security/pam_limits.so session required pam_limits.soSeven. Modify the user profile/etc/profile if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fiEight. change user login su-oracle and then change bash shell

Linux installs Oracle 11G process (test not finished)