本文共 6856 字，大约阅读时间需要 22 分钟。
ASM存储的作用和好处以及劣势，在这里就不多做介绍了，google下相关的资料多如牛毛！本文主要记录如何在oracle 11.2.0.3版本上面使用ASM存储！相关的软件包可以在网站上下载到，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' |
| [root@dg63 ~]# oracleasm listdisks DATA FRA [root@dg63 ~]# su - grid [grid@dg63 ~]$ cd /u01/11.2.0.3/grid/ [grid@dg63 grid]$ ./runInstaller |
[grid@dg63 ~]$ asmca
三：使用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 |
转载地址：http://chvbo.baihongyu.com/