oracle11gR2_asm安装.doc

Oracle 11gR2 for Linux 安装注：#开头的命令对应root用户执行，$开始的命令对应grid和oracle用户首先，创建四个组oinstall, dba, asmadmin, asmdba：#groupadd -g 1000 oinstall#groupadd -g 1100 dba#groupadd -g 1200 asmadmin#groupadd -g 1300 asmdba再创建两个用户grid和oracle：#useradd -u 1001 -g oinstall -G asmdba,asmadmin,dba grid#passwd grid#useradd -u 1002 -g oinstall -G dba,asmdba oracle#passwd oracle创建目录和授权：#mkdir -p /u01/app/grid 注:此目录用来安装grid软件#chown -R grid:oinstall /u01#chmod -R 775 /u01#mkdir -p /u02/app/oracle 注：此目录用来安装oracle软件#chown -R oracle:oinstall /u02#chmod -R 775 /u02所需的rpm包，参照oracle官方文档，根据不同的操作系统版本，rpm包的版本有所区别，包名肯定是一样的。binutils-.6compat-libstdc+-33-3.2.3elfutils-libelf-0.125elfutils-libelf-devel-0.125elfutils-libelf-devel-static-0.125gcc-4.1.2gcc-c+-4.1.2glibc-2.5-24glibc-common-2.5glibc-devel-2.5glibc-headers-2.5kernel-headers-2.6.18ksh-20060214libaio-0.3.106libaio-devel-0.3.106libgcc-4.1.2libgomp-4.1.2libstdc+-4.1.2libstdc+-devel-4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-devel-2.2.11pdksh编辑grid和oracle用户的.bash_profile,设置环境变量：1.grid 用户的.bash_profileumask 022export TMP=/tmpexport TMPDIR=/tmpexport ORACLE_BASE=/u01/appexport ORACLE_HOME=$ORACLE_BASE/gridexport PATH=$ORACLE_HOME/bin:$PATHexport ORACLE_SID=+ASMexport ORACLE_HOSTNAME=rhel54 注：rhel54是我的计算机名2.oracle 用户的.bash_profileumask 022export TMP=/tmpexport TMPDIR=/tmpexport ORACLE_BASE=/u02/appexport ORACLE_HOME=$ORACLE_BASE/oracleexport PATH=$ORACLE_HOME/bin:$PATHexport ORACLE_SID=ora11gexport ORACLE_HOSTNAME=rhel54 注：rhel54是我的计算机名编辑如下文件，设置相关的值。1.编辑/etc/security/limits.conf，添加如下行：grid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536grid hard stack 10240oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle hard stack 102402.编辑/etc/pam.d/login 添加如下行：session required pam_limits.so编辑/etc/profile ，添加如下行：if $USER = oracle | $USER = grid ; then if $SHELL = /bin/ksh ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022fi3.编辑/etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586执行 #sysctl p命令，使设置生效。安装asmlib包：/technology/software/tech/linux/asmlib/rhel5.html 下载asmlib相关的三个包，并上传到服务器上：oracleasm-2.6.18-164.el5PAE-2.0.5-1.el5.i686.rpmoracleasmlib-2.0.4-1.el5.i386.rpmoracleasm-support-2.1.3-1.el5.i386.rpm注：第一个包一定要和操作系统内核的版本相对应用#uname r查看内核版本：rootrhel54 test# uname -r2.6.18-164.el5PAE2.安装asmlib包#rpm -Uvh oracleasm*.rpm安装完asmlib包之后，执行如下命令：#/usr/sbin/oracleasm configure -i输入用户grid,输入用户组asmadmin执行#/usr/sbin/oracleasm init 命令3.创建asm磁盘，我创建了两个asm磁盘。操作系统的分区情况如下：rootrhel54 grid# fdisk -lDisk /dev/sda: 440.0 GB, 440073715712 bytes255 heads, 63 sectors/track, 53502 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System/dev/sda1 * 1 7649 61440561 83 Linux/dev/sda2 7650 8171 4192965 82 Linux swap / Solaris/dev/sda3 8172 53502 364121257+ 5 Extended/dev/sda5 8172 10662 20008926 83 Linux/dev/sda6 10663 13153 20008926 83 Linux/dev/sda7 13154 15644 20008926 83 Linux#chown grid:asmadmin /dev/sda5#chown grid:asmadmin /dev/sda6#/usr/sbin/oracleasm createdisk VOL1 /dev/sda5#/usr/sbin/oracleasm createdisk VOL2 /dev/sda6#/usr/sbin/oracleasm scandisksrootrhel54 grid# /usr/sbin/oracleasm scandisksReloading disk partitions: doneCleaning any stale ASM disks.Scanning system for ASM disks.#/usr/sbin/oracleasm listdisksrootrhel54 grid# /usr/sbin/oracleasm listdisksVOL1VOL2NTP setting:#/sbin/service ntpd stop#chkconfig ntpd off#mv /etc/ntp.conf /etc/ntp.conf.bak上面所有配置完成后，重启一下服务器。安装grid软件将数据库软件上传到服务器，并解压，上传软件个人建议使用Xmanager3.0，这是个非常好的软件，速度快，走ssh，安全。以grid用户登录服务器，进入到grid软件所在目录，$cd /test/grid$./runInstaller 开始安装grid，直接上图：下图中选择第二项：下图中是创建asm磁盘组：下图设置sys和asmsnmp用户口令，会有口令强度不足的警告提示，直接next下图中选yes，直接继续：下图中，各选项默认即可：下图中是Grid的安装目录：当安装到76%时，提示执行以下脚本，以root用户执行：确认安装是否成功：gridrhel54 $ ps -ef |grep +ASMgrid 8379 1 0 14:47 ? 00:00:00 asm_pmon_+ASMgrid 8381 1 0 14:47 ? 00:00:00 asm_vktm_+ASMgrid 8385 1 0 14:47 ? 00:00:00 asm_gen0_+ASMgrid 8387 1 0 14:47 ? 00:00:00 asm_diag_+ASMgrid 8389 1 0 14:47 ? 00:00:00 asm_psp0_+ASMgrid 8391 1 0 14:47 ? 00:00:00 asm_dia0_+ASMgrid 8393 1 0 14:47 ? 00:00:00 asm_mman_+ASMgrid 8395 1 0 14:47 ? 00:00:00 asm_dbw0_+ASMgrid 8397 1 0 14:47 ? 00:00:00 asm_lgwr_+ASMgrid 8399 1 0 14:47 ? 00:00:00 asm_ckpt_+ASMgrid 8401 1 0 14:47 ? 00:00:00 asm_smon_+ASMgrid 8403 1 0 14:47 ? 00:00:00 asm_rbal_+ASMgrid 8405 1 0 14:47 ? 00:00:00 asm_gmon_+ASMgrid 8407 1 0 14:47 ? 00:00:00 asm_mmon_+ASMgrid 8409 1 0 14:47 ? 00:00:00 asm_mmnl_+ASMgridrhel54 $ sqlplus / as sysasmSQL*Plus: Release .0 Production on Thu Jan 7 14:57:49 2010Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release .0 - ProductionWith the Automatic Storage Management optionSQL select name from v$asm_disk;NAME-VOL1SQL select name from v$asm_diskgroup;NAME-DG1SQL安装oracle软件以oracle用户登录$cd /test/database$./runInstaller开始安装oracle软件：下图中两项均为空：下图中点yes，忽略错误：下图中选第二项，只安装oracle软件，稍后以dbca创建数据库：下图中选第一项，单实例数据库：下图中各选项默认即可：当安装到94%时，提示执行如下脚本，以root用户执行：#sh /u02/app/oracle/root.shRunning Oracle 11g root.sh script.The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u02/app/oracleEnter the full pathname of the local bin directory: /usr/local/bin: The file dbhome already exists in /usr/local/bin. Overwrite it? (y/n) n: The file oraenv already exists in /usr/local/bin. Overwrite it? (y/n) n: The file coraenv already exists in /usr/local/bin. Overwrite it? (y/n) n: Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.创建数据库以oracle用户登录，输入dbca，开始建库：下图中“storage type” 项选asm耐心等待：验证结果：SQL select * from v$version;BANNER-Oracle Database 11g Enterprise Edition Release .0 - ProductionPL/SQL Release .0 - ProductionCORE .0 ProductionTNS for Linux: Version .0 - ProductionNLSRTL Version .0 - ProductionSQL select * from v$option;PARAMETER VALUE- -Partitioning TRUEObjects TRUEReal Application Clusters FALSEAdvanced replication TRUEBit-mapped indexes TRUEConnection multiplexing TRUEConnection pooling TRUEDatabase queuing TRUEIncremental backup and recovery TRUEInstead-of triggers TRUEParallel backup and recovery TRUEPARAMETER VALUE- -Parallel execution TRUEParallel load TRUEPoint-in-time tablespace recovery TRUEFine-grained access control TRUEProxy authentication/authorization TRUEChange Data Capture TRUEPlan Stability TRUEOnline Index Build TRUECoalesce Index TRUEManaged Standby TRUEMaterialized view rewrite TRUEPARAMETER VALUE- -Materialized view warehouse refresh TRUEDatabase resource manager TRUESpatial TRUEAutomatic Storage Management TRUEExport transportable tablespaces TRUETransparent Application Failover TRUEFast-Start Fault Recovery TRUESample Scan TRUEDuplexed backups TRUEJava TRUEOLAP Window Functions TRUEPARAMETER VALUE- -Block Media Recovery TRUEFine-grained Auditing TRUEApplication Role TRUEEnterprise User Security TRUEOracle Data Guard TRUEOracle Label Security FALSEOLAP TRUEBa