admin管理员组文章数量:1534189
2024年1月11日发(作者:)
Installing Grid Infrastructure on ASM for a Standalone Server
Lab:
Installing Grid Infrastructure on ASM
for a Standalone Server
Installing Grid Infrastructure on ASM for a Standalone Server
1 实验目的
通过本次实验,了解 Oracle Grid Infrastructure 11g R2 的安装
熟悉 ASM 的管理及操作
熟悉 CRS 的管理
熟悉 Enterprise Manager 管理及监控
2 实验环境
虚拟机
OS
Oracle
vmware server 1.07
oracle enterprise linux 5.4
Grid Infrastructure
Database
2G Mem/1 Cpu/30G HD
Linux Kernel 2.6.18 (32bit)
11g Release 2
11g Release 2
Grid Infrastructure 安装及管理参考:
/docs/cd/E11882_01/install.112/e10812/
/docs/cd/E11882_01/rac.112/e10717/
ASM管理参考:( Storage Administrator's Guide)
/docs/cd/E11882_01/server.112/e10500/
3 实验安装前准备工作
3.0 用户与组
1. 创建OS组
#/usr/sbin/groupadd -g 106 oinstall
#/usr/sbin/groupadd -g 107 dba
#/usr/sbin/groupadd -g 108 asmadmin
#/usr/sbin/groupadd -g 109 asmdba
#/usr/sbin/groupadd -g 110 asmoper
2. 创建OS用户
#/usr/sbin/useradd -u 501 -g oinstall -G
dba,asmadmin,asmdba,asmoper oracle
Installing Grid Infrastructure on ASM for a Standalone Server
3. 设置OS用户密码
#passwd oracle
3.1 系统检查
1. 服务器内存:(最少1.5 GB for grid infrastructure for a cluster)
#grep MemTotal /proc/meminfo
2. 服务器交换分区: (最少1.5 GB,建议1.5倍内存大小)
#grep SwapTotal /proc/meminfo
3. 磁盘空间需求:
/tmp目录: 1024MB
数据库软件: 5-10GB,依赖于安装类型
Grid Infrastructure: 5GB
文件系统: 5GB用来放置安装软件
3.2 软件检查
1. 操作系统版本及内核:
# uname –a
# getconf LONG_BIT
2. OS软件包:
# rpm –q package_name
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
Installing Grid Infrastructure on ASM for a Standalone Server
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
sysstat-7.0.2
unixODBC-2.2.11
unixODBC-2.2.11 (32 bit)
unixODBC-devel-2.2.11
unixODBC-devel-2.2.11 (32 bit)
3. 修改和配置系统核心参数
#vi /etc/
= 2097152
= 536870912
= 4096
= 250 32000 100 128
-max = 6815744
-max-nr = 1048576
_local_port_range = 9000 65500
Installing Grid Infrastructure on ASM for a Standalone Server
_default=4194304
_default=262144
_max=4194304
_max=1048576
#/sbin/sysctl -p
3.3 创建目录
1. 创建Grid Infrastructure Home目录
(Grid安装目录应置于ORACLE_BASE之外,RDBMS安装目录需置于ORACLE_BASE之内)
# mkdir -p /u01/ora11g/11.2.0/grid
2. 创建ORACLE_BASE目录
# mkdir -p /u01/ora11g/app/oracle
# mkdir /u01/ora11g/app/oracle/cfgtoollogs
3. 创建RDBMS Home目录
# mkdir -p /u01/ora11g/app/oracle/product/11.2.0/db_1
4. 修改目录属性
# chown -R oracle:oinstall /u01
# chmod -R 775 /u01/
3.4 初始化raw设备
1. 使用DD产生14个500M大小文件
dd if=/dev/zero of=/mnt/dsk/s_disk1 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk2 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk3 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk4 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk5 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk6 bs=1M count=500
Installing Grid Infrastructure on ASM for a Standalone Server
dd if=/dev/zero of=/mnt/dsk/s_disk7 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk8 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk9 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk10 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk11 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk12 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk13 bs=1M count=500
dd if=/dev/zero of=/mnt/dsk/s_disk14 bs=1M count=500
2. 将文件关联Loop设备
vi /etc/ --修改配置设置loop文件数量
options loop max_loop=20
vi /etc/ --自动加载loop devices
/sbin/losetup /dev/loop1 /mnt/dsk/s_disk1
/sbin/losetup /dev/loop2 /mnt/dsk/s_disk2
/sbin/losetup /dev/loop3 /mnt/dsk/s_disk3
/sbin/losetup /dev/loop4 /mnt/dsk/s_disk4
/sbin/losetup /dev/loop5 /mnt/dsk/s_disk5
/sbin/losetup /dev/loop6 /mnt/dsk/s_disk6
/sbin/losetup /dev/loop7 /mnt/dsk/s_disk7
/sbin/losetup /dev/loop8 /mnt/dsk/s_disk8
/sbin/losetup /dev/loop9 /mnt/dsk/s_disk9
/sbin/losetup /dev/loop10 /mnt/dsk/s_disk10
/sbin/losetup /dev/loop11 /mnt/dsk/s_disk11
/sbin/losetup /dev/loop12 /mnt/dsk/s_disk12
/sbin/losetup /dev/loop13 /mnt/dsk/s_disk13
/sbin/losetup /dev/loop14 /mnt/dsk/s_disk14
3. 将文件关联Loop设备
vi /etc/sysconfig/rawdevices
raw /dev/raw/raw1 /dev/loop1
Installing Grid Infrastructure on ASM for a Standalone Server
raw /dev/raw/raw2 /dev/loop2
raw /dev/raw/raw3 /dev/loop3
raw /dev/raw/raw4 /dev/loop4
raw /dev/raw/raw5 /dev/loop5
raw /dev/raw/raw6 /dev/loop6
raw /dev/raw/raw7 /dev/loop7
raw /dev/raw/raw8 /dev/loop8
raw /dev/raw/raw9 /dev/loop9
raw /dev/raw/raw10 /dev/loop10
raw /dev/raw/raw10 /dev/loop11
raw /dev/raw/raw10 /dev/loop12
raw /dev/raw/raw10 /dev/loop13
raw /dev/raw/raw10 /dev/loop14
4. 修改raw设备权限
chmod 660 /dev/raw/raw1
chown oracle:dba /dev/raw/raw1
chmod 660 /dev/raw/raw2
chown oracle:dba /dev/raw/raw2
chmod 660 /dev/raw/raw3
chown oracle:dba /dev/raw/raw3
chmod 660 /dev/raw/raw4
chown oracle:dba /dev/raw/raw4
chmod 660 /dev/raw/raw5
chown oracle:dba /dev/raw/raw5
chmod 660 /dev/raw/raw6
chown oracle:dba /dev/raw/raw6
chmod 660 /dev/raw/raw7
chown oracle:dba /dev/raw/raw7
chmod 660 /dev/raw/raw8
chown oracle:dba /dev/raw/raw8
chmod 660 /dev/raw/raw9
chown oracle:dba /dev/raw/raw9
chmod 660 /dev/raw/raw10
chown oracle:dba /dev/raw/raw10
Installing Grid Infrastructure on ASM for a Standalone Server
chmod 660 /dev/raw/raw11
chown oracle:dba /dev/raw/raw11
chmod 660 /dev/raw/raw12
chown oracle:dba /dev/raw/raw12
chmod 660 /dev/raw/raw13
chown oracle:dba /dev/raw/raw13
chmod 660 /dev/raw/raw14
chown oracle:dba /dev/raw/raw14
4 Grid Infrastructure安装
4.0 Grid Infrastructure安装
1. 以oracle用户登陆并设置DISPLAY 参数
$export DISPLAY=IP_ADDRESS:0
开启本地x-windows终端
2. 启动安装程序
$/mnt/software/grid /runInstaller
3. 完成安装过程
Installing Grid Infrastructure on ASM for a Standalone Server
选择“Install and configure grid Infrastructure for a Standalone Server”
Installing Grid Infrastructure on ASM for a Standalone Server
添加“Simplified Chinese”语言选项
Installing Grid Infrastructure on ASM for a Standalone Server
Create ASM Disk Group配置
选取8个500M容量的DISK, Redundancy类型为External, 命名DATADG
Installing Grid Infrastructure on ASM for a Standalone Server
输入AMS 实例的密码 “oracle”
Installing Grid Infrastructure on ASM for a Standalone Server
因密码简单不符合ORACLE推荐,忽略,继续
确认ASM相关组设置
Installing Grid Infrastructure on ASM for a Standalone Server
输入 Oracle Base:/u01/ora11g/app/oracle
Software Location:/u01/ora11g/11.2.0/grid
Installing Grid Infrastructure on ASM for a Standalone Server
确定 Inventory 目录
Installing Grid Infrastructure on ASM for a Standalone Server
点击Next 进行 安装前的检查
Installing Grid Infrastructure on ASM for a Standalone Server
检查通过,安装预览
Installing Grid Infrastructure on ASM for a Standalone Server
安装开始
Installing Grid Infrastructure on ASM for a Standalone Server
完成安装前,弹出窗口, 提示执行相关脚本:
以root 用户登陆,按照窗口提示, 顺序执行, 执行完毕,点OK 返回
Installing Grid Infrastructure on ASM for a Standalone Server
继续执行 Net 和 ASM 的配置
Installing Grid Infrastructure on ASM for a Standalone Server
全部完成Grid Infrastructure的安装,点CLOSE退出
5 数据库软件安装
5.0 数据库软件安装
1. 以oracle用户登陆并设置DISPLAY 参数
$export DISPLAY=IP_ADDRESS:0
开启本地x-windows终端
2. 启动安装程序
$ /mnt/software/database/runInstaller
Installing Grid Infrastructure on ASM for a Standalone Server
3. 完成安装过程
取消邮件接收的勾选
Installing Grid Infrastructure on ASM for a Standalone Server
选择“Create and configure a database”
Installing Grid Infrastructure on ASM for a Standalone Server
选择“ Server Class”
Installing Grid Infrastructure on ASM for a Standalone Server
选择 “Single Instance database installation” 数据库安装类型
Installing Grid Infrastructure on ASM for a Standalone Server
选择 “Advanced install” 高级安装类型
Installing Grid Infrastructure on ASM for a Standalone Server
添加简体中文
Installing Grid Infrastructure on ASM for a Standalone Server
选择“Enterprise edition”企业版
Installing Grid Infrastructure on ASM for a Standalone Server
确认 Oracle Base 和 Oracle Home 路径
Installing Grid Infrastructure on ASM for a Standalone Server
选择“General Purpose or Transaction Processing”通用/事务处理 类型
Installing Grid Infrastructure on ASM for a Standalone Server
确认数据库 SID 设置
Installing Grid Infrastructure on ASM for a Standalone Server
使用 “Automatic Memory Management”自动内存管理
Installing Grid Infrastructure on ASM for a Standalone Server
设置字符集
Installing Grid Infrastructure on ASM for a Standalone Server
默认使用Enterprise Manager 管理
Installing Grid Infrastructure on ASM for a Standalone Server
使用 ASM 为数据库存储,输入 ASMNMP 密码
Installing Grid Infrastructure on ASM for a Standalone Server
设置是否启用 自动备份
Installing Grid Infrastructure on ASM for a Standalone Server
选择 ASM Disk Group 为数据库存储
Installing Grid Infrastructure on ASM for a Standalone Server
设置数据库用户密码
Installing Grid Infrastructure on ASM for a Standalone Server
确认 DBA 组和 OINSTALL组的权限
Installing Grid Infrastructure on ASM for a Standalone Server
安装前检查
Installing Grid Infrastructure on ASM for a Standalone Server
安装Summary
Installing Grid Infrastructure on ASM for a Standalone Server
开始安装
Installing Grid Infrastructure on ASM for a Standalone Server
创建数据库过程
Installing Grid Infrastructure on ASM for a Standalone Server
建库完成
Installing Grid Infrastructure on ASM for a Standalone Server
完成前执行
可登陆数据库EM管理界面 192.168.17.8:1158/em,检查相关状态
Installing Grid Infrastructure on ASM for a Standalone Server
6 ASM,CRS及数据库 维护
6.0 ASM的维护
1. 以oracle 用户登陆,设置ORACLE_SID环境变量
$ . oraenv
ORACLE_SID = [ods] ? +ASM
The Oracle base for ORACLE_HOME=/u01/ora11g/11.2.0/grid is /u01/ora11g/app/oracle
输入ORACLE_SID时,使用以下命令可以确定:
cat /etc/oratab
或者
ps –ef|grep dbw
2. 检查状态和增加磁盘组操作:
A.使用srvctl l 命令
检查ASM实例状态: srvctl status asm
检查ASM磁盘组: srvctl status diskgroup -g datadg
B.使用sqlplus: $sqlplus / as sysasm
查看是否有数据库实例连接上ASM实例
SQL>select instance_name,db_name,status from v$asm_client;
查看磁盘组、磁盘信息
SQL> select group_number,name,total_mb,free_mb,type,state from
v$asm_diskgroup;
SQL> select group_number, disk_number, name, state, path, redundancy from
v$asm_disk order by 1,2;
Installing Grid Infrastructure on ASM for a Standalone Server
查看ASM的文件信息
SQL> select group_number,file_number,type,redundancy,striped,bytes from
v$asm_file;
查看ASM的BALANCE操作
SQL>select operation,state,power,actual,sofar from v$asm_operation;
挂载或卸载磁盘组
SQL> ALTER DISKGROUP DGNAEM|ALL MOUNT|DISMOUNT;
创建磁盘组
SQL>create diskgroup DGNAEM external redundancy disk 'DISKPATH ';
将DISK添加进磁盘组
SQL>alter diskgroup DGNAEM add disk 'DISKPATH' name DISKNAME;
磁盘组检查和BALANCE设置
SQL>alter diskgroup DGNAEM rebalance power 11;
SQL>alter diskgroup DGNAEM check all;
SQL>alter diskgroup DGNAEM check all repair;
3. 使用 asmcmd 命令对ASM磁盘组文件进行操作
设置好环境变量后使用
$ asmcmd
ASMCMD> help
ASMCMD> lsdg
Installing Grid Infrastructure on ASM for a Standalone Server
详情请参考如下Oracle官方手册Storage Administrator's Guide
/pls/db112/to_toc?pathname=server.112/e10500/
4. 使用 asmca图形界面对ASM磁盘组进行管理
5. 使用EM 数据库管理图形界面对ASM 进行管理
使用EM可以对ASM进行各种相关操作。连接URL为 IP:1158/em
登录用户信息:sysman/oracle
6.1 CRS的维护
1. 以oracle 用户登陆,设置ORACLE_SID环境变量
2. 检查应用程序资源的状态
$crsctl stat res -t
查询所有crs资源的状态
$crsctl stat res -t -init
查询crs init资源的状态。
crsctl与srvctl等命令在使用时可以随时使用 –h参数来得到帮助
如: crsctl start –h 或 crsctl stop crs -h
3. CRS 启动和停止
crsctl start res -all
crsctl stop res -all
6.2 数据库相关服务的管理
检查数据库状态
$srvctl status database -d orcl
RAC数据库启动和停止
Installing Grid Infrastructure on ASM for a Standalone Server
srvctl start db –d orcl
srvctl stop db –d o orcl
Listener的启动与停止
$ srvctl start listener -h
版权声明:本文标题:Oracle 11g ASM 实验 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/dianzi/1704954540a116060.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论