Follow in sb.'s footsteps in CentOS 6.4 install Oracle 11gR2

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Before the installation instructions:

  1. Memory (RAM) the minimum requirement is 1GB, 2GB and above.
  2. Swap virtual memory: memory is 1GB~2GB swap size is 1.5 times the size of memory; memory is 2GB~16GB swap size is the size of the memory; memory over swap 16GB 16GB.
  3. Requirements for temporary files directory, such as /tmp of disk space of at least 1GB.
  4. The disk space required for installation space: Enterprise Edition 4.35GB and above 1.7GB data file space; Standard Edition for the installation space of 4.22GB and above 1.5GB data file space.
  5. X window graphical interface.
  6. The need for root users to access

In this paper, the installation environment:

  1. Operating system CentOS 6.4 2.6.32-358.el6.x86_64 (desktop), 2GB RAM, 80GB hard disk space(4GB swap, 100MB /boot, 40GB /)
  2. The host name mophee, IP 192.168.80.19 (static)
  3. Environmental Science: VMware Workstation 9.0

Install the required software package (in the root operating account):

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
unixODBC-2.2.14-11.el6 (x86_64) or later
unixODBC-2.2.14-11.el6.i686 or later
unixODBC-devel-2.2.14-11.el6 (x86_64) or later
unixODBC-devel-2.2.14-11.el6.i686 or later
libXp

Use the command Yum list grep'package name'rpm | or -q'package name' or rpm -qa grep'package name'| view package is already installed.

Use the command Yum install -y'package name'to install the missing package, pdksh package except. Note: to install the 32 bit using Yum package, can modify the VI /etc/yum.conf, add a line: multilib_policy=all. The Oracle will require the installation of i386 in test environment, but the CentOS 6.4 CD 32 bit package is i686, all the same, ignore the differences should not (see installation section below).

yum install -y binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel make numactl sysstat libXp unixODBC unixODBC-devel

Install the pdksh package (the package is not included in the installation disk CentOS):

Use the command: WGet ftp://rpmfind.net/linux/centos/5.9/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm pdksh packages are downloaded to the local

To install using the command rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm (Note: the package conflict with KSH, if KSH is already installed, recommend the use of RPM -e ksh-* uninstall command)

User group to create the needed (in the root operating account):

groupadd oinstall;
groupadd dba;
groupadd oper;

Create the required account (in the root operating account):

Use the command ID oracle; check whether the Oracle account already exists, if not exists, use the following command to create

useradd -g oinstall -G dba,oper oracle; #The initial group is oinstall, effective group DBA, oper
passwd oracle; #Set the password for the Oracle account (installation time login required)

If the Oracle account already exists, then the command usermod -a -G DBA, oper Oracle will join the group DBA and oper

Modify the kernel parameters (operating in the root account):

To edit the kernel parameter configuration file VI /etc/sysctl.conf, modify or add such as down in that document:

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 = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

To execute the following command the configuration above take effect immediately:

sysctl -p;

Modify the system resource constraints (in the root operating account):

Edit the configuration file VI /etc/security/limits.conf system resource constraints, add the following lines in the file:

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

Edit the file VI /etc/pam.d/login, add the following lines (11gR1, R2 not required):

session required pam_limits.so

Edit the VI /etc/profile files, add the following lines (11gR1, R2 not required):

if [ $USER = "oracle" ]; then
        if [ $SHELL = "/bin/ksh" ]; then
              ulimit -p 16384
              ulimit -n 65536
        else
              ulimit -u 16384 -n 65536
        fi
fi

This configuration immediately in the user Oracle login, if the current Oracle users have logged on to exit after the re login to effect.

Close the SELinux (in the root operating account):

Edit the SELinux configuration file VI /etc/selinux/config, set the value of SELINUX is disabled, as follows:

SELINUX=disabled;

Modify the file to restart the system does not start SELinux. Close the currently open SELinux using the following command:

setenforce 0

Modify the /etc/hosts file (in the root operating account):

Edit the file VI /etc/hosts, add a line:

192.168.80.19 mophee

This operation will be installed when the pop-up warning without, and may influence the normal operation of the monitoring program, so that this change.

Create the desired directory (in the root operating account):

