Steps for installing database 11gr2 on Oracle Linux 6.1

 

 

1. Install Oracle Linux 6.1

Here I use vbox for installation. For details, refer:

 

Oraclevirtual box installation instructions

Http://blog.csdn.net/tianlesoftware/article/details/6826389

 

Install the following package during OS installation:

Base System> Base

Base System> Client Management Tools

Base System> compatibility Libraries

Base System> Hardware Monitoring utilities

Base System> large systems performance

Base System> Network File System Client

Base System> Performance Tools

Base System> Perl support

Servers> Server Platform

Servers> System Administration Tools

Desktops> Desktop

Desktops> desktop platform

Desktops> Fonts

Extends tops> general purpose Desktop

Desktops> graphical administration tools

Desktops> input methods

Desktops> X Window System

Development> additional development

Development> development tools

Applications> Internet browser

 

 

 

2. Install Oracle 11gr2

 

I have also compiled several Oracle Installation articles. For details, refer:

Installation documents for Oracle databases on Linux

Http://blog.csdn.net/tianlesoftware/article/details/4718218

 

Oracle Installation documentation for 64-bit Linux

Http://blog.csdn.net/tianlesoftware/article/details/6062816

 

Here we will take a look at the installation of Oracle under oraclelinux.

 

2.1 install software

Oracle can install the media independently from 11 GB. From OTN, we can only download to 11.2.0.1. From MOs, we can download to 11.2.0.3. Here I will use version 11.2.0.3 on MOS for testing.

 

OTN:

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

 

2.2 decompress patchset

 

The patchset of Oracle 11g divides several files, each of which has different functions.

 

First, the two packages indicate the database. If you upgrade the database, you only need the two files.

The third package indicates the grid, which is used to upgrade the CRS of RAC. If you want to upgrade RAC, use this file first.

The fourth parameter indicates the client,

Fifth indicates always ways,

The sixth one is examples. This is the installation package of our sample file.

The seventh parameter indicates deinstall.

 

For more information, see:

Roles of different Oracle 11gr2patchset files

Http://blog.csdn.net/tianlesoftware/article/details/6818770

 

#11.2.0.3

Unzipp10404530_112030_Linux-x86-64_1of7.zip

Unzipp10404530_112030_Linux-x86-64_2of7.zip

 

2.3 modify the hosts file

The "/etc/hosts" file mustcontain a fully qualified name for the server.

 

<IP-address> <fully-qualified-machine-Name> <machine-Name>

For example.

127.0.0.1 localhost

192.168.3.201 Dave

 

2.4 modify configuration parameters

 

2.4.1 use preinstall to automatically set

 

I have prepared a separate blog to describe the preinstall package. For details, refer:

Description of Oracle RDBMS server 11gr2 preinstall RPM package in Oracle linux6

Http://blog.csdn.net/tianlesoftware/article/details/7456878

 

This package automatically completes most of the configuration work to improve the efficiency of our deployment.

 

[Root @ Dave desktop] # Yum install oracle-rdbms-server-11gR2-preinstall

Loaded plugins: refresh-packagekit

Setting up install process

Resolving Dependencies

--> Running transaction check

---> Packageoracle-rdbms-server-11gR2-preinstall.x86_64. 0-3.el6 will be installed

--> Processing dependency: gcc-C ++ forpackage: oracle-rdbms-server-11gR2-preinstall-1.0-3.el6.x86_64

--> Processing dependency: libstdc ++-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-3.el6.x86_64

--> Processing dependency: libaio-develfor package: oracle-rdbms-server-11gR2-preinstall-1.0-3.el6.x86_64

--> Processing dependency: Ksh forpackage: oracle-rdbms-server-11gR2-preinstall-1.0-3.el6.x86_64

--> Running transaction check

---> Package gcc-C ++. x86_640: 4.4.6-3. el6 will be installed

--> Processing dependency: libstdc ++ = 4.4.6-3. el6 for package: gcc-C ++-4.4.6-3. el6.x86 _ 64

---> Package KSh. x86_640: 20100621-12.el6_2.1 will be installed

