Oracle Database 12c: Installation and Administration — Question 152

You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle
Grid Infrastructure for a standalone server is already installed on the server.
You want to configure job role separation. You create the following operating system users and groups:
- The user oracle as the owner of the Oracle database installation
- The user grid as the owner of Oracle Grid Infrastructure
- The group oinstall as an Oracle Inventory group
- The group dba as the OSDBA group for Oracle database
- The group asmdba as the OSDBA group for Oracle ASM
- The group asmadmin as the administration privileges group for Oracle ASM
- The group asmoper as the group for Oracle ASM
Which two additional tasks should you perform with regard to the OS-level owners and groups? (Choose two.)

Answer options

• A. creating a separate central inventory group for the Oracle Database 12c installation
• B. assigning oinstall as the primary group for the oracle user
• C. assigning asmadmin and asmoper as primary groups for the oracle user
• D. creating OS groups associated with the OSBACKUPDBA, OSDGDBA, and OSKMDBA system privileges
• E. assigning asmdba as the secondary group for the oracle user

Correct answer: B, E

Explanation

Option B is correct because assigning the oinstall group as the primary group for the oracle user ensures that the user has the necessary permissions for installation and software management. Option E is also correct as adding asmdba as a secondary group allows the oracle user to perform tasks related to ASM. The other options either create unnecessary groups or assign groups that do not align with job role separation best practices.