Oracle_Enterprise_Linux6.3下安装Oracle11g_Grid_ASM_oracle在linux下安装
Oracle_Enterprise_Linux6.3下安装Oracle11g_Grid_ASM由刀豆文库小编整理,希望给你工作、学习、生活带来方便,猜你可能喜欢“oracle在linux下安装”。
Oracle Enterprise Linux6.3下安装Oracle11g Grid ASM
/boot
100M Swap
4G /tmp
4g /
15G /u01 配置网络
1.修改网络配置文件:/etc/sysconfig/network-scripts/ifcfg-eth0 DEVICE=eth0 HWADDR=00:15:5D:01:6C:07 TYPE=Ethernet UUID=30156ccf-eed9-446e-80de-9cef5c4162df ONBOOT=yes NM_CONTROLLED=yes BOOTPROTO=static GATEWAY=192.168.100.1 IPADDR=192.168.100.3 NETMASK=255.255.255.0 重启服务生效:service network restart 修改域名对应关系 vim /etc/hosts
1.1 查看版本信息
cat /etc/redhat-release uname –a
echo 'multilib_policy=all' >> /etc/yum.conf 1.2 添加Oracle用户
useradd oracle-u 600 useradd grid-u 601 1.3 添加Oracle用户组
groupadd-g 1000 oinstall groupadd-g 1001 dba groupadd-g 1002 oper groupadd-g 1003 asmadmin groupadd-g 1004 asmoper groupadd-g 1005 asmdba groupadd-g 1006 orauser 1.4 修改Oracle用户所属组
usermod-g oinstall-G dba,asmdba oracle usermod-g oinstall-G dba,asmdba,oper,oinstall,asmadmin grid 1.5 设置密码
pawd oracle
(oracle)pawd grid(grid)1.6 创建目录
mkdir-p /u01/app/oracle mkdir-p /u01/app/grid chown-R grid:oinstall /u01 chown-R oracle:oinstall /u01/app/oracle chmod-R 775 /u01 1.7 查看安装的包
rpm-qa binutils rpm-q compat-libstdc++-33(rpm-qa compat-libstdc++*)rpm-qa | grep compat-rpm-qa | grep elfutils rpm-qa gcc rpm-qa gcc-c++ rpm-qa glibc rpm-qa glibc-common rpm-qa glibc-devel rpm-qa libaio rpm-qa libaio-devel(需要安装)rpm-qa libgcc rpm-qa libstdc++ rpm-qa libstdc++-devel rpm-qa make rpm-qa sytat rpm-qa unixODBC
rpm-q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel rpm-q glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make numactl-devel sytat
1.8 安装缺少的包
下载:
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.rpm rpm-Uvh ksh-20100621-16.el6.x86_64.rpm rpm-Uvh numactl-devel-2.0.7-3.el6.x86_64.rpm 1.9 修改系统用户资源权限
vi /etc/profile,增加: #oracle 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 022 fi
1.10 设置内核参数 1.10.1 修改
vi /etc/sysctl.conf,添加:
#kernel.shmall = 2097152(已有)
#kernel.shmmax = 2147483648(已有)kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.ip_local_port_range = 9000 65500 fs.suid_dumpable = 1 fs.file-max = 6815744 fs.aio-max-nr = 1048576 1.10.2 查看内核参数
/sbin/sysctl-a | grep fs.aio-max-nr
1.10.3 使内核参数生效
/sbin/sysctl-p 1.11 修改oracle 用户shell 限制
vi /etc/security/limits.conf,增加: #add by lcs for oracle grid soft nproc 2047 grid hard nproc 16384 grid soft nofile 1024 grid hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 1.12 oracle用户限制,登录
vi /etc/pam.d/login #add by lcs for oracle seion required pam_limits.so 1.13 设置磁盘配置策略
vi /etc/sysconfig/selinux #modify by lcs for oracle #old SELINUX=enforcing SELINUX=disabled
1.14 重新启动系统
reboot 1.15 Oracle asm设置
1.15.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.rpm 1.15.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.rpm 1.15.3 oracleasm配置
5、配置: /etc/init.d/oracleasm configure 信息:
Default user to own the driver interface [grid]: grid Default group to own the driver interface [dba]: asmadmin Start 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: done Initializing the Oracle ASMLib driver:
[ OK ] Scanning the system for Oracle ASMLib disks:
[ OK ] 1.15.4 通过vmware增加磁盘
1、增加磁盘:在vmware中settings下通过:hareware-add disk,增加2个10g的磁盘分区
1.15.5 创建分区
2、通过:fdisk –l看到Disk /dev/sdb: 10.7 GB;Disk /dev/sdc: 10.7 GB3、创建分区1:fdisk /dev/sdb
[root@localhost ~]# fdisk /dev/sdb Command(m for help): n Command action
e
extended
p
primary partition(1-4)p Partition number(1-4): 1 First cylinder(1-1305, default 1): Using default value 1
Last cylinder, +cylinders or +size{K,M,G}(1-1305, default 1305): Using default value 1305
Command(m for help): w The partition table has been altered!
Calling ioctl()to re-read partition table.Syncing disks.4、创建分区2:fdisk /dev/sdc fdisk /dev/sdc [root@localhost ~]# fdisk /dev/sdc Command(m for help): n Command action
e
extended
p
primary partition(1-4)p Partition number(1-4): 1 First cylinder(1-1305, default 1): Using default value 1 Last cylinder, +cylinders or +size{K,M,G}(1-1305, default 1305): Using default value 1305
Command(m for help): w The partition table has been altered!
Calling ioctl()to re-read partition table.Syncing disks.1.15.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 scandisks 1.15.7 查看oracleasm日志
创建工程中若出错看日志: tail-f /var/log/oracleasm more /var/log/oracleasm 1.16 配置ip地址和主机名
1、设置ip地址
] vi /etc/sysconfig/network-scripts/ifcfg-eth0 DEVICE=“eth0” #modify by lcs for oracle #old BOOTPROTO=“dhcp” BOOTPROTO=static ONBOOT=“yes” IPADDR=192.168.2.101 NETMASK=255.255.255.0 GATEWAY=192.168.2.1 HWADDR=“00:0C:29:33:E9:23” NM_CONTROLLED=“yes” #old ONBOOT=“no” TYPE=“Ethernet” UUID=“6777b2c9-5fd6-48be-a5cf-53169427b6b2”
2、修改主机名
vi /etc/sysconfig/network #modify by lcs for oracle #old HOSTNAME=localhost.localdomain HOSTNAME=oraclerac1
3.修改hosts文件 vi /etc/hosts #modify by lcs for oracle 192.168.2.101 oraclerac1 127.0.0.1
localhost localhost.localdomain localhost4 localhost4.localdomain4 #old ::1
localhost localhost.localdomain localhost6 localhost6.localdomain6 1.17 配置grid用户环境变量
进入gird用户:su – grid vi.bash_profile #add by lcs for oracle export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/grid export ORACLE_SID=+ASM export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export TMP=/tmp export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib 1.18 安装grid 1.18.1 切换到root su – xhost + 1.18.2 设置当前运行环境变量
Suroot /u01/app/oraInventory/orainstRoot.sh 提示信息:
Changing permiions of /u01/app/oraInventory.Adding read,write permiions for group.Removing read,write,execute permiions 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.sh Performing 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/grid
Enter 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 by Database Configuration Aistant when a database is created Finished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: 执行:
/u01/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params 提示信息:
Creating trace directory LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..Operation succeful.LOCAL ONLY MODE
Succefully accumulated neceary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation succeful.CRS-4664: Node oraclerac1 succefully pinned.Adding Clusterware entries to upstart
oraclerac1
2012/10/06 20:12:51
/u01/app/oracle/product/11.2.0/grid/cdata/oraclerac1/backup_20121006_201251.olr Succefully configured Oracle Grid Infrastructure for a Standalone Server
1.18.6 安装成功验证
su –grid sqlplus / as sysasm select name,state from v$asm_diskgroup;1.18.7 安装日志查看
/u01/app/oraInventory/logs/installActions2012-10-06_05-09-12PM.log