---> Package libaio-devel.x86_640: 0.3.107-10. el6 will be installed

---> Package libstdc ++-devel. x86_640: 4.4.6-3. el6 will be installed

--> Running transaction check

---> Package libstdc ++. x86_640: 4.4.5-6. el6 will be updated

---> Package libstdc ++. x86_640: 4.4.6-3. el6 will be an update

--> Finished dependency resolution

 

Dependencies resolved

 

========================================================== ==========================================================

Package arch version repository size

========================================================== ==========================================================

Installing:

Oracle-rdbms-server-11gR2-preinstall

X86_641.0-3.el6 ol6_latest 15 K

Installing for dependencies:

Gcc-C ++ x86_64 4.4.6-3. el6 ol6_latest 4.7 m

Ksh x86_6420100621-12.el6_2.1 ol6_latest 683 K

Libaio-devel x86_640.3.107-10.el6 ol6_latest 13 K

Libstdc ++-devel x86_64 4.4.6-3. el6 ol6_latest 1.5 m

Updating for dependencies:

Libstdc ++ x86_644.4.6-3.el6 ol6_latest 290 K

 

Transaction Summary

========================================================== ==========================================================

Install 5 package (s)

Upgrade 1 package (s)

 

Total size: 7.2 m

Total download size: 4.7 m

Is this OK [Y/n]: Y

Downloading packages:

Gcc-C ++-4.4.6-3. el6.x86 _ 64.rpm | 4.7 MB

Running rpm_check_debug

Running transaction Test

Transaction test succeeded

Running transaction

Updating: libstdc +++-4.4.6-3. el6.x86 _ 64 1/7

Installing: libstdc +++ devel-4.4.6-3.el6.x86_64 2/7

Installing: gcc-C ++-4.4.6-3. el6.x86 _64 3/7

Installing: libaio-devel-0.3.107-10.el6.x86_64 4/7

Installing: ksh-20100621-12.el6_2.1.x86_64 5/7

Installing: oracle-rdbms-server-11gR2-preinstall-1.0-3.el6.x86_64 6/7

Cleanup: libstdc +++-4.4.5-6. el6.x86 _ 64 7/7

 

Installed:

Oracle-rdbms-server-11gR2-preinstall.x86_64 0: 1. 0-3.el6

 

Dependency installed:

Gcc-C ++. x86_64 4. 4.6-3. el6 KSh. x86_64 0: 20100621-12.el6_2.1

Libaio-devel.x86_64. 3.107-10. el6 libstdc ++-devel. x86_64. 4.6-3. el6

 

Dependency updated:

Libstdc ++. x86_64. 4.6-3. el6

 

Complete!

[Root @ Dave desktop] #

 

2.4.2 manual settings

If you do not use the RPM package for automatic configuration, You need to manually configure it. The specific configuration work is as follows:

 

(1) modify the/etc/sysctl. conf file

The minimum configuration required by Oracle is as follows:

FS. suid_dumpable = 1

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

 

You can use the following command to view a parameter value:

/Sbin/sysctl-A | grep <param-Name>

 

Add or modify the following content in the/etc/sysctl. conf file:

FS. suid_dumpable = 1

FS. AIO-max-Nr = 1048576

FS. File-max = 6815744

Kernel. Shmall = 2097152

Kernel. shmmax = 536870912

Kernel. shmmni = 4096

# Semaphores: semmsl, semmns, semopm, semmni

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 = 1048586

 

After the modification is complete, run the following command to make the modification take effect:

/Sbin/sysctl-P

 

(2) Add the following content to the/etc/security/limits. conf file:

Oracle soft nproc 2047

Hard nproc 16384

Oracle soft nofile 4096

Oracle hard nofile 65536

Oracle soft stack 10240

 

(3) install related RPM packages

# From Oracle Linux 6 DVD

CD/Media/CDROM/Server/Packages

Rpm-uvh binutils-2 * x86_64 *

Rpm-uvh glibc-2 * x86_64 * nss-softokn-freebl-3 * x86_64 *

Rpm-uvh glibc-2 * i686 * nss-softokn-freebl-3 * i686 *

