Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 81:

  Which three actions are required to create a general purpose ASM cluster file system (ACFS) to be automatically mounted by Oracle Clusterware?

  A. Format an ASM volume with an ASM cluster file system.
  B. Create mount points on all cluster nodes where the ASM cluster file system will be mounted.
  C. Manually add an entry to /etc/fstab defining the volume, mount point, and mount options on each node in the cluster.
  D. Register the mount point.
  A. Format an ASM volume with an ASM cluster file system.
  B. Create mount points on all cluster nodes where the ASM cluster file system will be mounted.
  D. Register the mount point.

  ---

  File systems that are to be mounted persistently (across reboots) can be registered with the Oracle ACFS mount registry. In cluster configurations, registered Oracle ACFS file systems are automatically mounted by the mount registry, similar to a clusterwide mount table. However, in Oracle Restart configurations the automatic mounting of registered Oracle ACFS file systems is not supported. By default, an Oracle ACFS file system that is inserted into the cluster mount registry is automatically mounted on all cluster members, including cluster members that are added after the registry addition. However, the cluster mount registry also accommodates single-node and multi-node (subset of cluster nodes) file system registrations. The mount registry actions for each cluster member mount only registered file systems that have been designated for mounting on that member. The Oracle ACFS registry resource actions are designed to automatically mount a file system only one time for each Oracle Grid Infrastructure initialization to avoid potential conflicts with administrative actions to dismount a given file system. Oracle Automatic Storage Management Administrator's Guide

• Question 82:

  Examine the following details for a six-Instance RAC database:

  

  What is the most prominent problem indicated by the above output?

  A. high input/output (I/O) delays
  B. CPU saturation and memory depletion
  C. large number of untuned queries from one of the nodes
  D. misconfigured or faulty interconnect
  D. misconfigured or faulty interconnect

  ---

  In Oracle RAC environments, RDBMS gathers global cache work load statistics which are repor- ted in STATSPACK, AWRs and GRID CONTROL. Global cache lost blocks statistics ("gc cr block lost" and/or "gc current block lost") for each

  node in the cluster as well as aggregate stat- istics for the cluster represent a problem or inefficiencies in packet processing for the intercon- nect traffic. These statistics should be monitored and evaluated regularly to guarantee efficient

  interconnect Global Cache and Enqueue Service (GCS/GES) and cluster processing. Any block loss indicates a problem in network packet processing and should be investigated.

  Symptoms:

  Primary:

  "gc cr block lost" / "gc current block lost" in top 5 or significant wait event Secondary:

  SQL traces report multiple gc cr requests / gc current request / gc cr multiblock requests with long and uniform elapsed times Poor application performance / throughput Packet send/receive errors as displayed in ifconfig or vendor supplied

  utility Netstat reports errors/ retransmits/reassembly failures Node failures and node integration failures Abnormal cpu consumption attributed to network processing Changes As explained above, Lost blocks are generally caused by

  unreliable Private network. This can be caused by a bad patch or faulty network configuration or hardware issue.

  Cause

  In most cases, gc block lost has been attributed to (a) A missing OS patch (b) Bad network card (c) Bad cable (d) Bad switch (e) One of the network settings. Oracle Metalink "gc block lost diagnostics [ID 563566.1]"

