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

Installation of oracle 11g Database under Linux (1) 1 memory requirements

Minimum configuration: 1 GB of RAM

Recommended configuration: 2 GB of RAM or more

To determine the memory size, enter the following command: grep MemTotal / proc/meminfo

To determine the system version, enter the following command: uname-m

To determine the size of the swap space, enter the following command: grep SwapTotal / proc/meminfo

To determine the available memory and swap space, enter the following command: free

2 disk space requirements

Database software

The required size of the database software

Enterprise edition

4.7G

Standard edition

4.6G

Database file

The required size of the database file

Enterprise edition

1.7G

Standard edition

1.5G

3 check the systems supported by software requirements 3.1 Oracle Database 11gRelease 2 (11.2):

■ Asianux Server 3 SP2

■ Asianux Server 4 SP3

■ Oracle Linux 4 Update 7

■ Oracle Linux 5 Update 2 (with Red Hat Compatible Kernel)

■ Oracle Linux 5 Update 5

■ Oracle Linux 6

■ Oracle Linux 6 (with Red Hat Compatible Kernel)

■ Oracle Linux 7

■ Oracle Linux 7 (with the Red Hat Compatible Kernel)

■ Red Hat Enterprise Linux 4 Update 7

■ Red Hat Enterprise Linux 5 Update 2

■ Red Hat Enterprise Linux 6

■ Red Hat Enterprise Linux 7

■ SUSE Linux Enterprise Server 10 SP2

■ SUSE Linux Enterprise Server 11

3.2 Kernel requirements

■ On Oracle Linux 4 and Red Hat Enterprise Linux 4

2.6.9 or later

■ On Oracle Linux 5 Update 2 with Red Hat Compatible Kernel

2.6.18 or later

■ On Oracle Linux 5 Update 5 with Red Hat Compatible Kernel

2.6.18 or later

■ On Oracle Linux 5 Update 5 with Unbreakable Enterprise Kernel

2.6.32-100.0.19 or later

■ On Oracle Linux 6

2.6.32-100.28.5.el6.x86_64 or later

■ On Oracle Linux 6 with Red Hat Compatible Kernel

2.6.32-71.el6.x86_64 or later

■ On Oracle Linux 7

3.8.13-33.el7uek.x86_64 or later

■ On Oracle Linux 7 with Red Hat Compatible Kernel

3.10.0-54.0.1.el7.x86_64 or later

■ On Red Hat Enterprise Linux 5 Update 2

2.6.18 or later

■ On Red Hat Enterprise Linux 5 Update 5

2.6.18 or later

■ On Red Hat Enterprise Linux 6

2.6.32-71.el6.x86_64 or later

■ On Red Hat Enterprise Linux 7

3.10.0-54.0.1.el7.x86_64 or later

■ On Asianux Server 3

2.6.18 or later

■ On Asianux Server 4

2.6.32-71.el6.x86_64 or later

■ On SUSE Linux Enterprise Server 10

2.6.16.21 or later

■ On SUSE Linux Enterprise Server 11

2.6.27.19 or later

To determine the required kernel installation, enter the following command: uname-r

3.3.3.The package for 64-bit operating system requires 3.3.1 Oracle Linux 4 and Red Hat Enterprise Linux 4

Binutils-2.15.92.0.2

Compat-libstdc++-33-3.2.3

Compat-libstdc++-33-3.2.3 (32 bit)

Elfutils-libelf-0.97

Elfutils-libelf-devel-0.97

Expat-1.95.7

Gcc-3.4.6

Gcc-c++-3.4.6

Glibc-2.3.4-2.41

Glibc-2.3.4-2.41 (32 bit)

Glibc-common-2.3.4

Glibc-devel-2.3.4

Glibc-headers-2.3.4

Libaio-0.3.105

Libaio-0.3.105 (32 bit)

Libaio-devel-0.3.105

Libaio-devel-0.3.105 (32 bit)

Libgcc-3.4.6

Libgcc-3.4.6 (32-bit)

Libstdc++-3.4.6

Libstdc++-3.4.6 (32 bit)

Libstdc++-devel 3.4.6

Make-3.80

Numactl-0.6.4.x86_64

Pdksh-5.2.14

Sysstat-5.0.5

3.3.2 Oracle Linux 5, Red Hat Enterprise Linux 5, and Asianux Server 3

Binutils-2.17.50.0.6

Compat-libstdc++-33-3.2.3

Compat-libstdc++-33-3.2.3 (32 bit)

Coreutils-5.97-23.el5_4.1

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

3.3.3 Oracle Linux 6, Red Hat Enterprise Linux 6, and Asianux Server 4

Binutils-2.20.51.0.2-5.11.el6 (x86 / 64)

Compat-libcap1-1.10-1 (x86x64)

Compat-libstdc++-33-3.2.3-69.el6 (x86x64)

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

Gcc-4.4.4-13.el6 (x86 / 64)

Gcc-c++-4.4.4-13.el6 (x86 / 64)

Glibc-2.12-1.7.el6 (i686)

Glibc-2.12-1.7.el6 (x86 / 64)

Glibc-devel-2.12-1.7.el6 (x86 / 64)

Glibc-devel-2.12-1.7.el6.i686

Ksh

Libgcc-4.4.4-13.el6 (i686)

Libgcc-4.4.4-13.el6 (x86 / 64)

Libstdc++-4.4.4-13.el6 (x86 / 64)

Libstdc++-4.4.4-13.el6.i686

