grid用戶使用DBCA可以看到磁盤組。用戶組都是oinstall.
bash-4.3# id grid
uid=1002(grid) gid=107(oinstall) groups=16(dialout),33(video),107(oinstall)
bash-4.3# id oracle
uid=1001(oracle) gid=107(oinstall) groups=16(dialout),33(video),107(oinstall)
目錄權(quán)限也有
bash-4.3$ cd bin/
bash-4.3$ ls -lah |grep oracle
-rwsr-s--x 1 grid oinstall 177M Jun 24 14:31 oracle
也手工添加了磁盤組
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
asm_diskgroups string DATA
asm_diskstring string /dev/raw/raw1, /dev/raw/raw2,
/dev/raw/raw3, /dev/raw/raw4,
/dev/raw/raw5, /dev/raw/raw6,
/dev/raw/raw7, /dev/raw/raw8,
/dev/raw/raw9, /dev/raw/raw10,
/dev/raw/raw11, /dev/raw/raw1
2, /dev/raw/raw13, /dev/raw/ra
w14, /dev/raw/raw15
asm_power_limit integer 1
asm_preferred_read_failure_groups string
ORACLE用戶DBCA建庫報錯如下：
The error is:
java.io.IOException: /opt/oracle/product/11gR1/crs/bin/sqlplus: not found
[AWT-EventQueue-0] [ 2015-06-29 17:31:49.257 CST ] [ASMUtils.loadDiskGroups:668] Loading the diskgroups...
[AWT-EventQueue-0] [ 2015-06-29 17:31:49.258 CST ] [ASMUtils.loadDiskGroups:708] COULD NOT FIND ANY DISKGROUPS
[AWT-EventQueue-0] [ 2015-06-29 17:31:49.258 CST ] [DatabaseAreaPage.validateASMUse:816] No disk group found
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.664 CST ] [ASMUtils.loadDiskGroups:633] sql to be executed:=select NAME||'|'||round(TOTAL_MB)||'|'||round(USABLE_FILE_MB)||'|'||nvl(TYPE, 'DBCA_NULL')||'|'||STATE from v$asm_diskgroup order by NAME using sqlengine
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.665 CST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: null
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.670 CST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.671 CST ] [OracleHome.getVersion:943] Current Version From Inventory: null
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.672 CST ] [OracleHome.getVersion:948] using sqlplus: /opt/oracle/product/11gR1/crs/bin/sqlplus
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.672 CST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: null
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.675 CST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.675 CST ] [OracleHome.getVersion:943] Current Version From Inventory: null
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.675 CST ] [OracleHome.getVersion:948] using sqlplus: /opt/oracle/product/11gR1/crs/bin/sqlplus
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.676 CST ] [SQLPlusEngine.getCmmdParams:222] m_home null
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.676 CST ] [SQLPlusEngine.getCmmdParams:223] version > 112 false
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.676 CST ] [SQLEngine.getEnvParams:557] NLS_LANG: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.678 CST ] [SQLEngine.initialize:317] Execing SQLPLUS/SVRMGR process...
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.680 CST ] [ASMUtils.loadDiskGroups:646] can not connect There is an error in creating the following process:
/opt/oracle/product/11gR1/crs/bin/sqlplus -S /NOLOG
The error is:
java.io.IOException: /opt/oracle/product/11gR1/crs/bin/sqlplus: not found
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.681 CST ] [ASMUtils.loadDiskGroups:668] Loading the diskgroups...
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.681 CST ] [ASMUtils.loadDiskGroups:708] COULD NOT FIND ANY DISKGROUPS
[AWT-EventQueue-0] [ 2015-06-29 17:31:54.682 CST ] [DatabaseAreaPage.validateASMUse:816] No disk group found
oracle@hnstat-new-db:/opt/oracle/cfgtoollogs/dbca>
Last login: Mon Jun 29 17:37:55 2015 from 134.160.150.233