1z0-1094-23
Oracle Cloud Database 2023 Migration and Integration Professional
1z0-1094-23 Exam Guide: Oracle Cloud Database Migration and Integration Professional
The 1z0-1094-23 exam is associated with Oracle’s 2023 professional learning path for database migration and integration. Its subject matter is aimed especially at database administrators and practitioners who need to move Oracle databases to OCI, choose an appropriate migration method, and work with integration technologies. This guide helps you decide whether your current experience is sufficient, which technical areas to study first, whether hands-on practice is necessary, and what to verify before scheduling the online proctored exam.
What does 1z0-1094-23 validate?
The exam validates practical knowledge of migrating and integrating databases in Oracle Cloud, rather than isolated familiarity with product names. Preparation should connect migration planning, source and target choices, OCI Database Migration, Zero Downtime Migration, backup and replication technologies, and the operational steps required to validate and monitor a migration.
Oracle identifies database migration as a critical component of application migration. Its associated learning material presents the certification as a path for existing database administrators who want to advance their ability to migrate databases to the cloud. That makes the exam a better fit for practitioners who understand database administration than for candidates starting with no Oracle database or cloud background.
The 2023 Oracle learning path is titled “Become an Oracle Cloud Database Migration and Integration Specialist.” The available evidence does not provide a complete official blueprint, passing score, question count, or exam duration for 1z0-1094-23. Do not fill those gaps with third-party claims; use Oracle’s certification catalog and the exam registration page for the current details before booking.
Who should take this exam?
Database administrators, cloud migration engineers, Oracle consultants, and technical specialists responsible for moving databases to OCI are the clearest audience. Candidates who already troubleshoot connectivity, database users, backup procedures, and source-target compatibility will have a more useful starting point than candidates who have only watched introductory cloud videos.
Oracle’s learning path specifically says it is intended to help existing database administrators advance their knowledge to migrate databases to the cloud. The scope also suits professionals who must explain migration options to application teams, prepare source and target environments, or monitor a migration after configuration.
Use the following self-check before committing to preparation: can you explain the difference between an offline and online migration; identify the source and target components in a migration design; reason about network access and private endpoints; and describe how a migration is prepared, validated, started, monitored, and completed? If several answers are uncertain, begin with database and OCI fundamentals rather than jumping directly to practice questions.
When is another certification a better fit?
This exam is not a general OCI architecture certification and should not be treated as a substitute for broad networking, security, or operations training. If your primary responsibility is designing OCI networks, administering databases without migration work, or developing application integrations unrelated to database movement, compare Oracle’s currently available certifications and recommended learning before choosing this path.
Which technical skills should preparation cover?
Study the migration lifecycle as a connected workflow: assess the source, select the target and migration method, prepare cloud and database resources, establish secure connectivity, create the migration configuration, validate it, run the job, monitor progress, and plan the final transition. This workflow is more useful than memorizing disconnected service descriptions.
The available Oracle learning evidence identifies several skill areas: source and target database options; Oracle Zero Downtime Migration; data integration; migration to OCI using SQL Developer, Cloud Backup, and GoldenGate; and migration to Autonomous Database using RMAN, Data Pump, and cloning. Treat these as study domains, but do not assign unofficial percentage weights because no domain percentages are supplied in the research.
A sensible skills inventory is: migration planning and method selection; OCI Database Migration concepts and workflow; database preparation; network and private-endpoint requirements; offline and online migration behavior; Oracle GoldenGate and replication concepts; RMAN, Data Pump, cloning, Cloud Backup, and SQL Developer migration approaches; Autonomous Database targets; Zero Downtime Migration; and validation, monitoring, and cutover decisions.
Understand OCI Database Migration before memorizing procedures
Oracle describes OCI Database Migration as a fully managed service that moves databases in real time and at scale from one or more source databases to Oracle Cloud databases. It provides a single interface for configuring, running, and monitoring migrations. Learn what the service manages, what the administrator still has to prepare, and how migration objects represent the work.
Separate offline and online migration decisions
Offline migration uses a point-in-time snapshot copied to the target while applications remain offline. Online migration begins with an initial snapshot and then uses real-time replication of changes, allowing applications to remain online and operational during the migration. In study notes, always pair the method with its downtime, replication, validation, and cutover implications.
Know the architecture at the right level
The Oracle tutorial describes a control plane for managing migration and database connection objects through the OCI console and REST API, and a data plane that oversees ongoing migration jobs. It also explains that the managed service uses private endpoints to communicate with user resources and that customer data flows through OCI GoldenGate and Oracle Data Pump within the user’s tenancy rather than being stored by the data plane.
Map migration tools to use cases
Do not learn RMAN, Data Pump, cloning, SQL Developer, Cloud Backup, GoldenGate, and Zero Downtime Migration as interchangeable labels. For each tool, write down the migration situation it addresses, the source and target assumptions, whether the approach supports online or offline movement, and which preparation or validation tasks remain with the administrator.
What does the official documentation show you should practise?
A documented online-migration exercise provides a practical sequence for OCI Database Migration: prepare the source, prepare the target, create database connections, create the migration, validate the migration task, and start the migration. Reproduce that sequence in a lab or diagram, but replace tutorial credentials and example values with values belonging to your own environment.
The tutorial prepares an Oracle source for online migration using OCI GoldenGate by creating the common user C##GGADMIN in the container and a local user GGADMIN in the pluggable database. It also prepares a sample user and data in the source pluggable database, sets the ggadmin password in the target Autonomous Transaction Processing database, and unlocks the account.
The exercise then creates connections for the source container database, source pluggable database, and target database in the OCI Database Migration console. It creates a migration resource, validates the migration task, and starts the migration. These steps are valuable because they expose dependencies between database users, connectivity, target preparation, migration metadata, validation, and execution.
The same tutorial identifies supported target examples including Oracle Autonomous Database, Oracle Base Database Service, and Oracle Exadata Database Service on Dedicated Infrastructure. It also describes source databases located on premises, in third-party clouds, or on OCI. Use these options to practise design questions: the correct choice depends on the stated source, target, connectivity, downtime, and operational requirements.
Build a migration decision table
Create one row for each migration approach and record source type, target type, movement mechanism, downtime expectation, preparation work, and verification step. Include RMAN, Data Pump, cloning, Cloud Backup, GoldenGate-based online migration, SQL Developer, and Zero Downtime Migration. The purpose is not to predict exact questions; it is to force you to explain why one approach fits a scenario better than another.
Practise network reasoning, not only console clicks
The official tutorial uses a VCN security list with ingress rules for ports 1521, 1522, and 443. Treat this as a tutorial-specific configuration to understand, not as a universal rule for every migration. Practise identifying which endpoints must communicate, which ports and security rules are required by the selected architecture, and how a private subnet changes the setup.
Use the tutorial without copying its environment
Oracle notes that the tutorial uses example values for credentials, tenancy, and compartments and instructs learners to substitute values specific to their own cloud environment. Never publish, reuse, or expect tutorial credentials to work in another lab. Record the purpose of each step and the evidence that confirms it succeeded.
How should you prepare if you have database experience?
Start with the Oracle service model and then close gaps in OCI networking and cloud target administration. Experienced database administrators often know RMAN, Data Pump, or GoldenGate but underestimate private endpoints, OCI resource preparation, and the relationship between migration objects and migration jobs.
First, read the OCI Database Migration documentation from beginning to end, including the service overview, getting started flow, migration resources, API or SDK references, release notes, and known issues. Next, map the documentation to the Oracle learning-path topics. Finally, perform a complete migration exercise and explain every prerequisite without looking at the procedure.
Your notes should answer operational questions: what must exist before a migration is created; how source and target connections are represented; how the service validates an environment; what changes during an online migration; which activity belongs to OCI Database Migration and which belongs to GoldenGate, Data Pump, RMAN, or the database administrator; and how you would investigate a failed validation.
How should you prepare if you are new to cloud migration?
Do not begin with a large collection of exam questions. Build the missing foundations in sequence: Oracle database architecture, multitenant concepts, backup and recovery, Data Pump, replication, OCI compartments and networking, Autonomous Database, and the basic lifecycle of a managed migration service.
Use a layered study plan. Learn the purpose of each technology first, then read an implementation procedure, then perform or mentally simulate the procedure. For example, understand why online migration needs an initial copy and ongoing change replication before studying the GoldenGate user and connection setup shown in the Oracle tutorial.
Create a glossary in your own words for CDB, PDB, source database, target database, private endpoint, migration resource, migration job, validation, replication, cutover, RMAN, Data Pump, cloning, and GoldenGate. If you cannot distinguish an object that stores migration metadata from a job that executes migration or validation, return to the service documentation before advancing.
What is a practical study roadmap?
A four-stage roadmap works well when you need both conceptual coverage and implementation confidence: establish the baseline, learn the service workflow, practise migration methods, and conduct an exam-readiness review. Adjust the spacing to your work schedule; Oracle’s supplied material does not prescribe a universal preparation duration.
Stage one is an inventory. Review the official exam page and the 2023 learning path, list the technologies named in the learning material, and mark each as strong, familiar, or new. Check Oracle’s current catalog for the exact exam record, requirements, and scheduling information rather than relying on an older course page.
Stage two is service understanding. Study OCI Database Migration’s managed-service architecture, source and target support, connection objects, migration objects, migration jobs, validation, monitoring, and private communication. Draw the control-plane and data-plane relationship and annotate where GoldenGate and Data Pump participate.
Stage three is hands-on application. Work through the official online-migration tutorial, beginning with source preparation and ending with starting the migration. After the first pass, repeat the workflow from a blank page. Explain why each account, connection, network rule, and target setting is needed instead of merely following the displayed commands.
Stage four is retrieval practice. Create scenario prompts such as: an application cannot tolerate extended downtime; the source is on premises; the target is Autonomous Database; a database is in a private subnet; or validation fails after connections are created. For every prompt, state the migration approach, prerequisites, security considerations, validation evidence, and likely next investigation.
Finish with a gap review based on official topics, not a confidence score from unofficial materials. Re-read the relevant Oracle documentation for each weak area and verify current exam registration details immediately before scheduling.
A focused first study session
Read the official exam and learning-path descriptions, then write a one-page map of the migration lifecycle. Add the technologies named by Oracle and place each at the stage where it is used. This exposes whether your preparation is balanced or dominated by one familiar tool such as RMAN or GoldenGate.
A focused hands-on session
Use the Oracle tutorial to trace source preparation, target preparation, connection creation, migration creation, validation, and start. Keep a separate troubleshooting log containing the symptom, the dependency that could cause it, the documentation section to consult, and the evidence you would collect before changing configuration.
A focused final review
Review distinctions that are easy to blur: offline versus online migration; source versus target preparation; database connections versus migration resources; validation versus execution; and managed-service control functions versus data movement. Then check the official exam page for the current delivery and identification instructions.
Do you need hands-on lab practice?
Hands-on practice is strongly recommended for this subject because the official material includes a lab workflow and the service involves dependencies that are difficult to retain through reading alone. A lab is most valuable when you use it to understand preparation and diagnosis, not when you rush through commands without recording what each action changes.
Oracle University’s preparation material provides instructions for testing and configuring a system before participating in a lab, scheduling the lab, accessing the assigned environment, and requesting support. The lab material says credentials should be checked before the scheduled session and that lab access depends on a reservation; availability can therefore affect your preparation plan.
If you use an Oracle lab, schedule it early enough to leave room for a failed reservation, a connectivity issue, or a second pass. The course material includes support procedures for lab issues and warns learners not to post lab credentials in community questions. Keep credentials private and use the designated support route.
A lab is not a substitute for reading. The environment may abstract or preconfigure parts of a production architecture. After completing the exercise, revisit the OCI Database Migration documentation and identify which settings were tutorial conveniences, which were required by the architecture, and which would vary in an actual tenancy.
Which mistakes weaken preparation?
The most damaging mistake is studying service names without learning the decisions that connect them. Candidates also lose time by treating a historical course page as proof of current exam status, relying on leaked or memorized questions, ignoring networking prerequisites, and postponing the official scheduling checks until the final day.
Avoid these specific errors:
1. Treating the 2022 preparation course as the current 2023 exam record. The official course page identifies a 2022 professional exam and the page states that the event has been cancelled. Use it for concepts or lab instructions only when appropriate, and verify the current 1z0-1094-23 record in Oracle’s catalog.
2. Assuming every migration is online. Oracle’s tutorial distinguishes offline and online modes. Select a method from the application downtime requirement, source and target characteristics, replication needs, and operational plan.
3. Memorizing ports as universal answers. The tutorial shows ports 1521, 1522, and 443 in its VCN example. Learn how to reason about required connectivity for the stated architecture rather than copying a rule into every scenario.
4. Skipping validation. The documented workflow includes validating the migration task before starting it. Make validation evidence part of every practice run.
5. Confusing preparation with execution. Creating a target user, configuring a connection, creating a migration resource, validating it, and starting a job are different actions with different failure points.
6. Relying on exam dumps. Unauthorised or leaked content cannot replace understanding and may be inaccurate or against certification rules. Use official learning, documentation, labs, and your own scenario notes.
7. Ignoring version and catalog context. Oracle’s available pages include material for different years. Confirm that the learning path, exam record, and registration information you use correspond to the exam you intend to take.
What are the online delivery requirements?
The official exam page identifies the format as an online proctored exam. It requires a desktop or laptop with a reliable internet connection, microphone, and webcam; a system configuration check and secure browser installation; a quiet testing room; and government-issued photo identification. Check the current registration instructions because technical requirements and policies can change.
Oracle states that check-in is 30 minutes before the exam start time. The registration page also says that two forms of government-issued photo identification are required at exam check-in and that the name entered for registration must match the real government-issued ID exactly.
Before scheduling, run Oracle’s system configuration and precheck, install the required secure browser, confirm that your camera and microphone work, and choose a private room without interruptions. Do not wait until the exam appointment to discover that an operating-system, browser, network, or identification detail needs attention.
The supplied exam page does not expose a usable value for exam duration; its page text ends with “Duration: 1.” Do not rely on an inferred duration. Confirm the current value in Oracle’s registration flow or official exam record before making time-management plans.
What should you verify before booking?
Confirm the exact exam identifier and title in Oracle’s certification catalog, review the current exam topics and recommended learning, check available dates and time zones, and read the online-proctoring instructions. Oracle’s certification portal directs candidates to register for a selected exam and explore exam topics, recommended learning, and certification requirements.
What should you do on exam day?
Have the required identification available, use the prepared computer and testing space, and begin check-in 30 minutes before the scheduled start time. Keep the registration name consistent with the identification. If a technical issue occurs, follow the support instructions supplied by Oracle rather than attempting unapproved workarounds.
How should you use Oracle’s official resources?
Use each source for a different job. The exam page is the authority for current registration and delivery information; the 2023 learning path establishes the intended learning direction; the OCI Database Migration documentation explains the service; and the online-migration tutorial supplies a concrete implementation sequence.
Start with the exam page at https://learn.oracle.com/ols/exam/become-an-oracle-cloud-database-migration-and-integration-specialist/35573/92250/146400 and compare it with the related Oracle page at https://learn.oracle.com/ols/exam/become-an-oracle-cloud-database-migration-and-integration-specialist/35644/92250/146400. If either page presents incomplete or conflicting registration detail, use Oracle’s certification portal rather than guessing.
Read the service overview at https://docs.oracle.com/en/cloud/paas/database-migration/. Then use the hands-on tutorial at https://docs.oracle.com/en/learn/ocidms-online-mgrt/ to connect concepts with actions. The tutorial is especially useful for source and target preparation, database connections, migration creation, validation, and starting a migration.
Use the 2023 learning-path record at https://mylearn.oracle.com/ou/learning-path/become-an-oracle-cloud-database-migration-and-integration-2023-professional/122246 to organize preparation. The older preparation module at https://learn.oracle.com/ols/module/prepare-for-oracle-cloud-database-migration-professional/118071/139586 and course at https://learn.oracle.com/ols/course/prepare-for-oracle-cloud-database-migration-and-integration-professional-2022/88258/110195 may contain useful preparation and lab context, but the course page identifies a 2022 offering and says the event has been cancelled.
For broad registration and policy navigation, use https://www.oracle.com/education/certification/. Oracle’s portal describes preparation, scheduling, exam taking, and certification browsing as separate steps. That separation is useful: study decisions belong in your learning plan, while appointment and policy decisions belong in the current registration workflow.
How do you know you are ready to schedule?
Schedule when you can explain the migration lifecycle and justify a method in unfamiliar scenarios, not merely when you can repeat a lab. Readiness means you can connect source preparation, target preparation, networking, migration configuration, validation, replication, monitoring, and cutover into one coherent operational plan.
Use this readiness test without treating it as an official scoring formula:
- Explain what OCI Database Migration manages and what remains the administrator’s responsibility.
- Distinguish offline migration from online migration and state the operational consequence of each.
- Describe the role of the control plane, data plane, private endpoints, GoldenGate, and Data Pump at a useful architectural level.
- Select among RMAN, Data Pump, cloning, Cloud Backup, SQL Developer, GoldenGate, and Zero Downtime Migration when a scenario supplies different constraints.
- Walk through source preparation, target preparation, connection creation, migration creation, validation, and execution.
- Diagnose likely categories of failure involving users, credentials, private subnet access, security rules, database connections, and target readiness.
- Locate the current Oracle exam registration, delivery, identification, and system-precheck instructions without relying on an archived page.
If you can perform those tasks but one technology remains weak, target that gap with documentation and a focused lab exercise. If the workflow itself is unclear, postpone scheduling and rebuild the lifecycle map before attempting more questions.
What should you do next?
Begin by opening Oracle’s current certification and exam pages, confirming the 1z0-1094-23 record, and saving the current topic and registration information. Then read the OCI Database Migration overview, create a skills inventory, and reserve hands-on time only after you understand the workflow you intend to practise.
A practical next sequence is:
1. Verify the current exam identifier, recommended learning, requirements, and online delivery instructions in Oracle’s official catalog.
2. Read the OCI Database Migration service overview and sketch its migration lifecycle and architecture.
3. Study the 2023 learning path topics, giving special attention to source and target options, Zero Downtime Migration, data integration, SQL Developer, Cloud Backup, GoldenGate, RMAN, Data Pump, and cloning.
4. Work through the official online-migration tutorial and document the reason for every preparation and validation step.
5. Test yourself with scenario explanations that require a method choice and an operational justification.
6. Run Oracle’s system precheck, prepare identification, and confirm the current check-in instructions before booking or attending the exam.
This approach keeps preparation evidence-led and protects you from two common traps: mistaking an older training page for current exam information and mistaking memorization for migration competence.
Conclusion
The strongest preparation for 1z0-1094-23 is a combination of current Oracle registration information, service documentation, structured learning, and hands-on reasoning through a migration workflow. Focus on why a migration method fits a situation, how source and target environments are prepared, how OCI Database Migration coordinates the work, and how validation and connectivity affect execution. Once you can explain and reproduce that process, confirm the live exam requirements and schedule through Oracle rather than relying on incomplete historical details or unofficial question material.