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 DB=OWNER !=DB=OWNER

François LangeApr 9 2008 — edited May 7 2008
Hi,
For the moment, on our Sun Cluster servers there are more than one (OS) oracle users.
Call them
oracle_1
..
oracle_n
+ emoracle

Each of these Oracle users have 3 groups: oper, dba, install define.
Call them
dba_1 ... dba_n
oper_1 ... oper_n
install_1 ... install_n

echo dba_i, oper_i, install_i(default) is associated with oracle_i and emoracle.

The special (os) oracle user emoracle ( for the enterprise grid control agent is part ) of the install_*, dba_*, oper_* groups

Each os oracle users own between 1 and 3 DB!

During a product installation under the oracle_j user, it received all the install_* groups in order to create files in <Path_to_oraInventory_loc>/ContentsXML when directory a deport to the other node. That the case for the Entreprise grid control agentS which switch with their logical host IP and the associate instance.

Now we need to use ASM.
Which user should hold the raw disks and how to spread the disk group to be visible only by os oracle_i user which need it or better nobody to be sure that nobody made an os command (dd) and others database raw disks.

Does I need to one ASM database per server per os oracle_i user ?
How to find a document about this ?

Best regards François LANGE.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2008
Added on Apr 9 2008
3 comments
2,144 views