• Question 83:

  Which three statements are true about using RMAN with ASM?

  A. RMAN is the only supported method to back up database files stored in ASM.
  B. RMAN is the only supported method to back up ACFS files.
  C. RMAN can use ASM storage for backups.
  D. RMAN cannot use ASM storage for backups.
  E. Using RMAN, database files can be migrated to ASM from a file system.
  F. Using RMAN, database files cannot be moved from ASM to a file system
  A. RMAN is the only supported method to back up database files stored in ASM.
  C. RMAN can use ASM storage for backups.
  E. Using RMAN, database files can be migrated to ASM from a file system.

  ---

  RMAN is also critical to Automatic Storage Management (ASM). Since ASM is critical to GRID operations, RMAN is then critical for GRID based systems. In ASM, RMAN is responsible for tracking the ASM filenames and for performing the deletion of obsolete ASM files. ASM files cannot, however, be accessed through normal operating system in- terfaces; therefore, RMAN is the preferred means of copying ASM files. It is also pos- sible to use FTP through XDB, but generally, RMAN will be less complex. It is import- ant to learn to use RMAN first because RMAN is the only method for performing backups of a database containing ASM files. Setting Initialization Parameters for ASM The procedure for creating a duplicate database to an ASM location is similar to the pro- cedure described in "Settings and Restrictions for OMF Initialization Parameters" on page 25-4. The difference is that you must identify the initialization parameters that con- trol the location where files are created and set these parameters to an ASM disk group. For example, set DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_DEST_n,and CONTROL_FILES to +DISK1. To take advantage of Automatic Storage Management (ASM) with an existing database you must migrate that database into ASM. This migration is performed using Recovery Manager (RMAN) even if you are not using RMAN for your primary backup and recov- ery strategy. Oracle?Database Backup and Recovery Advanced User's Guide

• Question 84:

  Which three statements are true about Oracle Clusterware component log files?

  A. Oracle RAC uses a common unified log directory structure to store all Oracle Clusterware component log files.
  B. The consolidated directory structure simplifies diagnostic information collection and assists during data retrieval and problem analysis.
  C. The Clusterware and Database log files are stored under the same unified directory structure.
  D. The location of the log directory structure is /log/.
  E. The log directory structure is the same on UNIX and Linux systems, but different on Windows platforms.
  A. Oracle RAC uses a common unified log directory structure to store all Oracle Clusterware component log files.
  B. The consolidated directory structure simplifies diagnostic information collection and assists during data retrieval and problem analysis.
  D. The location of the log directory structure is /log/.

  ---

  Oracle Clusterware Main Log Files

  Oracle Clusterware uses a unified log directory structure to consolidate the Oracle Clusterware component log files. This consolidated structure simplifies diagnostic information collection and assists during data retrieval and problem analysis.

  The slide shows you the main directories used by Oracle Clusterware to store its log files:

  CRS logs are in /log//crsd/. The crsd.log file is archived every 10 MB (crsd.l01, crsd.l02, ...).

  CSS logs are in Grid_HOME /log//cssd/. The cssd.log file is archived every 20 MB (cssd.l01, cssd.l02, ...).

  EVM logs are in /log//evmd.

  SRVM (srvctl) and OCR (ocrdump, ocrconfig, ocrcheck) logs are in /log//client/ and $ORACLE_HOME/log//client/. Important Oracle Clusterware alerts can be found in alert.log in the

  /log/ directory.

  D60488GC11

  Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 2 - 11

• Question 85:

  Assume that you want to make a connection to the ERP service associated with a newly created RAC database called PROD on a cluster called cluster01 that consists of three nodes: node1, node2, and node3. Which two connect strings are correctly configured to connect to the ERP service?

  A. ERP=(DESCRIPTION = (LOAD_BALANCE=on ) (ADDRESS =(PROTOCOL=TCP)(HOST=cluster01-scan)(PORT=1521)) (CONNECT_DATA= ( SERVICE_NAME=ERP)))
  B. ERP= (DESCRIPTION= (LOAD_BALANCE=on ) (ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=node3-vip)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORCL)))
  C. ERP=(DESCRIPTION= (LOAD_BALANCE=on ) (ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan1)(PORT=1521)) (ADDRESS= (PROTOCOL=TCP)(HOST=cluster01-scan2)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP) (HOST=cluster01-scan3)(PORT=1521)) (CONNECT_DATA=( SERVICE_NAME=ERP)))
  D. url="jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(PORT=1521))) (CONNECT DATA= (SERVICE NAME=ERP)))"
  A. ERP=(DESCRIPTION = (LOAD_BALANCE=on ) (ADDRESS =(PROTOCOL=TCP)(HOST=cluster01-scan)(PORT=1521)) (CONNECT_DATA= ( SERVICE_NAME=ERP)))
  D. url="jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(PORT=1521))) (CONNECT DATA= (SERVICE NAME=ERP)))"

  ---

  Use Services with Client Applications D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 - 11

  

