DBCA Log Path
[Email protected] ~]# cd/u01/app/oracle/cfgtoollogs/dbca/
[email protected] dbca]# LL
Total 1700
-RW-R-----1 Oracle oinstall 1740250 Jul 10:31 trace.log_2018-07-24_09-31-27-am
-RW-R-----1 Oracle Oinstall 0 Jul 09:31 Trace.log_2018-07-24_09-31-27-am.lck
DBCA LOG has discovery ASM Disk Group
[Dbstorageoption.flowworker] [2018-07-24 09:35:52.924 CST] [ VERIFICATIONUTIL.TRACEANDLOGINTERNAL:15712] [storagedatahandler.getstoragedataforacfs:557] Discovered ' 0 ' ACFS Storage from node ' oracle74 '
[Dbstorageoption.flowworker] [2018-07-24 09:35:52.924 CST] [ VERIFICATIONUTIL.TRACEANDLOGINTERNAL:15712] [storagedatahandler.discoverstoragedata:201] Storage of type ' ACFS ' was Successfully discovered[count of storage found = ' 0 ']
[Dbstorageoption.flowworker] [2018-07-24 09:35:52.924 CST] [Sto RAGEDATAHANDLER.DISCOVERSTORAGEDATA:211] Sttype ACFS potentialmatchlist size 0
[Dbstorageoption.flowworker] [ 2018-07-24 09:35:52.925 CST] [verificationutil.traceandloginternal:15712] [Storagedatahandler.tracediscoveredset : 2415]
>>> Discovery details for storage type ' ASMDG ' ...
Count of devices = 3
- Ocrvote [1 Nodes:oracle74]
- Oradata [1 Nodes:oracle74]
- MGMT [1 Nodes:oracle74]
Reference http://qxm0411.blog.163.com/blog/static/13721454820137193352451/
Compare user groups to discover Oracle confirm Asmoper and asmadmin add on
[[email protected] ~]# ID grid
uid=54322 (GRID) gid=54321 (Oinstall) groups=54321 (Oinstall), 54322 (DBA), 54327 (ASMDBA), 54328 (Asmoper), 54329 ( Asmadmin)
[[email protected] ~]# ID Oracle
uid=54321 (Oracle) gid=54321 (oinstall) groups=54321 (Oinstall), 54322 (DBA), 54323 (Oper), 54324 (BACKUPDBA), 54325 (dgdba ), 54326 (KMDBA), 54327 (ASMDBA), 54329 (Asmadmin), 54330 (RACDBA)
[Email protected] ~]# usermod-u 54321-g oinstall-g dba,asmdba,backupdba,dgdba,kmdba,racdba,asmoper Oracle
[Email protected] ~]#
[Email protected] ~]#
[[email protected] ~]# ID Oracle
uid=54321 (Oracle) gid=54321 (oinstall) groups=54321 (Oinstall), 54322 (DBA), 54324 (BACKUPDBA), 54325 (DGDBA), 54326 ( KMDBA), 54327 (ASMDBA), 54328 (Asmoper), 54330 (RACDBA)
[[email protected] ~]# ID grid
uid=54322 (GRID) gid=54321 (Oinstall) groups=54321 (Oinstall), 54322 (DBA), 54327 (ASMDBA), 54328 (Asmoper), 54329 ( Asmadmin)
[[email protected] ~]# ID Oracle
uid=54321 (Oracle) gid=54321 (oinstall) groups=54321 (Oinstall), 54322 (DBA), 54324 (BACKUPDBA), 54325 (DGDBA), 54326 ( KMDBA), 54327 (ASMDBA), 54328 (Asmoper), 54330 (RACDBA)
[Email protected] ~]# usermod-u 54321-g oinstall-g dba,asmdba,backupdba,dgdba,kmdba,racdba,asmoper,asmadmin,oper Oracle
[[email protected] ~]# ID Oracle
uid=54321 (Oracle) gid=54321 (oinstall) groups=54321 (Oinstall), 54322 (DBA), 54324 (BACKUPDBA), 54325 (DGDBA), 54326 ( KMDBA), 54327 (ASMDBA), 54328 (Asmoper), 54329 (Asmadmin), 54330 (RACDBA)
Re-refresh to discover ASM DiskGroup
Refer to Other Links:
Http://www.itpub.net/forum.php?mod=viewthread&tid=1906331&page=1
Http://www.itpub.net/thread-1783419-2-1.html
Https://support.oracle.com/knowledge/Oracle%20Database%20Products/1952685_1.html
Oracle 12c DBCA cannot discover ASM DiskGroup