oracle用户看不到磁盘组,【已解决】dbca看不到asm磁盘？

Cause #1) File permissions in /bin/oracle executable not set properly.

Cause #2) If the Oracle user is not a part of asmdba group; DBCA will not be able to see the diskgroups, and may not start.

Cause #3) The OS environment variable ORA_CRS_HOME is set and set to the wrong Oracle Home. Please avoide setting this environment variable altogether.

Solution

* For cause #1:

As root, change the file permissions of the oracle executable under Grid_Home/bin to 6751:

# cd /bin

# chmod 6751 oracle

# ls -l oracle

-rwsr-s--x 1 grid oinstall 173515905 May 21 17:04 oracle

This is the setuid bit, and this must be set in order for users, other than "Grid" user to have it work.

* For cause #2:

In a Job Role Separation (JRS) environment (where a separate OS user is used to managae/administer the database and the ASM instances), assign the 'asmdba' role to the db_home owner.

For more details on JRS, please see the Oracle Install guide for the appropriate platform.

Example: For Linux and Grid Infrastructure (RAC) :

http://docs.oracle.com/cd/E11882 ... elinux.htm#CFIJDFIB

Oracle® Grid Infrastructure Installation Guide

11g Release 2 (11.2) for Linux

Part Number E22489-06

2.5.5 Creating Job Role Separation Operating System Privileges Groups and Users

Example: For Linux and Oracle Restart (non-RAC or Single Instance) :

http://docs.oracle.com/cd/E11882 ... nstall.htm#BABHHEJD

Oracle® Database Installation Guide

11g Release 2 (11.2) for Linux

Part Number E24321-06

2.8 Creating Required Operating System Groups and Users

* For Cause #3:

Either unset the ORA_CRS_HOME (recommended) or set this to point to the proper Grid Infrastructure home (gi_home)