1Z0-058 | High value Oracle 1Z0-058 exam question
Q61. Which three statements are true about the logging or tracing of Java-based Oracle tools?
A. By default, Oracle logs actions for DBCA and DBUA.
B. For tools such as SRVCTL and CLUVFY, tracing can be enabled by setting srvm trace = true your shell environment before executing the commands.
C. The srvm_trace environment variable can be set only in the user's shell environment file.
D. To disable tracing for Java-based tools, unset the srvm_trace variable: export srvm_trace=
Answer: A,B,D
Explanation: Enabling Tracing for Java-Based Tools and Utilities in Oracle RAC
All Java-based tools and utilities that are available in Oracle RAC are called by executing scripts of the same name as the tool or utility. This includes the Cluster Verification Utility (CVU), Database Configuration Assistant (DBCA), the Net Configuration Assistant (NETCA), Server Control Utility (SRVCTL), and the Global Services Daemon (GSD). For example to run DBCA, enter the command dbca. By default, Oracle Database enables traces for DBCA and the Database Upgrade Assistant (DBUA). For the CVU, GSDCTL, and SRVCTL, you can set the SRVM_TRACE environment variable to TRUE to make Oracle Database generate traces. Oracle Database writes traces to log files. For example, Oracle Database writes traces to log files in Oracle home/cfgtoollogs/dbca and Oracle home/cfgtoollogs/dbua for DBCA and DBUA, respectively.
Oracle. Real Application Clusters Administration and Deployment Guide
Q62. Which three steps must be completed to configure Fast Connection Failover for the CRM service with an Oracle Call Interface client?
A. Ensure that the CRM service has Advanced Queuing notifications enabled by setting the services values of AQ_HA_NOTIFICATIONS to TRUE.
For example:
$ srvctl modify service -d crm -s gl.us.oracle. com
-q TRUE -P BASIC -e SELECT -z 180 -w 5 -j LONG
B. Enable OCI_EVEINTS on the client at environment creation time by using the
OCIEnvCreate(…) function.
C. Use Oracle Call Interface to configure UP events for the service.
D. Client applications must be linked with the client thread or operating system library.
Answer: A,B,D
Explanation:
Configuring FCF for OCI Clients OCI applications must connect to an Oracle RAC instance to enable HA event notification. Furthermore, these applications must perform the following steps to configure FCF for an OCI client: Configure the service for your OCI connection pool to enable connection load balancing and runtime connection load balancing. Also configure the service to have Advanced Queuing notifications enabled, as shown in the following example: $ srvctl modify service -d crm -s ociapp.example.com -q TRUE -B THROUGHPUT -j LONG Set the context of the environment for OCI calls on the client to enable subscriptions by using the OCIEnvCreate() call, setting the MODE parameter value to OCI_EVENTS, as follows: (void) OCIEnvCreate(&myenvhp, OCI_EVENTS|OCI_OBJECT, ...); Link the application with a thread library. After linking with the thread library, the applications can register a callback that is invoked whenever a FAN event occurs.
Oracle. Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)
Q63. Which three statements are true about the management of Oracle Services?
A. To manage workloads or a group of applications, you can define services for a particular application or a subset of an application's operations.
B. Similar work can be categorized under services to ease workload management.
C. Users who share a service should have different service-level requirements.
D. Oracle Enterprise Manager or SRVCTL should be used to control cluster-managed services, not DBMS_SERVICE.
Answer: A,B,D
Explanation: Using Oracle Services
To manage workloads or a group of applications, you can define services that you assign to a particular application or to a subset of an application's operations. You can also group work by type under services. For example, online users can use one service, while batch processing can use another and reporting can use yet another service to connect to the database. Oracle recommends that all users who share a service have the same service level requirements. You can define specific characteristics for services and each service can represent a separate unit of work. There are many options that you can take advantage of when using services. Although you do not have to implement these options, using them helps optimize application performance.
Oracle does not recommend using the DBMS_SERVICE package for use with services used by an Oracle RAC database. Use SRVCTL or Oracle Enterprise Manager to create database services for Oracle RAC.
Oracle Real Application Clusters Administration and Deployment Guide
Q64. 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 <grid_home>/log/<hostname>/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.
Answer: B,C,D
Explanation:
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 <grid_home>/log/<hostname>/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
Q65. A policy-managed RAC database that hosts the ACCOUNTS service has only three instances running rather than the usual four on a six-node cluster.
Five of the six cluster nodes are active and the sixth (RACNODE6) is down for maintenance.
You decide to check the state of the servers in the server pools to see if there are problems with the OLTP pool to which the ACCOUNTS service has been assigned.
You used the crsctl status server-f command and see that the RACNODE3 node has STATE=VISIBLE.
What is true about this situation?
A. The Cluster Synchronization Services Daemon (cssd) is running and RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (crsd) is currently not running.
B. Both the Cluster Ready Services Daemon (crsd) and the Cluster Synchronization Service Daemon (cssd) are running on RACNODE3, but RACNODE3 is currently being moved to another server pool.
C. The Cluster Ready Services Daemon (crsd) is running and RACNODE3 is considered to be a part of the cluster, but the Cluster Synchronization Services Daemon (cssd) is currently not running.
D. Neither the Cluster Ready Services Daemon (crsd) nor the Cluster Synchronization Services Daemon (cssd) is running on RACNODE3.
Answer: A
Explanation: Cluster Synchronization Service daemon (CSSD)
An Oracle Clusterware component that discovers and tracks the membership state of each node by providing a common view of membership across the cluster. CSS also monitors process health, specifically the health of the database instance. The Global Enqueue Service Monitor (LMON), a background process that monitors the health of the cluster database environment and registers and de-registers from CSS.
Cluster Ready Services Daemon (CRSD)
The primary Oracle Clusterware process that performs high availability recovery and management operations, such as maintaining OCR. Also manages application resources and runs as root user (or by a user in the admin group on Mac OS X-based systems) and restarts automatically upon failure
STATE=VISIBLE
Servers that have Oracle Clusterware running, but not the Cluster Ready Services daemon (crsd), are put into the VISIBLE state. This usually indicates an intermittent issue or failure and Oracle Clusterware trying to recover (restart) the daemon. Oracle Clusterware cannot manage resources on servers while the servers are in this state.
Oracle Clusterware Administration and Deployment Guide
Q66. Which three statements are true about Clusterware resource debugging?
A. The crsctl command can be used to set debugging for Clusterware resources by using the following syntax:
crsctl set log resource "resource_name:logging_level".
B. Enabling logging for Clusterware resources can negatively affect cluster performance, so it should be used only when required.
C. After collecting debugging data for a specific Clusterware resource, terminate the collection of debugging data by issuing the crsctl set log resource "resource_name:stop" command.
D. Although the crsctl command can be used to dynamically affect logging for Clusterware resources, you can also configure resource debugging automatically by specifying a logging_ievel clause in the Grid_Home/log/hostname/admin/clscfg.ini file.
E. Debugging cannot be set for user-defined resources.
Answer: A,B,D Explanation:
Enabling Resource Debugging
Change the USR_ORA_DEBUG resource attribute to 1 for specific resources:
# crsctl set log res "ora.host01.vip:1"
After you capture all trace information, change the debug attribute back to 0:
# crsctl set log res "ora.host01.vip:0"
You can use an initialization file to configure debugging.
The initialization file name includes the name of the process that you are debugging (process_name.ini).
The file is located in the <Grid_Home>/log/host_name/admin/ directory.
Oracle Support may request that you enable tracing to capture additional information for problem resolution with Oracle Clusterware resources. Because the procedures described here may affect performance, perform these activities only with the assistance of Oracle Support.
The initialization file name includes the name of the process that you are debugging
(process_name.ini). The file is located in the <Grid_Home>/log/host_name/admin/ directory. For example, the name for the CLSCFG debugging initialization file on node1 would be: <Grid_Home>/log/node1/admin/clscfg.ini
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 6 - 13
Q67. 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=<(RACNODES -VI P, RACNODE6-VIP)
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 >
Answer: C
Explanation:
. Navigate to the Grid_home/oui/bin directory on node1 and run the addNode.sh script using 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_VIRTUAL_
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
Q68. During the installation of Oracle Grid Infrastructure 11.2, it is possible to incorporate failure isolation support by using Intelligent Platform Management Interface (IPMI).
Which four statements regarding IPMI configuration are true?
A. Each cluster member node requires a Baseboard Management Controller (BMC), which runs a firmware compatible with IPMI version 1.5.
B. The ethernet port on each cluster node used by BMC must be connected to the IPMI management network.
C. Each node in the cluster must have an IPMI driver installed.
D. The cluster requires a dedicated network specifically for IPMI.
E. If you intend to use IPMI, you must provide an administration account username and password when prompted during installation.
Answer: A,B,C,E
Explanation:
2.13.1 Requirements for Enabling IPMI You must have the following hardware and software configured to enable cluster nodes to be managed with IPMI:
Each cluster member node requires a Baseboard Management Controller (BMC) running firmware compatible with IPMI version 1.5 or greater, which supports IPMI over LANs, and configured for remote control using LAN.
Each cluster member node requires an IPMI driver installed on each node.
The cluster requires a management network for IPMI. This can be a shared network, but Oracle recommends that you configure a dedicated network.
Each cluster member node's Ethernet port used by BMC must be connected to the
IPMI management network.
Each cluster member must be connected to the management network.
Some server platforms put their network interfaces into a power saving mode when they are powered off. In this case, they may operate only at a lower link speed (for example, 100 MB, instead of 1 GB). For these platforms, the network switch port to which the BMC is connected must be able to auto-negotiate down to the lower speed, or IPMI will not function properly.
Have IPMI Configuration completed and have IPMI administrator account information If you intend to use IPMI, then ensure BMC interfaces are configured, and have an administration account username and password to provide when prompted during installation. For nonstandard installations, if you must change configuration on one or more nodes after installation (for example, if you have different administrator usernames and passwords for BMC interfaces on cluster nodes), then decide if you want to reconfigure the BMC interface, or modify IPMI administrator account information after installation. Oracle. Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Linux
Q69. You are managing a three-instance policy-managed RAC database PROD. You created a service called GL for the PROD database by using the following command:
[oracIe@gr7597~]$ srvctl add service -d PROD -s GL -g SP1 -c singleton -y manual Examine the following output: [oracIe@gr7597~]$ srvctl config database -d PROD -a Database unique name: PROD Database name: PROD Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracle Spfile: +DATA/PROD/spfileRACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: SP1 Database instances: Disk Groups: DATA, FRA Services: Database is enabled Database is policy managed [oracIe@gr7597~]$ crsctl stat res ora.PROD.db NAME=ora.PROD.db TYPE=cluster_resource TARGET=ONLINE STATE=ONLINE on gr7597 ONLINE on gr7602 ONLINE on gr7633 [oracIe@gr7597~]$ crsctl stat serverpool ora.SP1
NAME=ora.SP1
ACTIVE_SERVERS=gr7597 gr7602 gr7633
[oracle.gr7597-]$ crsctl stat res ora.prod.gl.svc
NAME=ora.prod.gl.svc
TYFE=ora.service.type
TARGET=ONLINE
STATE=ONLINE on gr7597
Which three steps are required to enable ODP.NET clients that connect to the GL service to receive FAN High Availability Events?
A. Enable Advanced Queuing notifications by using SRVCTL as shown in the following
command: $ srvctl modify service -d prod -s gl -q TRUE -j LONG
B. Execute the following statement for the users that will be connecting by way of the .Net
Application, where user_name is the user name:
EXECUTE DBMS_AQADM.GRANT_QUEUE_PRIVILEGE( 'DEQUEUE', '
SYS.SYS$SERVICE_METRICS',
user_name ) ;
C. Enable Transparent Application Failover (TAF), either on the client or for the service.
D. Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN
High Availability events. Do this by setting the HA events connection string attribute to true
at connection time.
E. Link client applications with the client thread or operating system library.
Answer: A,B,D
Explanation:
Enabling ODP.NET Clients to Receive FAN High Availability Events Perform the following steps to enable FAN for ODP.NET clients: Enable Advanced Queuing notifications for a service by using SRVCTL as shown in the following example: srvctl modify service -d crm -s odpnet.example.com -q TRUE Grant permissions on the internal event queue table by executing the following command for the users that will be connecting by way of the ODP.NET application, where user_name is the database user name: EXECUTE DBMS_AQADM.GRANT_QUEUE_PRIVILEGE('DEQUEUE','SYS.SYS$SERVICE_METRI CS', user_name);
Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN high availability events. To enable FCF, include "HA Events=true" and "pooling=true" (the default value) in the connection string, as shown in the following example where user_name is the name of the database user and password is the password for that user:
con.ConnectionString =
"User Id=user_name;Password=password;Data Source=odpnet;" +
"Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;" +
"HA Events=true;Incr Pool Size=5;Decr Pool Size=2";
Oracle. Real Application Clusters Administration and Deployment Guide
11g Release 2 (11.2)
Q70. The disk groups on the current ASM instance at version 11.2 were configured to support a version 10.2 database instance. The 10.2 instance has the COMPATIBLE parameter defined as 10.2.0. The compatible.asm attribute is set to 11.2 for each disk group. The database has been upgraded to 11.2. Which statement indicates the proper time to change the compatible.rdbms disk group attribute to 11.2?
A. Change the disk group attribute after the database instance COMPATIBLE parameter is upgraded to 11.2.
B. Change the disk group attribute after the database instance is started with the 11.2 software.
C. Change the disk group attribute after the database instance optimizer_features_enabled parameter is set to 11.2.
D. Change each disk group after the 11.2 features are required for use on the disk group.
E. Never, upgrading the attribute is not reversible.
Answer: A
Explanation:
COMPATIBLE.RDBMS The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
Oracle. Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)