Oracle Enterprise Linux6.3下安装Oracle11g Grid ASM.doc

1 Oracle Enterprise Linux6.3下安装Oracle11g Grid ASM1.1 查看版本信息cat /etc/redhat-releaseuname -a1.2 添加Oracle用户useradd oracle -u 600useradd grid -u 6011.3 添加Oracle用户组groupadd -g 1000 oinstallgroupadd -g 1001 dbagroupadd -g 1002 opergroupadd -g 1003 asmadmingroupadd -g 1004 asmopergroupadd -g 1005 asmdbagroupadd -g 1006 orauser1.4 修改Oracle用户所属组usermod -g oinstall -G dba,asmdba oracleusermod -g oinstall -G dba,asmdba,oper,oinstall,asmadmin grid1.5 设置密码passwd oracle (oracle)passwd grid (grid)1.6 创建目录mkdir /u01mkdir -p /u01/soft（存放grid和数据库软件）mkdir -p /u01/app/oraclemkdir -p /u01/app/oraInventorymkdir -p /u01/app/oracle/product/11.2.0/gridmkdir -p /u01/app/oracle/product/11.2.0/db_11.7 解压缩安装文件Grid文件：unzip /mnt/hgfs/SoftWare/oracle11g_linux64_11.2.0.3.0/p10404530_112030_Linux-x86-64_3of7.zip1.8 设置目录所有者chown -R oracle:oinstall /u01chown -R grid:oinstall /u01/soft/gridchown -R oracle:oinstall /u01/app/oraclechown -R grid:oinstall /u01/app/oraInventorychown -R grid:oinstall /u01/app/oracle/product/11.2.0/gridchown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_11.9 更改文件权限chmod -R 775 /u01/soft/gridchmod -R 775 /u01/app/oracle/product/11.2.0/gridchmod -R 775 /u01/app/oracle/product/11.2.0/db_1chmod -R 775 /u01/app/oraInventory1.10 查看安装的包rpm -qa binutilsrpm -q compat-libstdc+-33(rpm -qa compat-libstdc+*)rpm -qa | grep compat-rpm -qa | grep elfutilsrpm -qa gccrpm -qa gcc-c+rpm -qa glibcrpm -qa glibc-commonrpm -qa glibc-develrpm -qa libaiorpm -qa libaio-devel（需要安装）rpm -qa libgccrpm -qa libstdc+rpm -qa libstdc+-develrpm -qa makerpm -qa sysstatrpm -qa unixODBCrpm -q binutils compat-libstdc+-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c+ glibc glibc-common glibc-develrpm -q glibc-headers ksh libaio libaio-devel libgcc libstdc+ libstdc+-devel make numactl-devel sysstat1.11 安装缺少的包下载：1、 libaio-devel-0.3.105-2.i386.rpm2、 ksh-20100621-16.el6.x86_64.rpm3、 numactl-devel-2.0.7-3.el6.x86_64.rpm放到: K:SoftWareOracleEnterpriseLinux6.3rpm下cd /mnt/hgfs/SoftWare/OracleEnterpriseLinux6.3/rpm4、执行rpm -Uvh libaio-devel-0.3.107-10.el6.x86_64.rpmrpm -Uvh ksh-20100621-16.el6.x86_64.rpmrpm -Uvh numactl-devel-2.0.7-3.el6.x86_64.rpm1.12 修改系统用户资源权限vi /etc/profile，增加：#oracleif $USER = oracle | $USER = grid ; then if $SHELL = /bin/ksh ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022fi1.13 设置内核参数1.13.1 修改vi /etc/sysctl.conf，添加：#kernel.shmall = 2097152（已有）#kernel.shmmax = 2147483648（已有）kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576net.ipv4.ip_local_port_range = 9000 65500fs.suid_dumpable = 1fs.file-max = 6815744fs.aio-max-nr = 10485761.13.2 查看内核参数/sbin/sysctl -a | grep fs.aio-max-nr1.13.3 使内核参数生效/sbin/sysctl -p1.14 修改oracle 用户shell 限制vi /etc/security/limits.conf，增加：#add by lcs for oraclegrid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655361.15 oracle用户限制，登录vi /etc/pam.d/login#add by lcs for oraclesession required pam_limits.so1.16 设置磁盘配置策略vi /etc/sysconfig/selinux#modify by lcs for oracle#old SELINUX=enforcingSELINUX=disabled1.17 重新启动系统reboot1.18 Oracle asm设置1.18.1 下载oracle asm安装文件位置：K:SoftWareOracleEnterpriseLinux6.3rpm1、 oracleasm-support-2.1.5-1.el6.x86_64.rpm；2、 oracleasmlib-2.0.4-1.el6.x86_64.rpm1.18.2 安装cd /mnt/hgfs/SoftWare/OracleEnterpriseLinux6.3/rpm3、 rpm Uvh oracleasmlib-2.0.4-1.el6.x86_64.rpm 4、 rpm Uvh oracleasm-support-2.1.5-1.el6.x86_64.rpm1.18.3 oracleasm配置5、 配置: /etc/init.d/oracleasm configure信息：Default user to own the driver interface grid: gridDefault group to own the driver interface dba: asmadminStart Oracle ASM library driver on boot (y/n) y: Scan for Oracle ASM disks on boot (y/n) y: Writing Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: OK Scanning the system for Oracle ASMLib disks: OK 1.18.4 通过vmware增加磁盘1、 增加磁盘：在vmware中settings下通过：hareware-add disk,增加2个10g的磁盘分区1.18.5 创建分区2、 通过：fdisk l看到Disk /dev/sdb: 10.7 GB；Disk /dev/sdc: 10.7 GB3、 创建分区1：fdisk /dev/sdbrootlocalhost # fdisk /dev/sdbCommand (m for help): nCommand action e extended p primary partition (1-4)pPartition number (1-4): 1First cylinder (1-1305, default 1): Using default value 1Last cylinder, +cylinders or +sizeK,M,G (1-1305, default 1305): Using default value 1305Command (m for help): wThe partition table has been altered!Calling ioctl() to re-read partition table.Syncing disks.4、 创建分区2：fdisk /dev/sdcfdisk /dev/sdcrootlocalhost # fdisk /dev/sdcCommand (m for help): nCommand action e extended p primary partition (1-4)pPartition number (1-4): 1First cylinder (1-1305, default 1): Using default value 1Last cylinder, +cylinders or +sizeK,M,G (1-1305, default 1305): Using default value 1305Command (m for help): wThe partition table has been altered!Calling ioctl() to re-read partition table.Syncing disks.1.18.6 创建asm卷/etc/init.d/oracleasm createdisk asm_lv1 /dev/sdb1/etc/init.d/oracleasm createdisk asm_lv2 /dev/sdb2都提示：Marking disk asm_lv1 as an ASM disk: OK /etc/init.d/oracleasm scandisks1.18.7 查看oracleasm日志创建工程中若出错看日志：tail -f /var/log/oracleasmmore /var/log/oracleasm1.19 配置ip地址和主机名1、设置ip地址vi /etc/sysconfig/network-scripts/ifcfg-eth0DEVICE=eth0#modify by lcs for oracle#old BOOTPROTO=dhcpBOOTPROTO=staticONBOOT=yesIPADDR=192.168.2.101NETMASK=255.255.255.0GATEWAY=192.168.2.1HWADDR=00:0C:29:33:E9:23NM_CONTROLLED=yes#old ONBOOT=noTYPE=EthernetUUID=6777b2c9-5fd6-48be-a5cf-53169427b6b22、修改主机名vi /etc/sysconfig/network#modify by lcs for oracle#old HOSTNAME=localhost.localdomainHOSTNAME=oraclerac13.修改hosts文件vi /etc/hosts#modify by lcs for oracle192.168.2.101 oraclerac1127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4#old :1 localhost localhost.localdomain localhost6 localhost6.localdomain61.20 配置grid用户环境变量进入gird用户：su gridvi .bash_profile#add by lcs for oracleexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/gridexport ORACLE_SID=+ASMexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/libexport TMP=/tmpexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib1.21 安装grid1.21.1 切换到rootsu xhost +1.21.2 设置当前运行环境变量Su - gridexport DISPLAY=:0.0export LANG=en_US.UTF-81.21.3 执行安装Cd /u01/soft/grid./runInstaller1.21.4 设置口令sys/asmsnmp口令=oracle1.21.5 执行在root用户下：Su - root/u01/app/oraInventory/orainstRoot.sh提示信息：Changing permissions of /u01/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete./u01/app/oracle/product/11.2.0/grid/root.shPerforming root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/oracle/product/11.2.0/gridEnter the full pathname of the local bin directory: /usr/local/bin: Copying dbhome to /usr/local/bin . Copying oraenv to /usr/local/bin . Copying coraenv to /usr/local/bin .Creating /etc/oratab file.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-