Oracle Real Application Clusters 11g Essentials
Question No: 41
What should be the default software location for Oracle Clusterware?
The same directory as the Oracle Database home
Using Oracle RAC 11g Release 1, the Oracle Grid Infrastructure Home
Using Oracle RAC 11g Release 2, the Oracle Grid Infrastructure Home
The root file system
Explanation: * Oracle Clusterware is installed as part of Oracle Database 11g. OUI installs Oracle Clusterware into a directory structure that is referred to as CRS_home. This home is
separate from the home directories of other Oracle software products installed on the same server.
The Oracle RAC database software is installed from the same Oracle Database 11g installation media. By default, the standard Oracle Database 11g software installation process installs the Oracle RAC option when OUI recognizes that you are performing the installation on a cluster. OUI installs Oracle RAC into a directory structure that is referred to as Oracle_home. This home is separate from the home directories of other Oracle software products installed on the same server.
Reference: Installing and Configuring Oracle Clusterware and Oracle RAC
Question No: 42
Which two directories are used during the installation of Grid Infrastructure and Oracle Database (with the RAC option)?
Grid Infrastructure Oracle Home
Explanation: A: The Oracle RAC database software is installed from the same Oracle Database 11g installation media. By default, the standard Oracle Database 11g software installation process installs the Oracle RAC option when OUI recognizes that you are performing the installation on a cluster. OUI installs Oracle RAC into a directory structure that is referred to as Oracle_home. This home is separate from the home directories of other Oracle software products installed on the same server.
The apply patch output is Oracle Interim Patch Installer version 18.104.22.168.0 Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle_grid/product/22.214.171.124/grid Central Inventory : /opt/oracle/oraInventory
from : /oracle_grid/product/126.96.36.199/grid/oraInst.loc
OPatch version : 188.8.131.52.0 OUI version : 184.108.40.206.0
Log file location : /oracle_grid/product/220.127.116.11/grid/cfgtoollogs/opatch/o
Question No: 43
You want to set up your RAC-enabled Database software so that you have the ability to perform rolling software upgrades. Which configuration option must you use?
At least five voting disks in the cluster
At least five copies of the OCR
Use a local home for files for software that will be upgraded
With RAC, you can perform only rolling database and not-software upgrades.
Explanation: Change directory to the Oracle Clusterware home. As root, run the preupdate.sh script on the local node, and on all other nodes in the subset that you intend to upgrade. Use the following command syntax, where clusterware_home is the path to the existing Oracle Clusterware home, and installation_owner is the Oracle Clusterware installation owner:
/preupdate.sh -crshome clusterware_home -crsuser installation_owner Incorrect:
Not D: Both rolling database and rolling clusterware upgrades are possible. Reference: How to Perform Oracle Clusterware Rolling Upgrades
Question No: 44
Which two statements are true for crsctl and srvctl?
crsctl is used to manage resources defined in the OCR
srvctl can manage Clusterware daemons
crsctl is used to manage CSS and CRS
only srvctl can manage nodeapps
srvctl is used to determine the status of Clusterware installation
Answer: C,D Explanation: C:
CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects.
CSS- Cluster Synchronization Services – a daemon process that is used for synchronization between different RAC nodes and synchronization between ASM and Oracle database instances.
CRS – Oracle Clusterware is run by Cluster Ready Services (CRS) D: SRVCTL Node-Level Tasks
The node-level tasks are:
Adding and deleting node level applications.
Setting and unsetting the environment for node-level applications. Administering node applications.
Administering ASM instances.
Starting and stopping a group of programs that includes virtual IP addresses, Listeners, Oracle Notification Services, and Oracle Enterprise Manager agents (for maintenance purposes).
Note: The Server Control (SRVCTL) utility is installed on each node by default. You can use SRVCTL to start and stop the database and instances, manage configuration information, and to move or remove instances and services. You can also use SRVCTL to add services. SRVCTL also manages configuration information.
Some SRVCTL operations store configuration information in the Oracle Cluster Registry (OCR). SRVCTL performs other operations, such as starting and stopping instances, by sending requests to the Oracle Clusterware process (CRSD), which then starts or stops the Oracle Clusterware resources.
Incorrect: Not A:
OCR – Oracle Cluster Registry
Question No: 45
Which two options are checked by the Oracle Universal Installer, when you first install Oracle Software on a system?
if the OFA-compliant path is available
oraInst.loc should exist
that the user running the installation has permissions to write to the designated path
that you are running OUI as a DBA user
Answer: A,B Explanation: A:
When installing an OFA-compliant database using Oracle Universal Installer, ORACLE_BASE is set to /pm/app/oracle by default.
All Oracle products on CD-ROM are OFA-compliant; that is, Oracle Universal Installer places Oracle products in directory locations that follow OFA guidelines
B: Every Oracle software installation has an associated Central Inventory where the details of all the Oracle products installed on a host are registered. The Central Inventory is located in the directory that the inventory pointer file specifies. Each Oracle software installation has its own Central Inventory pointer file that is unknown to another Oracle software installation.
Default Inventory Pointer File Locations
PlatformDefault Inventory Pointer Location Linux LinuxPPC
Solaris SPARC HPUX-IA64 HPUX-PARISC
Windows Windows.X64 Windows.IA64 HKEY_LOCAL_MACHINE/Software/Oracle/inst.loc
Question No: 46
Which two options are valid choices for the ASM configuration file?
Explanation: ASM Configuration files: init.asm
Question No: 47
Why do you need SSH to install Oracle Database with the RAC option on Linux?
To authenticate the installation user
To copy software to other nodes in the cluster
Oracle Clusterware processes require SSH for post-install authentication across nodes
To authenticate the listener process for inter-node communication
Explanation: During the installation of Oracle RAC, OUI needs to copy files to and execute programs on the other nodes in the cluster. In order to allow OUI to do that, you must configure SSH to allow user equivalence. Establishing user equivalence with SSH provides a secure means of copying files and executing programs on other nodes in the cluster without requiring password prompts.
Question No: 48
Which step must you take before restoring from an OCR backup?
Set the proper directory with the -backuploc option
Identify the existing backups with the -backup option
Review the contents of the backup with the ocrdump command
Stop Oracle Clusterware on all nodes
Explanation: For recovering OCR from physical automated backup needs all cluster, RAC instances and RAC database bring down before performing recovery of OCR. Here you can find out command reference for Recovery of OCR from physical backup copy.
$ocrconfig -showbackup $srvctl -stop database -d RACDB (Shutdown all RAC instances and RAC database)
$crsctl stop crs (Shutdown Cluster)
#rm -f /u01/oradata/racdb/OCRFile
#cp /dev/null /u01/oradata/racdb/OCRFile
#chown root /u01/oradata/racdb/OCRFile
#chgrp oinstall /u02/oradata/racdb/OCRFile
#chmod 640 /u01/oradata/racdb/OCRFile
#ocrconfig -restore /u02/apps/crs/cdata/crs/backup00.ocr
$crsctl start crs (After issuing start cluster check status of cluster using #39;crs_stat -t#39;)
$srvctl start database -d RACDB (Start Oracle RAC database and RAC instances) Reference: How to Recover OCR from PHYSICAL Backup?
Question No: 49
Which two storage hardware requirements are correct for Oracle Database 11g Release 2?
Oracle Database home directory needs at least 7.5 GB of disk space.
Oracle Database home directory needs at least 4 GB of disk space.
Grid home directory needs at least 4.5 GB of disk space.
Grid home directory needs at least 1.3 GB of disk space.
(Unix) You need at least 5.5 GB of available disk space for the Grid home directory, which includes both the binary files for Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM) and their associated log files, and at least 4 GB of available disk space for the Oracle Database home directory, or Oracle home directory.
Question No: 50
You want to move a service from one instance to another. Which utility would you use?
Explanation: The Server Control (SRVCTL) utility is installed on each node by default. You can use SRVCTL to start and stop the database and instances, manage configuration information, and to move or remove instances and services. You can also use SRVCTL to add services. SRVCTL also manages configuration information.
Not A: Cluster Verification Utility (CVU)
A tool that verifies a wide range of Oracle RAC components such as shared storage devices, networking configurations, system requirements, Oracle Clusterware, groups, and users.
Not C: CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects.
You can use CRSCTL commands to perform several operations on Oracle Clusterware, such as:
Starting and stopping Oracle Clusterware resources Enabling and disabling Oracle Clusterware daemons
Checking the health of the cluster
Managing resources that represent third-party applications
Integrating Intelligent Platform Management Interface (IPMI) with Oracle Clusterware to provide failure isolation support and to ensure cluster integrity
Debugging Oracle Clusterware components
Not D: The Oracle Interface Configuration Tool (OIFCFG) command-line interface helps you to define and administer network interfaces.