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

开发者社区> 数据库> 正文

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

 

 

 


  1. [root@dg63 ~]# ps -ef |grep ASM  
  2. grid      7094     1  0 22:08 ?        00:00:00 asm_pmon_+ASM  
  3. grid      7096     1  0 22:08 ?        00:00:00 asm_psp0_+ASM  
  4. grid      7098     1  0 22:08 ?        00:00:00 asm_vktm_+ASM  
  5. grid      7102     1  0 22:08 ?        00:00:00 asm_gen0_+ASM  
  6. grid      7104     1  0 22:08 ?        00:00:00 asm_diag_+ASM  
  7. grid      7106     1  0 22:08 ?        00:00:00 asm_dia0_+ASM  
  8. grid      7108     1  0 22:08 ?        00:00:00 asm_mman_+ASM  
  9. grid      7110     1  0 22:08 ?        00:00:00 asm_dbw0_+ASM  
  10. grid      7112     1  0 22:08 ?        00:00:00 asm_lgwr_+ASM  
  11. grid      7114     1  0 22:08 ?        00:00:00 asm_ckpt_+ASM  
  12. grid      7116     1  0 22:08 ?        00:00:00 asm_smon_+ASM  
  13. grid      7118     1  0 22:08 ?        00:00:00 asm_rbal_+ASM  
  14. grid      7120     1  0 22:08 ?        00:00:00 asm_gmon_+ASM  
  15. grid      7122     1  0 22:08 ?        00:00:00 asm_mmon_+ASM  
  16. grid      7124     1  0 22:08 ?        00:00:00 asm_mmnl_+ASM  
  17. grid      7126     1  0 22:08 ?        00:00:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))  
  18. 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

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章