Oracle 11g R2 要使用ASM需要安装Grid Infrastructure
来源:互联网 发布:java mvc 编辑:程序博客网 时间:2024/05/16 15:09
Oracle 11g R2 要使用ASM需要安装Grid Infrastructure
Oracle 11g R2 要使用ASM需要安装Grid Infrastructure,本文就如何安装Grid Infrastructure以及通过asm建库进行简单的文本记录
1、安装操作系统 RHEL5U4
[root@dbabc ~]# uname -r
2.6.18-164.el5
[root@dbabc ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
2、检查并安装必须的安装包
rpm -q –qf ‘%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})n’ binutils
compat-libstdc++-33
elfutils-libelf
elfutils-libelf-devel
gcc
gcc-c++
glibc
glibc-common
glibc-devel
glibc-headers
ksh
libaio
libaio-devel
libgcc
libstdc++
libstdc++-devel
make
sysstat
unixODBC
unixODBC-devel
需要以下安装包,当然也可以加grep 直接查看未安装的包
rpm -q –qf ‘%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})n’ binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common
glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel | grep not
* binutils-2.17.50.0.6
* compat-libstdc++-33-3.2.3
* compat-libstdc++-33-3.2.3(32 位)
* elfutils-libelf-0.125
* elfutils-libelf-devel-0.125
* elfutils-libelf-devel-static-0.125
* gcc-4.1.2
* gcc-c++-4.1.2
* glibc-2.5-24
* glibc-2.5-24(32 位)
* glibc-common-2.5
* glibc-devel-2.5
* glibc-devel-2.5(32 位)
* glibc-headers-2.5
* ksh-20060214
* libaio-0.3.106
* libaio-0.3.106(32 位)
* libaio-devel-0.3.106
* libaio-devel-0.3.106(32 位)
* libgcc-4.1.2
* libgcc-4.1.2(32 位)
* libstdc++-4.1.2
* libstdc++-4.1.2(32 位)
* libstdc++-devel 4.1.2
* make-3.81
* sysstat-7.0.2
* unixODBC-2.2.11
* unixODBC-2.2.11(32 位)
* unixODBC-devel-2.2.11
* unixODBC-devel-2.2.11(32 位)
挂载iso
[root@dbabc ~]# mount -o loop /u01/packages/linux_iso/RedHat 5.0_U4_64.iso /mnt/temp/
通过rpm -ivh进行安装需要的软件包
通常情况下会缺少如下几个安装包
[root@dbabc Server]# rpm -ivh elfutils-libelf-devel-*
warning: elfutils-libelf-devel-0.137-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing… ########################################### [100%]
package elfutils-libelf-devel-static-0.137-3.el5.x86_64 is already installed
package elfutils-libelf-devel-0.137-3.el5.x86_64 is already installed
[root@dbabc Server]# rpm -q –qf ‘%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})n’ binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++
glibc glibc-common glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel | grep not
package libaio-devel is not installed
package sysstat is not installed
package unixODBC is not installed
package unixODBC-devel is not installed
[root@dbabc Server]# rpm -ivh libaio-devel-0.3.106-3.2.*
warning: libaio-devel-0.3.106-3.2.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing… ########################################### [100%]
1:libaio-devel ########################################### [ 50%]
2:libaio-devel ########################################### [100%]
[root@dbabc Server]# rpm -ivh sysstat-7.0.2-3.el5.x86_64.rpm
warning: sysstat-7.0.2-3.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing… ########################################### [100%]
1:sysstat ########################################### [100%]
[root@dbabc Server]# rpm -ivh unixODBC-2.2.11-7.1.*
warning: unixODBC-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing… ########################################### [100%]
1:unixODBC ########################################### [ 50%]
2:unixODBC ########################################### [100%]
[root@dbabc Server]# rpm -ivh unixODBC-devel-2.2.11-7.1.*
warning: unixODBC-devel-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing… ########################################### [100%]
1:unixODBC-devel ########################################### [ 50%]
2:unixODBC-devel ########################################### [100%]
3、创建用户以及目录
/usr/sbin/groupadd -g 500 oinstall
/usr/sbin/groupadd -g 501 dba
/usr/sbin/groupadd -g 502 oper
/usr/sbin/groupadd -g 600 asmadmin
/usr/sbin/groupadd -g 601 asmoper
/usr/sbin/groupadd -g 602 asmdba
/usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle
/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,dba grid
mkdir -p /u01/product/grid -p
mkdir -p /u01/product/db -p
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/product/db
chmod -R 775 /u01
passwd oracle
passwd grid
创建grid用户的登录脚本
在/home/grid/.bash_profile中添加一下信息
ORACLE_SID=+ASM; export ORACLE_SID
ORACLE_BASE=/u01/product; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/grid; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
PATH=$PATH:$HOME/bin
PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
创建Oracle用户的登录脚本
4、配置Linux服务器
配置内核参数
cat /etc/sysctl.conf <> /etc/security/limits.conf <> /etc/pam.d/login <> /etc/profile <<EOF
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
EOF
5、安装并配置 ASMLib 2.0
根据操作系统获得安装包 http://www.oracle.com/technology/software/tech/linux/asmlib/rhel5.html
[root@dbabc asm]# uname -r
2.6.18-164.el5
[root@dbabc asm]# ll
total 252
-rw-r–r– 1 root root 136910 Sep 29 19:33 oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm
-rw-r–r– 1 root root 14176 Sep 29 19:33 oracleasmlib-2.0.4-1.el5.x86_64.rpm
-rw-r–r– 1 root root 90444 Sep 29 19:33 oracleasm-support-2.1.3-1.el5.x86_64.rpm
[root@dbabc asm]# rpm -ivh oracleasm-support-2.1.3-1.el5.x86_64.rpm
warning: oracleasm-support-2.1.3-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing… ########################################### [100%]
1:oracleasm-support ########################################### [100%]
[root@dbabc asm]# rpm -ivh oracleasm-
oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm oracleasm-support-2.1.3-1.el5.x86_64.rpm
[root@dbabc asm]# rpm -ivh oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm
warning: oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing… ########################################### [100%]
1:oracleasm-2.6.18-164.el########################################### [100%]
[root@dbabc asm]# rpm -ivh oracleasmlib-2.0.4-1.el5.x86_64.rpm
warning: oracleasmlib-2.0.4-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing… ########################################### [100%]
1:oracleasmlib ########################################### [100%]
验证
[root@dbabc asm]# rpm -qa –queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})n"| grep oracleasm | sort
oracleasm-2.6.18-164.el5-2.0.5-1.el5 (x86_64)
oracleasmlib-2.0.4-1.el5 (x86_64)
oracleasm-support-2.1.3-1.el5 (x86_64)
配置 ASMLib
查看ASMlib配置
[root@dbabc ~]# oracleasm configure
ORACLEASM_ENABLED=false
ORACLEASM_UID=
ORACLEASM_GID=
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
配置ASMlib
[root@dbabc ~]# oracleasm configure -i
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
该脚本完成以下任务:
* 创建 /etc/sysconfig/oracleasm 配置文件
* 创建 /dev/oracleasm 挂载点
* 挂载 ASMLib 驱动程序文件系统
注:ASMLib 驱动程序文件系统并非常规的文件系统。它只用于自动存储管理库与自动存储管理驱动程序的通讯。
加载 oracleasm 内核模块:
[root@dbabc ~]# /usr/sbin/oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module “oracleasm”: oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm
为 Oracle 创建 ASM 磁盘
在创建ASM磁盘之前先看一下主机的磁盘情况
[root@dbabc ~]# fdisk -l
Disk /dev/sda: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 5221 41833260 8e Linux LVM
Disk /dev/sdb: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdb doesn’t contain a valid partition table
Disk /dev/sdc: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdc doesn’t contain a valid partition table
Disk /dev/sdd: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdd doesn’t contain a valid partition table
其中sda 用来安装Linux操作系统了,sdb(2147M)、sdc(8589M)、sdd(10.7G)是新增加的磁盘,用来做asm磁盘
[root@dbabc ~]# fdisk /dev/sdb
Command (m for help): p
Disk /dev/sdb: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-261, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-261, default 261):
Using default value 261
Command (m for help): p
Disk /dev/sdb: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 261 2096451 83 Linux
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@dbabc ~]# oracleasm createdisk crs /dev/sdb1
Writing disk header: done
Instantiating disk: done
同样把 sdc和sdd创建为fra和data磁盘组
查看asm磁盘
[root@dbabc ~]# oracleasm listdisks
CRS
DATA
FRA
6、安装Oracle 11g r2 Grid Infrastructure 软件
解压软件unzip linux.x64_11gR2_grid.zip
使用gird用户来安装Oracle 11g r2 Grid Infrastructure
进入grid目录运行./runInstaller
[root@dbabc grid]# ./runInstaller
选择[Install and Configure Grid Infrastructure for a Standalone Server]–>Next–>【添加语言】–>Next[]剩下的图形界面就简单了,暂到这里
- Oracle 11g R2 要使用ASM需要安装Grid Infrastructure
- 在oracle 11g r2中要使用ASM,是不是一定要安装Grid Infrastructure?【基本问题解惑】
- Oracle 11g R2+ RAC+ ASM+ OracleLinux6.4安装详解(2)Grid Infrastructure
- Oracle 11g R2 的 Grid Infrastructure 安装包
- 安装Oracle 11g r2 Grid Infrastructure 软件
- oracle 11g grid infrastructure install
- 11g R2 Deinstall of Grid Infrastructure Cluster
- 在OEL6.1下安装ORACLE 11G R2和ASM(用grid安装包)[未曾亲自试过]
- Oracle Grid Infrastructure安装
- Oracle 11g R2+RAC+ASM+redhat安装详解1
- Oracle 11g R2+RAC+ASM+redhat安装详解2
- Oracle ASM + 11g R2 + Centos 6.5 安装
- oracle 11gR2 grid infrastructure无法识别ASM disks
- 11g 安装grid Infrastructure,checks user existence :grid failed
- 连接 Oracle 11G R2 ASM实例
- Oracle 11g R2 ASM:了解 Oracle ASM 基本概念
- Oracle 11g R2 Grid常用操作
- Oracle 11g R2 RAC 卸载 grid
- TiXml使用详解
- B+树和R树的原理和C++代码实现
- 元件keepout层与覆铜间距
- IOS的成员变量、局部变量、全局变量
- 摄像机和镜头的基础知识
- Oracle 11g R2 要使用ASM需要安装Grid Infrastructure
- 黑马程序员-java 泛型
- 值新春佳节来临之际,祝大家新春愉快,合家欢乐!
- 杭电Hd 2028 Lowest Common Multiple Plus
- JAVA分页实现(代码)
- 五 linux 串口驱动
- 关于信噪比SNR【转载】
- Gentoo Linux 在命令行下用鼠标
- 关于C#和Java平台的MD5