ASM之创建ASM实例

ASM之创建ASM实例

---

(下面基于VMware + RHEL 5.4 + Oracle 10g R2演示)

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1.安装ASM包 使用ASM实例，需要到Oracle官方网站下载所需的ASM包。
   下载路径：ASMLib下载 注意下载支持该内核的包，分为两部分，一是Library and Tools，二是Drivers for kernel
如本人的Linux的内核为：
[root@oradb ~]# uname -rm 2.6.18-164.el5 i686
则下载对应的包为：
Library and Tools oracleasmlib-2.0.4-1.el5.x86_64.rpm
oracleasm-support-2.1.3-1.el5.i386.rpm
Drivers for kernel 2.6.18-164.el5 oracleasm-2.6.18-164.el5xen-2.0.5-1.el5.i686.rpm
oracleasm-2.6.18-164.el5debug-2.0.5-1.el5.i686.rpm
oracleasm-2.6.18-164.el5PAE-2.0.5-1.el5.i686.rpm
oracleasm-2.6.18-164.el5-debuginfo-2.0.5-1.el5.i686.rpm
oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm

使用下面类似的方式来安装这些包，关于RPM 的使用请参考：RPM 使用简介

[root@oradb asm]# rpm -Uvh oracleasm-support-2.1.3-1.el5.i386.rpm

验证安装的包
[root@oradb asm]#
rpm -qa | grep asm oracleasm-support-2.1.3-1.el5
rpm -qa | grep oracleasm-2.6.18-164.el5-debuginfo-2.0.5-1.el5
rpm -qa | grep oracleasm-2.6.18-164.el5-2.0.5-1.el5


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2.启用css服务(Cluster Synchronization Services )

用于同步ASM实例与RDBMS实例 使用root帐户进行配置,配置程序位于$ORACLE_HOME/bin
[root@oradb ~]# /u01/oracle/10g/bin/localconfig add
/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized Adding to inittab Startup will be queued to init within 90 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes. oradb CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3.创建ASM参数文件(使用VI或VIM)

[oracle@oradb dbs]$ cat /u01/oracle/10g/dbs/init+ASM.ora

*.asm_diskstring='' #为空表示可以搜索任意的ASM磁盘
*.background_dump_dest='/u01/oracle/admin/+ASM/bdump' #后台进程存放位置
*.core_dump_dest='/u01/oracle/admin/+ASM/cdump' #核心进程存放位置
*.user_dump_dest='/u01/oracle/admin/+ASM/udump' #用户进程存放位置
*.instance_type='ASM' #实例类型，普通实例默认则为RDBMS *.instance_name='+ASM' #实例名字
*.large_pool_size=12M #为实例分配large_pool的大小
*.remote_login_passwordfile='SHARED' #登陆认证方式
*.asm_power_limit=1 #控制均衡操作的资源，缺省为

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
4.创建ASM后台进程目录，

参照参数文件中的配置来创建
[oracle@oradb ~]$ echo $ORACLE_BASE /u01/oracle/10g
[oracle@oradb ~]$ mkdir -p $ORACLE_BASE/admin/+ASM/bdump
[oracle@oradb ~]$ mkdir -p $ORACLE_BASE/admin/+ASM/udump
[oracle@oradb ~]$ mkdir -p $ORACLE_BASE/admin/+ASM/cdump


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5.创建密码文件及spfile参数文件
[oracle@oradb ~]$ orapwd file=$ORACLE_HOME/dbs/orapw+ASM password=redhat entries=8
[oracle@oradb ~]$ export ORACLE_SID=+ASM
SQL> conn / as sysdba Connected to an idle instance.
SQL> startup ASM instance started
ORA-15110: no diskgroups mounted
SQL> create spfile from pfile;
SQL> select * from v$asm_diskgroup;
no rows selected

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
7.创建ASM磁盘及配置ASMlib驱动

在Vmware分配几个空闲的磁盘用于创建ASM磁盘，建议使用不同的磁盘控制器
下面使用个磁盘来组建ASM磁盘组,分别为sdd,sde,sdf,sdg 分别对个磁盘进行分区,列出sdd的分区样例，其余如法炮制
[root@oradb ~]# fdisk /dev/sdd
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): w
The partition table has been altered! Calling ioctl() to re-read partition table.
Syncing disks.


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
8.创建ASM数据库 使用dbca工具根据提示来创建使用ASM存储的数据库
创建使用ASM存储的数据库完毕之后，对于ASM数据库启动应首先保证ASM实例先被启动，因为RDBMS是ASM实例服务的一个客户端
接下来再来启动RDBMS

--首先启动asm实例
export ORACLE_SID=+ASM sqlplus / as sysdba startup exit --接下来启动rdbms数据库
export ORACLE_SID=orcl
sqlplus / as sysdba startup

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29500582/viewspace-1356551/，如需转载，请注明出处，否则将追究法律责任。