\u57fa\u4e8easm\u7684\u5355\u5b9e\u4f8b\u6570\u636e\u5e93\u542f\u52a8\u65f6\u62a5\u9519ORA-15032 ORA-15063\u4e00\u4f8b<\/p>\n
--\u62a5\u9519\u5982\u4e0b\uff1a
\nSQL> startup
\nASM instance started<\/p>\n
Total System Global Area 83886080 bytes
\nFixed Size 1217836 bytes
\nVariable Size 57502420 bytes
\nASM Cache 25165824 bytes
\nORA-15032: not all alterations performed
\nORA-15063: ASM discovered an insufficient number of disks for diskgroup \"DATA\"<\/p>\n
--\u67e5\u770b\u9519\u8bef\u4fe1\u606f\uff1a
\n[oracle@rhl5 ~]$ oerr ora 15032
\n15032, 00000, \"not all alterations performed\"
\n\/\/ *Cause: At least one ALTER DISKGROUP action failed.
\n\/\/ *Action: Check the other messages issued along with this summary error.
\n\/\/
\n[oracle@rhl5 ~]$ oerr ora 15063
\n15063, 00000, \"ASM discovered an insufficient number of disks for diskgroup \\\"%s\\\"\"
\n\/\/ *Cause: ASM was unable to find a sufficient number of disks belonging to the
\n\/\/ diskgroup to continue the operation.
\n\/\/ *Action: Check that the disks in the diskgroup are present and functioning,
\n\/\/ that the owner of the ORACLE binary has read\/write permission to
\n\/\/ the disks, and that the ASM_DISKSTRING initialization parameter
\n\/\/ has been set correctly. Verify that ASM discovers the appropriate
\n\/\/ disks by querying V$ASM_DISK from the ASM instance.<\/p>\n
--\u67e5\u770basm\u7684\u76f8\u5173\u8fdb\u7a0b\u662f\u5426\u5b58\u5728\uff1a
\n[oracle@rhl5 rules.d]$ ps -ef | grep ASM
\noracle 4618 1 0 06:50 ? 00:00:00 asm_pmon_+ASM
\noracle 4620 1 0 06:50 ? 00:00:00 asm_psp0_+ASM
\noracle 4622 1 0 06:50 ? 00:00:00 asm_mman_+ASM
\noracle 4624 1 0 06:50 ? 00:00:00 asm_dbw0_+ASM
\noracle 4626 1 0 06:50 ? 00:00:00 asm_lgwr_+ASM
\noracle 4628 1 0 06:50 ? 00:00:00 asm_ckpt_+ASM
\noracle 4630 1 0 06:50 ? 00:00:00 asm_smon_+ASM
\noracle 4632 1 0 06:50 ? 00:00:00 asm_rbal_+ASM
\noracle 4634 1 0 06:50 ? 00:00:00 asm_gmon_+ASM
\noracle 4636 4611 0 06:50 ? 00:00:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
\noracle 4697 4651 0 06:52 pts\/2 00:00:00 grep ASM<\/p>\n
--\u67e5\u770b\u78c1\u76d8\u7ec4
\nSQL> select name,state from v$asm_diskgroup;<\/p>\n
no rows selected<\/p>\n
--\u8bd5\u56fe\u624b\u52a8\u521b\u5efa\u78c1\u76d8\u7ec4
\nSQL> create diskgroup data external redundancy disk '\/dev\/racdisk1';
\ncreate diskgroup data external redundancy disk '\/dev\/racdisk1'
\n*
\nERROR at line 1:
\nORA-15018: diskgroup cannot be created
\nORA-15031: disk specification '\/dev\/racdisk1' matches no disks
\nORA-15025: could not open disk '\/dev\/racdisk1'
\nORA-15056: additional error message
\nLinux Error: 13: Permission denied
\nAdditional information: 42
\nAdditional information: 141148497
\nAdditional information: 213724448<\/p>\n
--\u67e5\u770basm\u53c2\u6570\u6587\u4ef6
\n[oracle@rhl5 ~]$ strings \/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/spfile+ASM.ora
\n6q0\/
\n+ASM.asm_diskgroups='DATA'#Manual Mount
\n*.asm_diskgroups='DATA'
\n*.asm_diskstring='\/dev\/racdisk1'
\n*.background_dump_dest='\/u01\/app\/oracle\/admin\/+ASM\/bdump'
\n*.core_dump_dest='\/u01\/app\/oracle\/admin\/+ASM\/cdump'
\n*.instance_type='asm'
\n*.large_pool_size=12M
\n*.remote_login_passwordfile='SHARED'
\n*.user_dump_dest='\/u01\/app\/oracle\/admin\/+ASM\/udump'<\/p>\n
--\u67e5\u770b\u78c1\u76d8\u8bfb\u5199\u6743\u9650\u5e76\u4fee\u6539\u6743\u9650
\n[root@rhl5 dev]# ls -l rac*
\nbrw-rw---- 1 grid asmadmin 8, 16 Sep 19 06:43 racdisk1
\n[root@rhl5 dev]# chmod 777 rac*
\n[root@rhl5 dev]# ls -l rac*
\nbrwxrwxrwx 1 grid asmadmin 8, 16 Sep 19 06:43 racdisk1<\/p>\n
--\u6b63\u5e38\u542f\u52a8asm\uff08\u6302\u8f7d\u78c1\u76d8\u7ec4\uff09
\n[oracle@rhl5 ~]$ export ORACLE_SID=+ASM
\n[oracle@rhl5 ~]$ sqlplus \/nolog<\/p>\n
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 19 07:12:17 2012<\/p>\n
Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n
SQL> conn \/as sysdba
\nConnected.
\nSQL> shutdown immediate
\nORA-15100: invalid or missing diskgroup name<\/p>\n
ASM instance shutdown
\nSQL> startup
\nASM instance started<\/p>\n
Total System Global Area 83886080 bytes
\nFixed Size 1217836 bytes
\nVariable Size 57502420 bytes
\nASM Cache 25165824 bytes
\nASM diskgroups mounted<\/p>\n
--\u6b63\u5e38\u542f\u52a8\u6570\u636e\u5e93
\n[oracle@rhl5 ~]$ env | grep ORACLE_SID
\nORACLE_SID=ora10gr2
\n[oracle@rhl5 ~]$ sqlplus \/nolog<\/p>\n
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 19 07:13:58 2012<\/p>\n
Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n
SQL> conn \/as sysdba
\nConnected.
\nSQL> select open_mode from v$database;
\nselect open_mode from v$database
\n*
\nERROR at line 1:
\nORA-01507: database not mounted<\/p>\n
SQL> shutdown immediate
\nORA-01507: database not mounted<\/p>\n
ORACLE instance shut down.
\nSQL> startup
\nORACLE instance started.<\/p>\n
Total System Global Area 608174080 bytes
\nFixed Size 1220844 bytes
\nVariable Size 159387412 bytes
\nDatabase Buffers 444596224 bytes
\nRedo Buffers 2969600 bytes
\nDatabase mounted.
\nDatabase opened.<\/p>\n
\u603b\u7ed3\uff1a\u6b64\u4f8b\u662f\u7531\u4e8easm\u78c1\u76d8\u7ec4\u7684\u6743\u9650\u51fa\u73b0\u95ee\u9898\u5bfc\u81f4asm\u78c1\u76d8\u65e0\u6cd5\u6b63\u5e38\u6302\u8f7d\u5bfc\u81f4\u7684\u3002\u4fee\u6539\u76f8\u5e94\u6743\u9650\u5373\u53ef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u57fa\u4e8easm\u7684\u5355\u5b9e\u4f8b\u6570\u636e\u5e93\u542f\u52a8\u65f6\u62a5\u9519ORA-15032 ORA-15063\u4e00\u4f8b –\u62a5\u9519\u5982\u4e0b\uff1a SQL> […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32,36],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/277"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=277"}],"version-history":[{"count":5,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/277\/revisions"}],"predecessor-version":[{"id":502,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/277\/revisions\/502"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}