Shulou(Shulou.com)06/01 Report--

I. preparation before Oracle installation

Check the package, all must be installed:

Binutils-2.20.51.0.2-5.43.el6.x86_64

Compat-libstdc++-296-2.96-144.el6.i686

Compat-libstdc++-33-3.2.3-69.el6.x86_64

Elfutils-libelf-0.161-3.el6.x86_64

Elfutils-libelf-devel-0.161-3.el6.x86_64

Gcc-4.4.7-16.el6.x86_64

Gcc-c++-4.4.7-16.el6.x86_64

Glibc-2.12-1.166.el6_7.3.x86_64

Glibc-2.12-1.166.el6_7.3.i686

Glibc-common-2.12-1.166.el6_7.3.x86_64

Glibc-devel-2.12-1.166.el6_7.3.x86_64

Glibc-devel-2.12-1.166.el6_7.3.i686

Libaio-0.3.107-10.el6.i686

Libaio-0.3.107-10.el6.x86_64

Libaio-devel-0.3.107-10.el6.i686

Libaio-devel-0.3.107-10.el6.x86_64

Libgcc-4.4.7-16.el6.i686

Libgcc-4.4.7-16.el6.x86_64

Libstdc++-4.4.7-16.el6.x86_64

Libstdc++-4.4.7-16.el6.i686

Libstdc++-devel-4.4.7-16.el6.x86_64

Libstdc++-devel-4.4.7-16.el6.i686

Make-3.81-20.el6.x86_64

Sysstat-9.0.4-27.el6.x86_64

UnixODBC-2.2.14-14.el6.i686

UnixODBC-2.2.14-14.el6.x86_64

UnixODBC-devel-2.2.14-14.el6.i686

UnixODBC-devel-2.2.14-14.el6.x86_64

two。 Create oracle users and groups

Su-root

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba oracle

Echo oracle | passwd-- stdin oracle

three。 System parameters and configuration files

1. Add the following to the file / etc/sysctl.conf

Kernel.sysrq = 0

Kernel.core_uses_pid = 1

Net.ipv4.tcp_syncookies = 1

Kernel.msgmnb = 65536

Kernel.msgmax = 65536

Kernel.shmmax = 4294967295

Kernel.shmall = 268435456

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

Fs.file-max = 6815744

Fs.aio-max-nr = 1048576

/ sbin/sysctl-p

two。 Add the following to the file / etc/security/limits.conf

Session required / lib64/security/pam_limits.so

Session required pam_limits.so

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

3. Add the following to the file / etc/profile

If [$USER = "oracle"]; then

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

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

four。 Modify environment variabl

/ home/oracle/.bash_profile

# .bash _ profile

# Get the aliases and functions

If [- f ~ / .bashrc]; then

. ~ / .bashrc

Fi

# User specific environment and startup programs

Export ORACLE_SID=orcl

Export ORACLE_BASE=/home/oracle/

Export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:ORACLE_HOME/lib

Export ORACLE_HOME=/home/oracle/product/11.2.0/dbhome_1

Export ORACLE_HOME_LISTNER=$ORACLE_HOME

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

Umask 022

Export PATH

Sh / home/oracle/.bash_profile

five。 Start installation

Go to the instal folder of oracle

. / runlnstaller

If nothing happens, there will be a graphical installation interface for oracle

Follow the prompts to install step by step

In the second step of installation, oracle will check whether the environment conforms to it. If you prompt swap or large, or small, ignore, next step

When you are finished, follow the prompts to execute with root

Root.sh and

OrainstRoot.sh

Just enter.

It's almost done at this point.

six。 Create an instance

Create an instance graphically

Cd $home_ORACLE/product/11.2.0/dbhome_1/bin/

. / dbca

Then a graphical interface will appear to create the instance, and follow the prompts to proceed to the next step.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.