SuSE 11SP2 安裝11GR2 DBCA建庫(kù)找不到ASM磁盤組？

oushitianxia915

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建庫(kù)報(bào)錯(cuò)如下：
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


但是重啟了ASM庫(kù)，還是看不到磁盤組呀，有大神解決過(guò)嗎？

oushitianxia915

問(wèn)題解決了，
/etc/profile.d 下面oracle.sh oracle.csh 兩個(gè)腳本中 設(shè)置了錯(cuò)誤的路徑導(dǎo)致下面的報(bào)錯(cuò)
java.io.IOException: /opt/oracle/product/11gR1/crs/bin/sqlplus: not found

renxiao2003

看來(lái)安裝Oracle環(huán)境變量配置很重要。特別是在Linux下。