\u5ba2\u6237\u5b89\u88c5\u4e86\u4e00\u4e2aOracle 11.2.0.2 for Linux X64\u73af\u5883\uff0c\u4f7f\u7528\u4e86ASM\u65b9\u5f0f\uff0c\u91cd\u542f\u540e\u53d1\u73b0\u6570\u636e\u5e93\u6ca1\u6709\u542f\u52a8\u3002
\n\u68c0\u67e5\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u7a0b\uff0c\u53d1\u73b0ASM\u5df2\u7ecf\u542f\u52a8\uff0cCLUSTER\u73af\u5883\u4e5f\u542f\u52a8\u5b8c\u6210\uff0c\u4f46\u662f\u6570\u636e\u5e93\u5e76\u672a\u542f\u52a8\uff0c\u5c1d\u8bd5\u624b\u5de5\u542f\u52a8\u6570\u636e\u5e93\uff0c\u62a5\u9519\u627e\u4e0d\u5230\u5bf9\u5e94\u7684SPFILE\u3002
\n\u767b\u5f55ASM\u5b9e\u4f8b\uff0c\u67e5\u8be2\u53d1\u73b0\u627e\u4e0d\u5230\u4efb\u4f55\u7684ASM\u78c1\u76d8\u7ec4\u4fe1\u606f\uff1a<\/p>\n
[grid@rptdb trace]$ sqlplus \/ as sysasm\r\nSQL*Plus: Release 11.2.0.2.0 Production on Tue Dec 20 18:41:41 2011\r\nCopyright (c) 1982, 2010, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Automatic Storage Management option\r\nSQL> select * from v$asm_diskgroup;\r\nno rows selected<\/pre>\n\u67e5\u8be2V$ASM_DISK\u53ef\u4ee5\u770b\u5230\u78c1\u76d8\u4fe1\u606f\uff0c\u4f46\u662f\u78c1\u76d8\u5934\u7684\u5934\u72b6\u6001\u662fUNKNOWN\uff1a<\/p>\n
SQL> SELECT GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, PATH FROM V$ASM_DISK;\r\nGROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU PATH\r\n------------ ----------- ------- ------------ ----------------------------------\r\n 0 1 CLOSED UNKNOWN ORCL:FRAVOL\r\n 0 0 CLOSED UNKNOWN ORCL:DATAVOL<\/pre>\n\u663e\u7136Oracle\u5e76\u6ca1\u6709\u53bb\u52a0\u8f7d\u78c1\u76d8\u7ec4\uff0c\u5229\u7528\u5f53\u524dASM\u7684SPFILE\u751f\u6210PFILE\u540e\u53d1\u73b0\uff0c\u53ea\u6709\u6700\u57fa\u672c\u7684\u53c2\u6570\uff1a<\/p>\n
*.asm_power_limit=1\r\n*.diagnostic_dest='\/u01\/app\/grid'\r\n*.instance_type='asm'\r\n*.large_pool_size=12M\r\n*.remote_login_passwordfile='EXCLUSIVE'<\/pre>\n\u8fdeASM_DISKGROUPS\u53c2\u6570\u90fd\u6ca1\u6709\uff0c\u96be\u602a\u67e5\u8be2V$ASM_DISKGROUP\u627e\u4e0d\u5230\u4efb\u4f55\u6570\u636e\uff0c\u6dfb\u52a0\u4e0b\u9762\u7684\u53c2\u6570\uff1a<\/p>\n
asm_diskgroups='DATA','FRA'\r\nasm_diskstring='ORCL:*VOL'<\/pre>\n\u91cd\u542fASM\u5b9e\u4f8b\uff0c\u5728\u52a0\u8f7d\u78c1\u76d8\u7ec4\u65f6\u62a5\u9519\uff1a<\/p>\n
[grid@rptdb ~]$ sqlplus \/ as sysasm\r\nSQL*Plus: Release 11.2.0.2.0 Production on Tue Dec 20 18:25:03 2011\r\nCopyright (c) 1982, 2010, Oracle. All rights reserved.\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Automatic Storage Management option\r\nSQL> shutdown immediate\r\nORA-15100: invalid or missing diskgroup name\r\nASM instance shutdown\r\nSQL> startup pfile=\/home\/grid\/init+ASM.ora\r\nASM instance started\r\nTotal System Global Area 283930624 bytes\r\nFixed Size 2225792 bytes\r\nVariable Size 256539008 bytes\r\nASM Cache 25165824 bytes\r\nORA-15032: not all alterations performed\r\nORA-15017: diskgroup \"FRA\" cannot be mounted\r\nORA-15063: ASM discovered an insufficient number of disks for diskgroup \"FRA\"\r\nORA-15017: diskgroup \"DATA\" cannot be mounted\r\nORA-15063: ASM discovered an insufficient number of disks for diskgroup \"DATA\"<\/pre>\n\u5bfc\u81f4\u8fd9\u4e2a\u9519\u8bef\u7684\u539f\u56e0\u6709\u5f88\u591a\uff0c\u6bd4\u5982\u6743\u9650\uff0c\u591a\u8def\u5f84\u8bbe\u7f6e\uff0c\u5b58\u50a8\u8bbe\u7f6e\u7b49\u7b49\uff0c\u68c0\u67e5\u544a\u8b66\u65e5\u5fd7\u5bfb\u627e\u8fdb\u4e00\u6b65\u7684\u4fe1\u606f\uff1a<\/p>\n
Tue Dec 20 18:25:47 2011\r\n* instance_number obtained from CSS = 1, checking for the existence of node 0...\r\n* node 0 does not exist. instance_number = 1\r\nStarting ORACLE instance (normal)\r\n****************** Huge Pages Information *****************\r\nHuge Pages memory pool detected (total: 42000 free: 42000)\r\nDFLT Huge Pages allocation successful (allocated: 0)\r\n***********************************************************\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nPicked latch-free SCN scheme 3\r\nUsing LOG_ARCHIVE_DEST_1 parameter default value as \/u01\/app\/grid\/product\/11.2.0\/grid\/dbs\/arch\r\nAutotune of undo retention is turned on.\r\nIMODE=BR\r\nILAT =0\r\nLICENSE_MAX_USERS = 0\r\nSYS auditing is disabled\r\nStarting up:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Automatic Storage Management option.\r\nUsing parameter settings in client-side pfile \/home\/grid\/init+ASM.ora on machine rptdb\r\nSystem parameters with non-default values:\r\n large_pool_size = 12M\r\n instance_type = \"asm\"\r\n remote_login_passwordfile= \"EXCLUSIVE\"\r\n asm_diskstring = \"ORCL:*VOL\"\r\n asm_diskgroups = \"DATA\"\r\n asm_diskgroups = \"FRA\"\r\n asm_power_limit = 1\r\n diagnostic_dest = \"\/u01\/app\/grid\"\r\nTue Dec 20 18:25:48 2011\r\nPMON started with pid=2, OS id=14718\r\nTue Dec 20 18:25:48 2011\r\nPSP0 started with pid=3, OS id=14722\r\nTue Dec 20 18:25:49 2011\r\nVKTM started with pid=4, OS id=14726 at elevated priority\r\nVKTM running at (1)millisec precision with DBRM quantum (100)ms\r\nTue Dec 20 18:25:49 2011\r\nGEN0 started with pid=5, OS id=14732\r\nTue Dec 20 18:25:49 2011\r\nDIAG started with pid=6, OS id=14736\r\nTue Dec 20 18:25:49 2011\r\nDIA0 started with pid=7, OS id=14740\r\nTue Dec 20 18:25:49 2011\r\nMMAN started with pid=8, OS id=14744\r\nTue Dec 20 18:25:49 2011\r\nDBW0 started with pid=9, OS id=14748\r\nTue Dec 20 18:25:49 2011\r\nLGWR started with pid=10, OS id=14752\r\nTue Dec 20 18:25:49 2011\r\nCKPT started with pid=11, OS id=14756\r\nTue Dec 20 18:25:49 2011\r\nSMON started with pid=12, OS id=14760\r\nTue Dec 20 18:25:49 2011\r\nRBAL started with pid=13, OS id=14764\r\nTue Dec 20 18:25:49 2011\r\nGMON started with pid=14, OS id=14768\r\nTue Dec 20 18:25:49 2011\r\nMMON started with pid=15, OS id=14772\r\nTue Dec 20 18:25:49 2011\r\nMMNL started with pid=16, OS id=14776\r\nORACLE_BASE not set in environment. It is recommended\r\nthat ORACLE_BASE be set in the environment\r\nTue Dec 20 18:25:49 2011\r\nSQL> ALTER DISKGROUP ALL MOUNT\r\nNOTE: Diskgroups listed in ASM_DISKGROUPS are\r\n DATA\r\n FRA\r\nNOTE: cache registered group DATA number=1 incarn=0x157c40a1\r\nNOTE: cache began mount (first) of group DATA number=1 incarn=0x157c40a1\r\nNOTE: cache registered group FRA number=2 incarn=0x158c40a2\r\nNOTE: cache began mount (first) of group FRA number=2 incarn=0x158c40a2\r\nNOTE: Loaded library: \/opt\/oracle\/extapi\/64\/asm\/orcl\/1\/libasm.so\r\nORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]\r\nORA-15025: could not open disk \"ORCL:DATAVOL\"\r\nORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]\r\nORA-15025: could not open disk \"ORCL:FRAVOL\"\r\nERROR: no PST quorum in group: required 2, found 0\r\nNOTE: cache dismounting (clean) group 1\/0x157C40A1 (DATA)\r\nNOTE: dbwr not being msg'd to dismount\r\nNOTE: lgwr not being msg'd to dismount\r\nNOTE: cache dismounted group 1\/0x157C40A1 (DATA)\r\nNOTE: cache ending mount (fail) of group DATA number=1 incarn=0x157c40a1\r\nNOTE: cache deleting context for group DATA 1\/0x157c40a1\r\nGMON dismounting group 1 at 2 for pid 17, osid 14779\r\nERROR: diskgroup DATA was not mounted\r\nERROR: no PST quorum in group: required 2, found 0\r\nNOTE: cache dismounting (clean) group 2\/0x158C40A2 (FRA)\r\nNOTE: dbwr not being msg'd to dismount\r\nNOTE: lgwr not being msg'd to dismount\r\nNOTE: cache dismounted group 2\/0x158C40A2 (FRA)\r\nNOTE: cache ending mount (fail) of group FRA number=2 incarn=0x158c40a2\r\nNOTE: cache deleting context for group FRA 2\/0x158c40a2\r\nGMON dismounting group 2 at 4 for pid 17, osid 14779\r\nERROR: diskgroup FRA was not mounted\r\nORA-15032: not all alterations performed\r\nORA-15017: diskgroup \"FRA\" cannot be mounted\r\nORA-15063: ASM discovered an insufficient number of disks for diskgroup \"FRA\"\r\nORA-15017: diskgroup \"DATA\" cannot be mounted\r\nORA-15063: ASM discovered an insufficient number of disks for diskgroup \"DATA\"\r\nERROR: ALTER DISKGROUP ALL MOUNT<\/pre>\n\u8fd9\u91cc\u53d1\u73b0\u4e86ORA-15186\u548cORA-15025\u9519\u8bef\u3002\u800cORA-15186\u9519\u8bef\u53d1\u751f\u5728ASMLIB\u8c03\u7528\u4e0a\uff0c\u6839\u636e\u8fd9\u4e2a\u9519\u8bef\u66f4\u5bb9\u6613\u5b9a\u4f4d\u5230\u95ee\u9898\u7684\u539f\u56e0\u3002
\n\u5728MOS\u4e0a\uff0c\u6709\u4e13\u95e8\u7684\u6587\u7ae0\u63cf\u8ff0\u8fd9\u4e2a\u95ee\u9898\uff1aMount ASM Disk Group Fails : ORA-15186, ORA-15025, ORA-15063 [ID 1384504.1]\uff0c\u6839\u636e\u95ee\u9898\u63cf\u8ff0\uff0c\u5bfc\u81f4\u8fd9\u4e2a\u9519\u8bef\u7684\u539f\u56e0\u662f\u591a\u8def\u5f84\u7684\u914d\u7f6e\u5b58\u5728\u95ee\u9898\uff1a<\/p>\n
[grid@rptdb ~]$ \/etc\/init.d\/oracleasm listdisks\r\nDATAVOL\r\nFRAVOL\r\n[grid@rptdb ~]$ cat \/proc\/partitions\r\nmajor minor #blocks name\r\n 8 0 285155328 sda\r\n 8 1 104391 sda1\r\n 8 2 285049327 sda2\r\n 8 16 1073741824 sdb\r\n 8 17 322119283 sdb1\r\n 8 18 429497775 sdb2\r\n 8 19 322119315 sdb3\r\n 8 32 1073741824 sdc\r\n 8 33 322119283 sdc1\r\n 8 34 429497775 sdc2\r\n 8 35 322119315 sdc3\r\n 8 48 1073741824 sdd\r\n 8 49 322119283 sdd1\r\n 8 50 429497775 sdd2\r\n 8 51 322119315 sdd3\r\n 8 64 1073741824 sde\r\n 8 65 322119283 sde1\r\n 8 66 429497775 sde2\r\n 8 67 322119315 sde3\r\n 253 0 150896640 dm-0\r\n 253 1 134119424 dm-1\r\n 253 2 1073741824 dm-2\r\n 253 3 322119283 dm-3\r\n 253 4 429497775 dm-4\r\n 253 5 322119315 dm-5\r\n[grid@rptdb ~]$ ls -l \/dev\/oracleasm\/disks\r\ntotal 0\r\nbrw-rw---- 1 grid oinstall 8, 18 Dec 20 17:42 DATAVOL\r\nbrw-rw---- 1 grid oinstall 8, 19 Dec 20 17:42 FRAVOL<\/pre>\n\u53ef\u4ee5\u770b\u5230\uff0cDATAVOL\u548cFRAVOL\u6ca1\u6709\u5bf9\u5e94\u5230\u591a\u8def\u5f84\u8bbe\u5907dm-n\u4e0a\uff0c\u800c\u662f\u5bf9\u5e94\u5230\u4e86sdb2\u548csdb3\u4e0a\u3002
\n\u4fee\u6539\/etc\/sysconfig\/oracleasm\u6587\u4ef6\uff0c\u5c06ORACLEASM_SCANORDER\u53c2\u6570\u548cORACLEASM_SCANEXCLUDE\u4fee\u6539\u5982\u4e0b\uff1a<\/p>\n
ORACLEASM_SCANORDER=\"mpath dm\"\r\nORACLEASM_SCANEXCLUDE=\"sd\"<\/pre>\n\u4fee\u6539\u540e\u91cd\u542f\u670d\u52a1\u5668\uff0c\u7531\u4e8eASM\u4e2d\u7684SPFILE\u8fd8\u662f\u5b58\u5728\u95ee\u9898\u7684\uff0c\u6240\u4ee5\u5148\u5173\u95ed\uff0c\u7136\u540e\u91cd\u65b0\u542f\u52a8\uff1a<\/p>\n
[grid@rptdb ~]$ sqlplus \/ as sysasm\r\nSQL*Plus: Release 11.2.0.2.0 Production on Tue Dec 20 19:05:33 2011\r\nCopyright (c) 1982, 2010, Oracle. All rights reserved.\r\nConnected.\r\nSQL> shutdown abort\r\nASM instance shutdown\r\nSQL> startup pfile=\/home\/grid\/init+ASM.ora\r\nASM instance started\r\nTotal System Global Area 283930624 bytes\r\nFixed Size 2225792 bytes\r\nVariable Size 256539008 bytes\r\nASM Cache 25165824 bytes\r\nASM diskgroups mounted\r\nSQL> create spfile='+DATA' from pfile='\/home\/grid\/init+ASM.ora';\r\nFile created.<\/pre>\n\u78c1\u76d8\u7ec4\u5df2\u7ecf\u987a\u5229\u542f\u52a8\uff0c\u521b\u5efa\u4e00\u4e2aSPFILE\u6587\u4ef6\uff0c\u786e\u4fdd\u4e0b\u6b21ASM\u81ea\u52a8\u542f\u52a8\u53ef\u4ee5\u52a0\u8f7d\u78c1\u76d8\u7ec4\u3002\u5207\u6362\u5230Oracle\u7528\u6237\u6253\u5f00\u6570\u636e\u5e93\uff1a<\/p>\n
[root@rptdb ~]# su - oracle\r\n[oracle@rptdb ~]$ sqlplus \/ as sysdba\r\nSQL*Plus: Release 11.2.0.2.0 Production on Tue Dec 20 19:06:27 2011\r\nCopyright (c) 1982, 2010, Oracle. All rights reserved.\r\nConnected to an idle instance.\r\nSQL> startup\r\nORACLE instance started.\r\nTotal System Global Area 6.4939E+10 bytes\r\nFixed Size 2242560 bytes\r\nVariable Size 3.0467E+10 bytes\r\nDatabase Buffers 3.4360E+10 bytes\r\nRedo Buffers 109195264 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL> exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Partitioning, Automatic Storage Management, OLAP, Data Mining\r\nand Real Application Testing options<\/pre>\n\u6570\u636e\u5e93\u987a\u5229\u6253\u5f00\uff0c\u6700\u540e\u68c0\u67e5\u4e00\u4e0bASM\u78c1\u76d8\u7684\u8bbe\u7f6e\uff1a<\/p>\n
[oracle@rptdb ~]$ ls -l \/dev\/oracleasm\/disks\r\ntotal 0\r\nbrw-rw---- 1 oracle oinstall 253, 4 Dec 20 19:00 DATAVOL\r\nbrw-rw---- 1 oracle oinstall 253, 5 Dec 20 19:00 FRAVOL\r\n[oracle@rptdb ~]$ cat \/proc\/partitions \r\nmajor minor #blocks name\r\n 8 0 285155328 sda\r\n 8 1 104391 sda1\r\n 8 2 285049327 sda2\r\n 8 16 1073741824 sdb\r\n 8 17 322119283 sdb1\r\n 8 18 429497775 sdb2\r\n 8 19 322119315 sdb3\r\n 8 32 1073741824 sdc\r\n 8 33 322119283 sdc1\r\n 8 34 429497775 sdc2\r\n 8 35 322119315 sdc3\r\n 8 48 1073741824 sdd\r\n 8 49 322119283 sdd1\r\n 8 50 429497775 sdd2\r\n 8 51 322119315 sdd3\r\n 8 64 1073741824 sde\r\n 8 65 322119283 sde1\r\n 8 66 429497775 sde2\r\n 8 67 322119315 sde3\r\n 253 0 150896640 dm-0\r\n 253 1 134119424 dm-1\r\n 253 2 1073741824 dm-2\r\n 253 3 322119283 dm-3\r\n 253 4 429497775 dm-4\r\n 253 5 322119315 dm-5<\/pre>\n\u8c03\u6574oracleasm\u7684\u914d\u7f6e\u540e\uff0c\u591a\u8def\u5f84\u7684\u914d\u7f6e\u6062\u590d\u6b63\u5e38\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u5b89\u88c5\u4e86\u4e00\u4e2aOracle 11.2.0.2 for Linux X64\u73af\u5883\uff0c\u4f7f\u7528\u4e86ASM\u65b9\u5f0f\uff0c\u91cd\u542f\u540e\u53d1\u73b0\u6570\u636e\u5e93\u6ca1\u6709\u542f\u52a8\u3002 \u68c0\u67e5\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u7a0b\uff0c\u53d1\u73b0ASM\u5df2\u7ecf\u542f\u52a8\uff0cCLUSTER\u73af\u5883\u4e5f\u542f\u52a8\u5b8c\u6210\uff0c\u4f46\u662f\u6570\u636e\u5e93\u5e76\u672a\u542f\u52a8\uff0c\u5c1d\u8bd5\u624b\u5de5\u542f\u52a8\u6570\u636e\u5e93\uff0c\u62a5\u9519\u627e\u4e0d\u5230\u5bf9\u5e94\u7684SPFILE\u3002 \u767b\u5f55ASM\u5b9e\u4f8b\uff0c\u67e5\u8be2\u53d1\u73b0\u627e\u4e0d\u5230\u4efb\u4f55\u7684ASM\u78c1\u76d8\u7ec4\u4fe1\u606f\uff1a [grid@rptdb trace]$ sqlplus \/ as sysasm SQL*Plus: Release 11.2.0.2.0 Production on Tue Dec 20 18:41:41 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 … Continue reading