$ . oraenv
ORACLE_SID = [+ASM] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
$ dbca
设置数据库文件的存储类型为ASM,存储路径使用OMF:+DATA(也可以通过点击Browse选择+DATA)
输入ASM密码:oracle_4U
设置FRA存储路径:+FRA(也可以通过点击Browse选择+FRA)
保存数据库模版:
安装后的检查:# su - oracle
$ . oraenv
ORACLE_SID = [orcl] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE ora11g
ora.FRA.dg ora....up.type ONLINE ONLINE ora11g
ora....ER.lsnr ora....er.type ONLINE ONLINE ora11g
ora.asm ora.asm.type ONLINE ONLINE ora11g
ora.cssd ora.cssd.type ONLINE ONLINE ora11g
ora.diskmon ora....on.type ONLINE ONLINE ora11g
ora.orcl.db ora....se.type ONLINE ONLINE ora11g
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 13 21:49:34 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
SQL> select status from v$instance;
STATUS
------------------------------------
STARTED
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
[oracle@ora11g ~]$ . oraenv
ORACLE_SID = [+ASM] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@ora11g ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 13 21:50:45 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
OPEN