Oracle Real Application Clusters 11g Essentials v6.2 (1z0-593)

Page:    1 / 6   
Total 82 questions

Which option should you use to find out if the Oracle Inventory directory exists in a
Linux/UNIX environment?

  • A. # show /etc/oraInst.loc
  • B. # more /etc/oraInst.loc
  • C. # more /etc/oraInst
  • D. # more oraInst.loc

Answer : B

Explanation: When you install Oracle software on the system for the first time, the Installer creates the oraInst.loc file. This file identifies the name of the Oracle Inventory group and the path of the Oracle Inventory directory. To determine whether the Oracle Inventory group exists, enter the following command:
# more /etc/oraInst.loc

ASMLIB is__________.

  • A. Used to enhance disk I/O performance
  • B. Used to prevent problems with persistant names and permissions after a Linux reboot.
  • C. A requirement that manages ASM disks
  • D. Used to provide mirroring for ASM disk groups

Answer : A

Explanation: ASMLib is an optional support library for the Automatic Storage Management feature of the Oracle Database. Automatic Storage Management (ASM) simplifies database administration and greatly reduces kernel resource usage (e.g. the number of open file descriptors). It eliminates the need for the DBA to directly manage potentially thousands of Oracle database files, requiring only the management of groups of disks allocated to the Oracle Database. ASMLib allows an Oracle Database using ASM more efficient and capable access to the disk groups it is using.

Reference: Oracle ASMLib -

How many OCR locations are allocated if you choose an ASM diskgroup using external redundancy?

  • A. 1
  • B. 2
  • C. 3
  • D. You cannot use external redundancy for OCR files.

Answer : A

* Oracle Cluster Registry (OCR)
* External redundancy
Oracle ASM does not provide mirroring redundancy and relies on the storage system to provide RAID functionality. Any write error causes a forced dismount of the disk group. All disks must be located to successfully mount the disk group.

Which two statements about ASM paths and file names are correct?

  • A. Absolute paths must begin from the root directory of the server.
  • B. Relative paths start from the Grid Infrastructure home directory.
  • C. When an Oracle ASM file is created with an alias file name, you can access the file with either name.
  • D. Absolute paths can access a file or directory regardless of the current directory.

Answer : C,D

Explanation: C: Alias names, or aliases, are intended to provide a more user-friendly means of referring to Oracle ASM files, rather than using the system-generated filenames.
You can create an alias for a file when you create it in the database, or you can add an alias to an existing file using the ADD ALIAS clause of the ALTER DISKGROUP statement.
You can create an alias in any system-generated or user-created Oracle ASM directory. An alias must include the disk group name; you cannot create an alias at the root level (+).

You are beginning the Installation of an Oracle Database, 11g Release 1. The OUI detects that you are installing onto a cluster. Which two choices does it give you?

  • A. The ability to install a single node non cluster Installation on the local node
  • B. The ability to select the nodes to install the RAC enabled Oracle database software
  • C. the ability to install clusterware
  • D. The ability to install RAC on some nodes and a single instance Oracle database on others

Answer : A,B

Explanation: A: On the Select Database Management Option page, if you have already completed the Grid Control Management Agent installation, then you can select either Grid or Local Database control. Otherwise, only Local Database control for database management is supported for Oracle RAC.
B: You can install Oracle RAC One Node on two or more nodes in the cluster. An Oracle
RAC One Node installation starts up an instance on one of the nodes you select as an
Oracle RAC One Node pool member. If that instance goes down, then the Oracle RAC One
Node instance is started up on another pool member using Online Database Relocation.
This feature migrates database instances and connections to other cluster nodes for high availability.
When you run OUI, you can select the Typical or the Advanced Install type.
The Typical install type installs a default configuration of Oracle Database, with basic configuration choices. Oracle recommends that most users select Typical as their installation type.
The Advanced installation type is for customized installations, and should be used only when you have a specific requirement for it, such as requiring different passwords for the
SYS, SYSMAN, SYSTEM and DBSNMP accounts, or using a different database character set than is in use on your servers, changing product languages, or other nonstandard configuration

Choose two options that are not suitable for shared storage in a RAC 11g Release 2 database created using DBCA.

  • A. Block device
  • B. Raw device
  • C. ASM
  • D. CFS

Answer : A,B