To install Oracle in the /opt/oracle directory, so need to create this directory:

mkdir /opt/oracle;
chown oracle:oinstall /opt/oracle;
chmod 755 /opt/oracle;

The installation also need to set the Inventory directory, so need to create this directory:

mkdir /opt/oraInventory;
chown oracle:oinstall /opt/oraInventory;
chmod 755 /opt/oraInventory;

Installation package:

Installation package is compressed into two files Oracle 11g R2: linux.x64_11gR2_database_1of2.zip, linux.x64_11gR2_database_2of2.zip, Upload them to install the machine, And use the unzip linux.x64_11gR2_database_1of2.zip; unzip linux.x64_11gR2_database_2of2.zip; extract, Will get a name for the database directory. I put it in the /home/oracle/database.

As the installation process is done with the Oracle identity, so the need to ensure that the Oracle account has permissions to /home/oracle/database, can use the following command to this directory will be endowed with all Oracle account, and have permission to execute:

chmod -R 700 /home/oracle/database;
chown -R oracle:oinstall /home/oracle/database;

------------------------ exit root, log in as Oracle ----------------------------------

Set the Oracle account login environment (from the Oracle login):

Edit the file VI /home/oracle/.bash_profile, add the following lines:

ORACLE_BASE=/opt/oracle; #The installation directory
ORACLE_HOME=$ORACLE_BASE/11g; #The Oracle home directory
ORACLE_SID=orcl; #The instance name
LD_LIBRARY_PATH=$ORACLE_HOME/lib;
PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin;
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH;

Save and exit after the implementation of the above settings take effect immediately following command:

source /home/oracle/.bash_profile

To start the installation (from the Oracle login):

/home/oracle/database/runInstaller; ##The implementation of the program to start the installation

The following will enter the graphical installer


Figure -1 type email, and click Next


Figure -2 due to the installation of machine I not connected to Internet, so that I set the proxy. Select the check box, and click Continue


Figure -3 select the first item, create and simple configuration database in the installation is complete, click Next


Figure -4 selected Server Class, click Next


Figure -5 to the singleton pattern installation (if installed RAC, select the next item), click Next


Figure -6 selected Advanced install, click Next


Figure -7 setup interface language, only English, click Next


Figure -8 choose to install the enterprise edition, click Next


Figure -9 installed base directory and the Home directory, because we have set the environment variable ORACLE_BASE and ORACLE_HOME, here no longer select, click Next


Figure -10 in the oinstall group identity for installation, click Next


Figure -11 installation for transaction processing database (data warehouse select next), click Next


Figure -12 since we have set the environment variable ORACLE_SID, so this step without modification, click Next


Maximum memory map can be used by -13.1, Oracle recommends the use of automatic memory management, click the tab on the Character sets character set


Figure -13.2 UTF-8 is chosen as the database character set, click on the Sample Schemas and create Oracle provides case


Figure -13.3 select the check box, and click Next


Figure -14 nothing to set (according to their own needs), click Next


Figure -15 this step can be stored data files, I chose a simple file system, click Next


Figure -16 whether to enable the automatic backup, in a production environment is enabled, click Next


Figure -17 system management account password, after input and click Next


Figure -18 select the DBA account group (using conn / as SYSDBA database) and oper account group, click Next


Figure -19 installation procedures for the environment, because the CentOS 32bit package is i686, and Oracle i386, so it can fail, just ignore it. Click Next


Figure -20 click Finish, start the installation


Figure -21 install ing. . .


Figure -22 install ing. . .


Figure -23 click Password Management can set the related management account password, as in figure -17 has been so there is no need to set, click OK


Figure -24 retention, to perform the next step: log in as root executive that two sh files


Figure -25 login as root executive that two sh files, such as in the lower left corner. The execution is completed, click on the OK, can be accomplished.

Open the browser, enter the https://localhost:1158/em, open the Database Control management interface, Oracle has begun to operate.

In this paper, reference Oracle official documents: Oracle® Database Quick Installation Guide 11g Release 2 (11.2) for Linux x86-64

Statement: the blogger specific environment is original, in order to avoid misleading and readers and bloggers communication, please indicate the source in the transfer.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Tammy at November 27, 2013 - 11:22 AM