1Z0-078 Exam Guide: Oracle Database 19c RAC, ASM, and Grid Infrastructure Administration
The 1Z0-078 exam validates administration knowledge across Oracle Database 19c Real Application Clusters, Automatic Storage Management, and Grid Infrastructure. Oracle places it in the High Availability section of its certification catalog, making it relevant to database administrators and infrastructure specialists who support clustered Oracle environments. This guide helps you decide whether your experience is ready for the exam, which technical areas require hands-on practice, how to sequence study, and what to verify before purchasing and scheduling an attempt.
What does 1Z0-078 validate?
1Z0-078 is titled “Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration.” Its scope is administration of the clustered database platform and the infrastructure that supports availability, shared storage, workload placement, and operational control. Oracle’s dedicated MyLearn page identifies the exam by this title and code: https://mylearn.oracle.com/ou/exam/oracle-database-19c-rac-asm-and-grid-infrastructure-administration-1z0-078/38560/112132/172866
The exam should therefore be approached as an administration assessment rather than a general SQL test. Preparation needs to connect architecture with operational decisions: how instances access one database, how Clusterware manages resources, how ASM supplies shared storage, and how services direct workloads across a cluster.
Oracle’s RAC documentation describes the core model as a one-to-many relationship between one database and several instances. Each instance runs on a separate server and uses the cluster interconnect. RAC also adds instance-specific undo and at least one additional redo thread for each instance. These are not isolated facts to memorize; they explain why instance, storage, service, and failure-management questions must be studied together.
Who is the exam intended for?
The strongest candidate is a DBA or infrastructure administrator who already understands Oracle Database administration and now needs to operate RAC, ASM, and Grid Infrastructure in a 19c environment. A candidate who has only read about clustering but has never examined services, instances, disk groups, or cluster resources should build practical foundations before scheduling.
Oracle’s database training catalogue lists separate official workshops for Clusterware Administration, ASM Administration, RAC Administration, and Data Guard Administration. That separation is useful when diagnosing your preparation needs: you may be comfortable with database administration but still need focused work on ASM or Clusterware. See the training catalogue at https://www.oracle.com/education/training/database/
Use a simple readiness decision. If you can explain why RAC requires Clusterware, identify the role of ASM within Grid Infrastructure, and troubleshoot a service or instance using documented administration tools, begin blueprint-oriented revision. If those topics are unfamiliar, start with structured training and a lab before buying an attempt. The official catalogue does not establish a prerequisite in the supplied evidence, so this readiness test is a practical recommendation, not an Oracle eligibility rule.
Which technical abilities should you measure?
Measure your ability to reason from an availability or administration requirement to the correct Oracle component, configuration model, and verification method. The supplied official RAC chapter identifies the main subject areas, including installation, RAC One Node, Clusterware, RAC architecture and processing, dynamic database services, server pools, policy-managed databases, QoS Management, Hang Manager, Multitenant with RAC, Database In-Memory with RAC, and RAC administration.
Build a skills inventory under these headings rather than treating the exam title as three unrelated products. For each topic, record whether you can explain the concept, perform a task in a lab, verify the result with an Oracle utility or view, and diagnose a failure. The last two columns matter because administration questions often test consequences and operational choices, not definitions alone.
The RAC documentation identifies SRVCTL, Oracle Enterprise Manager, SQL*Plus, and other utilities as administration tools for a cluster database treated as a single-system image. Your study notes should distinguish cluster-wide administration from commands that operate on the current instance. For example, SQL*Plus commands operate on the current instance, so a connection context is part of the task, not incidental background.
How should RAC architecture be studied?
Start with the boundaries between database, instances, Clusterware, the interconnect, and shared storage. Oracle RAC permits several instances to access one database, while Oracle Clusterware provides the infrastructure required to run RAC and manages resources such as VIP addresses, databases, listeners, and services. This architecture is the foundation for later troubleshooting and configuration questions.
Draw the environment on paper during study, then reproduce it in your lab notes digitally because pen and paper is not allowed during the exam; Oracle states that a digital whiteboard is available in the exam delivery platform. Keep the diagram focused on resource relationships: nodes host instances, instances access the shared database, services expose workloads, and Clusterware coordinates availability.
Review RAC processing through failure scenarios. Ask what happens when an instance stops, when a node becomes unavailable, or when a service is moved. Then ask which component detects the condition, which resource must be relocated or restarted, and how a client is directed to a healthy instance. This sequence is more useful than memorizing isolated product descriptions.
Do not confuse high availability with complete disaster recovery. Oracle explains that an extended cluster can provide fast recovery from a site failure, but it may not satisfy every organization’s disaster-recovery requirement. The RAC documentation also recommends considering Data Guard with RAC for comprehensive protection against disasters, including corruptions and regional disasters.
What should you learn about Clusterware and Grid Infrastructure?
Study Clusterware as the control layer for cluster membership, resource management, and high availability, and study ASM as the storage layer. Oracle states that Clusterware is required for RAC. Clusterware and ASM together comprise Oracle Grid Infrastructure, which can provide clustered storage for RAC and non-cluster databases.
Create a component table with four columns: resource, owner or managing layer, dependency, and recovery behavior. Include nodes, VIP addresses, listeners, databases, instances, services, disk groups, and server pools. This makes dependencies visible and helps prevent a common mistake: assigning every availability problem to the database when the cause may be a cluster resource or storage dependency.
The official RAC chapter says Clusterware provides node membership, group services, global resource management, and high availability functions. Revise each phrase with a practical question. What establishes membership? What resources need coordinated placement? How does the cluster preserve service availability after a failure? Your answers should refer to the architecture and documented administration tools rather than unsupported command lists.
Use the Oracle ASM Administration Workshop as a targeted resource if ASM is your weakest area. The supplied Oracle course description covers ASM instances, Flex ASM, ASM disk groups, ASM files, directories and templates, and Oracle ACFS/ADVM enhancements: https://learn.oracle.com/ols/course/oracle-database-19c-asm-administration-workshop/125325/125307
How do services, server pools, and policy management fit together?
Services connect application workloads to RAC instances and availability policies. Oracle describes services as entities that group workloads, route work to optimal assigned instances, and support high availability for planned and unplanned actions. Study services together with server pools and deployment style because the correct behavior depends on how the database is managed.
Contrast administrator-managed and policy-managed deployments in your notes. Administrator-managed databases bind instances to specific nodes and use preferred and available instance designations for services. Policy-managed databases use server pools, whose properties control scalability and availability. The ability to expand or shrink instances by changing server pool size applies to policy-managed deployments, not administrator-managed deployments.
Practice interpreting server pool policy. Oracle explains that the IMPORTANCE attribute ranks services and can remove the need to run a service on every node to keep it available. A higher-importance pool can receive resources first after failures or during startup. The practical question is not simply “what is IMPORTANCE?” but “which workload should remain available when resources are constrained, and why?”
Also review dynamic workload management. Load Balancing Advisory supplies applications with information about current service levels, while Runtime Connection Load Balancing helps Oracle clients allocate connections according to the service level provided by database instances. Include client behavior in your study because service configuration and connection routing are related but not identical decisions.
What RAC topics deserve hands-on practice?
Prioritize tasks that expose state, dependencies, and recovery behavior: inspect cluster resources, identify instance and service placement, examine ASM disk groups and files, test service relocation, and verify the result from the client side. Hands-on work turns terminology into operational reasoning and reveals where your mental model is incomplete.
Use a repeatable lab cycle. First write the intended availability outcome. Next identify the resources and dependencies involved. Then make one controlled change, verify cluster and database state, and record the effect on connections and workloads. Finally restore the environment and explain what would happen if the same event were unplanned.
For Multitenant with RAC, study how services determine where a PDB is available. Oracle states that a PDB can be available on every instance of the RAC CDB or on a subset of instances, and that the first dynamic database service assigned to the PDB makes it available on the instances where that service runs. Test this relationship conceptually even if your lab cannot reproduce every deployment.
For temporary space, distinguish shared and local behavior. Oracle documents that creating a local temporary tablespace creates local temporary files on every instance rather than one shared file. Instance-specific temporary-file information can differ between instances, so it is stored in the SGA rather than the control file. This is a useful example of why RAC administration requires instance-aware verification.
How should you prepare for ASM and storage questions?
Study ASM through the complete storage path: ASM instance, disk group, file or template, database dependency, redundancy or availability objective, and operational verification. Do not revise ASM as a list of storage terms. For each feature, explain what it protects, where it is configured, how a database consumes it, and what evidence confirms that it is working.
A focused ASM lab should include creating or inspecting disk groups, understanding ASM files and directories, reviewing templates, and considering Flex ASM. The official Oracle workshop specifically covers these areas, along with ACFS and ADVM enhancements. Use the workshop description to fill identified gaps, while relying on the current Oracle course and exam pages for scheduling or availability rather than assuming a lab is always open.
Link storage decisions to availability requirements. Oracle’s RAC documentation notes that when data must be located at both sites for availability reasons, disk mirroring technology is required. That statement should prompt a design discussion: what failure is being addressed, where is the second copy located, and is storage mirroring alone sufficient for the organization’s recovery objectives?
Avoid unsupported certainty about exact exam commands or question formats. Practice documented administration workflows and read the 19c RAC material closely, but do not infer that a command appearing in a lab or study note will necessarily appear on the exam.
Which advanced RAC subjects should not be skipped?
Advanced topics are easiest to retain when tied to a use case: server pools for consolidation, QoS for resource priorities, Hang Manager for system hangs, Multitenant for PDB placement, and Database In-Memory for instance-level memory decisions. Give each subject one architecture page and one troubleshooting scenario instead of postponing all advanced material until the final revision session.
For consolidation, understand why policy-managed databases can share a server pool and use instance caging to adjust database capacity horizontally through server pool size and vertically through the CPU_COUNT server configuration attribute. The same source notes that server pools can dynamically increase or decrease database instances to meet demand or business policies.
For Database In-Memory, pay attention to RAC-wide versus instance-specific settings. Oracle states that INMEMORY_SIZE in each RAC database instance must not exceed 16 GB and gives the example that a node not requiring an IM column store should set INMEMORY_SIZE to 0. Treat these as documented 19c facts attached to the specific parameter and instance context.
For Hang Manager, learn the progression from detection to action. Oracle records that Hang Manager initially identified system hangs and wrote relevant information to a trace file, while in Oracle Database 12c release 2 it could take action and attempt to resolve the hang. Focus on the operational purpose and version context rather than memorizing historical trivia without explanation.
What study sequence works best?
Study in dependency order: architecture first, then Clusterware and ASM, then RAC administration and services, then policy management and advanced features, and finally exam operations. This sequence prevents you from memorizing service or server-pool behavior without understanding the nodes, instances, storage, and cluster resources that make the behavior possible.
A practical six-stage sequence is:
1. Baseline: read the MyLearn exam page and list every topic it currently presents. Mark each as familiar, partly understood, or new. The supplied evidence confirms the page and exam title but does not provide a verified percentage blueprint, question count, duration, passing score, languages, or prerequisite list.
2. Architecture: study the official RAC introduction and produce diagrams for standard RAC, RAC One Node, Clusterware, Grid Infrastructure, and extended-cluster concepts. Explain each diagram aloud without notes.
3. Administration core: work through ASM, Clusterware, database, instance, listener, VIP, and service relationships. Use a lab where available and record verification steps.
4. Workload and availability: compare services, Load Balancing Advisory, Runtime Connection Load Balancing, server pools, IMPORTANCE, policy-managed deployments, and administrator-managed deployments.
5. Advanced integration: revise Multitenant with RAC, Database In-Memory with RAC, Hang Manager, QoS Management, consolidation, and maintenance or failure scenarios.
6. Readiness and scheduling: review official exam instructions, test the chosen delivery environment, verify identification, and schedule only after your weak areas have been retested.
Oracle’s training page describes hands-on labs as dedicated environments for applying skills through practical use cases. Use that approach: every reading block should end with a task, a diagram, a troubleshooting explanation, or a short self-test.
How can you turn weak areas into a final revision plan?
Use evidence from your own practice rather than a vague feeling of readiness. A topic is not ready when you can recognize its vocabulary; it is ready when you can explain its purpose, choose between relevant deployment or availability options, perform or outline the administration workflow, and verify the resulting state.
Keep a defect log with four fields: misunderstood concept, misleading assumption, corrected rule, and verification method. Examples include confusing a database with an instance, treating policy-managed behavior as administrator-managed behavior, assuming every service must run on every node, or checking a cluster-wide result through only one instance.
Revisit mistakes by category. Architecture mistakes need diagrams. Configuration mistakes need a procedure and rollback. Diagnostic mistakes need a symptom-to-component map. Scheduling mistakes need a checklist and an official policy link. This prevents spending another study session rereading topics you already know.
Do not use exam dumps, leaked questions, or memorization claims as a substitute for learning. They are not a reliable way to establish current exam scope, can reinforce incorrect administration behavior, and may conflict with Oracle’s certification rules. Prepare from Oracle’s current exam page, official documentation, training, and legitimate practice activities instead.
What delivery and computer details must you verify?
Delivery requirements depend on the exam route, so first confirm whether your appointment is delivered through Oracle University or Pearson VUE. Oracle’s exam-preparation page explicitly says its listed instructions are not valid for exams scheduled and delivered by Pearson VUE. Follow the instructions attached to your actual appointment rather than mixing requirements from different vendors.
For the Oracle University online requirements supplied here, use an administrator-enabled computer with the latest Chrome or Edge on Windows 11, Windows 10, or Mac OS X (13 or later). iOS, Windows CE, Windows RT, Android, Chrome OS, and Linux are not supported. Oracle also specifies OS minimum RAM of 8 GB or more, a single display, and no mobile device or Chromebook.
The stated connection requirement is at least 3 mb/sec upload and download with a ping of less than 100 ms. Oracle advises against a mobile hotspot and requires proxy and VPN connections to be disabled and disconnected. Check the connection from the exact location and computer you intend to use.
The webcam must have a minimum resolution of 640x490 at 10 fps. Confirm that the webcam, audio, and microphone work before exam day. Oracle also requires an English QWERTY keyboard, closed applications and browsers except for the MyLearn Exam page tab, and developer mode and incognito mode turned off.
These are official online-exam requirements from https://www.oracle.com/education/certification/exam-prep/. They are not a guarantee that a particular appointment uses this delivery route. Recheck the current instructions after scheduling.
How should you handle scheduling and exam-day administration?
Oracle’s certification page states that candidates can buy an exam attempt, choose a date, and schedule the exam on Oracle MyLearn. It also states that an attempt purchased through Oracle MyLearn must be taken within six months. Check the live purchase and appointment terms before payment because availability, vendor route, and pricing information can change.
For a proctored exam, Oracle’s exam-preparation instructions require check-in at least 30 minutes before the exam start time. Candidates who try to check in after the scheduled exam time may not be admitted. Put the check-in time in your calendar separately from the appointment time and complete the system, identification, and room checks before that point.
If you need to cancel or reschedule, the supplied Oracle policy states that the action must be completed at least 24 hours before the appointment time. Missing that window risks forfeiting the exam attempt. Confirm the policy on the current page before making a change: https://www.oracle.com/education/certification/guidelines/
Government-issued identification is required for the online exam instructions supplied here. The first and last name must exactly match the registration, and the ID must be valid, government issued, and contain a recent recognizable photo. Resolve a name or identification mismatch before scheduling rather than treating it as an exam-day problem.
Oracle states that candidates may not retake an exam they have already passed. If you fail, the retake policy permits scheduling a retake with the earliest appointment date determined from the failed exam appointment date. Consult the current policy for the exact terms applying to your delivery route.
What are the most common preparation mistakes?
The costliest mistakes are usually poor scope control and weak operational practice: studying generic Oracle administration instead of RAC-specific behavior, ignoring ASM, learning commands without understanding dependencies, and scheduling before validating the delivery environment. Correct these by mapping every study activity to an official topic and requiring a practical explanation or verification step.
Mistake one is chasing an unsupported blueprint. No domain percentages, question count, exam duration, passing score, or language list is included in the supplied official evidence. Do not publish or rely on numbers from unofficial listings as though Oracle verified them. Use the current MyLearn exam page for the live scope.
Mistake two is treating RAC as a performance-only product. RAC is also about resource coordination, service placement, recovery, and availability. Include failure, relocation, workload-routing, and maintenance scenarios in revision.
Mistake three is memorizing administrator-managed and policy-managed terminology without comparing behavior. Write a side-by-side table and explain what changes when server pools control placement. Oracle specifically distinguishes the instance-to-node binding of administrator-managed deployments from the server-pool model of policy-managed deployments.
Mistake four is assuming a lab automatically covers the exam. A lab can expose procedures, but you still need architecture, decision-making, and documented reasoning. After each exercise, explain why the configuration meets the availability requirement and what changes after a node or service failure.
Mistake five is relying on dumps. Unauthorized or inaccurate materials cannot establish current scope or correct behavior. Oracle’s guidelines also state that fraudulent activities can result in forfeiture of fees and further sanctions. Study legitimate resources and protect the value of the credential.
What should you do next?
Begin with the official MyLearn exam page and the Oracle 19c RAC introduction, then make a personal gap list. Choose a lab or official workshop for the weakest practical area, build a dependency diagram, and schedule only after you can explain and verify the core RAC, ASM, Clusterware, service, and deployment-model relationships.
Use these next actions in order:
1. Confirm the current 1Z0-078 title and scope in Oracle MyLearn: https://mylearn.oracle.com/ou/exam/oracle-database-19c-rac-asm-and-grid-infrastructure-administration-1z0-078/38560/112132/172866
2. Read the official RAC introduction, especially architecture, Clusterware, services, server pools, policy-managed databases, Multitenant, In-Memory, Hang Manager, and administration tools: https://docs.oracle.com/en/database/oracle/oracle-database/19/racad/introduction-to-oracle-rac.html
3. Select focused Oracle training for ASM, Clusterware, RAC, or Data Guard based on your gap list: https://www.oracle.com/education/training/database/
4. Use the ASM Administration Workshop description to decide whether its topics match your storage needs: https://learn.oracle.com/ols/course/oracle-database-19c-asm-administration-workshop/125325/125307
5. Before scheduling, read the current exam-preparation and certification-guideline pages, confirm the vendor route, test the equipment, and check the cancellation and rescheduling window.
The practical decision is simple: schedule when your evidence comes from repeatable understanding and controlled practice, not from recognition of copied questions. If the architecture still feels fragmented, delay the appointment and close that gap first.
Conclusion
1Z0-078 preparation is strongest when RAC, ASM, and Grid Infrastructure are studied as one operating system for database availability. Build from architecture to administration, connect services and server pools to workload requirements, and use hands-on verification to expose weak assumptions. Before paying or scheduling, confirm the live Oracle scope, delivery route, system requirements, identification rules, and appointment policies. A disciplined study record and legitimate official resources provide a sounder basis for the decision than dumps or unsupported exam statistics.
Related exams
- 1z0-076 exam — Oracle Database 19c: Data Guard Administration
- 1z0-084 exam — Oracle Database 19c: Performance Management and Tuning
- 1z0-1116-23 exam — Oracle Guided Learning Content Developer Foundations Associate Rel 1
- 1z0-149 exam — Oracle Database 19c: Program with PL/SQL
- 1z0-202 exam — Siebel 8 Consultant Exam
- 1z0-532 exam — Oracle Hyperion Financial Management 11 Essentials