Explanation: Before you use DBCA to convert a single-instance database to an Oracle
RAC or an Oracle RAC One Node database, ensure that your system meets the following conditions:
/ It is a supported hardware and operating system software configuration.
/ It has shared storage: either Oracle Cluster File System (CFS) (not D) or Oracle ASM (not
C) is available and accessible from all nodes. On Linux on POWER systems, ensure that
GPFS is available and accessible from all nodes.
/ Your applications have no design characteristics that preclude their use with cluster database processing.
* DBCA (Database Configuration Assistant) is a utility used for creating, configuring and removing Oracle Databases.
Reference: Creating Oracle Real Application Clusters Databases with Database

Configuration Assistant -
Reference: Converting to Oracle RAC and Oracle RAC One Node with DBCA

What is the difference between running the CVU in stage mode and component mode?

  • A. Stage mode checks all nodes automatically.
  • B. Component mode is used for an individual node prior to Installation.
  • C. Component mode requires a list of nodes, whereas stage mode does not.
  • D. Component mode is designed to be run after a database is installed with RAC and is active

Answer : D

D (not B): Use component mode to diagnose components after ClusterWare installation.

Not A, C: Examples of syntax -
/ cluvfy stage -pre acfscfg -n node_list [-asmdev asm_device_list] [-verbose]
* The Cluster Verification Utility (CVU or cluvfy)
* Use stage mode during installation/upgrade

Multipathing software_________.

  • A. cannot improve system availability
  • B. cannot improve system performance
  • C. is inherently built into all storage products
  • D. is supported by ASM

Answer : D

Explanation: Although ASM is not designed with multipathing functionality, ASM does operate with multipathing technologies. Multipathing technologies are available from many sources. Storage vendors offer multipathing products to support their specific storage products, while software vendors usually develop multipathing products to support several server platforms and storage.
* Multipathing solutions provide failover by using redundant physical path components.
These components include adapters, cables, and switches that reside between the server and the storage subsystem. If one or more of these components fails, then applications can still access their data, eliminating a single point of failure with the Storage Area Network
(SAN), Host Bus Adapter, interface cable, or host port on a multiported storage array.
Reference: Oracle Database Storage Administrator's Guide, ASM and Multipathing

Which three statements about mounting ASM cluster file systems are true?

  • A. You can mount ACFS volumes with Oracle Enterprise Manager.
  • B. You can mount ACFS volumes on Windows platforms by using the acfsmountvol command.
  • C. You can mount ACFS volumes with the ASMCMD utility.
  • D. You can mount an ACFS volume with the standard Linux/UNIX mount command (only if the ACFS type is specified).
  • E. You cannot mount an ACFS volume with ASMCA.

Answer : A,B,D

Explanation: A: Log in to OEM, scroll to the bottom of the home page, then click on one of the ASM instances listed. On the resulting ASM screen, click on the "ASM Cluster File
System" tab. You are then presented with the following screen. Click the "Create" button.
Click the "Create ASM Volume" button.
Enter the Volume Name and Size and click the "OK" button. Wait for the volume to be created.
B, D: Mount the file system with the Oracle ACFS mount command. You can mount a file system before or after registering the file system. If the file system has been registered, you can wait for the file system to be mounted automatically.
For example:
# /bin/mount -t acfs /dev/asm/volume1-123 /u01/app/acfsmounts/myacfs
See "mount" (Linux or UNIX) or "acfsmountvol" (Windows). The root privilege is required run the mount command and the Windows Administrator privilege is required to run the acfsmountvol command.
* Oracle ASM Cluster File System (ACFS) is a general purpose cluster file system implemented as part of ASM.
* ASM Configuration Assistant (ASMCA),
Not E: Probably the easiest interface to use is the ASM Configuration Assistant (ASMCA), but Enterprise Manager does allow you to see all the commands being run to perform each task. The easiest way to learn how to use the command line utilities is to use Enterprise
Manager and click the "Show Command" button each step of the way.
Reference: Accessing an Oracle ACFS File System on a Different Node in the Cluster

Which two actions do you need to take in Oracle Grid Infrastructure 11g Release 2 to enable debugging for the resource

  • A. Make sure you are logged in as a privileged user.
  • B. crsctl debug res
  • C. crsctl set log res
  • D. crsctl debug log res

Answer : A,C

Explanation: A: You can use crsctl commands as the root user to enable dynamic debugging for the Oracle Clusterware Cluster Ready Services (CRS), Oracle Cluster
Registry (OCR), Cluster Synchronization Services (CSS), and the Event Manager (EVM).
C: You can enable debugging for the CRS, OCR, CSS, and EVM modules and their components by setting environment variables or by issuing crsctl debug commands using the following syntax: crsctl debug log module_name component:debugging_level
Reference: Oracle Clusterware Administration and Deployment Guide, Component Level