Libstdc++-devel-4.4.4-13.el6 (x86 / 64)

Libstdc++-devel-4.4.4-13.el6.i686

Libaio-0.3.107-10.el6 (x86 / 64)

Libaio-0.3.107-10.el6.i686

Libaio-devel-0.3.107-10.el6 (x86 / 64)

Libaio-devel-0.3.107-10.el6.i686

Make-3.81-19.el6

Sysstat-9.0.4-11.el6 (x86 / 64)

3.3.4 Oracle Linux 7 and Red Hat Enterprise Linux 7

Binutils-2.23.52.0.1-12.el7.x86_64

Compat-libcap1-1.10-3.el7.x86_64

Gcc-4.8.2-3.el7.x86_64

Gcc-c++-4.8.2-3.el7.x86_64

Glibc-2.17-36.el7.i686

Glibc-2.17-36.el7.x86_64

Glibc-devel-2.17-36.el7.i686

Glibc-devel-2.17-36.el7.x86_64

Ksh

Libaio-0.3.109-9.el7.i686

Libaio-0.3.109-9.el7.x86_64

Libaio-devel-0.3.109-9.el7.i686

Libaio-devel-0.3.109-9.el7.x86_64

Libgcc-4.8.2-3.el7.i686

Libgcc-4.8.2-3.el7.x86_64

Libstdc++-4.8.2-3.el7.i686

Libstdc++-4.8.2-3.el7.x86_64

Libstdc++-devel-4.8.2-3.el7.i686

Libstdc++-devel-4.8.2-3.el7.x86_64

LibXi-1.7.2-1.el7.i686

LibXi-1.7.2-1.el7.x86_64

LibXtst-1.2.2-1.el7.i686

LibXtst-1.2.2-1.el7.x86_64

Make-3.82-19.el7.x86_64

Sysstat-10.1.5-1.el7.x86_64

3.3.5 SUSE Linux Enterprise Server 10

Binutils-2.16.91.0.5

Compat-libstdc++-5.0.7

Gcc-4.1.0

Gcc-c++-4.1.2

Glibc-2.4-31.63

Glibc-devel-2.4-31.63

Glibc-devel-32bit-2.4-31.63

Ksh-93r-12.9

Libaio-0.3.104

Libaio-32bit-0.3.104

Libaio-devel-0.3.104

Libaio-devel-32bit-0.3.104

Libelf-0.8.5

Libgcc-4.1.2

Libstdc++-4.1.2

Libstdc++-devel-4.1.2

Make-3.80

Numactl-0.9.6.x86_64

Sysstat-8.0.4

3.3.6 SUSE Linux Enterprise Server 11

Binutils-2.19

Gcc-4.3

Gcc-32bit-4.3

Gcc-c++-4.3

Glibc-2.9

Glibc-32bit-2.9

Glibc-devel-2.9

Glibc-devel-32bit-2.9

Ksh-93t

Libaio-0.3.104

Libaio-32bit-0.3.104

Libaio-devel-0.3.104

Libaio-devel-32bit-0.3.104

Libstdc++33-3.3.3

Libstdc++33-32bit-3.3.3

Libstdc++43-4.3.3mm 20081022

Libstdc++43-32bit-4.3.3_20081022

Libstdc++43-devel-4.3.3_20081022

Libstdc++43-devel-32bit-4.3.3_20081022

Libgcc43-4.3.3mm 20081022

Libstdc++-devel-4.3

Make-3.81

Sysstat-8.1.5

To determine the required installation package, enter the following command: rpm-Q package_name

4 create the required operating system groups and users

4.1 create an Oracle Inventory group: / usr/sbin/groupadd oinstall

4.2 create an OSDBA group: / usr/sbin/groupadd dba

4.3 create an OSASM group: / usr/sbin/groupadd asmadmin

4.4 create an OSDBA group: / usr/sbin/groupadd asmdba

4.5 create software user: / usr/sbin/useradd-g oinstall-G dba asmdba oracle

4.6 create user password: passwd oracle

5 configure kernel parameters and resource limits 5.1 kernel parameters

Vim / etc/sysctl.conf / / add or edit

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

Net.ipv4.tcp_wmen = 262144 262144 262144

Net.ipv4.tcp_rmen = 4194304 4194304 4194304

Command: / sbin/sysctl-p / / Parameter takes effect

Command: / sbin/sysctl-a / / detect parameters.

5.2 limit parameters

Vim / etc/security/limits.conf

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft stack 10240

Oracle hard stack 32768

Vim / etc/pam.d/login

Session required pam_limits.so

6 create an oracle base directory

6.1 mkdir-p / u01/app/oracle

6.2 chown-R oracle:oinstall / u01/app/

6.3 chmod-R 775 / u01/app/

7 database file directory

7.1 mkdir / mount_point/oradata

7.2 chown oracle:oinstall / mount_point/oradata

7.3 chmod 775 / mount_point/oradata

8 restore the file directory

8.1 mkdir / mount_point/fast_recovery_area

8.2 chown oracle:oinstall / mount_point/fast_recovery_area

8.3 chmod 775 / mount_point/fast_recovery_area

9 Editing the Oracle user environment

9.1 su-oracle

9.2 vi .bash _ profile

Umask 022

Export TMP=/mount_point/tmp

Export TMPDIR=/mount_point/tmp

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_SID=orcle

Export ORACLE_HOME=/u01/app/oracle/ product/11.2.0/db_1

Export PATH=$ORACLE_HOME/bin/PATH

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.