Exadata虚拟机_3

创建两个Exadata所需的配置文件。Exadata所需要的配置文件有两个一个是cellinit.ora，此文件中填入DB节点的ip地址和子网掩码。另外一个是cellip.ora, 此文件填入Cell节点的ip地址，我本机的配置如下所示：

[root@db ~]# mkdir -p    /etc/oracle/cell/network-config[root@db ~]# chown -R grid:oinstall  /etc/oracle/cell/network-config[root@db ~]# chmod -R 775 /etc/oracle/cell/network-config[root@db ~]# vi /etc/oracle/cell/network-config/cellinit.ora [root@db ~]# cat /etc/oracle/cell/network-config/cellinit.ora ipaddress1=192.168.56.102/24[root@db ~]# vi /etc/oracle/cell/network-config/cellip.ora [root@db ~]# cat /etc/oracle/cell/network-config/cellip.ora cell="192.168.56.101"

就可以在我其他虚拟机创建asm了

[oracle@rac1 ~]$ source asm_profile 

[oracle@rac1 ~]$ sqlplus /nolog


SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 9 13:42:52 2014


Copyright (c) 1982, 2009, Oracle.  All rights reserved.


SQL> conn / as sysdba
Connected.
SQL> select disk_number, name, failgroup, path, header_status from v$asm_disk where path like 'o/%' order by disk_number;


DISK_NUMBER NAME
----------- ------------------------------------------------------------
FAILGROUP
------------------------------------------------------------
PATH
--------------------------------------------------------------------------------
HEADER_STATUS
------------------------
          2
LOCALHOST
o/192.168.175.138/date_CD_disk01_localhost
UNKNOWN




DISK_NUMBER NAME
----------- ------------------------------------------------------------
FAILGROUP
------------------------------------------------------------
PATH
--------------------------------------------------------------------------------
HEADER_STATUS
------------------------
          3
LOCALHOST
o/192.168.175.138/date_CD_disk02_localhost
UNKNOWN




DISK_NUMBER NAME
----------- ------------------------------------------------------------
FAILGROUP
------------------------------------------------------------
PATH
--------------------------------------------------------------------------------
HEADER_STATUS
------------------------
          4
LOCALHOST
o/192.168.175.138/date_CD_disk05_localhost
UNKNOWN




DISK_NUMBER NAME
----------- ------------------------------------------------------------
FAILGROUP
------------------------------------------------------------
PATH
--------------------------------------------------------------------------------
HEADER_STATUS
------------------------
          5
LOCALHOST
o/192.168.175.138/date_CD_disk03_localhost
UNKNOWN




DISK_NUMBER NAME
----------- ------------------------------------------------------------
FAILGROUP
------------------------------------------------------------
PATH
--------------------------------------------------------------------------------
HEADER_STATUS
------------------------
          6
LOCALHOST
o/192.168.175.138/date_CD_disk04_localhost
UNKNOWN




DISK_NUMBER NAME
----------- ------------------------------------------------------------
FAILGROUP
------------------------------------------------------------
PATH
--------------------------------------------------------------------------------
HEADER_STATUS
------------------------
          7
LOCALHOST
o/192.168.175.138/date_CD_disk06_localhost
UNKNOWN




6 rows selected.

SQL> 

SQL>  create diskgroup exdg1  external  redundancy  disk 'o/192.168.175.138/date_CD_disk*';
 create diskgroup exdg1  external  redundancy  disk 'o/192.168.175.138/date_CD_disk*'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 1 regular failure groups, discovered only
0

ORA-56864: Master Diskmon "ADD CELL o/192.168.175.138" operation cannot complete because of a LIBCELL network error
ORA-56846: Message 56846 not found;  product=RDBMS; facility=ORA
Attempt to start using an Exadata storage cell failed, since not all cluster nodes are configured to use Exadata storage.
Make sure that either all or none of the cluster nodes are configured to use Exadata storage.
Errors in file /orac/orahome/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_dskm_7003.trc:
ORA-56864: Master Diskmon "ADD CELL o/192.168.175.138" operation cannot complete because of a LIBCELL network error
ORA-56846: Message 56846 not found;  product=RDBMS; facility=ORA
NOTE: De-assigning number (2,0) from disk (o/192.168.175.138/date_CD_disk01_localhost)
NOTE: De-assigning number (2,1) from disk (o/192.168.175.138/date_CD_disk02_localhost)
NOTE: De-assigning number (2,2) from disk (o/192.168.175.138/date_CD_disk05_localhost)
NOTE: De-assigning number (2,3) from disk (o/192.168.175.138/date_CD_disk03_localhost)
NOTE: De-assigning number (2,4) from disk (o/192.168.175.138/date_CD_disk04_localhost)
NOTE: De-assigning number (2,5) from disk (o/192.168.175.138/date_CD_disk06_localhost)
NOTE: initiating PST update: grp = 2
kfdp_update(): 17 
Sat Aug 09 14:06:13 2014
kfdp_updateBg(): 17 
NOTE: PST update grp = 2 not completed, ret 10
kfdp_dismount(): 18 
kfdp_dismountBg(): 18 
kfdp_dismount(): 19 
kfdp_dismountBg(): 19 
ERROR: diskgroup EXDG1 was not created
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 1 regular failure groups, discovered only 0
ERROR:  create diskgroup exdg1  external  redundancy  disk 'o/192.168.175.138/date_CD_disk*'
Attempt to start using an Exadata storage cell failed, since not all cluster nodes are configured to use Exadata storage.
Make sure that either all or none of the cluster nodes are configured to use Exadata storage.
Errors in file /orac/orahome/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_dskm_7003.trc:
ORA-56864: Master Diskmon "ADD CELL o/192.168.175.138" operation cannot complete because of a LIBCELL network error
ORA-56846: Message 56846 not found;  product=RDBMS; facility=ORA
[oracle@rac1 trace]$                    more  /orac/orahome/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_dskm_7003.trc
/orac/orahome/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_dskm_7003.trc: No such file or directory