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