Debugging -

Which command can be used to stop Oracle Clusterware and Oracle ASM instances on all nodes in the cluster running in Linux/UNIX?

  • A. #emcrsctl stop crs –all
  • B. srvctl stop cluster –all
  • C. #crsctl stop cluster –all
  • D. #crsctl stop crs –d database

Answer : C

Explanation: To stop Oracle Clusterware on all nodes in the cluster, execute the following command on any node: crsctl stop cluster all
Reference: Stopping Oracle Clusterware

Oracle provides Cluster Verification Utility (CVU) to perform system checks in preparation for Installation, patch updates, or other system changes. Select three verification tasks that
CVU can perform.

  • A. Checking the Oracle Clusterware integrity
  • B. Oracle software home verification
  • C. Network connectivity verification
  • D. Storage access verification

Answer : A,C,D

You can perform the following tests using CVU as described under the following topics:
(A) Cluster Verification Utility Oracle Clusterware Component Verifications
To verify the integrity of all of the Oracle Clusterware components, use the component verification comp crs command: cluvfy comp crs [ -n node_list ] [-verbose]
(C) Cluster Verification Utility Connectivity Verifications
To verify the cluster nodes can be reached from the local node or from any other cluster node, use the component verification command nodereach as follows: cluvfy comp nodereach -n node_list [ -srcnode node ] [-verbose]
(D) Cluster Verification Utility Storage Verifications
To verify whether storage is shared among the nodes in your cluster database or to identify all of the storage that is available on the system and can be shared across the cluster nodes, use the component verification command ssa as follows: cluvfy comp ssa [ -n node_list ] [ -s storageID_list ] [-verbose]
Cluster Verification Utility System Requirements Verifications
Cluster Verification Utility User and Permissions Verifications
Cluster Verification Utility Node Comparisons and Verifications
Cluster Verification Utility Installation Verifications
Cluster Verification Utility Cluster Integrity Verifications
Cluster Verification Utility Argument and Option Definitions
Reference: Performing Various CVU Tests

When can a wildcard character be used to change a directory with the ASMCMD CD command?

  • A. Always
  • B. If the wildcard character causes a match to a single directory
  • C. If the wildcard character causes a match to multiple directories
  • D. Never

Answer : B

Explanation: * If a wildcard pattern matches only one directory when using wildcard characters with cd, then cd changes the directory to that destination. If the wildcard pattern matches multiple directories, then ASMCMD does not change the directory but instead returns an error.
* The wildcard characters * and % match zero or more characters anywhere within an absolute or relative path, which saves typing of the full directory or file name. The two wildcard characters behave identically. There are various ASMCMD commands that accept wildcards. These include cd, du, find, ls, lsattr, lsdg, lsdsk, lsgrp, lsusr, and rm.
Note: ASMCMD is a command-line utility that you can use to manage Oracle ASM instances, disk groups, file access control for disk groups, files and directories within disk groups, templates for disk groups, and volumes.
You can run the ASMCMD utility in either interactive or noninteractive mode.
Reference: About ASMCMD, Wildcard Characters

List the two granularity levels supported by the Cluster Verification Utility (CVU).

  • A. Component
  • B. Stage
  • C. Composite
  • D. CVU only supports one level; just run it
  • E. Object

Answer : A,B

Explanation: A:
* Use component mode to diagnose components after ClusterWare installation.
* To verify the minimal system requirements on the nodes prior to installing Oracle
Clusterware or Oracle RAC, use the sys component verification command as follows: cluvfy comp sys [ -n node_list ] -p { crs | database } } [-r { 10gR1 | 10gR2 |
11gR1} ] [ -osdba osdba_group ] [ -orainv orainventory_group ] [-verbose]
* * Use stage mode during installation/upgrade
* To verify whether your system meets all of the criteria for an Oracle Clusterware installation, use the -pre crsinst command for the Oracle Clusterware installation stage as follows: cluvfy stage -pre crsinst -n node_list
[ -c ocr_location ] [-r { 10gR1 | 10gR2 | 11gR1} ][ -q voting_disk ]
[ -osdba osdba_group ]
[ -orainv orainventory_group ] [-verbose]

Select two Clusterware administration tasks that must be performed as the root user.

  • A. List the location of the voting disks.
  • B. Check the health and viability of the Clusterware on all nodes.
  • C. Disable the Clusterware from automatic start at node reboot.
  • D. Start the Clusterware manually on one node.
  • E. Check the health of the Clusterware on one node.

Answer : C,D

Page:    1 / 6   
Total 82 questions