• Question 86:

  Some new non-ASM shared storage has been made available by the storage administrator, and the Oracle Grid Infrastructure administrator decides to move the voting disks, which do not reside in ASM, to this new non-ASM location. How can this be done?

  A. by running crsctl add css votedisk followed by crsctl delete css votedisk
  B. by running crsctl replace css votedisk
  C. by running srvctl replace css votedisk
  D. by running srvctl add css votedisk followed by srvctl delete css votedisk
  A. by running crsctl add css votedisk followed by crsctl delete css votedisk

  ---

  Adding, Deleting, or Migrating Voting Disks

  Modifying voting disks that are stored in Oracle ASM To migrate voting disks from Oracle ASM to an alternative storage device, specify the path to the non-Oracle ASM storage device with which you want to replace the Oracle ASM disk

  group using the following command:

  $ crsctl replace votedisk path_to_voting_disk

  You can run this command on any node in the cluster.

  To replace all voting disks not stored in Oracle ASM with voting disks managed by Oracle ASM in an Oracle

  ASM disk group, run the following command:

  $ crsctl replace votedisk +asm_disk_group

  Modifying voting disks that are not stored on Oracle ASM:

  To add one or more voting disks, run the following command, replacing the path_to_voting_disk variable with one or more space-delimited, complete paths to the voting disks you want to add:

  $ crsctl add css votedisk path_to_voting_disk [...]

  To replace voting disk A with voting disk B, you must add voting disk B, and then delete voting disk A. To add a new disk and remove the existing disk, run the following command, replacing the path_to_voting_diskB variable with the fully

  qualified path name of voting disk B:

  $ crsctl add css votedisk path_to_voting_diskB -purge The -purge option deletes existing voting disks. To remove a voting disk, run the following command, specifying one or more space-delimited, voting disk FUIDs or comma-delimited

  directory paths to the voting disks you want to remove:

  $ crsctl delete css votedisk {FUID | path_to_voting_disk[...]} Oracle?Clusterware Administration and Deployment Guide 11g Release 2 (11.2)

