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

Inscription: the installation and configuration of oracle and ASM should be regarded as a clich é. As the installation and configuration method of 11gR2 is very different from that of the previous version, I specially took the time to do this experiment and share the whole installation process with you. I hope I can help you, please give more advice! 1. Preparation work

(1) operating system version

[root@AS5] # uname-a

Linux AS5 2.6.18-164.el5 # 1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux

(2) creation of Yum warehouse

[root@AS5] # mount-o remount / dev/hdc / mnt

[root@AS5 ~] # cat / etc/yum.repos.d/rhel-debuginfo.repo

[rhel-debuginfo]

Name=Red Hat Enterprise Linux $releasever-$basearch-Debug

Baseurl= file:///mnt/Server

Enabled=1

Gpgcheck=0

[root@AS5 ~] # yum clean all

Loaded plugins: rhnplugin, security

Cleaning up Everything

[root@AS5 ~] # yum grouplist

(3) hard disk, memory and other information

[root@AS5] # df-H

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 17G 2.7G 14G 17% /

/ dev/sda1 104m 12m 87m 12% / boot

Tmpfs 1.1G 0 1.1G 0% / dev/shm

/ dev/hdc 3.1g 3.1g 0100% / mnt

[root@AS5] # free-m

Total used free shared buffers cached

Mem: 1010 239 771 0 15 184

-/ + buffers/cache: 39 971

Swap: 2000 0 2000

(4) Network configuration

[root@AS5 ~] # ifconfig eth0

Eth0 Link encap:Ethernet HWaddr 00:0C:29:C7:70:76

Inet addr:172.24.0.200 Bcast:172.24.0.255 Mask:255.255.255.0

Inet6 addr: fe80::20c:29ff:fec7:7076/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:1343052 errors:31 dropped:31 overruns:0 frame.:0

TX packets:113486 errors:0 dropped:0 overruns:0 carrier:0

Collisions:0 txqueuelen:1000

RX bytes:2019886062 (1.8 GiB) TX bytes:11644712 (11.1 MiB)

Interrupt:75 Base address:0x2000

[root@AS5 ~] # hostname

AS5

[root@AS5 ~] # cat / etc/sysconfig/network

NETWORKING=yes

NETWORKING_IPV6=no

HOSTNAME=AS5

GATEWAY=172.24.0.1

[root@AS5 ~] # cat / etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost AS5

:: 1 localhost6.localdomain6 localhost6

172.24.0.200 AS5

(5) install the necessary software packages

The necessary software packages required by oracle are as follows:

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

Installation method: (I added these two packages during installation: libXp pdksh)

[root@AS5 ~] # yum-y install binutils compat-* elfutils-libelf* gcc gcc-c++ glibc* kernel-headers ksh libaio* libgcc libgomp libstdc++* make sysstat unixODBC* libXp pdksh

(6) establish users and groups

[root@AS5 ~] # groupadd oinstall

[root@AS5 ~] # groupadd dba

[root@AS5 ~] # groupadd asmadmin

[root@AS5 ~] # groupadd asmdba

[root@AS5] # useradd-g oinstall-G asmdba,asmadmin,dba grid

[root@AS5] # useradd-g oinstall-G dba,asmdba oracle

[root@AS5 ~] # passwd grid

[root@AS5 ~] # passwd oracle

[root@AS5 ~] # id grid

Uid=500 (grid) gid=500 (oinstall) groups=500 (oinstall), 501,502 (asmadmin), 503 (asmdba)

[root@AS5 ~] # id oracle

Uid=501 (oracle) gid=500 (oinstall) groups=500 (oinstall), 501 (dba), 503 (asmdba)

(7) configure kernel parameters and other configuration options

Add the following to the / etc/sysctl.conf configuration file:

# = oracle11gr2=

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

Then execute:

[root@AS5] # sysctl-p

Then add to the / etc/security/limits.conf configuration file:

# = oracle11gr2==

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Grid soft nproc 2047

Grid hard nproc 16384

Grid soft nofile 1024

Grid hard nofile 65536

Add to the / etc/pam.d/login configuration file:

# = oracle11gr2=

Session required pam_limits.so

Add to the / etc/profile configuration file:

# = oracle11gr2=

If [$USER = "oracle"] | | [$USER = "grid"]; then

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

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

(8) establish the corresponding catalogue

[root@AS5] # mkdir-p / u01/app/oracle

[root@AS5] # chown-R oracle:oinstall / U01

[root@AS5] # chmod-R 775 / U01

(9) configure environment variables for grid and oracle users

Add: to the ~ grid/.bash_profile configuration file:

# = oracle11gr2-grid = =

