Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Intermediate Practice Exam: Medium Difficulty 2025

You are installing Grid Infrastructure on a four-node cluster. During the configuration, you need to specify the SCAN (Single Client Access Name) for the cluster. The DNS administrator has configured three IP addresses for the SCAN name 'prod-scan.example.com'. Which statement is true regarding SCAN configuration in this scenario?

Your ASM instance is using COMPATIBLE.ASM set to 19.0.0.0 and COMPATIBLE.RDBMS set to 19.0.0.0. You want to implement ASM Flex Diskgroup redundancy for a new diskgroup that will store less critical database files. What is the minimum configuration required to create an ASM Flex Diskgroup?

During a RAC database maintenance window, you need to relocate a service named 'SALES_SERVICE' currently running on instance RAC1 to instance RAC2 without disconnecting existing sessions. The service is configured with connection load balancing. Which command accomplishes this goal?

You are adding a new disk group to your ASM environment. The disk group will store archived redo logs and requires NORMAL redundancy. You have 6 disks available, each on a separate storage controller. To achieve optimal failure isolation, how should you configure the failure groups?

Your three-node RAC cluster is experiencing network issues. The clusterware log shows messages indicating that node eviction is being considered for NODE3. You execute 'crsctl check cluster -all' and see that NODE3 has a CSS state of 'MEMBER' but the cluster state shows 'ONLINE (INTERMEDIATE)'. What is the most likely cause and immediate action?

You need to add a fourth node to an existing three-node RAC cluster. The Grid Infrastructure is already running on nodes 1-3, and you have prepared the operating system on node 4. Which sequence of high-level steps is correct for adding this node?

Your ASM disk group DATA has NORMAL redundancy and is currently 85% full. You need to add storage capacity. You have four new disks available. After adding the disks to the disk group, what happens to the existing data, and what should you monitor?

You have configured a RAC database service with UNIFORM distribution for connection load balancing and LONG for runtime load balancing. During peak hours, users report that some sessions experience slower response times. Upon investigation, you find that one instance is processing significantly more work than others. What is the most effective solution?

After a storage maintenance, one of the voting disks in your RAC cluster is showing as OFFLINE in the output of 'crsctl query css votedisk'. The cluster is still operational. What is the appropriate action to resolve this situation?

You are configuring policy-managed database deployment in a RAC cluster with two server pools: POOL_ONLINE (min=2, max=3) and POOL_BATCH (min=1, max=2). Your database PRODDB has a server pool named 'prodpool' assigned to POOL_ONLINE. A node fails and GI automatically migrates services. What determines which node the database instance will start on after the failure?