ITPub博客

首页 > 数据库 > Oracle > 创建ASM完整步骤及截图

创建ASM完整步骤及截图

原创 Oracle 作者:wenjunheyixiao 时间:2016-02-26 00:57:27 0 删除 编辑

操作环境:linux6.5

所需介质

软件包安装

1.oracleasm-support的安装,在操作系统Packages下安装oracle-support

2.oracleasmlib-2.0.4-1.el6.x86_64.rpm,在官网下载

3.GI软件p13390677_112040_linux_x86-64_3of7.zip,在官网下载

[root@PROD1 mnt]# ls

hgfs  oracleasmlib-2.0.4-1.el6.x86_64.rpm  p13390677_112040_Linux-x86-64_3of7.zip

[root@PROD1 mnt]# df

Filesystem     1K-blocks      Used Available Use% Mounted on

/dev/sda3       36822724   6315312  28630268  19% /

tmpfs            1018232       224   1018008   1% /dev/shm

/dev/sda1         194241     55714    128287  31% /boot

.host:/        367000572 232994896 134005676  64% /mnt/hgfs

/dev/sr0         3794060   3794060         0 100% /media/OL6.5 x86_64 Disc 1 20131125

[root@PROD1 mnt]# cd /media/OL6.5\ x86_64\ Disc\ 1\ 20131125/Packages/

[root@PROD1 Packages]# rpm -ivh oracleasm-support-2.1.8-1.el6.x86_64.rpm 

warning: oracleasm-support-2.1.8-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Preparing...                ########################################### [100%]

   1:oracleasm-support      ########################################### [100%]

[root@PROD1 Packages]# cd /mnt

[root@PROD1 mnt]# ls

hgfs  oracleasmlib-2.0.4-1.el6.x86_64.rpm  p13390677_112040_Linux-x86-64_3of7.zip

[root@PROD1 mnt]# rpm -ivh oracleasmlib-2.0.4-1.el6.x86_64.rpm 

warning: oracleasmlib-2.0.4-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Preparing...                ########################################### [100%]

   1:oracleasmlib           ########################################### [100%]

配置用户及组,在root用户下

[root@PROD1 mnt]# groupadd asmadmin 

[root@PROD1 mnt]# groupadd asmdba 

[root@PROD1 mnt]# groupadd asmoper 

[root@PROD1 mnt]# groupadd dba

[root@PROD1 mnt]# groupadd oinstall

[root@PROD1 mnt]# useradd -g oinstall -G asmdba,asmadmin,asmoper,dba grid 

[root@PROD1 mnt]# useradd -g oinstall -G asmdba,asmadmin,dba oracle

[root@PROD1 mnt]# echo grid | passwd --stdin grid

Changing password for user grid.

passwd: all authentication tokens updated successfully.

[root@PROD1 mnt]# echo oracle | passwd --stdin oracle

Changing password for user oracle.

passwd: all authentication tokens updated successfully.

 

配置目录,在root用户下

[root@PROD1 mnt]# mkdir -p /u01/app/grid 

[root@PROD1 mnt]# mkdir -p /u01/app/11.2.0/grid 

[root@PROD1 mnt]# chown -R grid:oinstall /u01/app/grid /u01/app/11.2.0/grid

在root用户下,分配用户内存等内核参数资源

[root@PROD1 mnt]# vi /etc/security/limits.conf

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 1024

grid hard nofile 65536

grid soft stack 10240

配置grid用户的配置文件,在.bash_profile配置文件中添加

[root@PROD1 mnt]# su - grid

[grid@PROD1 ~]$ vi .bash_profile

 

 

# .bash_profile

 

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

 

 

# User specific environment and startup programs

 

 

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_SID=+ASM

export ORACLE_BASE=/u01/app/grid 

export ORACLE_HOME=/u01/app/11.2.0/grid 

export PATH=$PATH:$ORACLE_HOME/bin 

export ORACLE_OWNER=oracle 

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

 

[grid@PROD1 ~]$ source .bash_profile

 

创建ASM磁盘及配置ASMlib驱动

分区(分区之前先在虚拟机上新建4个大小为3G的磁盘)

[grid@PROD1 ~]$ su - 

Password: 

[root@PROD1 ~]# fdisk -l

 

 

Disk /dev/sda: 42.9 GB, 42949672960 bytes

255 heads, 63 sectors/track, 5221 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x000d40af

 

 

   Device Boot      Start         End      Blocks   Id  System

/dev/sda1   *           1          26      204800   83  Linux

Partition 1 does not end on cylinder boundary.

/dev/sda2              26         548     4194304   82  Linux swap / Solaris

Partition 2 does not end on cylinder boundary.

/dev/sda3             548        5222    37542912   83  Linux

 

 

Disk /dev/sdb: 3221 MB, 3221225472 bytes

255 heads, 63 sectors/track, 391 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x000f1e5f

 

 

   Device Boot      Start         End      Blocks   Id  System

 

 

Disk /dev/sdc: 3221 MB, 3221225472 bytes

255 heads, 63 sectors/track, 391 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x0001aeb7

 

 

   Device Boot      Start         End      Blocks   Id  System

 

 

Disk /dev/sde: 3221 MB, 3221225472 bytes

255 heads, 63 sectors/track, 391 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x000c3532

 

 

   Device Boot      Start         End      Blocks   Id  System

 

 

Disk /dev/sdd: 3221 MB, 3221225472 bytes

255 heads, 63 sectors/track, 391 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x000b360e

 

 

   Device Boot      Start         End      Blocks   Id  System

 

[root@PROD1 ~]# fdisk /dev/sdb

 

 

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

 

 

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-391, default 1): 

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-391, default 391): 

Using default value 391

 

 

Command (m for help): w

The partition table has been altered!

 

 

