ITPub博客

首页 > 数据库 > Oracle > 配置ASM

配置ASM

Oracle 作者:wenjunheyixiao 时间:2016-01-21 21:40:16 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@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-1980433/,如需转载,请注明出处,否则将追究法律责任。

上一篇: flashback drop
下一篇: RAC---命令集
请登录后发表评论 登录
全部评论

注册时间:2015-12-02

  • 博文量
    117
  • 访问量
    160347