Rpm-uvh compat-libstdc ++-33 * x86_64 *

Rpm-uvh glibc-common-2 * x86_64 *

Rpm-uvh glibc-devel-2 * x86_64 *

Rpm-uvh glibc-devel-2 * i686 *

Rpm-uvh glibc-headers-2 * x86_64 *

Rpm-uvh elfutils-libelf-0 * x86_64 *

Rpm-uvh elfutils-libelf-devel-0 * x86_64 *

Rpm-uvh gcc-4 * x86_64 *

Rpm-uvh gcc-C ++-4 * x86_64 *

Rpm-uvh KSh-* x86_64 *

Rpm-uvh libaio-0 * x86_64 *

Rpm-uvh libaio-devel-0 * x86_64 *

Rpm-uvh libaio-0 * i686 *

Rpm-uvh libaio-devel-0 * i686 *

Rpm-uvh libgcc-4 * x86_64 *

Rpm-uvh libgcc-4 * i686 *

Rpm-uvh libstdc ++-4 * x86_64 *

Rpm-uvh libstdc ++-4 * i686 *

Rpm-uvh libstdc ++-devel-4 * x86_64 *

Rpm-uvh make-3.81 * x86_64 *

Rpm-uvh numactl-devel-2 * x86_64 *

Rpm-uvh sysstat-9 * x86_64 *

Rpm-uvh compat-libstdc ++-33 * i686 *

Rpm-uvh compat-libcap *

CD/

Eject

 

(4) create groups and users

Groupadd-G 501 oinstall

Groupadd-G 502 DBA

Groupadd-G 503 running

Groupadd-G 504 asmadmin

Groupadd-G 506 asmdba

Groupadd-G 505 asmoper

 

Useradd-u 502-G oinstall-gdba, asmdba, external Oracle

Passwd Oracle

 

 

2.5 Other settings

 

2.5.1 disable SELinux

 

Set SELinux = disabled in/etc/SELinux/config.

 

To modify this parameter, you must restart the system.

 

2.5.2 create a directory and grant permissions

Mkdir-P/u01/APP/Oracle/product/11.2.0/db_1

Chown-r ORACLE: oinstall/u01

Chmod-r 775/u01

 

2.5.3 switch to the Oracle user and modify the. bash_profile File

 

[Oracle @ Dave ~] $ VI ~ /. Bash_profile

 

Add the following content to the. bash_profile file:

# Oracle settings

TMP =/tmp; export TMP

Tmpdir = $ TMP; export tmpdir

 

Oracle_hostname = Dave; exportoracle_hostname

Oracle_unqname = Dave; export oracle_unqname

Oracle_base =/u01/APP/Oracle; exportoracle_base

ORACLE_HOME = $ oracle_base/product/11.2.0/db_1; export ORACLE_HOME

Oracle_sid = Dave; export oracle_sid

 

Path =/usr/sbin: $ path; export path

Path = $ ORACLE_HOME/bin: $ path; export path

 

LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH

Classpath = $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib; export classpath

 

 

2.6 install software

Nomachine, VNC, and other tools can be used here.

 

Remote Desktop tool-nomachine

Http://blog.csdn.net/tianlesoftware/article/details/6003610

 

Here I will go directly to the system:

 

(1) run the following command with the root user:

Xhost +

 

(2) Use Oracle to execute:

Display = <machine-Name>: 0.0; exportdisplay

 

(3) Start Installation

./Runinstaller

 

 

2.7 modify auto-start Parameters

Modify the/etc/oratab file and change the last tag to y.

Edit the "/etc/oratab" filesetting the restart flag for each instance to 'y '.

DAVE:/u01/APP/Oracle/product/11.2.0/db_1: Y

 

For more information about auto-start of Oracle instances, see:

Description of Oracle Auto-start, oratab, and dbstart scripts in Linux

Http://blog.csdn.net/tianlesoftware/article/details/7220657

 

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Skype: tianlesoftware

Email: tianlesoftware@gmail.com

Blog: http://www.tianlesoftware.com

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

LinkedIn: http://cn.linkedin.com/in/tianlesoftware

 

 

------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940