• Question 87:

  You are ready to add two new nodes called RACNODE5 and RACNODE6 to your existing four- node cluster using addNode.sh

  You have run cluvfy -peer to check the new nodes against a reference node. When you originally created the cluster, the network administrators chose to statically define the scan vip addresses in the corporate DNS server, and you installed the Oracle Grid Infrastructure without using GNS.

  What is the correct way to silently add the nodes? r

  A. addNode . sh -silent "CLUSTER_NEW_nodes={ RACNODE5, RACNODEg > "
  B. addNode . sh -silent "CLUSTER_NEW_VIRTUAL_HOSTNAMES=
  C. addNode. sh -silent "CLUSTER_NEW_NODES= { RACNODES, RACNODE6 } " "CLUSTER_NEW_VlRTUAL_HOSTNAMES= RACNODE5-VIP, RACNODE6-VI P > "
  D. addNode.sh -silent -responseFile mynewnodea . txt With the response file containing only E. CLUSTER_NEW_NODES= {"RACNODE5, RACNODE6")
  F. addNode.sh -silent -responseFile mynewnodes . txt With the response file containing only CLUSTER NEW VIRTUAL HOSTNAMES= { " RACNODE3-VI P , RACNODE4 -VI P >
  C. addNode. sh -silent "CLUSTER_NEW_NODES= { RACNODES, RACNODE6 } " "CLUSTER_NEW_VlRTUAL_HOSTNAMES= RACNODE5-VIP, RACNODE6-VI P > "

  ---

  Navigate to the Grid_home/oui/bin directory on node1 and run the addNode.sh script us- ing the following syntax, where node2 is the name of the node that you are adding and node2-vip is the VIP name for the node:

  If you are using Grid Naming Service (GNS):

  $ ./addNode.sh -silent "CLUSTER_NEW_NODES={node2}"

  If you are not using GNS:

  $ ./addNode.sh -silent "CLUSTER_NEW_NODES={node2}" "CLUSTER_NEW_VIR- TUAL_ HOSTNAMES={node2-vip}"

  Alternatively, you can specify the entries in a response file, where file_name is the name of the file, and run the addNode.sh script, as follows:

  $ addNode.sh -silent -responseFile file_name

  When the addNode.sh script completes, a message window displays a list of nodes in the cluster and root scripts that must be run on those nodes. Oracle?Clusterware Administration and Deployment Guide

• Question 88:

  The Oracle Grid Infrastructure administrator wants to perform daily checks on the integrity of the Clusterware files. Which three steps can be performed to determine the health of the OCR files and voting disks?

  A. Run ocrcheck to verify the health of the OCR file only from the master node, which performs all input/ output (I/O) operations on the OCR.
  B. Run grep voting /log//cssd/ocssd.log from any cluster node.
  C. Run cluvfy comp ocr -n all from any cluster node.
  D. Run ocrcheck to verify the health of the OCR file from any cluster node.
  E. Run votecheck to verify the health of the voting disk from any cluster node.
  B. Run grep voting /log//cssd/ocssd.log from any cluster node.
  C. Run cluvfy comp ocr -n all from any cluster node.
  D. Run ocrcheck to verify the health of the OCR file from any cluster node.

  ---

  Checking the Integrity of Oracle Clusterware Configuration Files The following techniques are used to validate the integrity of Oracle Cluster configuration files. Check the ocssd.log for voting disks issues. $ grep voting /log//cssd/ocssd.log Use the cluvfy utility or the ocrcheck command to check the integrity of the OCR. $ cluvfy comp ocr n all -verbose $ ocrcheck

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration

• Question 89:

  Which two statements are true regarding the Active Session History (ASH) reports for RAC?

  A. They provide details about Oracle databases for all current sessions, and history of past session all RAC nodes.
  B. They provide statistics about Oracle databases for the active sessions on all the RAC nodes.
  C. They report on data captured for active sessions. The volume of data is directly related to the work being performed by sessions.
  D. They report on data captured for active sessions. The volume of data is directly related to the number of sessions on the system.
  A. They provide details about Oracle databases for all current sessions, and history of past session all RAC nodes.
  C. They report on data captured for active sessions. The volume of data is directly related to the work being performed by sessions.

  ---

  ASH report statistics provide details about Oracle Database session activity. Oracle Database re- cords information about active sessions for all active Oracle RAC instances and stores this data in the System Global Area (SGA). Any session that is connected to the database and using CPU is considered an active session. The exception to this is sessions that are waiting for an event that belongs to the idle wait class. ASH reports present a manageable set of data by capturing only in- formation about active sessions. The amount of the data is directly related to the work being per- formed, rather than the number of sessions allowed on the system. Oracle Real Application Clusters Administration and Deployment Guide

• Question 90:

  Assuming a RAC database called ORCL, select three statements that correctly demonstrate management actions for the AP service.

  A. To start the AP service, execute: srvctl start service -d ORCL -s AP
  B. To disable the AP service on the ORCL4 instance, execute: srvctl disable service -d ORCL -s AP -i ORCL4
  C. To stop the AP service, execute: srvctl stop service -s AP
  D. To make ORCL5 a preferred instance for the AP service, execute: srvctl set service -d ORCL -s AP -i ORCL5 -r
  E. To relocate the AP service from the ORCL5 instance to the ORCL4 instance, execute: srvctl relocate service -d ORCL -s AP -i ORCL5 -t ORCL4
  A. To start the AP service, execute: srvctl start service -d ORCL -s AP
  B. To disable the AP service on the ORCL4 instance, execute: srvctl disable service -d ORCL -s AP -i ORCL4
  E. To relocate the AP service from the ORCL5 instance to the ORCL4 instance, execute: srvctl relocate service -d ORCL -s AP -i ORCL5 -t ORCL4

  ---

  SRVCTL Command Reference srvctl start service -d db_unique_name [-s "service_name_list" [-n node_name | -i instance_name]] [-o start_options] srvctl disable service -d db_unique_name -s "service_name_list" [-i instance_name | -n node_name] srvctl stop service -d db_unique_name [-s "service_name_list" [-n node_name | -i instance_name] [-f] srvctl relocate service -d db_unique_name -s service_name {-c source_node -n target_node | -i old_instance_name -t new_instance_name} [-f]

  Oracle?Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)