因为使用asm ,必须要有 css 服务,为了后续的 asm 实验,所以有了这个安装


1.创建用户




groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 asmadmin
groupadd -g 505 asmdba
groupadd -g 506 asmoper


useradd -u 501 -g oinstall -G asmdba,dba,oper oracle
useradd -u 502 -g oinstall -G asmadmin,asmdba,asmoper grid




2.为虚拟机准备两块盘


fdisk -l


Disk /dev/xvdb: 17.1 GB, 17179869184 bytes
255 heads, 63 sectors/track, 2088 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes




Disk /dev/xvdc: 536.8 GB, 536870912000 bytes
255 heads, 63 sectors/track, 65270 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes




/dev/xvdb与/dev/xvdc






3.安装 Oracle Grid Infrastructure for a Standalone Server


 




 


这里ocr,表决磁盘不大,给个 10G 就差不多了,用一块硬盘就可
其它都是顺风顺水,一路向下既可


 
















安装 db 时,好像只能选择  single instance database installation


SQL> select name,state from v$asm_diskgroup;


NAME                           STATE
------------------------------ -----------
DATA                           MOUNTED
DG                             DISMOUNTED


测试一下删除diskgroup




ps:删除必须用  sqlplus  / as sysasm


SQL> alter diskgroup dg drop disk '/dev/xvdd';
alter diskgroup dg drop disk '/dev/xvdd'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15001: diskgroup "DG" does not exist or is not mounted




SQL> alter diskgroup dg mount;


Diskgroup altered.






现在进行一下 diskgroup 信息确认




SQL> select group_number, name, state, type from v$asm_diskgroup;


GROUP_NUMBER NAME                           STATE       TYPE
------------ ------------------------------ ----------- ------
           1 DATA                           MOUNTED     EXTERN
           2 DG                             MOUNTED     EXTERN


SQL> col path format a30
SQL> col name format a30
SQL> select disk_number, path, name from v$asm_disk where group_number = 2;


DISK_NUMBER PATH                           NAME
----------- ------------------------------ ------------------------------
          0 /dev/xvdd                      DG_0000






SQL> drop diskgroup DG;


Diskgroup dropped.




4.安装db软件


正常安装


5.创建数据库实例




create diskgroup dg external redundancy disk '/dev/xvdd';


创建了一个diskgroup组


 





实例创建顺风顺水


由于上传图比较费劲，所有没有图,安装 asm 实例是为了后面  rman copy 迁移搭环境
今天你学会了么