Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASM Disk Privileges for multi user multi Oracle Home installation

1528341Jan 12 2015 — edited Jan 13 2015

Hi,

We are creating three databases with ASM storage on 11.2.0.3.

Grid user: grid

Primary Group: oinstall

Secondary Group: asmdba, asmadmin, asmoper

Oracle1 User: oracle1

Primary Group: oinstall

Secondary Group: dba1, dboper1, asmdba

Oracle2 User: oracle2

Primary Group: oinstall

Secondary Group: dba2, dboper2, asmdba

Oracle1 User: oracle3

Primary Group: oinstall

Secondary Group: dba3, dboper3, asmdba

Voting Disk Group: VOTE_DG

Oracle1 Disk Group: ORCL1_DATA

Oracle2 Disk Group: ORCL2_DATA

Oracle3 Disk Group: ORCL3_DATA

I have read some notes indicating as follows:

Change the user and group ownership of devices to oracle:dba or grid:asmadmin (ASM role separation)

But, I have also seen the following note:

In general, the owner of the disk devices should be the same as the owner of the Oracle binary. The group ownership should be OSDBA of the ASM instance, which is defined at installation.

What should be the ASM disk privileges? Thanks in advance.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2015
Added on Jan 12 2015
12 comments
3,261 views