Configure ASM on Oracle 11.2.0.3-阿里云开发者社区

ASM存储的作用和好处以及劣势，在这里就不多做介绍了，google下相关的资料多如牛毛！本文主要记录如何在oracle 11.2.0.3版本上面使用ASM存储！相关的软件包可以在http://support.oracle.com网站上下载到，11.2.0.3的补丁集只需要下载前3个即可，在10g中，ASM是包含在数据库软件包当中的，在11g里面，需要单独安装grid infrastructure才可以使用ASM，一般推荐的做法是新建一个grid用户来管理ASM实例！在开始之前要先安装好必须得软件包，调整好内核参数，以及grid，oracle用户的最大进程数和文件句柄打开数等等，这方面的配置可以参考oracle 11g的online document

一：创建用户和相关目录，设置用户的环境变量和目录权限

[root@dg63 ~]# groupadd -g 501 oinstall
[root@dg63 ~]# groupadd -g 502 dba
[root@dg63 ~]# groupadd -g 503 oper
[root@dg63 ~]# groupadd -g 504 asmadmin
[root@dg63 ~]# groupadd -g 506 asmdba
[root@dg63 ~]# groupadd -g 507 asmoper
[root@dg63 ~]# useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper grid
[root@dg63 ~]# useradd -u 502 -g oinstall -G dba,asmdba,oper oracle

[root@dg63 ~]# mkdir -p /u01/app/11.2.0/grid
[root@dg63 ~]# mkdir -p /u01/app/oracle/product/11.2.0/db_1
[root@dg63 ~]# mkdir -p /u01/app/grid
[root@dg63 ~]# mkdir -p /u01/app/oraInventory
[root@dg63 ~]# chown -R oracle.oinstall /u01
[root@dg63 ~]# chown -R grid.oinstall /u01/app/11.2.0/grid/
[root@dg63 ~]# chown -R grid.oinstall /u01/app/grid/
[root@dg63 ~]# chown -R grid.oinstall /u01/app/oraInventory/

[root@dg63 ~]# echo oracle |passwd --stdin oracle
Changing password for user oracle.
passwd: all authentication tokens updated successfully.
[root@dg63 ~]# echo oracle |passwd --stdin grid
Changing password for user grid.
passwd: all authentication tokens updated successfully.
[root@dg63 ~]# id oracle
uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)
[root@dg63 ~]# id grid
uid=501(grid) gid=501(oinstall) groups=501(oinstall),504(asmadmin),506(asmdba),507(asmoper)

[root@dg63 ~]# cat /home/grid/.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 ORACLE_TERM=xterm
export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
export TNS_ADMIN= $ORACLE_HOME/network/admi export PATH=.:/usr/sbin:$ ORACLE_HOME/bin: $ORACLE_HOME/jdk/bin:$ PATH
export LD_LIBRARY_PATH= $ORACLE_HOME/lib:/usr/X11R6/lib:$ LD_LIBRARY_PATH
export CLASSPATH= $ORACLE_HOME/jlib:$ ORACLE_HOME/rdbms/jlib:$CLASSPATH
export NLS_LANG="american_america.AL32UTF8"
export EDITOD=vim
export LANG=en_us.UTF-8
export NLS_DATE_FORMAT=yyyy-mm-dd:hh24:mi:ss
export TEMP=/tmp
export TMPDIR=/tmp
umask 022

alias sqlplus='/usr/local/rlwrap/bin/rlwrap sqlplus'
alias rman='/usr/local/rlwrap/bin/rlwrap rman'

[root@dg63 ~]# cat /home/oracle/.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=dg63
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME= $ORACLE_BASE/product/11.2.0/db_1 export ORACLE_TERM=xterm export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS" export TNS_ADMIN=$ ORACLE_HOME/network/admi
export PATH=.:/usr/sbin: $ORACLE_HOME/bin:$ ORACLE_HOME/jdk/bin: $PATH export LD_LIBRARY_PATH=$ ORACLE_HOME/lib:/usr/X11R6/lib: $LD_LIBRARY_PATH export CLASSPATH=$ ORACLE_HOME/jlib: $ORACLE_HOME/rdbms/jlib:$ CLASSPATH
export NLS_LANG="american_america.AL32UTF8"
export EDITOD=vim
export LANG=en_us.UTF-8
export NLS_DATE_FORMAT=yyyy-mm-dd:hh24:mi:ss
export TEMP=/tmp
export TMPDIR=/tmp
umask 022

