Wednesday, April 19, 2017

Cannot see ASM disk groups in DBCA from oracle

The situation is you have installed the Grid Infrastructure software, created an ASM instance
created at least one disk group, and installed the Oracle database binaries. Now you are running the
Database Configuration Assistant (DBCA) to create the databases. 

Only thing is that you can not view the disk groups in your ASM instance.

You need to have the set uid bit set even though both user oracle and grid have a common group
membership. 


User oracle

[root@rac1-pub bin]# chmod 6751 oracle

[root@rac1-pub bin]# ll oracle

-rwsr-s--x 1 oracle oinstall 239626641 Apr 18 17:49 oracle

[root@rac1-pub bin]# pwd

/u01/app/oracle/product/11203/dbhome/bin

  User grid

[root@rac1-pub bin]# chmod 6751 oracle

[root@rac1-pub bin]# ll oracle

-rwsr-s--x 1 grid oinstall 209914471 Apr 18 16:15 oracle
[root@rac1-pub bin]# pwd

/u01/app/11203/bin






No comments:

Post a Comment

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts