We give your very best to make sure that you might have a wonderful encounter our Oracle Oracle check engine. Well begun, half accomplished. Choose the Oracle 1Z0-058 exam is the wise choice in your lifestyle. If you need to have any data about how you can use the Oracle Oracle exam, please contact your customer assistance. Our staff members operate around the clock for you to offer the best service for all the candidates. You are going to get timely and also satisfied answers to you questions.
2021 Aug 1Z0-058 practice
Q31. 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 =
B. ERP= (DESCRIPTION=
(CONNECT DATA=(SERVICE NAME=ERP)))"
Use Services with Client Applications
untitled D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 - 11
Q32. For which two purposes would you recommend an ASM clustered file system (ACFS)?
A. a shared home directory for Oracle database executables in a single-instance cluster for cold failover
B. a shared home directory for Oracle Grid Infrastructure executables
C. a root file system for the operating system
D. a shared file system for RAC data files
E. a general purpose shared file system for OS files
F. a clustered file system for OCR and voting disk files
Overview of Oracle ACFS Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic Storage Management (Oracle ASM) functionality to support customer files maintained outside of Oracle Database. Oracle ACFS supports many database and application files, including executables, database trace files, database alert logs, application reports, BFILEs, and configuration files. Other supported files are video, audio, text, images, engineering drawings, and other general-purpose application file data.
Notes: Oracle ASM is the preferred storage manager for all database files. It has been specifically designed and optimized to provide the best performance for database file types. For a list of file types supported by Oracle ASM, see Table 7-1, "File types supported by Oracle ASM". Oracle ACFS is the preferred file manager for non-database files. It is optimized for general purpose files. Oracle ACFS does not support any file type that can be directly stored in Oracle ASM, except where explicitly noted in the documentation. Not supported means Oracle Support Services does not take calls and development does not fix bugs associated with storing unsupported file types in Oracle ACFS. Starting with Oracle Automatic Storage Management 11g Release 2 (188.8.131.52), Oracle ACFS supports RMAN backups (BACKUPSET file type), archive logs (ARCHIVELOG file type), and Data Pump dumpsets (DUMPSET file type). Note that Oracle ACFS snapshots are not supported with these files. Oracle ACFS does not support files for the Oracle Grid Infrastructure home. Oracle ACFS does not support Oracle Cluster Registry (OCR) and voting files. Oracle ACFS functionality requires that the disk group compatibility attributes for ASM and ADVM be set to
11.2 or greater. For information about disk group compatibility, refer to "Disk Group Compatibility".
Oracle. Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)
Q33. After Oracle Grid Infrastructure has been installed, you should take a few moments to verify the installation. Which two actions would be useful in verifying the installation?
A. Run the crsctl status resource –t command to confirm that all necessary cluster resources are online.
B. Use the operating system utilities to verify that your SCAN addresses are being properly resolved.
C. Start Oracle Enterprise Manager and check all monitored targets.
D. Run the cluvfy comp nodecon –n all –verbose command to verify the entire Grid Infrastructure installation.
Verifying the Grid Infrastructure Installation Execute the crsctl command as shown in the slide to confirm that all cluster resources are up and running. root@racnode01 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t In addition, you should confirm that your DNS is properly forwarding address requests for your application and SCAN VIPs to your GNS and that they are resolved properly. You can do this with dig. Execute the dig command with DNS and VIP addresses as shown: # dig @myDNS.example.com racnode01-cluster01.example.com
;; QUESTION SECTION: ;racnode01-vip.cluster01.example.com. IN A ;; ANSWER SECTION: racnode01-vip.cluster01.example.com. 120 IN A
# dig @myDNS.example.com cluster01-scan.cluster01.example.com
;; QUESTION SECTION: ;cluster01-scan.cluster01.example.com. IN A ;; ANSWER SECTION: cluster01-scan.cluster01.example.com. 120 IN A 192.0.2.248 cluster01-scan.cluster01.example.com. 120 IN A 192.0.2.253 cluster01-scan.cluster01.example.com. 120 IN A 192.0.2.254 D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 2 – 44
Q34. Which two statements are true regarding the Automatic Workload Repository (AWR) In a RAC environment?
A. The AWR includes time model statistics based on time usage for activities displayed In the VSSYS_TIME_MODEL and VSSESS_TIHE_HODEL views.
B. The AWR is controlled by the statistics_level initialization parameter and it must be set to TYPICAL or BASIC
C. The Manageability Monitor Processes (MMON) process gathers statistics every hour from every instance and creates an AWR snapshot and stores it In the SGA.
D. The MMON process gathers statistics from its' own instance and kicks off statistics collection form other instances every hour from other instances and creates an AWR snapshot which is written to the sysaux tablespace.
Explanation: The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views. The statistics collected and processed by AWR include:
. Object statistics that determine both access and usage statistics of database segments . Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views . Some of the system and session statistics collected in the V$SYSSTAT and V$SESSTAT views . SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time
. Active Session History (ASH) statistics, representing the history of recent sessions Activity MMON (Memory Monitor) is a background process that gathers memory statistics (snapshots) stores this information in the AWR (automatic workload repository). MMON is also responsible for issuing alerts for metrics that exceed their thresholds.
Oracle Database Performance Tuning Guide
Q35. Your cluster has Oracle Grid Infrastructure installed and working to support RAC databases and all the related resources.
There is also a vendor HA software on the cluster providing HA services for some non-Oracle applications. You want to remove the vendor HA software and use Oracle Grid Infrastructure to provide the HA framework for your applications.
The first application to be migrated to Oracle HA is used to display financial currency information at various fixed flat screens at a business park. This application must be owned by the Financial Application owner.
Which three components of the framework are required to support this application for HA?
A. an application VIP to support sending data to the screens
B. a resource definition defining the application and various HA attributes
C. privileges to permit the application to run as the correct user and to have the correct access rights to files
D. an action program called by the HA framework for starting, stopping, and monitoring the application
E. a resource dependency to make certain that the application VIP is started before the application is started and to start VIP automatically if it is down
Overview of Using Oracle Clusterware to Enable High Availability To manage your applications with Oracle Clusterware:
1. Create an action script or use an existing agent.
2. Register your applications as resources with Oracle Clusterware.
If a single application requires that you register multiple resources, you may be required to define relevant dependencies between the resources.
3. Assign the appropriate privileges to the resource.
4. Start or stop your resources.
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Refresh 1Z0-058 exam question:
Q36. You notice that there is a very high percentage of wait time for the ’enq:HW-contention’ event in your RAC database that has frequent insert operations.
Which two recommendations may reduce this problem?
A. shorter transactions
B. increasing sequence cache sizes
C. using reverse key indexes
D. uniform and large extent sizes
E. automatic segment space management
F. smaller extent sizes
Explanation: Segments have High Water Mark (HWM) indicating that blocks below that HWM have been formatted. New tables or truncated tables [that is truncated without reuse storage clause], have HWM value set to segment header block. Meaning, there are zero blocks below HWM. As new rows inserted or existing rows updated (increasing row length), more blocks are added to the free lists and HWM bumped up to reflect these new blocks. HW enqueues are acquired in Exclusive mode before updating HWM and essentially HW enqueues operate as a serializing mechanism for HWM updates. Allocating additional extent with instance keyword seems to help in non-ASSM tablespace Serialization of data blocks in the buffer cache due to lack of free lists, free list groups, transaction slots (INITRANS), or shortage of rollback segments. This is particularly common on INSERT-heavy applications, in applications that have raised the block size above 8K, or in applications with large numbers of active users and few rollback segments. Use automatic segment-space management (ASSM) and automatic undo management to solve this problem. HW enqueue The HW enqueue is used to serialize the allocation of space beyond the high water mark of a segment.
. V$SESSION_WAIT.P2 / V$LOCK.ID1 is the tablespace number.
. V$SESSION_WAIT.P3 / V$LOCK.ID2 is the relative dba of segment header of the object for which space is being allocated. If this is a point of contention for an object, then manual allocation of extents solves the problem.
Q37. 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
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
Q38. Which two network addresses are required to be static, non-dhcp addresses when using the Grid Naming?
A. GNS VIP Address
B. SCAN VIP Address
C. Node VIP Address
D. Node Public Address
E. Node Private Address
Explanation: 2.6.2 IP Address Requirements
Before starting the installation, you must have at least two network adapters configured on each node: One for the private IP address and one for the public IP address.
You can configure IP addresses with one of the following options:
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.
Oracle. Grid Infrastructure Installation Guide
To implement GNS, you must collaborate with your network administrator to obtain an IP address on the public network for the GNS VIP. DNS uses the GNS VIP to forward requests for access to the cluster to GNS. You must also collaborate with your DNS administrator to delegate a domain to the cluster. This can be a separate domain or a subdomain of an existing domain. The DNS server must be configured to forward all requests for this new domain to the GNS VIP. Since each cluster has its own GNS, it must be allocated a unique domain of which to be in control.
Oracle. Clusterware Administration and Deployment Guide
Q39. 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.
How to Modify Public or Private Network Information in Oracle Clusterware [ID 283684.1] Modified 14-MAR-2012 Type HOWTO Status PUBLISHED
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 184.108.40.206 - Release: 10.1 to 11.2 Information in this document applies to any platform.
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 Linux and are changing the private IP address for your cluster, you may also need to change the private IP address that OCFS2 is using to communicate with other nodes. For more information on this, please refer to <Note 604958.1>
3. Verify the correct interface subnet is in use by re-running oifcfg with the 'getif' option: % $ORA_CRS_HOME/bin/oifcfg getif eth0 10.2.166.0 global public eth1 192.168.1.0 global cluster_interconnect How to Modify Private Network Interface in 11.2 Grid Infrastructure [ID 1073502.1] Modified 08-FEB-2012 Type HOWTO Status PUBLISHED
Oracle Server - Enterprise Edition - Version: 220.127.116.11.0 and later [Release: 11.2 and later ] Information in this document applies to any platform.
The purpose of this document is to demonstrate how to change the private network interface configuration stored in the OCR. This may be required if the name of the interface for the private network (cluster interconnect) needs to be changed at the OS level, for example, the private network is configured on a single network interface eth0, now you want to replace it with a bond interface bond0 and eth0 will be part of the bond0 interface. It also includes command for adding/deleting a private network interface.
As of 11.2 Grid Infrastructure, the CRS daemon (crsd.bin) now has a dependency on the private network configuration stored in the gpnp profile and OCR. If the private network is not available or its definition is incorrect, the CRSD process will not start and any subsequent changes to the OCR will be impossible. Therefore care needs to be taken when making modifications to the configuration of the private network. It is important to perform the changes in the correct order. Note: If only private network IP is going to be changed, the subnet and network interface remain same (for examples changing private IP from 192.168.0.1 to 192.168.0.10), simply shutdown GI stack, make IP modification at OS level (like /etc/hosts, network config etc) for private network, then restart GI stack will complete the task. The following procedures apply when subnet or network interface name also requires change. Please take a backup of profile.xml on all cluster nodes before proceeding, as grid user: $ cd $GRID_HOME/gpnp/<hostname>/profiles/peer/ $ cp -p profile.xml profile.xml.bk
To modify the private network (cluster_interconnect):
1. Ensure CRS is running on ALL cluster nodes in the cluster
2. As grid user, add new interface:
Find the interface which needs to be removed. For example:
$ oifcfg getif
eth1 18.104.22.168 global public
eth0 192.168.0.0 global cluster_interconnect
Here the eth0 interface will be replaced by bond0 interface.
Add new interface bond0:
$ oifcfg setif -global <interface>/<subnet>:cluster_interconnect
$ oifcfg setif -global bond0/192.168.0.0:cluster_interconnect
This can be done with -global option even if the interface is not available yet, but this can
not be done with - node option if the interface is not available, it will lead to node eviction.
If the interface is available on the server, subnet address can be identified by command:
$ oifcfg iflist
It lists the network interface and its subnet address. This command can be run even if CRS
is not up and running. Please note, subnet address might not be in the format of x.y.z.0.
For example, it can be:
$ oifcfg iflist
lan2 10.2.3.64 << this is the private network subnet address associated with privet network
If the scenario is just to add a 2nd private network, for example: new interface is eth3 with
192.168.1.96, then issue:
$ oifcfg setif -global eth3/192.168.1.96:cluster_interconnect
Verify the change:
$ oifcfg getif
3. Shutdown CRS on all nodes and disable the CRS as root user: # crsctl stop crs # crsctl disable crs
4. Make the network configuration change at OS level as required, ensure the new interface is available on all nodes after the change. $ ifconfig -a
$ ping <private hostname>
5. Enable CRS and restart CRS on all nodes as root user:
# crsctl enable crs
# crsctl start crs
6. Remove the old interface:
$ oifcfg delif -global eth0
Note #1. This step is not required for adding 2nd interface scenario.
#2. If the new interface is added without removing the old interface, eg: old interface still available when CRS restart, then after step 6, CRS needs to be stop and start again to ensure the old interface is no longer in use. untitled
Workaround: restore the OS network configuration back to the original status, start CRS.
Then follow above steps to make the changes again.
Please consult with Oracle Support Service if after restoring OS network configuration,
CRS still could not start.
2. If any one node is down in the cluster, oifcfg command will fail with error: $ oifcfg setif -global bond0/192.168.0.0:cluster_interconnect PRIF-26: Error in update the profiles in the cluster Workaround: start CRS on the node where it is not running. Ensure CRS is up on all cluster nodes.
3. If a user other than Grid Infrastructure owner issues above command, it will fail with same error: $ oifcfg setif -global bond0/192.168.0.0:cluster_interconnect PRIF-26: Error in update the profiles in the cluster Workaround: ensure to login as Grid Infrastructure owner to perform such command.
4. From 22.214.171.124 onwards, if attempt to delete the last private interface (cluster_interconnect) without adding a new one first, following error will occur:
PRIF-31: Failed to delete the specified network interface because it is the last private interface Workaround: Add new private interface first before deleting the old private interface.
5. If CRS is down on the node, the following error is expected: $ oifcfg getif PRIF-10: failed to initialize the cluster registry Workaround: Start the CRS on the node My Oracle Support
Q40. 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.
Explanation: ASH report statistics provide details about Oracle Database session activity. Oracle Database records 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 information about active sessions. The amount of the data is directly related to the work being performed, rather than the number of sessions allowed on the system.
Oracle Real Application Clusters Administration and Deployment Guide