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

SQL> select group_number, name, state from v$asm_diskgroup;
no rows selected
SQL> select group_number, name, state from v$asm_diskgroup_stat;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 VOTE_DG MOUNTED
2 DATA MOUNTED
SQL> select group_number, name, value from v$asm_attribute where name like '%compatible%';
GROUP_NUMBER NAME VALUE
------------ -------------------------------------- ---------------
1 compatible.asm 12.1.0.0.0
1 compatible.rdbms 12.1.0.0.0
2 compatible.asm 12.1.0.0.0
2 compatible.rdbms 10.1.0.0.0

Try to set the attribute

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

Confirm the status of the disks in the Diskgroup

SQL> select name, group_number from v$asm_disk;
NAME GROUP_NUMBER
------------------ ------------
DATA_0042 2
DATA_0040 2
DATA_0058 2
DATA_0056 2
DATA_0055 2
VOTE_DG_0003 1
DATA_0054 2
DATA_0053 2
DATA_0057 2
DATA_0052 2
DATA_0051 2
......
NAME GROUP_NUMBER
------------------ ------------
DATA_0011 2
DATA_0010 2
DATA_0048 2
DATA_0047 2
DATA_0046 2
DATA_0044 2
VOTE_DG_0002 1
DATA_0043 2
DATA_0045 2
DATA_0041 2
65 rows selected.

Confirm if the Diskgroup is usable

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

Check the parameter

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

Set the parameter with right value

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

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

ITPub博客

Oracle 12c GI v$asm_diskgroup returns no row

The Problem:

Diagnostic:

最新文章