oracle asm ora-15031

imlihj2007發表於2008-05-17

ora-15031 DBCA找不到ASM磁碟組

使用DBCA建立資料庫,使用ASM儲存。ASM例項已經建立,但是在建立磁碟組視窗,無法找到已經建立的ASM磁碟組。ORACLEASM顯示正常。
[yangwenchao@yangwenchao ~]$ /etc/init.d/oracleasm status
Checking if ASM is loaded: [ OK ]
Checking if /dev/oracleasm is mounted: [ OK ]
[yangwenchao@yangwenchao ~]$ /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4
VOL5
[yangwenchao@yangwenchao ~]$ /etc/init.d/oracleasm scandisks
Scanning system for ASM disks:

請問怎樣才能新增上ASM磁碟組?

#/etc/init.d/oracleasm createdisk VOL1 /dev/sdb
  #/etc/init.d/oracleasm createdisk VOL2 /dev/sdc
  #/etc/init.d/oracleasm createdisk VOL3 /dev/sdd
  #/etc/init.d/oracleasm createdisk VOL4 /dev/sde
#/etc/init.d/oracleasm createdisk VOL5 /dev/sdf

解決方法一

[root@racdb1 ~]# /etc/init.d/oracleasm scandisks
Scanning system for ASM disks: [ OK ]
[root@racdb1 disks]# /etc/init.d/oracleasm status
Checking if ASM is loaded: [ OK ]
Checking if /dev/oracleasm is mounted: [ OK ]
注意mount在 /dev/oracleasm

建立的時候路徑要用全部路徑(絕對路徑)同時要要看
*.asm_diskgroups='ORACLE','dgtest' -----這個地方要經常更改
*.asm_diskstring='/dev/oracleasm/disks/VOL*' -----特別要注意這個地方
*.background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
*.core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/u01/app/oracle/admin/+ASM/udump'

SQL> create diskgroup dgtest1 normal redundancy
2 failgroup dgtest_0001 disk '/dev/oracleasm/disks/VOL4' name dgtest_0003
3 failgroup dgtest_0002 disk '/dev/oracleasm/disks/VOL5' name dgtest_0004;

Diskgroup created.



  解決方法二

  修改$ORACLE_HOME/dbs/init+ASM.ora檔案
  新增一行:asm_diskstring='ORCL:VOL*'
  
  啟動例項
  報錯,ORA-29701: unable to connect to Cluster Manager
  查google,查不到
  再查metalink,原來是因為安裝完10g以後,就直接把/etc/inittab中的
  h1:35:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1   這句註釋了
  原來這就是10g內建的cluster manager
  
  取消註釋
  重新啟動系統
  再次啟動例項,OK
  

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9879835/viewspace-1004180/,如需轉載,請註明出處,否則將追究法律責任。

相關文章