Oracle-asm Installation Tutorials

The steps to install the ASM database are much more repetitive than the steps to install RAC, so the installation documentation for the previous RAC has been modified to successfully install the ASM-managed database. The installed environment is the centos6.5_64 bit, and the database to be installed is the 11GR2 version.

The steps to install are as follows:

1. Create operating system groups and users

GROUPADD-G 501 Oinstall

GROUPADD-G 502 DBA

GROUPADD-G 504 Asmadmin

GROUPADD-G 506 ASMDBA

GROUPADD-G 507 Asmoper

Useradd-u 501-g oinstall-g dba,asmadmin,asmdba,asmoper grid

Useradd-u 502-g oinstall-g Dba,asmdba Oracle

Modify User Password

passwd grid

passwd Oracle

2. vim/etc/hosts Edit File

192.168.62.102 ASM

3. Configure kernel parameters and resource limits for Oracle, grid users

Vim/etc/sysctl.conf

FS.AIO-MAX-NR = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 4294967295

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

/sbin/sysctl-p

Vim/etc/security/limits.conf

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

Vim/etc/pam.d/login

Session Required Pam_limits.so

Vim/etc/profile

if [$USER = "Oracle"] | | [$USER = "Grid"]; Then

if [$SHELL = "/bin/ksh"]; Then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Umask 022

Fi

4. Turn off SELinux function

Vim/etc/selinux/config

Selinux=disabled

Rebooting the system

[/etc/init.d/oracleasm createdisk data1/dev/sdb1 This step error, restart after the resolution]

4. Create the relevant path for GI database software

#创建Inventory路径

Mkdir-p/u01/app/orainventory

Chown-r grid:oinstall/u01/app/orainventory

Chmod-r 775/u01/app/orainventory

#创建GI主目录

Mkdir-p/u01/app/grid

Chown-r Grid:oinstall/u01/app/grid

Chmod-r 775/u01/app/grid

#创建数据库主目录

Mkdir-p/u01/app/oracle

Mkdir/u01/app/oracle/cfgtoollogs

Chown-r oracle:oinstall/u01/app/oracle

Chmod-r 775/u01/app/oracle

#切换到对应的用户操作

# Vim ~/.bash_profile

#Grid ADD

Export Oracle_sid=+asm

Export Oracle_base=/u01/app/grid

Export Oracle_home=/u01/app/11.2.0/grid

Export path= $ORACLE _home/bin: $PATH

#oracleAdd

Export ORACLE_SID=ORCL

Export ORACLE_UNQNAME=ORCL

Export Oracle_base=/u01/app/oracle

Export Oracle_home= $ORACLE _base/product/11.2.0/db_1

Export path= $ORACLE _home/bin: $PATH

5. Verify that the following OS packages are installed

SH yum.sh

Yum Install binutils*-y

Yum Install compat*-y

Yum Install elfutils*-y

Yum Install gcc*-y

Yum Install glibc*-y

Yum Install kernel*-y

Yum Install ksh*-y

Yum Install libaio*-y

Yum Install libgcc*-y

Yum Install libgomp*-y

Yum Install libstdc*-y

Yum Install make*-y

Yum Install sysstat*-y

Yum Install unixodbc*-y

Yum Install libcap*-y

Yum Install-y compat-libcap1*

Yum Install-y compat-libstdc*

6, the use of FDISK/DEV/SDB allocation of disk space, 10G of space allocated to/DEV/SDB1,/DEV/SDB2,/dev/sdb3 three disks

N P W

Device Boot Start End Blocks Id System

/DEV/SDB1 1 393 3156741 Linux

/DEV/SDB2 394 786 3156772+-up Linux

/DEV/SDB3 787 1179 3156772+-up Linux

7. Turn off the firewall

/etc/init.d/iptables stop;

Chkconfig iptables off;

8. Install Asmlib and create ASM disks

To download the oracleasm, find the relevant version download in the address below:

Http://www.oracle.com/technetwork/topics/linux/asmlib/index-101839.html

Yum-y Install kmod-oracleasm.x86_64

RPM-IVH oracleasmlib-2.0.4-1.el6.x86_64.rpm

RPM-IVH oracleasm-support-2.1.8-1.el6.x86_64.rpm

9. Create ASM HDD

/etc/init.d/oracleasm Configure

Default user to own the driver interface [Oracle]: Grid

Default Group to own the driver interface [Oinstall]:

Start Oracle ASM Library driver on Boot (y/n) [y]:

Scan for Oracle ASM disks on Boot (y/n) [y]:

/etc/init.d/oracleasm Enable

/etc/init.d/oracleasm Createdisk DATA1/DEV/SDB1

/etc/init.d/oracleasm Createdisk DATA2/DEV/SDB2

/etc/init.d/oracleasm Createdisk DATA3/DEV/SDB3

/etc/init.d/oracleasm Listdisks

10. Install GI

To switch to a grid user:

Exprot Lang=en_us

Go to the Package folder to execute./runinstaller, the next step is through the interface, follow the interface prompts to walk down.

When adding daemon to inittab occurs while executing the root.sh script, the following command is executed immediately in another window using root (otherwise root.sh script fails):

/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/nullbs=1024 Count=1,

Until it's stuck.

11. Install database Software

Switch to Oracle User

Exprot Lang=en_us

Go to the database folder to execute./runinstaller, follow the interface prompts step-by-step down.

12, DBCA set up an example

When creating an instance, storage type selects ASM, and the other is the same as the normal installation.

This article is from the "three countries Cold jokes" blog, please be sure to keep this source http://myhwj.blog.51cto.com/9763975/1825835

Oracle-asm Installation Tutorials