Umask 022

TMP=/tmp

TMPDIR=/tmp

PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin

ORACLE_BASE=/u02/app/grid

ORACLE_HOME=$ORACLE_BASE/11.2.0

ORACLE_SID=+ASM

PATH=$ORACLE_HOME/bin:$PATH

Export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH TMP TMPDIR

# stty erase ^ h

Add: to the ~ oracle/.bash_profile configuration file:

# = = oracle11gr2=

Umask 022

TMP=/tmp

TMPDIR=/tmp

PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin

LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

ORACLE_SID=ora10

LD_LIBRARY_PATH=$ORACLE_HOME/jdk/jre/lib/i386:$ORACLE_HOME/jdk/jre/lib/i386/server:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH

PATH=$ORACLE_HOME/bin:$PATH

NLS_LANG=American_America.ZHS16GBK

Export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH NLS_LANG TMP TMPDIR

Stty erase ^ h

At this point, the whole environment has been built. If possible, it is recommended to restart the system.

2. Install ASM Storage (grid)

Note: if the database files are stored directly in the file system, this step can be skipped.

(1) the system now has free partitions

[root@AS5 install] # fdisk-l / dev/sdb

Disk / dev/sdb: 21.4 GB, 21474836480 bytes

255 heads, 63 sectors/track, 2610 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/ dev/sdb1 1 2610 20964793 + 5 Extended

/ dev/sdb5 1 366 2939832 83 Linux

/ dev/sdb6 367,732 2939863 + 83 Linux

/ dev/sdb7 733 1098 2939863 + 83 Linux

/ dev/sdb8 1099 1342 1959898 + 83 Linux

[root@AS5 u02] # chown grid:asmadmin / dev/sdb?

[root@AS5 U02] # ls-l / dev/sdb?

Brw-r- 1 grid asmadmin 8, 17 Jul 15 18:25 / dev/sdb1

Brw-r- 1 grid asmadmin 8, 21 Jul 15 18:24 / dev/sdb5

Brw-r- 1 grid asmadmin 8, 22 Jul 15 18:25 / dev/sdb6

Brw-r- 1 grid asmadmin 8, 23 Jul 15 18:24 / dev/sdb7

Brw-r- 1 grid asmadmin 8, 24 Jul 15 18:25 / dev/sdb8

(2) install AMBlib package

[root@AS5 U02] # rpm-ivh oracleasm-support-2.1.3-1.el5.i386.rpm

Preparing... # [100%]

1:oracleasm-support # # [100%]

[root@AS5 U02] # rpm-ivh oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm

Warning: ora005_oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... # [100%]

1:oracleasm-2.6.18-164.el### [100%]

[root@AS5 U02] # rpm-ivh oracleasmlib-2.0.4-1.el5.i386.rpm

Preparing... # [100%]

1:oracleasmlib # # [100%]

(3) configure ASM

[root@AS5 u02] # / etc/init.d/oracleasm configure

Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library

Driver. The following questions will determine whether the driver is

Loaded on boot and what permissions it will have. The current values

Will be shown in brackets ('[]'). Hitting without typing an

Answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: grid

Default group to own the driver interface []: asmadmin

Start Oracle ASM library driver on boot (yzone) [n]: y

Scan for Oracle ASM disks on boot (yzone) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver: [OK]

Scanning the system for Oracle ASMLib disks: [OK]

[root@AS5 u02] # / usr/sbin/oracleasm init

(4) create ASM disk

[root@AS5 u02] # service oracleasm createdisk VOL01 / dev/sdb5

Marking disk "VOL01" as an ASM disk: [OK]

[root@AS5 u02] # service oracleasm createdisk VOL02 / dev/sdb6

Marking disk "VOL02" as an ASM disk: [OK]

[root@AS5 u02] # service oracleasm createdisk VOL03 / dev/sdb7

Marking disk "VOL03" as an ASM disk: [OK]

[root@AS5 u02] # service oracleasm createdisk VOL04 / dev/sdb8

Marking disk "VOL04" as an ASM disk: [OK]

[root@AS5 u02] # oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks...

Scanning system for ASM disks...

[root@AS5 u02] # oracleasm listdisks

VOL01

VOL02

VOL03

VOL04

(5) shut down the time service

[root@AS5 u02] # service ntpd stop

Shutting down ntpd: [FAILED]

[root@AS5 u02] # chkconfig ntpd off

[root@AS5 u02] # mv / etc/ntp.conf / etc/ntp.conf_bak

Continue the next part, "detailed Operation of Oracle11gR2+ASM installation (2)" http://space.itpub.net/25881373/viewspace-702462

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.