Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration
Question No: 81
Which four statements about mounting ASM cluster file systems are true?
An ACFS volume can be mounted by using ASMCA.
The standard Linux/UNIX mount command can be used to mount an ACFS volume, provided the ACFS type is specified; (mount -t acfs).
ACFS volumes can be mounted by using the ASMCMD utility.
The acfsmountvol command can be used to mount ACFS volumes on Windows platforms.
Oracle Enterprise Manager can be used to mount ACFS volumes.
Answer: A,B,D,E Explanation:
->Oracle ASM Configuration Assistant enables you to create or configure an Oracle
ACFS file system. Some commands require root privileges, such as mounting a file system. Oracle ASM Configuration Assistant generates the command for you to run manually as root or as a privileged user.
There are buttons for Create, Show Mount All, and Show Dismount All commands
->mount attaches a file system to the Oracle ACFS hierarchy at the mount point that is the name of a directory. The mount happens on the node where the mount command was issued. The mount command returns an error if the file system is not in a dismounted state on this node
root privilege is required to run mount.
->acfsmountvol attaches an Oracle ACFS to the file system hierarchy at the specified path name or drive letter. dir must be an empty directory. Oracle ACFS mount points can be created on any empty directory and they can be hierarchical (nested).
Windows Administrator privileges are required to mount an Oracle ACFS
->ASM Cluster File System tab in Oracle Enterprise Manager. This tab lists all of the Oracle ACFS associated with the Oracle ASM instance.
On this page, you can choose to mount, dismount, delete, create snapshot, view content, register, and deregister a selected file system. In addition, you can create a file system, mount all file systems, or dismount all file systems.
Oracle庐 Automatic Storage Management Administrator#39;s Guide
Question No: 82
Which interconnect design is NOT supported for Oracle Clusterware?
crossover cable design
single switch design
multiple switch design
redundant interconnect design
Answer: A Explanation:
2.7.1 Network Hardware Requirements
For the private network, the interface must support the user datagram protocol (UDP) using high-speed network adapters and switches that support TCP/IP (minimum requirement 1 Gigabit Ethernet).
UDP is the default interface protocol for Oracle RAC, and TCP is the interconnect protocol for Oracle Clusterware. You must use a switch for the interconnect. Oracle recommends that you use a dedicated switch.
Oracle does not support token-rings or crossover cables for the interconnect. Oracle庐 Grid Infrastructure Installation Guide
11g Release 2 (11.2)
Question No: 83
After Oracle Grid Infrastructure has been installed, you should take a few moments to verify the installation. Which two actions would be useful in verifying the installation?
Run the crsctl status resource -t command to confirm that all necessary cluster resources are online.
Use the operating system utilities to verify that your SCAN addresses are being properly
Start Oracle Enterprise Manager and check all monitored targets.
Run the cluvfy comp nodecon -n all -verbose command to verify the entire Grid Infrastructure installation.
Answer: A,B Explanation:
Verifying the Grid Infrastructure Installation
Execute the crsctl command as shown in the slide to confirm that all cluster resources are up and running.
root@racnode01 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t
In addition, you should confirm that your DNS is properly forwarding address requests for your application and SCAN VIPs to your GNS and that they are resolved properly. You can do this with dig. Execute the dig command with DNS and VIP addresses as shown:
# dig @myDNS.example.com racnode01-cluster01.example.com
;; QUESTION SECTION:
;racnode01-vip.cluster01.example.com. IN A
;; ANSWER SECTION:
racnode01-vip.cluster01.example.com. 120 IN A 192.0.2.103
# dig @myDNS.example.com cluster01-scan.cluster01.example.com
;; QUESTION SECTION:
;cluster01-scan.cluster01.example.com. IN A
;; ANSWER SECTION:
cluster01-scan.cluster01.example.com. 120 IN A 192.0.2.248
cluster01-scan.cluster01.example.com. 120 IN A 192.0.2.253
cluster01-scan.cluster01.example.com. 120 IN A 192.0.2.254 D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 2 – 44
Question No: 84
You are managing RAC database with policy managed services. The database is started by using an SPILE.
Which two statements are true regarding initialization parameters In a RAC environment?
All initialization parameters must have identical settings on all instances.
All instances in the cluster database use the same SPFILE.
To change values for initialization parameters for an instance, you must log in to that instance.
All initialization parameters for all instances can be changed from any instance In a RAC database.
Answer: B,D Explanation:
RAC Initialization Parameter Files
An SPFILE is created if you use the DBCA.
The SPFILE must be created in an ASM disk group or a cluster file system file. All instances use the same SPFILE.
If the database is created manually, create an SPFILE from a PFILE.
SPFILE Parameter Values and RAC
You can change parameter settings using the ALTER SYSTEM SET command from any instance
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 12 – 22, 23
Question No: 85
You have created four top-level server pools called OLTP, BATCH, DSS, and support for a policy-managed, eight-node cluster. The OLTP pool has two child pools called OLTP_CHILD1 and OLTP_CHILD2. Which two statements are true about sharing servers among the various server pools on your cluster?
Servers are never shared and are always mutually exclusive between top-level server pools.
Use the exclusive_pools attribute to prevent servers being shared between top-level server pools.
Use the exclusive_pools attribute to prevent servers being shared between OLTP_CHILD1 and OLTP_CHILD2 .
Use the exclusive_pools attribute to prevent servers being shared between batch, dss,
support, oltp_childi, and OLTP_CHILD2.
Servers are never shared and are always mutually exclusive between top-level server pools and between sibling child pool.
Explanation: Top-level server pools:
->Logically divide the cluster
->Are always exclusive, meaning that one server can only reside in one particular server pool at a certain point in time
This optional attribute indicates if servers assigned to this server pool are shared with other server pools. A server pool can explicitly state that it is exclusive of any other server pool that has the same value for this attribute. Two or more server pools are mutually exclusive when the sets of servers assigned to them do not have a single server in common. For example, server pools A and B must be exclusive if they both set the value of this attribute to foo_A_B.
Top-level server pools are mutually exclusive, by default.
Question No: 86
Which three programs or utilities can be used to convert a single-instance database to a Real Application Cluster database?
the SRVCTL utility
the RCONFIG utility
the CRSCTLl utility
Answer: A,C,D Explanation:
Single Instance to RAC Conversion
Single-instance databases can be converted to RAC using:
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated
Question No: 87
Which three statements are true about ASM dynamic volume manager (ADVM)?
ADVM provides volume management services and a standard disk device driver interface to file system drivers.
The administrator can use ADVM to create volumes that contain bootable vendor operating systems.
File systems and other disk-based applications issue I/O requests to ADVM volume devices as they would to other storage devices on a vendor operating system.
ADVM extends ASM by providing a disk driver interface to storage backed by an ASM volume.
To use the ADVM driver, the oraclesacfs, oradeoks, and oracleadvm drivers must be loaded, but an ASM instance is not required.
Answer: A,C,D Explanation:
At the operating system (OS) level, the ASM instance provides the disk group, which is a logical container for physical disk space. The disk group can hold ASM database files and ASM dynamic volume files. The ASM Dynamic Volume Manager (ADVM) presents the volume device file to the operating system as a block device.
The mkfs utility can be used to create an ASM file system in the volume device file. Four OS kernel modules loaded in the OS provide the data service. On Linux, they are: oracleasm, the ASM module;
oracleadvm, the ASM dynamic volume manager module;
oracleoks, the kernel services module; and oracleacfs, the ASM file system module. These modules provide the ASM Cluster File System, ACFS snapshots, the ADVM, and cluster services.
The ASM volumes are presented to the OS as a device file at /dev/asm/lt;volume namegt;-
ADVM provides volume management services and a standard disk device driver interface to clients. Clients, such as file systems and other disk-based applications, issue I/O requests to ADVM volume devices as they would to other storage devices on a vendor operating system.
ADVM extends ASM by providing a disk driver interface to storage backed by an ASM file. The administrator can use the ADVM to create volumes that contain file systems. These file systems can be used to support files beyond Oracle database files such as executables, report files, trace files, alert logs, and other application data files. With the addition of
ADVM and ACFS, ASM becomes a complete storage solution of user data for both database and non-database file needs. ACFS is intended as a general file system accessible by the standard OS utilities. ACFS can be used in either a single server or a cluster environment.
Note: Oracle ACFS file systems cannot be used for an Oracle base directory or an Oracle grid infrastructure home that contains the software for Oracle Clusterware, ASM, Oracle ACFS, and Oracle ADVM components.
Oracle ACFS file systems cannot be used for an OS root directory or boot directory. ASM volumes serve as containers for storage presented as a block device accessed through ADVM. File systems or user processes can do I/O on this “ASM volume device” just as they would on any other device. To accomplish this, ADVM is configured into the operating system. A volume device is constructed from an ASM file.
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 10 – 3,4,5
Question No: 88
Choose four tools that can be used to create ASM disk groups.
Question No: 89
You want to create an ACFS on an ADVM volume using a shell script and the appropriate command-line utilities. These are the requirements:
The dynamic volume file must use space in the VOLFILE disk group with a size of 500 M and be called prodvol.
The mount point called /acfs already exists.
Which four steps must be performed to achieve this?
As the Grid Infrastructure owner, run mount -t acfs /dev/asm/prodvol-417 /acfs to mount the file system.
As the Grid Infrastructure owner, run asmcmd volinfo -d volfile prodvol to determine the volume information.
As the Grid Infrastructure owner, run asmcmd volcreate -d volfile -s 500M prodvol to create the volume file.
As the Grid Infrastructure owner, run mkfs -t acfs /dev/asm/prodvol-417 to create the file system.
As root, run mount -t acfs /dev/asm/prodvol-417 /acfs to mount the file system.
As root, run mkfs -t acfs /dev/asm/prodvol-417 to create the file system.
Answer: B,C,E,F Explanation:
Creating an ACFS Volume Create the volume:
$ asmcmd volcreate -G DATA -s 100M testvol
View the volume information:
$ asmcmd volinfo -G DATA testvol
Make a mount point directory:
$ mkdir /u01/app/oracle/acfsdata/testvol
Make the file system (as root):
# mkfs -t acfs /dev/asm/testvol-403
Mount the file system to the mount point:
# mount -t acfs /dev/asm/testvol-403 \
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 10 – 13 Create a file system with the Oracle ACFS mkfs command.
Create a file system using an existing volume device.
$ /sbin/mkfs -t acfs /dev/asm/volume1-123 mkfs.acfs: version = 22.214.171.124.0.0 mkfs.acfs: on-disk version = 39.0
mkfs.acfs: volume = /dev/asm/volume1-123 mkfs.acfs: volume size = 10737418240 mkfs.acfs: Format complete.
See quot;mkfsquot; (Linux or UNIX) or quot;acfsformatquot; (Windows). The root privilege is not required. The ownership of the volume device file dictates who can run this command.
Oracle庐 Automatic Storage Management Administrator#39;s Guide 11g Release 2 (11.2)
Question No: 90
Identify the three valid storage options for Grid Infrastructure voting disk and Install.
a certified Cluster File System (CFS)
a certified Network File System (NFS)
ASM Cluster File System (ACFS)
Automatic Storage Management (ASM)
shared disk slices (block or raw devices)
Answer: A,B,D Explanation: