Page: 1
/ 10
Total 144 questions
As part of the preinstatlation process for adding two new nodes to your four-node UNIX cluster, you are in discussions with the OS administrators about the operating system
Installation and setup for the two new nodes called RACNODE5 and RACNODE6.
The nodes have already been connected to the network infrastructure and the administrators are ready for the OS installation. Which two methods fulfill the installation requirements?
- A. Install a new image of the OS, then configure SSH for the root user.
- B. Install a cloned image of the OS that at least matches the existing node images for drivers, patches, and updates.
- C. Install a new image of the OS, that at least matches an existing node for drivers, patches, and updates, and create the necessary OS users and groups with user and group IDs matching those on the existing nodes.
- D. Install a new image of the OS that at least matches the existing node Images for drivers.
- E. Install a new image of the OS, and create the necessary OS users and groups with any user and group IDs.
Answer : B,C
Explanation:
Prerequisite Steps for Adding Cluster Nodes
1. Make physical connections.
Connect the nodes' hardware to the network infrastructure of your cluster. This includes establishing electrical connections, configuring network interconnects, configuring shared disk subsystem connections, and so on. See your hardware vendor documentation for details about this step.
2. Install the operating system.
Install a cloned image of the operating system that matches the operating system on the other nodes in your cluster. This includes installing required service patches, updates, and drivers. See your operating system vendor documentation for details about this process.
Note: Oracle recommends that you use a cloned image. However, if the installation fulfills the installation requirements, then install the operating system according to the vendor documentation.
3. Create Oracle users.
You must create all Oracle users on the new node that exist on the existing nodes. For example, if you are adding a node to a cluster that has two nodes, and those two nodes have different owners for the Grid Infrastructure home and the Oracle home, then you must create those owners on the new node, even if you do not plan to install an Oracle home on the new node.
Oracle Clusterware Administration and Deployment Guide
11g Release 2 (11.2)
You notice that there is a very high percentage of wait time for the gc current split event in your RAC database that has frequent insert operations.
Which two recommendation would you make to reduce this problem?
- A. shorter transactions
- B. using hash partitioned global indexes
- C. uniform and large extent sizes
- D. automatic segment space management
- E. smaller extent sizes
- F. increasing sequence cache sizes
Answer : D,F
You are ready to add two new nodes called RACNODE 5 and RACNODE 6 to your existing four-node cluster by 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?
- A. addNode.sh -silent “CLUSTER_NEW_NODES={RACNODE5, RACNODE6} "
- B. addNode.sh -silent " CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE5-VIP, RACNODE6-VIP} "
- C. addNode.sh -silent CLUSTER_NEW_NODES={RACNODE5, RACNODE6}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE5-VIP, RACNODE6-VIP}"
- D. addNode.sh -silent -responseFile mynewnodes.txt with the response file containing only CLUSTER_NEW_NODES={RACNODE5, RACNODE6} "
- E. addNode.sh -silent -responseFile mynewnodes.txt With the response file containing "CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE3-VIP, RACNODE4-VIP}"
Answer : C
Explanation:
Adding a Cluster Node on Linux and UNIX Systems
If you are not using GNS, run the following command:
$ ./addNode.sh "CLUSTER_NEW_NODES={node3}"
"CLUSTER_NEW_VIRTUAL_HOSTNAMES={node3-
vip}"
Oracle Clusterware Administration and Deployment Guide
11g Release 2 (11.2)
The DBA has executed the command:
srvctl add service -d PROD -s BATCH -g SP2 -c singleton -y manual
What is the result of this command?
- A. Creates a singleton service named batch using the server pool sp2 with a manual service management policy.
- B. Creates a singleton service named batch for the prod database by using only server pool SP2 with a manual service management policy.
- C. Creates a singleton service named batch, which runs by default in the prod database by using the server pool SP2 with a manual service management policy, but can fail over to other databases.
- D. Creates a singleton service, which is only used for batch workloads for the prod database by using only server pool sp2 with a manual service management policy.
Answer : B
Explanation:
srvctl add service
Adds services to a database and assigns them to instances. If you have multiple instances of a cluster database on the same node, then always use only one instance on that node for all of the services that node manages.
Oracle Real Application Clusters Administration and Deployment Guide
11g Release 2 (11.2)
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: oracle@gr7597~]$srvctl add service d PROD -s GL g SP1 -c singleton -y manual
Examine the following output:
(oracle@gr7597~]$srvctl config database -d PROD -a
Database unique name: PROD -
base name: PROD
Oracle home: /u0l/app/oracle/product/11.2.0/dbhome_l cle user: oracle Spfile:
+DATA/PROD/spfil6RACDB.ora
Domain:
Start options: open -
Stop options: immediate -
Database role: PRIMARY -
Management policy: AUTOMATIC -
Server pools: SPl Database instances:
Disk Groups: DATA, FRA -
Services:
Database is enabled Database is policy managed
[oracle@gr?597~]$ crsctl stat res ora.PROD.db
NAME=ora.PROD.db -
TYPE=cluster__resource -
TARGET=ONLlNE -
STATE^ONLINE on gr7597 ONLINE on gr7602 ONLINE on gr7633
[oracle@gr7597~]S crsctl stat serverpool ora.SPl
NAME=ora.SPl -
ACTIVE_SERVERS=gr7S97 gr7 602 gr7633
[oracle@gr7597-JS crsctl NAME=ora.prod.gl.svc
TYPE=ora.service - type -
TARGET=ONLINE -
STATE=ONLlNE on gr7597 -
Which three steps are required to enable ODP.NET clients that connect to the GL services 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.SYSSSERVICE_METRI CS 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: 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_METR
ICS', 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";
Which command will set full debugging for the communications and resource management components of the CRS module on nodes host01 and host03?
- A. srvctl set log -m CRS -c CRSCTI 5, CRSCOMM 5 -m host01,host03
- B. ocrconfig set log CRS "CRSRTI, CRSCOMM: 5" -nodelist host01,host03
- C. crsctl set log CRS "CRSRTI: 5, CRSCOMM: 5" -nodelist host01,host03
- D. crsctl lsmodules crs set log CRSRTX : 5, CRSCOMM: 5 -nodelist host01, host03
Answer : C
Explanation:
Dynamic Debugging -
This section includes the following CRSCTL commands that aid in debugging: crsctl set log
Use the crsctl set log command to set log levels for Oracle Clusterware.
Syntax -
crsctl set log {[crs | css | evm "component_name=log_level, [...]"] |
[all=log_level]}
You can also set log levels for the agents of specific resources, as follows: crsctl set log res "resource_name=log_level, [...]"
Oracle Clusterware Administration and Deployment Guide
11g Release 2 (11.2)
Which three statements are true about cluster (OCR) and local registries (OLR)?
- A. The ocrdump command can be used to dump the contents of either the cluster registry (OCR) or the local registry (OLR).
- B. Information in the OCR is organized by keys that are associated with privileges. Therefore, the root user will see more information when using ocrdump than the grid user.
- C. After the cluster is created, the size of the OCR is static unless the Clusterware software Is upgraded.
- D. The ocrdump command can be used to dump information for a single OCR key.
Answer : A,B,D
Explanation:
-> This section explains how to use the OCRDUMP utility to view OCR and Oracle
Local Registry (OLR) content for troubleshooting. The OCRDUMP utility enables you to view OCR and OLR contents by writing the content to a file or stdout in a readable format.
You can use several options for OCRDUMP. For example, you can limit the output to a key and its descendents. You can also write the contents to an XML file that you can view using a browser. OCRDUMP writes the OCR keys as ASCII strings and values in a data type format. OCRDUMP retrieves header information based on a best effort basis.
Displays OCR content in the terminal window in XML format
directory.
You must run this command as root to be able to view all of the keys.
You have configured your eight-node cluster to use GNS. The network administrator has established delegated subdomain for the Custer which is MYCLUSTER.EXAMPLE.COM.
DHCP has been configured so that the cluster now manages IP addresses within the cluster.
Select three responses that describe the VIPs that will exist in this configuration.
- A. 3 GNS VIPs
- B. 8 Node VIPs
- C. 3 SCAN VIPs
- D. 1 GNS VIP
- E. 3 Node VIPs
Answer : B,C,D
Explanation: Implementing GNS -
If you use GNS, then you must specify a static IP address for the GNS VIP address, and delegate a subdomain to be delegated to that static GNS VIP address.
Dynamic IP address assignment using Oracle Grid Naming Service (GNS)
If you select this option, then network administrators assign static IP address for the physical host name and dynamically allocated IPs for the Oracle Clusterware managed VIP addresses. In this case, IP addresses for the VIPs are assigned by a DHCP and resolved using a multicast domain name server configured as part of Oracle Clusterware within the cluster. If you plan to use GNS, then you must have the following:
-> A DHCP service running on the public network for the cluster
-> Enough addresses on the DHCP to provide 1 IP address for each node's virtual IP, and 3 IP addresses for the cluster used by the Single Client Access Name (SCAN) for the cluster
Your Apache-based application resource called MyApp has a VIP application resource definition and an application resource definition.
The application is administrator managed and is currently active on nodeRACNODE3.
You want to move it to host RACNODE4, which is one of the HOSTING_MEMBERS in the resource definition.
What is the most efficient method to move the application and the VIP?
- A. Run crsctl relocate resource MyApp - n RACNODE4 - f.
- B. Run crsctl stop resource MyApp -n RACNODE3 -f followed by crsctl start MyApp -n RACNODE4 -f.
- C. Run crsctl stop resource MyApp -n RACNODE3 -f followed by crsctl relocate resource MyApp n RACNODE4.
- D. Run crsctl relocate resource MyApp -n RACNODE4.
Answer : A
Explanation:
Relocating Applications and Application Resources
Use the crsctl relocate resource command to relocate applications and application resources. For example, to relocate the Apache Web server application to a server named rac2, run the following command:
# crsctl relocate resource myApache -n rac2
Each time that the action program is called, the crsctl relocate resource command waits for the duration specified by the value of the SCRIPT_TIMEOUT resource attribute to receive notification of success or failure from the action program. A relocation attempt fails if:
The application has required resources that run on the initial server
Applications that require the specified resource run on the initial server
To relocate an application and its required resources, use the -f option with the crsctl relocate resource command. Oracle Clusterware relocates or starts all resources that are required by the application regardless of their state.
Oracle Clusterware Administration and Deployment Guide
11g Release 2 (11.2)
In your two-instance RAC database, you find that FAST_START_MTTR_TARGET is set to
300 on both the nodes. The ESTD_CLUSTER_AVAILABLE_TIME column in the
V$INSTANCE_RECOVERY view shows the value 100.
What is the correct interpretation? (Choose 2)
- A. In the event of an instance failure, the database will become partially available In 100 seconds.
- B. In the event of an instance failure, the database will become fully available in 100 seconds.
- C. In the event of an instance failure, the failed instance will become fully available In 300 seconds.
- D. In the event of an instance failure, the database will become partially available in 200 seconds.
- E. In the event of an instance failure, the failed instance will become available In 300 seconds.
Answer : A,E
Explanation:
FAST_START_MTTR_TARGET -
FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified,
FAST_START_MTTR_TARGET is overridden by
LOG_CHECKPOINT_INTERVAL.
V$INSTANCE_RECOVERY -
Estimated time (in seconds) that the cluster would become partially available should this instance fail. This column is only meaningful in an Oracle Real Application Clusters (Oracle
RAC) environment. In a non-Oracle
RAC environment, the value of this column is null.
Oracle Database Reference -
11g Release 2 (11.2)
Your network administrator informs you that the Internet service provider is being changed in a month's time in conjunction with a data center move.
You are asked to plan for the changes required in the Oracle Grid Infrastructure, which is set up to use GNS.
The IP addresses and subnets of the public network are to change.
Which two must be done in the Oracle Grid Infrastructure network setup to accommodate this change using the command-line Interfaces available?
- A. The SCAN VIPs and node VIPs must be reconfigured using srvctl.
- B. The SCAN VIPs and SCAN listener resources must be removed and added to obtain the new SCAN IP addresses from DHCP.
- C. The interconnect must be reconfigured by using oifcfg, crsctl, and ifconfig.
- D. The SCAN VIPs and node VIPs must be reconfigured by using oifcfg.
- E. The Interconnect must be reconfigured by using srvctl.
Answer : C,D
Explanation:
How to Modify Public or Private Network Information in Oracle Clusterware [ID
283684.1]
Modified 14-MAR-2012 Type HOWTO Status PUBLISHED
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.3 - Release: 10.1 to 11.2
Information in this document applies to any platform.
Goal -
The purpose of this note is to describe how to change or update the cluster_interconnect and/or public interface information that is stored in OCR.
It may be necessary to change or update interface names, or subnet associated with an interface if there is a network change affecting the servers, or if the original information that was input during the installation was incorrect. It may also be the case that for some reason, the Oracle Interface Configuration Assistant ('oifcfg') did not succeed during the installation.
This note is not intended as a means to change the Public or Private Hostname themselves. Public hostname or Private hostname can only be changed by removing/adding nodes, or reinstalling Oracle Clusterware.
However, node VIP name/IP can be changed, refer to Note 276434.1 for details.
Refer to note 1386709.1 for basics of IPv4 subnet and Oracle Clusterware
Instructions for Changing Interfaces/Subnet
1. Public Network Change
If the change is only public IP address and the new ones are still in the same subnet, nothing needs to be done on clusterware level (all changes needs to be done on OS level to reflect the change).
If the change involves different subnet or interface, as there is not a 'modify' option - you will need to delete the interface and add it back with the correct information. So, in the example here, the subnet is being changed from 10.2.156.0 to 10.2.166.0 via two separate commands - first a 'delif' followed by a 'setif':
% $ORA_CRS_HOME/bin/oifcfg delif -global eth0
% $ORA_CRS_HOME/bin/oifcfg setif -global eth0/10.2.166.0:public syntax: oifcfg setif
<interface-name>/<subnet>:<cluster_interconnect|public>
Note: If public network is changed, it may be necessary to change VIP as well, refer to
Note 276434.1 for details; for 11gR2, it may be necessary to change SCAN as well, refer to note 972500.1 for details (This procedure does not apply when GNS is being used).
2. Private Network Change
2A. For pre-11gR2, if you wish to change the cluster_interconnect information and/or private IP address, hosts file needs to be modified on each node to reflect the change while the Oracle Clusterware Stack is down on all nodes. After the stack has restarted, to change the cluster_interconnect used by RDBMS and ASM instances, run oifcfg. In this example:
% $ORA_CRS_HOME/bin/oifcfg delif -global eth1
% $ORA_CRS_HOME/bin/oifcfg setif -global eth1/192.168.1.0:cluster_interconnect
2B. For 11gR2 and higher, refer to note 1073502.1
Note: For 11gR2, as clusterware also uses cluster_interconnect, intended private network must be added by "oifcfg setif" before stopping clusterware for any change.
Note: If you are running OCFS2 on
You installed the Oracle Grid Infrastructure on a four-node cluster before discussing the network requirements with the network administrator who was on holiday.
You created a single scan named mydb-scan.myclust.example.com by adding this name to the /etc/hosts file. As a result, the Grid Infrastructure has four node listeners and node VIP but only a single SCAN listener and SCAN VIP.
The network administrator has returned and modified the corporate DNS server to associate three IP addresses with the mydb-scan.myclust.example.com scan name. The
SCAN VIPs are on the same network as the node VIPs.
You now must replace the single SCAN VIP and listener with three of each for high availability purposes and make certain that the SCANs and listeners are active. Which procedure will do this properly if run as the root user?
- A. srvctl stop scan_listener srvctl stop scan srvctl start scan srvctl start scan_listener
- B. srvctl stop scan_listener srvctl stop scan srvctl remove scan srvctl add scan -n MYDB-SCAN.MYCLUST.EXAMPLE.COM srvctl start scan srvctl start scan_listener
- C. srvctl add scan -n MYDB-SCAN.MYCLUST.EXAMPLE.COM srvctl start scan srvctl start scan_listener
- D. srvctl stop scan_listener srvctl stop scan srvctl remove scan srvctl add scan srvctl start scan srvctl start scan listener
Answer : B
Explanation:
How to update the IP address of the SCAN VIP resources (ora.scan.vip) [ID 952903.1]
Modified 03-JAN-2012 Type HOWTO Status PUBLISHED
In this Document -
Goal -
Solution -
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.1 - Release: 11.2 to 11.2
Information in this document applies to any platform.
Goal -
The purpose of this document is to explain how to change the IP addresses associated with the SCAN VIPs in a 11gR2 Grid (CRS) environment.
The IP addresses associated with the SCAN VIP resources are initially set when the SCAN resources are created.
Any changes to the DNS entry for the SCAN are not automatically propagated to the clusterware and need to be done manually.
This applies only to installations that are not using GNS.
The information in this note can also be helpful in cases where SCAN was originally configured with just one address and is now being expanded to accommodate three IP addresses.
Solution -
Before the SCAN VIPs can be changed, the entry for the SCAN name on the Domain
Name Server (DNS) needs to be updated with the new IP addresses. This usually will be done by a network administrator. To check the current setting, the following command can be used: nslookup <scan_name>
To check the current IP address(es) of the SCAN VIPs, run the following commands as the root user:
$GRID_HOME/bin/srvctl config scan
Next refresh the SCAN VIPs with the new IP addresses from the DNS entry:
$GRID_HOME/bin/srvctl modify scan -n <scan_name>
To check if the SCAN VIPs have been changed, run the following command, it should now show the new IP addresses.
$GRID_HOME/bin/srvctl config scan
Below is an example using the following configuration:
The name of the SCAN is sales-scan.example.com
subnet of the public network is 10.100.10.0
netmask for the public network is 255.255.255.0
name of the public interface is eth1
old IP addresses: 10.100.10.81, 10.100.10.82 & 10.100.10.83
new IP addresses: 10.100.10.121, 10.100.10.122 & 10.100.10.123
A lookup of the SCAN on the DNS server shows that the entry has already been updated with the new IP addresses:
$ nslookup sales-scan.example.com
Server: dns1.example.com -
Address: 10.100.10.70#53 -
Name: sales-scan.example.com -
Address: 10.100.10.123 -
Name: sales-scan.example.com -
Address: 10.100.10.122 -
Name: sales-scan.example.com -
Address: 10.100.10.121 -
Stop the SCAN listener and the SCAN VIP resources:
# $GRID_HOME/bin/srvctl stop scan_listener
# $GRID_HOME/bin/srvctl stop scan
# $GRID_HOME/bin/srvctl status scan
SCAN VIP scan1 is enabled -
SCAN VIP scan1 is not running -
SCAN VIP scan2 is enabled -
SCAN VIP scan2 is not running -
SCAN VIP scan3 is enabled -
SCAN VIP scan3 is not running -
# $GRID_HOME/bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is not running
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is not running
The SCAN VIP r
Examine the following details from the AWR report for your three-instance RAC database:
Which inferences is correct?
- A. There are a large number of requests for cr blocks or current blocks currently in progress.
- B. Global cache access is optimal without any significant delays.
- C. The log file sync waits are clue to cluster interconnect latency.
- D. To determine the frequency of two-way block requests you must examine other events In the report.
Answer : B
Explanation:
Analyzing Cache Fusion Transfer Impact Using GCS Statistics
This section describes how to monitor GCS performance by identifying objects read and modified frequently and the service times imposed by the remote access. Waiting for blocks to arrive may constitute a significant portion of the response time, in the same way that reading from disk could increase the block access delays, only that cache fusion transfers in most cases are faster than disk access latencies.
The following wait events indicate that the remotely cached blocks were shipped to the local instance without having been busy, pinned or requiring a log flush: gc current block 2-way gc current block 3-way gc cr block 2-way gc cr block 3-way
The object statistics for gc current blocks received and gc cr blocks received enable quick identification of the indexes and tables which are shared by the active instances. As mentioned earlier, creating an ADDM analysis will, in most cases, point you to the SQL statements and database objects that could be impacted by interinstance contention.
Any increases in the average wait times for the events mentioned in the preceding list could be caused by the following occurrences:
High load: CPU shortages, long run queues, scheduling delays
Misconfiguration: using public instead of private interconnect for message and block traffic
If the average wait times are acceptable and no interconnect or load issues can be diagnosed, then the accumulated time waited can usually be attributed to a few SQL statements which need to be tuned to minimize the number of blocks accessed.
Oracle Real Application Clusters Administration and Deployment Guide
11g Release 2 (11.2)
What does a high “gc current block busy” event value indicate?
- A. Access to cached data blocks was delayed because they were busy either in the remote or the local cache.
- B. A large number of requested blocks were not cached In any instance.
- C. Asynchronous input/output (I/O) is disabled.
- D. Delay in processing has occurred In the GCS, caused by CPU saturation and would have to be solved by additional CPUs and load-balancing.
Answer : A
Explanation: The gc current block busy wait event indicates that the access to cached data blocks was delayed because they were busy either in the remote or the local cache.
This could be caused by any of the following:
-> The blocks were pinned
-> The blocks were held up by sessions
-> The blocks were delayed by a log write on a remote instance
-> A session on the same instance was already accessing a block which was in transition between instances and the current session needed to wait behind it (for example, gc current block busy)
You have two administrator-defined server pools on your eight-node cluster called OLTP and DSS.
Hosts RACNODE3, RACNODE4, and RACNODE5 are currently assigned to the DSS Pool.
Hosts RACNODE6, RACNODE7, and RACNODE8 are assigned to the OLTP Pool.
Hosts RACNODE1 and RACNODE2 are assigned to the Generic pool.
You are patching the Oracle Grid Infrastructure in a rolling fashion for your cluster and you have completed patching nodes RACNODE3, RACNODE4, RACNODE5, and
RACNODE6, but you have not patched nodes RACNODE1 and RACNODE2.
While examining the status of RACNODE2 software, you get this output:
$ crsctl query crs softwareversion
Oracle Cluster-ware version on node [RACNODE2] is [11.2.0.2.0]
$ crsctl query crs activeversion
Oracle Clusterware active version on node [RACNODE2] is [11.2.0.1.0]
Which two statements describe the reasons for the active versions on the nodes of the cluster?
- A. The active version is 11.2.0.2.0 on RACNODE3, RACNODE4, and RACNODE5 because all the nodes in the DSS server pool have the same installed version.
- B. The active version is 11.2.0.1.0 on RACNODE6, RACNODE7, and RACNODE8 because some nodes in the cluster still have version 11.2.0.1.0 installed.
- C. The active version is 11.2.0.1.0 on RACNODE6, RACNODE7, and RACNODE8 because some nodes in the OLTP Pool still have version 11.2.0.1.0 installed.
- D. The active version is 11.2.0.1.0 on RACNODE3, RACNODE4, and RACNODE5 because some nodes in the cluster still have version 11.2.0.1.0 installed.
Answer : B,D
Explanation:
crsctl query crs softwareversion
Use the crsctl query crs softwareversion command to display latest version of the software that has been successfully started on the specified node. crsctl query crs activeversion
Use the crsctl query crs activeversion command to display the active version of the Oracle
Clusterware software running in the cluster. During a rolling upgrade, however, the active version is not advanced until the upgrade is finished across the cluster, until which time the cluster operates at the pre-upgrade version.
Oracle Clusterware Administration and Deployment Guide
11g Release 2 (11.2)