Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
A.
By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
B.
The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
C.
The Oracle Grid Infrastructure installation must be owned by the grid user.
D.
The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
E.
The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
F.
The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
It’s confirmed by the below quotes
https://docs.oracle.com/database/121/CWLIN/usrgrps.htm#CWLIN483
The -g option specifies the primary group, which must be the Oracle Inventory group. For example: oinstall.
You can designate a unique group for the SYSASM system privilege, separate from database administrator groups, or you can designate one group as the OSASM and OSDBA group, so that members of that group are granted the SYSASM and SYSDBA privilege to grant system privileges to administer both the Oracle ASM instances and Oracle Database instances.
If you are creating this user to own both Oracle Grid Infrastructure and an Oracle Database installation, then this user must have the OSDBA for ASM group as a secondary group.
In Oracle documentation, a user created to own the Oracle Grid Infrastructure binaries is called the grid user. This user owns both the Oracle Clusterware and Oracle Automatic Storage Management binaries.
A - false - Members of this group are granted the SYSASM system privilege to administer Oracle ASM.SYSASM system privileges do not grant access privileges on an Oracle Database instance.
B- Correct -
C - false Only if you wish to define role separation but is not a must
D - correct
E- false OSOPER is optional is not a must
F - the same OSDBA could be used but is not a must ( usually SYSDBA and SYSASM are used for separation us duties )
Based on 19c documentation.
https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/creating-users-groups-paths-for-grid-infrastructure.html#GUID-3D41DE23-ED6B-4AF1-BC7F-4EFA1D25E86C
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ald85
Highly Voted 3 years, 7 months agoAlejandrrro
3 years agoIOracle
Highly Voted 3 years, 6 months ago_gio_
Most Recent 6 months, 1 week agoScottL
9 months, 1 week agohilaire
1 year, 1 month agoflaviogcmelo
1 year, 4 months agoPatrick9230
1 year, 6 months agoarpz
2 years, 5 months agoObserverPL
2 years, 8 months agoAbdou1968
3 years, 4 months agoSha7
3 years, 7 months ago