alias sqlplus='/usr/local/rlwrap/bin/rlwrap sqlplus'
alias rman='/usr/local/rlwrap/bin/rlwrap rman'

[grid@dg63 ~]$ asmca

 
 

  
  [root@dg63 ~]# ps -ef |grep ASM  

  
  grid      7094     1  0 22:08 ?        00:00:00 asm_pmon_+ASM  

  
  grid      7096     1  0 22:08 ?        00:00:00 asm_psp0_+ASM  

  
  grid      7098     1  0 22:08 ?        00:00:00 asm_vktm_+ASM  

  
  grid      7102     1  0 22:08 ?        00:00:00 asm_gen0_+ASM  

  
  grid      7104     1  0 22:08 ?        00:00:00 asm_diag_+ASM  

  
  grid      7106     1  0 22:08 ?        00:00:00 asm_dia0_+ASM  

  
  grid      7108     1  0 22:08 ?        00:00:00 asm_mman_+ASM  

  
  grid      7110     1  0 22:08 ?        00:00:00 asm_dbw0_+ASM  

  
  grid      7112     1  0 22:08 ?        00:00:00 asm_lgwr_+ASM  

  
  grid      7114     1  0 22:08 ?        00:00:00 asm_ckpt_+ASM  

  
  grid      7116     1  0 22:08 ?        00:00:00 asm_smon_+ASM  

  
  grid      7118     1  0 22:08 ?        00:00:00 asm_rbal_+ASM  

  
  grid      7120     1  0 22:08 ?        00:00:00 asm_gmon_+ASM  

  
  grid      7122     1  0 22:08 ?        00:00:00 asm_mmon_+ASM  

  
  grid      7124     1  0 22:08 ?        00:00:00 asm_mmnl_+ASM  

  
  grid      7126     1  0 22:08 ?        00:00:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))  

  
  root      7167  5727  0 22:12 pts/2    00:00:00 grep ASM

三：使用oracle用户dbca建库，并验证！

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SQL> select name,open_mode from v$database;

NAME OPEN_MODE
--------- --------------------
DG63 READ WRITE

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/dg63/onlinelog/group_1.257.766190357
+FRA/dg63/onlinelog/group_1.257.766190365
+DATA/dg63/onlinelog/group_2.258.766190367
+FRA/dg63/onlinelog/group_2.258.766190373
+DATA/dg63/onlinelog/group_3.259.766190375
+FRA/dg63/onlinelog/group_3.259.766190383

6 rows selected.

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+DATA/dg63/datafile/system.260.766190391
+DATA/dg63/datafile/sysaux.261.766190445
+DATA/dg63/datafile/undotbs1.262.766190487
+DATA/dg63/datafile/users.264.766190515

SQL> show parameter control;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      +DATA/dg63/controlfile/current
                                                 .256.766190349, +FRA/dg63/cont
                                                 rolfile/current.256.766190353
control_management_pack_access       string      DIAGNOSTIC+TUNING

SQL> select name,open_mode from v$database;

NAME OPEN_MODE
--------- --------------------
DG63 READ WRITE

SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/dg63/spfiledg63.ora

SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/dg63/spfiledg63.ora
SQL> show parameter instance;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
active_instance_count                integer
cluster_database_instances           integer     1
instance_groups                      string
instance_name                        string      dg63
instance_number                      integer     0
instance_type                        string      RDBMS
open_links_per_instance              integer     4
parallel_instance_group              string
parallel_server_instances            integer     1
本文转自斩月博客51CTO博客，原文链接http://blog.51cto.com/ylw6006/704738如需转载请自行联系原作者

ylw6006

Configure ASM on Oracle 11.2.0.3

热门文章

最新文章

相关课程

相关电子书

推荐镜像

探索云世界

热门

云计算

大数据

云原生

人工智能

数据库

开发与运维

活动广场

任务中心

训练营

直播

乘风者计划

下载

镜像站

技术资料