[实践]VMWare虚拟机RedhatEnterpriseLinux6Oracle11GR2,单节点配置ASM(二)

2014-11-24 14:25:28 · 作者: · 浏览: 1
sm*,然后全选建好的三个Disk Path;

3. Perform Prerequiste checks,选Ignore all;

4.安装到76%时报错:OUI-10094:Problem in saving inventory. Installation cannot continue./opt/app/oracle/orainventory/ContentsXML/comps.xml (Permission denied)

执行以下语句:

1).使用deinstall.sh删除不成功的安装;

2). 重新创建$ORACLE_HOME目录,并在该目录下Create a new oraInst.loc file:

This file should have the follow content:
inventory_loc=/opt/app/oraclegrid/product/11.2.0/grid/oraInventory
inst_group=oinstall

3).start OUI with the following options:

./runInstaller -invPtrLoc $ORACLE_HOME/oraInst.loc
The -invPtrLoc flag is used to locate the oraInst.loc file.
5.执行root.sh

6. 在update Inventory 报错了 [INS-20802] update Inventory failed. 网上说这是个dummy进程可以忽略,于是跳过;

7.此时 +ASM实例已自动创建,并自动启动,listener也自动启动,端口为1521,此时oracle database的listener不需要再启动,会zidon注册到这个listener中。

[grid@RHVM ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 1 21:43:49 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SQL> show parameter instance
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
cluster_database_instances integer
1
instance_name string
+ASM
instance_number integer
1
instance_type string
asm
SQL>

四、将数据迁移到ASM:

1.使用sys用户登录到EM,在server标签中选择Migrate to ASM,升级后所有文件都迁移到"+DATA"目录下:

+DATA/ipcdb/datafile/system.257.835737429
+DATA/ipcdb/datafile/sysaux.258.835737491
+DATA/ipcdb/datafile/undotbs1.259.835737555
+DATA/ipcdb/datafile/users.262.835737591
+DATA/ipcdb/datafile/user_02.261.835737589
+DATA/ipcdb/datafile/users_03.260.835737581
+DATA/ipcdb/datafile/users_04.269.835738407