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

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

Configure ASM on Oracle 11.2.0.3

科技探索者 2017-11-13 799浏览量

简介：

  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. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    18. 

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



三：使用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





            
            

                

                    SQL
                    Oracle
                    关系型数据库
                    数据库管理
                    Java
                    存储
                    开发工具
                    Linux
                    数据库
                    Perl
                

            


            

            

                

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

            


            

                分享：
                
                        

                            
                        

                    
                
            


        

        

            
            
        


        

            

        

    

    

    

        

        

            

                
                    
                
                

                    数据库
                    

                        

                            
                            使用钉钉扫一扫加入圈子
                        

                    

                

                

                    + 订阅
                

            

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

            

        


        

        

            
            
其他文章


            

                

                    

                        

                        
展开