oracle asm ora-15031
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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9879835/viewspace-1004180/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle asmOracleASM
- 【ORACLE ASM】ASM 支援工具簡介OracleASM
- oracle asm命令OracleASM
- Oracle ASM 管理OracleASM
- Oracle ASM 限制OracleASM
- oracle asm asmcmdOracleASM
- Oracle ASM Disk DirectoryOracleASM
- Oracle ASM File DirectoryOracleASM
- Oracle ASM Allocation TableOracleASM
- Oracle ASM Disk PartnerOracleASM
- Oracle ASM Alias DirectoryOracleASM
- Oracle ASM Template DirectoryOracleASM
- Oracle Find block in ASMOracleBloCASM
- Oracle ASM 詳解OracleASM
- oracle ASM中ASM_POWER_LIMIT引數OracleASMMIT
- Oracle ASM神書《撥雲見日 解密Oracle ASM核心》出版了OracleASM解密
- 【ASM】Oracle asm刪除磁碟組注意事項ASMOracle
- Oracle ASM擴容(NFS)OracleASMNFS
- Oracle ASM Filter Driver (ASMFD)OracleASMFilter
- Oracle ASM Partnership and Status TableOracleASM
- Oracle ASM Free Space TableOracleASM
- Oracle ASM Disk HeaderOracleASMHeader
- 【轉】Oracle ASM介紹OracleASM
- Oracle ASM spfile in a disk groupOracleASM
- Oracle ASM Attributes DirectoryOracleASM
- Oracle ASM Volume DirectoryOracleASM
- Oracle ASM Active Change DirectoryOracleASM
- oracle 手動建立ASMOracleASM
- Oracle ASM 配置錯誤OracleASM
- oracle中的asm文化OracleASM
- Oracle ASM檢視資訊OracleASM
- ORACLE ASM 基礎篇OracleASM
- oracle asm 10gOracleASM
- oracle asm 管理容量OracleASM
- oracle asm 儲存限制OracleASM
- ORACLE 11.2.0.3配置ASMOracleASM
- oracle10g asm---第三回---asmOracleASM
- Oracle ASM AMDU工具的使用OracleASM