1z0-078
Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration
1Z0-078 Exam Guide: Oracle Database 19c RAC, ASM, and Grid Infrastructure Administration
The 1Z0-078 exam validates administration knowledge for Oracle Database 19c environments using Real Application Clusters, Automatic Storage Management, and Grid Infrastructure. Oracle places it in the High Availability section of its certification catalog. It is most relevant to database administrators, infrastructure engineers, and professionals responsible for clustered database availability. This guide helps you decide whether your experience is ready, which technical areas need hands-on practice, how to sequence your study, and what to confirm before scheduling.
What 1Z0-078 is designed to validate
1Z0-078 is titled “Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration.” Its subject matter combines clustered database administration with storage and cluster-management responsibilities, so preparation should connect individual commands and components to availability, workload placement, and recovery decisions.
Oracle’s certification catalog places the exam in the High Availability section. That classification is useful when judging fit: this is not simply a general SQL or single-instance administration exam. The relevant skill is understanding how Oracle Database 19c operates when multiple instances, shared storage, services, and cluster infrastructure must work together.
The official Oracle MyLearn page provides a dedicated exam entry for this certification. Use that page, rather than an unofficial topic list, to confirm the current exam information before committing to a schedule. Oracle certification pages can change as exam versions and program arrangements are updated.
Who should consider it
The strongest candidates are administrators who already understand Oracle Database operations and now need to manage RAC, ASM, and Grid Infrastructure. It can also suit engineers who support clustered platforms, database availability, storage layout, service placement, or operational maintenance.
A candidate who has only studied single-instance administration should treat the exam as a progression rather than a routine extension. RAC introduces shared database access by multiple instances, instance-specific resources, interconnect communication, services, clusterware, and workload-management choices. Those relationships are difficult to learn through terminology review alone.
What the credential does not prove by itself
Passing an administration exam does not automatically demonstrate that someone has designed a complete disaster-recovery architecture or operated every production failure scenario. Oracle’s RAC documentation distinguishes extended-cluster availability from broader disaster-recovery requirements and discusses Oracle Data Guard with RAC for comprehensive disaster protection.
Use the credential as evidence of validated exam knowledge, then assess practical readiness separately. Production responsibility still requires change control, version compatibility checks, backup and recovery planning, monitoring, security procedures, and experience with the organization’s specific infrastructure.
The technical model you need before studying details
Start with the RAC architecture: several instances can access one database, while the instances use the same interconnect and Oracle Clusterware provides the infrastructure that binds the servers into one system. Once this model is clear, ASM, services, server pools, and administration tools become easier to place in context.
In a non-cluster database, the database and instance have a one-to-one relationship. Oracle RAC changes that relationship to one database with multiple instances. Each RAC instance has an additional redo thread and an instance-specific undo tablespace. The combined processing power of multiple servers can provide throughput and scalability beyond a single server.
Oracle Clusterware is required for Oracle RAC and manages resources including VIP addresses, databases, listeners, and services. Oracle Clusterware and ASM together form Oracle Grid Infrastructure, which provides clustered storage and cluster-management capabilities for RAC and non-cluster databases.
Build a diagram before memorizing commands. Show the servers, instances, shared database files, interconnect, Clusterware, ASM disk groups, listeners, and services. Then annotate which items are shared and which are instance-specific. This simple separation prevents many conceptual errors.
The role of ASM and Grid Infrastructure
ASM is not just a storage label to memorize. Study how it participates in the Grid Infrastructure layer and how disk groups, ASM instances, ASM files, directories, and templates support database storage. Oracle’s official ASM Administration Workshop specifically covers ASM instances, Flex ASM, ASM disk groups, ASM files, directories and templates, and Oracle ACFS/ADVM enhancements.
When reading storage scenarios, ask what the administrator is trying to achieve: shared access, redundancy, capacity management, file placement, or availability during maintenance. Record the reason for each configuration choice, not only the syntax used to implement it.
The administration tools and their scope
Oracle describes RAC administration as a single-system-image activity using SRVCTL, Oracle Enterprise Manager, SQL*Plus, and other utilities. However, the tools do not all express the same scope. SQL*Plus commands operate on the current instance, which may be the local default instance or a remote instance reached through Oracle Net Services.
For every procedure you study, write down whether it affects the current instance, the database, a service, a node, a disk group, or the cluster. This habit is more valuable than copying command sequences because it helps you evaluate the consequences of an answer in a multi-instance environment.
The measured skill areas to organize your preparation around
The supplied official research does not provide a verified percentage blueprint or a complete domain-by-domain objective list for 1Z0-078. Do not assign invented weights to RAC, ASM, or Clusterware. Instead, organize study around the technical areas Oracle documents for RAC administration and verify the current objectives on Oracle MyLearn before scheduling.
The RAC documentation’s overview includes RAC architecture and installation, RAC One Node, Clusterware, automatic workload management with dynamic database services, server pools and policy-managed databases, Database Quality of Service Management, Hang Manager, Multitenant with RAC, Database In-Memory with RAC, and RAC environment management.
This is a study map, not a claim that each topic carries a particular exam percentage. If the current Oracle exam page supplies measured domains or percentages, copy each domain label with its associated percentage into your own checklist. Never compare bare percentages without their official domain names.
RAC architecture, Clusterware, and installation concepts
Understand the infrastructure required for concurrent access to shared storage and data files, interprocess communication across nodes, a combined cache view, and node-status monitoring. Clusterware supplies node membership, group services, global resource management, and high-availability functions.
Review the installation relationship between Grid Infrastructure and database software. For mixed database versions in one cluster, Oracle states that Grid Infrastructure must be the same version as, or higher than, the highest Oracle Database version deployed in that cluster. Treat compatibility as a decision to verify from current Oracle documentation, not as a shortcut based on memory.
Services and automatic workload management
Services group workloads, route work to suitable instances, and support high availability during planned and unplanned actions. Study service characteristics such as workload balancing, failover, preferred availability, and the way client and server-side components use service names.
Load Balancing Advisory provides applications with information about current service levels from the database and its instances. Runtime Connection Load Balancing enables Oracle clients to allocate connection-pool connections according to the service level provided by database instances. Learn these as connected mechanisms rather than isolated definitions.
Server pools and policy-managed databases
Distinguish administrator-managed deployment from policy-managed deployment. Administrator-managed databases bind instances to specific nodes, while policy-managed databases use server pools and allow resource placement to be controlled through pool properties.
Policy-managed databases can use instance caging and server-pool sizing to adjust database capacity horizontally and vertically. Server-pool minimum, maximum, and importance settings influence placement, availability, and priority. A useful exercise is to explain what should happen when demand rises, a server fails, or a lower-priority workload must yield resources.
RAC One Node, Multitenant, and Database In-Memory
Study RAC One Node as a high-availability deployment with different placement and failover considerations from a multinode RAC database. Oracle notes that a policy-managed RAC One Node database needs a server pool configured with a server available for failover; administrator-managed deployments require attention to the candidate node list.
For Multitenant with RAC, understand how services determine where a PDB is available. A PDB can be made available on every instance or on a subset of instances. The CDB is typically managed by services running on the PDB, so service placement is central to the operational model.
For Database In-Memory with RAC, focus on instance-level behavior and configuration boundaries. Oracle states that the INMEMORY_SIZE setting in each RAC database instance must not exceed 16 GB. If an RAC node does not require an IM column store, Oracle documents setting INMEMORY_SIZE to 0.
Monitoring, Hang Manager, and operational administration
Review the purpose of Hang Manager, which can identify system hangs and, in later functionality, attempt to resolve them. Also connect monitoring to the wider administration workflow: identify the affected instance or service, inspect the relevant resource state, and choose a controlled corrective action.
Do not study monitoring as a list of alert messages. For each symptom, write a short chain: what users experience, which cluster component may be involved, what evidence you would collect, and what action could preserve availability. This develops the reasoning needed for scenario-based questions without relying on leaked or purported live questions.
How to prepare when your experience is uneven
Use your weakest operational area to determine the first study block, not the topic you already know best. A RAC administrator with little ASM practice should begin with storage architecture and disk-group operations; an ASM specialist should spend more time on services, server pools, failover, and multi-instance behavior.
Make a skills inventory with three columns: can explain, can perform in a lab, and needs review. Put RAC architecture, Clusterware, ASM, services, policy-managed deployment, RAC One Node, Multitenant, In-Memory, monitoring, and administration tools into the inventory. Reassess it after each lab rather than treating course completion as proof of readiness.
A practical resource sequence
Begin with the official MyLearn exam page and the current Oracle certification catalog entry. Confirm the exam title and any current learning recommendations. Then read the Oracle RAC introduction to establish architecture and terminology before moving into procedural training.
Use Oracle’s database training page to identify relevant official learning options. It lists separate workshops for Clusterware Administration, ASM Administration, RAC Administration, and Data Guard Administration. Select training according to your gap; do not assume that completing every course is necessary or that a single workshop covers the entire exam.
The official ASM Administration Workshop is particularly relevant for candidates who need structured practice with ASM instances, Flex ASM, disk groups, ASM files, directories and templates, and ACFS/ADVM enhancements. The available course page indicates that hands-on lab access and scheduling are handled through Oracle’s learning environment, so verify current availability before planning around it.
How to read Oracle documentation actively
Read each section with a decision question in mind. For example: which component owns this resource, what changes across instances, what happens after a node failure, and which service or server-pool setting controls placement? Capture the answer in your own words, then verify it against the documentation.
Create a one-page relationship map for Clusterware, ASM, RAC instances, services, server pools, PDBs, and client connection behavior. Add a second page for distinctions that are easy to confuse, such as shared versus local temporary files, administrator-managed versus policy-managed databases, and database-wide versus instance-specific settings.
A staged study roadmap you can adapt
A useful roadmap moves from architecture to controlled administration, then to failure and workload scenarios. Do not begin with random practice questions. First build a model of the platform, then verify it by performing or tracing tasks, and finally test whether you can explain why one configuration is preferable to another.
Adjust the pace to your existing Oracle experience and access to a practice environment. The stages below are a sequence of work, not a promise that a fixed number of days or hours is sufficient for every candidate.
Stage one: establish the platform model
Read the RAC introduction and draw the complete component map. Explain the database-to-instance relationship, the interconnect, Clusterware, ASM, services, and the role of Grid Infrastructure without looking at notes.
At the end of this stage, you should be able to answer basic architecture questions in operational language: why Clusterware is required, why instances need instance-specific redo and undo, what shared storage enables, and which functions Clusterware manages. If you cannot explain these clearly, postpone detailed syntax study.
Stage two: build storage and cluster administration fluency
Work through ASM topics in a deliberate order: ASM instances, disk groups, file management, directories and templates, Flex ASM, and related storage features. For every exercise, record the starting state, command or interface used, expected result, and verification query or observation.
Then connect storage administration to Grid Infrastructure and RAC. A disk-group action is not complete merely because the command succeeds; you should know which database files or cluster services depend on it and what availability implications follow.
Stage three: study workload placement and availability
Practice explaining services, Load Balancing Advisory, Runtime Connection Load Balancing, server pools, importance, minimum and maximum sizing, and policy-managed databases as one workload-management system.
Use scenarios rather than isolated flashcards. Ask how you would prioritize a business-critical service, keep a failover server available, place a PDB on selected instances, or preserve important services when cluster capacity is reduced. Oracle documents that server-pool importance can cause higher-priority services to start first and remain available after a multinode failure, which makes priority a practical availability control rather than a cosmetic setting.
Stage four: integrate special topics and troubleshooting
Review RAC One Node, Multitenant with RAC, Database In-Memory with RAC, Hang Manager, local temporary tablespaces, and administration utilities. Relate each topic to the instance, database, service, or cluster scope it affects.
Use troubleshooting drills: a service is not reaching the intended instances; a PDB is unavailable where expected; a node cannot provide the required failover capacity; a temporary file view shows instance-specific information; or a workload must be deprioritized during a resource shortage. For each drill, identify evidence before proposing a change.
Stage five: perform a readiness review
Revisit the current official exam page and compare its objectives with your skills inventory. Mark a topic as ready only when you can explain its architecture, recognize a configuration choice, and carry out or verify a representative task in an approved lab or practice environment.
Use practice questions only as a diagnostic tool. Review every wrong answer against Oracle documentation and write why the selected option was wrong. Avoid dumps, leaked questions, and memorization claims; they do not replace understanding and may violate certification rules.
Hands-on practice that produces useful evidence
Hands-on work should force you to observe scope, dependencies, and recovery behavior. A lab session is most valuable when you begin with a hypothesis, make one controlled change, and verify its effect through the appropriate cluster, database, service, or storage view.
If you use Oracle training labs, read the current access instructions carefully. The supplied ASM workshop page contains lab scheduling and environment information, but its displayed availability and session details are not a permanent guarantee. Confirm that the lab is available and suitable before making it the foundation of your schedule.
High-value exercises
Create a component inventory for the lab and identify which resources are managed by Clusterware. Practice observing ASM disk groups and database storage, then connect those observations to the RAC database and its instances.
Create or inspect services and document which instances offer them. Trace how service placement affects application access and workload routing. Compare the reasoning for a service that should run broadly with the reasoning for a service deliberately restricted to selected instances.
Compare administrator-managed and policy-managed deployment in a written scenario. Explain how node binding, server pools, minimum and maximum sizes, importance, and instance caging change the available operational controls.
Practice Multitenant placement decisions by describing how a PDB becomes available on instances where its dynamic service runs. Separately, review instance-level In-Memory settings and identify when an instance should not use an IM column store.
What to record after each lab
Keep a change log with five fields: objective, initial state, action, verification, and lesson. Add a sixth field for rollback or recovery. This turns lab time into reusable revision material and exposes gaps that passive video viewing can hide.
Do not copy credentials, screenshots containing secrets, or proprietary configuration into public notes. Oracle’s learning page warns users not to share lab credentials in community posts. Keep your study record technical, sanitized, and private.
Mistakes that commonly weaken preparation
The most damaging preparation errors are not usually a missing command; they are incorrect assumptions about scope, availability, and version context. Correct them by tying every fact to a component and a scenario, then verifying current details in Oracle sources.
Avoid treating the following habits as harmless shortcuts.
Memorizing commands without ownership
A command can be syntactically familiar while its effect remains unclear. Before learning a procedure, identify whether it changes a service, instance, database, node, disk group, or cluster policy. Then learn how to verify the result and how to reverse it safely.
Confusing RAC with disaster recovery
RAC improves availability and scalability within its architecture, but it is not a universal substitute for disaster recovery. Oracle’s documentation notes that an extended cluster may not satisfy every disaster-recovery requirement and recommends considering Data Guard with RAC for comprehensive protection against disasters, including regional disasters.
Ignoring deployment style
Do not apply policy-managed assumptions to administrator-managed databases. Administrator-managed databases do not run in server pools, so changing server-pool size cannot expand or shrink their number of instances. Write comparison tables and test each scenario against the deployment model named in the question.
Treating services as aliases only
Services are workload and availability controls. They influence routing, balancing, failover, PDB availability, and the prioritization of applications. Study why a service is configured a certain way, not just how its name appears in a command.
Relying on an outdated or unofficial blueprint
The supplied research does not verify percentage weights for 1Z0-078. Do not build a study plan around an unverified domain breakdown or a third-party claim about question distribution. Check Oracle MyLearn and the current Oracle certification resources immediately before finalizing your priorities.
Scheduling and exam-day planning
Schedule only after confirming the current exam entry, delivery route, price currency, and available appointment information through Oracle or the applicable test vendor. Oracle states that candidates can buy an exam attempt, choose a date, and schedule through Oracle MyLearn, and that an attempt purchased through MyLearn must be taken within six months.
Delivery instructions differ by provider. Oracle’s exam-preparation page explicitly says its instructions are not valid for exams scheduled and delivered by Pearson VUE. Identify your provider first, then follow that provider’s current requirements rather than combining instructions from different pages.
If your exam uses Oracle University’s proctored process
The Oracle University preparation page states that proctored candidates must check in at least 30 minutes before the exam start time. It also lists supported operating-system and browser requirements, a single-display restriction, minimum connection and RAM requirements, webcam and microphone requirements, and identification rules. Run the official readiness check and recheck the page before the appointment because technical requirements can change.
The same page states that pen and paper are not allowed, while a digital whiteboard is available in the exam delivery platform. Prepare to work without physical notes and make sure your browser, microphone, webcam, and network satisfy the current published requirements.
Protecting the appointment
Oracle’s certification guidance states that cancellation and rescheduling must be completed at least 24 hours before the appointment. Missing that window may put the exam attempt at risk. Treat the appointment as a commitment only after your identity document, computer, network, room, and provider instructions are ready.
Oracle also warns that candidates who try to check in after the scheduled exam time may not be admitted. Put the check-in time on your calendar separately from the exam start time and allow room for the required checks.
Rules and retakes
Oracle states that candidates may not retake an exam they have already passed. Its guidelines also describe retake arrangements for failed exams and prohibit attempts to bypass policy by creating a new identity. Read the current policy before scheduling a retake rather than assuming that a previous Oracle exam’s rules apply.
Fraudulent activity can result in forfeited fees and additional sanctions. Use legitimate study materials, respect the candidate agreement, and treat practice questions as learning aids rather than substitutes for preparation.
How to decide whether you are ready
You are closer to readiness when you can reason through a new RAC administration scenario without relying on a memorized phrase. In particular, you should be able to identify the affected layer, distinguish shared from instance-specific behavior, select the relevant tool or configuration, and explain the availability consequence.
Use the following decision test before scheduling: can you explain the RAC and Grid Infrastructure architecture; distinguish ASM, Clusterware, instances, databases, and services; compare administrator-managed and policy-managed deployment; reason about service placement and server-pool priority; and interpret Multitenant, In-Memory, monitoring, and temporary-storage scenarios?
If several answers are “not yet,” schedule more lab and documentation time. If the gaps are limited to terminology, use targeted notes and verification exercises. Do not use a high practice-question score as the only readiness measure, particularly when the questions come from an unverified source.
A final review checklist
Confirm the current 1Z0-078 title and objectives on Oracle MyLearn. Confirm the delivery provider and follow only its current technical instructions. Check identification, browser, operating system, display, network, camera, microphone, and check-in requirements where applicable.
Review your architecture diagram and deployment-style comparison. Rehearse explaining service placement, server-pool importance, failover capacity, ASM responsibilities, Clusterware responsibilities, and the difference between database-wide and instance-specific settings.
Prepare a short list of official references for last-minute clarification, but do not attempt to learn a large new topic immediately before the exam. Focus on relationships, decision rules, and evidence-based troubleshooting.
What to do next
Open the official MyLearn page and record the current exam information. Then compare its stated preparation resources with your own skills inventory. Choose one architecture review, one ASM or Clusterware lab, and one services or server-pool scenario as your immediate next actions.
After those activities, update your readiness decision. If you can explain the outcome and verify the changes, move to integrated review. If you cannot, keep the appointment unscheduled until the missing foundation is addressed. This approach makes the certification decision deliberate: you are preparing for the administration responsibilities represented by 1Z0-078, not merely collecting isolated facts.
Conclusion
1Z0-078 preparation is strongest when RAC architecture, ASM storage, Grid Infrastructure, services, and availability decisions are studied as one operating system rather than separate vocabulary lists. Use Oracle’s current exam page to confirm objectives and scheduling details, use the RAC documentation to test your technical reasoning, and use hands-on work to verify scope and consequences. Schedule when you can explain and validate the major administration choices, not when an unofficial question source suggests that you are ready.
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