What are two benefits of installing Grid Infrastructure software for a stand-alone server before
installing and creating an Oracle database?
A.
Effectively implements role separation
B.
Enables you to take advantage of Oracle Managed Files.
C.
Automatically registers the database with Oracle Restart.
D.
Helps you to easily upgrade the database from a prior release.
E.
Enables the Installation of Grid Infrastructure files on block or raw devices.
Explanation:
C: To use Oracle ASM or Oracle Restart, you must first install Oracle Grid
Infrastructure
for a standalone server before you install and create the database. Otherwise, you must
manually register the database with Oracle Restart.
E:*Oracle ASM is Oracle’s recommended storage management solution that provides an alternative
to conventional volume managers, file systems, and raw devices.
*The Oracle Grid Infrastructure for a standalone server provides the infrastructure to
include your single-instance database in an enterprise grid architecture. Oracle
Database 12c combines these infrastructure products into one software installation
called the Oracle Grid Infrastructure home. On a single-instance database, the Oracle
Grid Infrastructure home includes Oracle Restart and Oracle Automatic Storage
Management (Oracle ASM) software.
Reference: Oracle Grid Infrastructure for a Standalone Server, Oracle Database, Installation
Guide, 12c
Not B. OMF is not a benefit of GI
Not E. With the release of Oracle Database and Oracle RAC 11g release 2 (11.2), using Database Configuration Assistant or the installer to store Oracle Clusterware or Oracle Database files on block or raw devices is not supported.
So me for AE. Any idea?
Sorry definitely AC!
You guys mis-read the question. it is “Grid Infrastructure software for a stand-alone” not just any grid infrastructure.
“Grid Infrastructure software for a stand-alone” includes ASM.
E is correct – Grid Infrastructure for a stand alone server includes ASM binary.
“Oracle Grid Infrastructure for a standalone server includes Oracle Restart and Oracle Automatic Storage Management. Oracle combined the two infrastructure products into a single set of binaries that is installed into an Oracle Restart home.”
http://docs.oracle.com/cd/E16655_01/install.121/e17735/oraclerestart.htm#NTDBI999
configuring ASM of raw device is under same chapter.
So the answer is C and E.
“E. Installation of Grid Infrastructure files on block or raw devices”
Raw Devices for Database Files on ASM, but not for GI files on raw devices.
CE
C and E
C. Automatically registers the database with Oracle Restart.
E. Enables the Installation of Grid Infrastructure files on block or raw devices.
E – is wrong, not enables Installation GI files in ASM on block or raw devices, but files Oracle Database is true.
implements role separation with two users oracle and grid.
Definitely A and C.
agreed, GI files need to be on a file system and cannot reside on raw devices.
Agree with Hindu, A and C.
AC – OK
https://docs.oracle.com/database/121/LADBI/usr_grps.htm#LADBI7657
A and C are correct.
E – Grid Infrastructure files on block/raw devices is contradiction to the ASM!
Which answer is correct? Can any one give me latest link of free dumps for the same exam. [email protected].
Thank you
CE
CE
a: never heard of role separation, what is that in relatin to GI?
b. OMF is not GI specific
c. is automatic, yes, not manual
If you want to use Oracle ASM or Oracle Restart, then you must install Oracle Grid Infrastructure for a standalone server before you install and create the database. Otherwise, you must manually register the database with Oracle Restart.
d: is rubbish
e. http://docs.oracle.com/cd/E11882_01/install.112/e47689/oraclerestart.htm#LADBI1212
Oracle Grid Infrastructure for a standalone server is the software that includes Oracle Restart and Oracle ASM
…
Oracle ASM is Oracle’s recommended storage management solution that provides an alternative to conventional volume managers, file systems, and raw devices.
CE
me, Oracle ASM can use raw devices but you can’t install Grid Infrastructure files on it.
From Oracle 11R2 book:
Optional groups (if doing separation of duty across multiple users):
— oper
— asmdba
— asmoper
— asmadmin
One of the required steps is to create the necessary operating system groups and users. The two required operating system groups are: oinstall and dba. If you are implementing separation of duty across multiple user accounts then other groups that should be created are: oper, asmdba, asmoper, and asmadmin.
I think this is role separation.
Answers AC
Answer – A,C
•Use of raw or block devices is not supported. You cannot use raw or block devices under Oracle ASM.
https://docs.oracle.com/database/121/CWSOL/storage.htm#CWSOL597
With the release of Oracle Database and Oracle RAC 11g release 2 (11.2), using Database Configuration Assistant or the installer to store Oracle Clusterware or Oracle Database files on block or raw devices is not supported.
If you intend to upgrade an existing Oracle RAC database, or an Oracle RAC database with Oracle ASM instances, then you can use an existing raw or block device partition, and perform a rolling upgrade of your existing installation. Performing a new installation using block or raw devices is not allowed.
AC
C E
Answers : A & C.
A :
The Grid Infrastructure (ASM, cluster and standalone) is owned, controlled and managed by one user and the database installations become clients of the Grid Infrastructure service. The roles within this relationship are managed by operating system group memberships and privileges.
http://www.barada.co.uk/role-separation/
I will go for A,C because “E” does not make any sense. What do GI files need to be installed on block/raw devices. Plus, I have read in many places that use of raw/block devices for ASM is now unsupported starting with 11gR2.
E: Enables the Installation of Grid Infrastructure files on block or raw devices.
AC
AC no doubt. Oracle 12c does not support raw devices anymore
AC
B.
Enables you to take advantage of Oracle Managed Files.
<== means use Oracle product to manage datafiles etc. via asm in grid.
C.
Automatically registers the database with Oracle Restart.
you can use OMF on normal stand-alone oradb, file system setup. Simply launch dbca and see options
role seperation probably means install with different OS user and various OS groups for db/grid
https://docs.oracle.com/database/121/CWSOL/usrgrps.htm#CWSOL763
AC
A, C looks correct.
AC looks correct
We all agree on C – it is correct!.
A vs E is the debate here: Both seem correct but not 100%. I am not perfectly sure which one is the correct but I’d go with A. I will share my thoughts:
A: Role separation refers to the use of SYSDBA,SYSOPER,SYSKM,SYSBACKUP and in our case particularly SYSASM. So is the need of GI installation prior to the db a prerequisite to use SYSASM? I think not as it could be configured afterwards. It would however be more effective if it was implemented from the beggining!
E: The direct use of raw devices in 12c is deprecated. BUT raw devices can be used in ASM and ASM can be used for any use other than clusterware/RAC binaries. So IF ‘installing GI files’ refers to binaries then it is false.
Please provide your feedback if you disagree!