Calling ioctl() to re-read partition table.

Syncing disks.

[root@PROD1 ~]# fdisk /dev/sdc

..............

[root@PROD1 ~]# fdisk /dev/sdd

..............

[root@PROD1 ~]# fdisk /dev/sde

..............

 

配置ASMlib驱动(root用户

[root@PROD1 ~]# /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 (y/n) [n]: y

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

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver:                     [  OK  ]

Scanning the system for Oracle ASMLib disks:               [  OK  ]

创建ASM磁盘(root用户)

[root@PROD1 ~]# oracleasm createdisk VOL1 /dev/sdb1

Writing disk header: done

Instantiating disk: done

[root@PROD1 ~]# oracleasm createdisk VOL2 /dev/sdc1

Writing disk header: done

Instantiating disk: done

[root@PROD1 ~]# oracleasm createdisk VOL3 /dev/sdd1

Writing disk header: done

Instantiating disk: done

[root@PROD1 ~]# oracleasm createdisk VOL4 /dev/sde1

Writing disk header: done

Instantiating disk: done

[root@PROD1 ~]# oracleasm listdisks

VOL1

VOL2

VOL3

VOL4

安装GI

[root@PROD1 ~]# cd /mnt

[root@PROD1 mnt]# ls

grid  hgfs  oracleasmlib-2.0.4-1.el6.x86_64.rpm  p13390677_112040_Linux-x86-64_3of7.zip

[root@PROD1 mnt]# chown grid  p13390677_112040_Linux-x86-64_3of7.zip 

[root@PROD1 ~]# su - grid

[grid@PROD1 ~]$ cd /mnt

[grid@PROD1 mnt]$ ls

hgfs  oracleasmlib-2.0.4-1.el6.x86_64.rpm  p13390677_112040_Linux-x86-64_3of7.zip

[grid@PROD1 mnt]$ unzip p13390677_112040_Linux-x86-64_3of7.zip 

[grid@PROD1 mnt]$ ls

grid  hgfs  oracleasmlib-2.0.4-1.el6.x86_64.rpm  p13390677_112040_Linux-x86-64_3of7.zip

[grid@PROD1 mnt]$ cd grid

[grid@PROD1 grid]$ ls

install  readme.html  response  rpm  runcluvfy.sh  runInstaller  sshsetup  stage  welcome.html

[grid@PROD1 grid]$ ./runInstaller 

Starting Oracle Universal Installer...

 

 

Checking Temp space: must be greater than 120 MB.   Actual 26464 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 4095 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-01-04_05-57-08PM. Please wait ...[grid@PROD1 grid]$ 

 

 

 

 

 

 

 

 

 

[root@PROD1 ~]# mkdir -p /u01/app/oraInventory

[root@PROD1 ~]# chown grid:oinstall -R /u01/app/oraInventory

[root@PROD1 ~]# /tmp/CVU_11.2.0.4.0_grid/runfixup.sh

Response file being used is :/tmp/CVU_11.2.0.4.0_grid/fixup.response

Enable file being used is :/tmp/CVU_11.2.0.4.0_grid/fixup.enable

Log file location: /tmp/CVU_11.2.0.4.0_grid/orarun.log

Setting Kernel Parameters...

The value for shmmni in response file is not greater than value of shmmni for current session. Hence not changing it.

The value for semmsl in response file is not greater than value of semmsl for current session. Hence not changing it.

The value for semmns in response file is not greater than value of semmns for current session. Hence not changing it.

The value for semmni in response file is not greater than value of semmni for current session. Hence not changing it.

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.wmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_max = 1048576

The value for aio-max-nr in response file is not greater than value of aio-max-nr for current session. Hence not changing it.

[root@PROD1 ~]# cd /media/OL6.5\ x86_64\ Disc\ 1\ 20131125/Packages/

[root@PROD1 Packages]# rpm -ivh ksh-20120801-10.el6.x86_64.rpm 

warning: ksh-20120801-10.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Preparing...                ########################################### [100%]

   1:ksh                    ########################################### [100%]

[root@PROD1 Packages]# rpm -ivh libaio-devel-0.3.107-10.el6.x86_64.rpm 

warning: libaio-devel-0.3.107-10.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Preparing...                ########################################### [100%]

   1:libaio-devel           ########################################### [100%]

 

 

[root@PROD1 Packages]# /u01/app/oraInventory/orainstRoot.sh

[root@PROD1 Packages]# /u01/app/11.2.0/grid/root.sh

 

 

点击OK;SKip跳过继续安装

 

 

通过grid用户执行crs_stat -t 检查asm是否安装好,并且要配置要监听,监听端口号不要设置为

1521,因为1521会被占用。

[grid@PROD1 grid]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora.DATA.dg    ora....up.type ONLINE    ONLINE    prod1       

ora....ER.lsnr ora....er.type ONLINE    ONLINE    prod1       

ora.asm        ora.asm.type   ONLINE    ONLINE    prod1       

ora.cssd       ora.cssd.type  ONLINE    ONLINE    prod1       

ora.diskmon    ora....on.type OFFLINE   OFFLINE               

ora.evmd       ora.evm.type   ONLINE    ONLINE    prod1       

ora.ons        ora.ons.type   OFFLINE   OFFLINE           

[grid@PROD1 grid]$ sqlplus / as sysasm

 

 

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 4 18:32:24 2016

 

 

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

 

 

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Automatic Storage Management option

SQL> select name from v$asm_disk;

 

 

NAME

------------------------------

VOL1

VOL2

VOL3

VOL4

 

 

SQL> select name from v$asm_diskgroup;

 

 

NAME

------------------------------

DATA

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30606702/viewspace-1994837/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-12-02

  • 博文量
    117
  • 访问量
    160429