Oracle 12c GI v$asm_diskgroup returns no row

The Problem:

    After Oracle 12c GI and DB having been installed, I execute dbca with oracle user.
When I try to choose ASM DG, it returned an empty diskgroups list. All the status of \
CRS resource is online.

Diagnostic:

Check status of diskgroup

1. SQL> select group_number, name, state from v$asm_diskgroup;
   
2.  
   
3. no rows selected
   
4. 
   
5. SQL> select group_number, name, state from v$asm_diskgroup_stat;
   
6.  
   
7. GROUP_NUMBER NAME STATE
   
8. ------------ ------------------------------ -----------
   
9.            1 VOTE_DG MOUNTED
   
10.            2 DATA MOUNTED
    
11. 
    
12. SQL> select group_number, name, value from v$asm_attribute where name like '%compatible%';
    
13.  
    
14. GROUP_NUMBER NAME VALUE
    
15. ------------ -------------------------------------- ---------------
    
16.            1 compatible.asm                         12.1.0.0.0
    
17.            1 compatible.rdbms                       12.1.0.0.0
    
18.            2 compatible.asm                         12.1.0.0.0
    
19.            2 compatible.rdbms                       10.1.0.0.0
20. 
    

Try to set the attribute

1. SQL> alter diskgroup DATA set attribute 'compatible.rdbms'='11.2';  
2. 
   
3. Diskgroup altered.
4. 
   
5. SQL> select group_number, name, state from v$asm_diskgroup;
   
6. 
   
7. no rows selected                 // not work.

Confirm the status of the disks in the Diskgroup

1. SQL> select name, group_number from v$asm_disk;
   
2.  
   
3. NAME GROUP_NUMBER
   
4. ------------------ ------------
   
5. DATA_0042          2
   
6. DATA_0040          2
   
7. DATA_0058          2
   
8. DATA_0056          2
   
9. DATA_0055          2
   
10. VOTE_DG_0003       1
    
11. DATA_0054          2
    
12. DATA_0053          2
    
13. DATA_0057          2
    
14. DATA_0052          2
    
15. DATA_0051          2
    
16. 
    
17. ......
    
18.  
    
19. NAME GROUP_NUMBER
    
20. ------------------ ------------
    
21. DATA_0011          2
    
22. DATA_0010          2
    
23. DATA_0048          2
    
24. DATA_0047          2
    
25. DATA_0046          2
    
26. DATA_0044          2
    
27. VOTE_DG_0002       1
    
28. DATA_0043          2
    
29. DATA_0045          2
    
30. DATA_0041          2
    
31.  
    
32. 65 rows selected.

Confirm if the Diskgroup is usable

1. [grid@xxx-db01 ~]$ asmcmd
2. ASMCMD> lsdg
3. State   Type   Rebal Sector Block AU      Total_MB  Free_MB   Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
4. MOUNTED NORMAL N     512    4096  1048576 225067123 225062497 38146970        93457763       0             N            DATA/
5. MOUNTED NORMAL N     512    4096  1048576 61440     51733     10240           20746          0             Y            VOTE_DG
6. // Everything seems OK.

Check the parameter

1. [grid@xxx-db01 ~]$ asmcmd dsget
   
2. parameter:                                   // It is empty.
   
3. profile: /dev/asmdisks,/dev/asmdisks/sn*
   
4. [grid@xxx-db01 ~]$ sqlplus / as sysdba
   
5. SQL> show parameter asm_diskstring;
   
6.  
   
7. NAME TYPE VALUE
   
8. -------------------- ----------- --------------------------
   
9. asm_diskstring       string                                    // It is empty, because of above.

Set the parameter with right value

1. SQL> alter system set asm_diskstring='/dev/asmdisks/sn*';
   
2.  
   
3. System altered.
   
4.  
   
5. SQL> select group_number, name, state from v$asm_diskgroup;
   
6.  
   
7. GROUP_NUMBER NAME STATE
   
8. ------------ ------------------------------ -----------
   
9.            2 DATA                           MOUNTED
   
10.            1 VOTE_DG                        MOUNTED
11. // Finally, It works.

After I can see the diskgroup, I execute dbca again. I can choose the Diskgroups Now.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25521690/viewspace-2123239/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25521690/viewspace-2123239/