Upgrade Oracle9i/10g/11g OCA or OCP to Oracle Database 12c OCP: Exam 1Z0-067 Guide
Exam 1Z0-067 is Oracle’s designated upgrade exam for candidates moving from an Oracle9i, 10g, or 11g OCA credential toward Oracle Database 12c OCP. It is most relevant to an OCA holder who needs the upgrade route, while an existing OCP holder may have a different path. This guide helps you confirm the correct credential route, separate official requirements from sensible preparation, and build a study plan around Oracle 12c upgrade administration rather than relying on question memorization.
Is 1Z0-067 the right upgrade exam for you?
The first decision is credential eligibility, not study material selection. Oracle identifies 1Z0-067 as “Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP,” so it is the specifically catalogued OCA-to-OCP upgrade examination. An existing OCP holder should verify the separate OCP upgrade route before preparing for this exam.
Oracle’s official certification catalog lists 1Z0-067 under the Oracle9i/10g/11g OCA-to-12c OCP label. That wording matters: it describes a route based on an OCA credential, not a universal examination for every Oracle administrator who has used an earlier database release.
Oracle separately documents a route in which an existing Oracle Certified Professional credential from Oracle Database 7.3 through Oracle Database 11g can be upgraded to the 12c certification version with one exam, 1Z0-060. Oracle describes that as different from the 1Z0-067 OCA-to-OCP path.
Before buying an attempt or booking preparation, write down the exact credential you hold, the database release named on it, whether you already passed a qualifying SQL examination, and whether you hold an existing Database Administrator Certified Professional credential. Then compare that information with Oracle’s current certification requirements. Do not assume that the exam title alone proves your eligibility.
A practical route check
Use this sequence: identify your current Oracle credential; locate the matching Oracle upgrade-path entry; check whether a SQL requirement is already satisfied; check any hands-on course requirement; and confirm that the selected exam is currently offered. Save the official requirement page or document used for your decision.
Oracle’s upgrade-path document states that a previously passed SQL exam satisfies the SQL requirement for later Oracle OCA and OCP credentials, so another SQL exam is not required in the applicable pathway. Treat this as a requirement check tied to the documented pathway, not as permission to skip all SQL revision.
What the exam is intended to validate
The exam is intended to assess whether an earlier-version Oracle OCA candidate can move toward Oracle Database 12c OCP through the designated upgrade examination. Oracle’s preparation seminar is described as helping candidates review the exam objectives and understand the topics and skills needed to pass 1Z0-067.
The supplied official material does not provide a complete list of 1Z0-067 objectives, domain weights, question count, passing score, exam duration, language list, or delivery format. Those details should not be filled with estimates from third-party pages. Check Oracle’s current exam record and preparation instructions for any live details.
The Oracle Database upgrade documentation provides a useful technical frame for preparation. It covers backup planning, preupgrade work, manual upgrade procedures, Database Upgrade Assistant, non-CDB scenarios, multitenant architecture, upgrade status, diagnostic logs, troubleshooting, rerunning upgrades, and restarting an upgrade from a failed phase. These are documented upgrade subjects, but the guide should not present the database documentation as a verbatim 1Z0-067 blueprint.
A strong candidate therefore prepares for decisions and procedures: how to establish a safe starting point, how to select an upgrade approach, how to verify the result, and how to investigate a failure. Memorizing isolated commands is less useful than understanding what each step protects, changes, or proves.
How to handle missing blueprint percentages
No verified domain percentages are supplied for 1Z0-067 here. Consequently, this guide does not assign weights to upgrade planning, tools, multitenant architecture, troubleshooting, or any other domain. If Oracle displays domain percentages on the current exam page, record each percentage together with its exact official domain name before allocating study time.
Do not compare bare percentages copied from an unofficial outline. A percentage without its associated exam domain can be misleading, especially when older exam versions and similarly named upgrade examinations are mixed together.
Which technical areas deserve laboratory practice?
Begin with the upgrade lifecycle, then practise the tools and failure-handling decisions that make the lifecycle credible. Oracle’s Database Upgrade Guide describes backup procedures, preupgrade checks, manual upgrades, DBUA, multitenant and non-CDB scenarios, diagnostic output, troubleshooting, reruns, and restart options. Use those subjects to structure a lab rather than treating them as disconnected facts.
For upgrade planning, document the source database release, target release, application dependencies, available rollback or recovery approach, and validation criteria. The objective of the exercise is not merely to start an upgrade; it is to show that you know what must be checked before making an irreversible operational change.
For execution, compare the documented roles of the Parallel Upgrade Utility, the dbupgrade scripts, and Database Upgrade Assistant. The Oracle documentation explains that DBUA provides a graphical interface and works for CDB and non-CDB database systems. It also describes manual upgrade work using parallel processing and related controls.
For verification, inspect the upgrade status and diagnostic information, then perform application-oriented checks. Record what evidence would tell you that the database upgrade completed, what evidence would indicate an incomplete phase, and where you would look for logs. Oracle’s documentation identifies the Automatic Diagnostic Repository and diagnostic log locations as environment-dependent, so practise locating them in your own lab rather than memorizing one path.
For recovery-oriented practice, deliberately stop a nonproduction exercise at a controlled point and study the documented rerun and restart procedures. Oracle describes options for rerunning upgrades and restarting from a specific phase after fixing errors. The valuable skill is choosing a safe next action from the recorded failure, not repeatedly executing commands until something changes.
The upgrade concepts to explain in your own words
Your notes should answer five questions. What must be backed up before an upgrade? Which preupgrade findings require remediation? When is a guided DBUA workflow appropriate compared with a manual procedure? How do CDB and non-CDB scenarios affect the plan? What evidence supports a successful postupgrade state? If you cannot answer one of these without copying a command, return to the documentation and lab.
Why version awareness matters
Older Oracle administration experience is valuable, but it can also create assumptions that no longer fit the 12c target. Oracle’s documentation notes that the function of the earlier catupgrd.sql script is replaced by the Parallel Upgrade Utility, catctl.pl, and the dbupgrade scripts. Treat changes in upgrade tooling as a study priority and verify syntax and procedure details against the documentation for the environment you are practising.
How should an experienced administrator study?
Use a gap-led plan rather than rereading every older Oracle administration topic. First map what you already do confidently in 9i, 10g, or 11g administration. Then isolate 12c upgrade differences, especially the target architecture, upgrade utilities, preupgrade and postupgrade checks, and failure recovery. Finish with timed objective review and a repeatable lab run.
A useful first pass is a two-column inventory. In the first column, list familiar administration tasks such as backups, startup and shutdown, storage, users, security, recovery, and performance observation. In the second, write what changes when the target is Oracle Database 12c. Mark each item as known, uncertain, or untested.
Study uncertain concepts from Oracle documentation before looking for practice questions. For example, if you know that an upgrade needs validation but cannot explain which checks occur before and after the operation, read the relevant upgrade sections and create a checklist. If you know DBUA by name but have never compared it with a manual upgrade, document the trade-off in your own words.
Then convert each topic into a decision card: starting condition, required checks, selected method, expected evidence, and response to failure. This format is better suited to an upgrade examination than a list of commands because it forces you to connect procedure with purpose.
Use practice questions only as an audit of understanding. When an answer seems familiar, explain why the alternatives are wrong and locate the supporting concept in the official material. Do not use dumps, leaked questions, or memorized answer patterns as a substitute for learning; they cannot establish that you understand a live upgrade scenario and may reflect an obsolete exam version.
The official learning options
Oracle describes an experienced-11g-and-prior DBA learning path as preparation for 1Z0-067. Oracle states that the path provides more than 11 hours of training and includes practice in a live environment. That makes it a useful structured option for a candidate who needs guided coverage and hands-on exposure, while it should not be treated as a guarantee of exam readiness.
Oracle also lists an official 1Z0-067 exam-preparation seminar intended to review the objectives and the topics and skills needed for the exam. The listed seminar duration is one day. A one-day seminar is best used as an orientation or review checkpoint, not as a reason to omit independent practice when your lab experience is limited.
A four-stage preparation roadmap
A staged roadmap keeps preparation focused: confirm the route, build the technical map, execute and troubleshoot a lab, and then make a readiness decision. Move forward only when you can produce evidence of understanding at each stage. This avoids spending the final study period discovering that the real gap was eligibility, multitenant concepts, or recovery procedure.
Stage one is administrative confirmation. Verify whether your credential is an OCA or OCP, check the applicable upgrade-path document, establish whether your SQL requirement is already met, and investigate the hands-on course rule. Oracle states that holders of an existing Database Administrator Certified Professional credential do not need to meet the hands-on course requirement for a later OCP credential in the applicable pathway described in its upgrade-path document. Confirm that the rule applies to your specific record.
Stage two is objective and documentation mapping. Obtain the current Oracle exam record, copy the current objectives into a checklist if they are displayed, and link each objective to a reading or lab task. Where no official weight is shown, rank topics by your own weakness and by their operational importance rather than inventing a percentage-based schedule.
Stage three is laboratory execution. Build a runbook that starts with backup and preupgrade checks, selects a documented upgrade method, records output and logs, performs postupgrade verification, and states what you would do after an error. Repeat the run after correcting the weakest step. A lab that ends at successful startup is incomplete if you cannot verify status and application behavior.
Stage four is readiness review. Close the books and explain the upgrade flow aloud or in writing. Work through unfamiliar variations such as a non-CDB procedure, a CDB-related scenario, a failed phase, or a diagnostic-log question. Review every wrong answer by concept, not by memorized option. Schedule only after you can consistently justify the sequence and the recovery decision.
A compact weekly pattern
For a working administrator, divide each study session into three parts: read one official topic, perform or inspect the corresponding lab task, and write a short decision summary. Reserve a separate session for route and policy checks. This pattern exposes the difference between recognizing terminology and being able to apply it.
At the end of each week, select one topic you can teach and one topic you still cannot troubleshoot. The second item becomes the next week’s first lab task. Keep version-specific notes clearly separated from general Oracle administration notes so that old procedures do not silently replace 12c procedures.
How to build a useful upgrade lab
A useful lab records evidence, not just successful commands. Start with a documented baseline, preserve backups or snapshots appropriate to the environment, capture preupgrade findings, and keep the upgrade output and diagnostic information. After the operation, compare the resulting state with the baseline and write down any issue that would require remediation before production use.
Use a nonproduction environment and never treat a training exercise as permission to experiment on a live database. Oracle’s upgrade documentation emphasizes backing up the database before attempting an upgrade and provides procedures for troubleshooting and rerunning an upgrade. Your lab plan should therefore include a restoration or reset method before you begin.
Create three runbook sections. The first is preparation: inventory, backup, preupgrade checks, compatibility review, and maintenance planning. The second is execution: selected utility, prerequisites, command or interface sequence, output capture, and stop conditions. The third is validation: upgrade status, logs, database access, object or component checks, application smoke tests, and documented follow-up.
Add a failure table with columns for symptom, likely phase, evidence to collect, corrective action, and whether a rerun or phase restart is appropriate. This is a practical recommendation, not an official exam format. Its purpose is to make troubleshooting systematic and to prevent a common mistake: changing several variables before identifying what actually failed.
If your environment cannot reproduce every 12c scenario, use Oracle’s documentation to create a paper simulation. Draw the sequence for a non-CDB upgrade and a multitenant upgrade, identify where the procedures differ, and state which facts would need confirmation before execution. A carefully reasoned paper exercise is still more valuable than an unverified command list.
A lab completion test
You are ready to move beyond basic reading when you can explain the purpose of each major phase, identify the evidence produced by that phase, locate the relevant diagnostic information, and select a documented response to a failure. If your only proof is that a script completed once, the lab has not yet tested operational understanding.
Common preparation mistakes
The most damaging mistakes are route confusion, obsolete procedure recall, and passive question practice. Correct them early: verify the credential path, anchor version-specific work in Oracle’s documentation, and require an explanation for every practice answer. These changes improve both study efficiency and the quality of your final readiness decision.
Mistake one is treating “OCA or OCP” as interchangeable. Oracle’s catalog specifically labels 1Z0-067 as the OCA-to-OCP upgrade exam, while Oracle documents 1Z0-060 as a different route for an existing OCP credential. Check the credential before you commit study time.
Mistake two is assuming a previously passed SQL exam must be repeated. Oracle’s upgrade-path document states that a previously passed SQL exam satisfies the SQL requirement for later Oracle OCA and OCP credentials in the applicable pathway. Verify your own record, but do not automatically schedule another SQL examination.
Mistake three is studying only the interface or only the command line. Oracle documents both DBUA and manual upgrade approaches, along with CDB and non-CDB scenarios. Even if you prefer one method operationally, understand the purpose and boundaries of the documented alternatives.
Mistake four is ignoring logs and failure recovery. A candidate who can describe a happy-path upgrade but cannot say what to inspect after an error has learned a sequence, not an administration process. Include diagnostic output, rerun behavior, and restart-from-phase decisions in every serious revision cycle.
Mistake five is trusting an old objective list or an unofficial exam profile. The supplied evidence does not establish current question count, duration, passing score, languages, pricing, or availability. Treat any such detail as unverified until Oracle’s current exam page confirms it.
Mistake six is using exam dumps. Memorized leaked material does not demonstrate upgrade competence, can contain wrong or outdated information, and does not replace a lab or official objective review. Prepare from Oracle’s materials and use legitimate practice only to identify gaps.
A better correction loop
When you miss a question, do not merely record the correct letter. Name the underlying decision, locate the official concept, reproduce it in a lab or diagram, and write one sentence explaining why the tempting alternative fails. Revisit the item later without looking at the answer. This turns an error into reusable knowledge.
What is officially known about scheduling and delivery?
Oracle’s certification site directs candidates to buy an exam attempt, schedule it through Oracle MyLearn, and take the exam after reviewing the applicable system requirements and online-exam preparation instructions. The supplied evidence does not establish the current delivery mode, price, appointment availability, or live status of 1Z0-067, so confirm those details directly before making a booking.
Oracle’s general certification page states that a purchased exam attempt gives you six months to take your exam. Because this is a current policy statement on the certification site rather than a 1Z0-067-specific exam blueprint detail, check the purchase terms shown for your account and selected exam.
Do not plan around a preferred date until Oracle’s current catalog and scheduling workflow accept the examination. Older certification references can remain searchable after a program changes. Verify the exam identifier, title, eligibility requirements, attempt terms, and system requirements in the same session in which you schedule.
If a hands-on course is required for your pathway, resolve that requirement before booking on the assumption that passing the exam alone completes the credential. Conversely, if Oracle’s documented pathway says your existing Database Administrator Certified Professional credential removes that requirement, retain the evidence and confirm that Oracle has associated the credential correctly with your account.
The scheduling checklist
Before purchase, confirm the exact exam identifier and title, the credential route, any SQL or hands-on requirement, the current delivery and system requirements, the attempt terms, and the period in which the attempt must be used. After purchase, verify that the scheduled exam appears correctly in Oracle MyLearn and keep confirmation details accessible.
How to decide whether you are ready
Readiness should be based on defensible performance, not on the number of pages read or a single practice score. You are ready to consider scheduling when you can map the official objectives, explain the end-to-end upgrade workflow, execute the core lab sequence safely, and troubleshoot a failure using evidence rather than guesswork.
Use a readiness matrix with four ratings for each topic: explain, perform, verify, and recover. “Explain” means you can describe the concept without notes. “Perform” means you can carry out the documented task in a suitable lab. “Verify” means you can identify evidence that the task succeeded. “Recover” means you can choose a safe next step when it does not.
Any topic that is only at “explain” deserves additional hands-on work. Any topic that is only at “perform” deserves written explanation, because procedural memory can conceal misunderstandings. Upgrade administration requires both execution and judgment, particularly when a procedure produces warnings or fails during a later phase.
Run one final review from a blank page. Draw the preparation, execution, validation, and recovery flow; add the tools and evidence at the appropriate points; then compare your drawing with Oracle’s documentation. Finish by checking the current exam and certification pages again, since scheduling and policy information can change independently of your study notes.
The next actions to take
First, confirm whether 1Z0-067 or the separately documented 1Z0-060 route matches your credential. Second, download or review the applicable Oracle upgrade-path material and current exam record. Third, build a lab runbook around backup, preupgrade checks, execution, validation, logs, and recovery. Fourth, use the Oracle learning path or seminar as a structured supplement, then schedule only after your readiness matrix shows no critical procedural gap.
Official sources to keep open while preparing
Use Oracle’s certification catalog and upgrade-path document for eligibility and credential decisions, Oracle Learn for the 1Z0-067 learning resources, and Oracle’s Database Upgrade Guide for technical procedure study. The certification site is the appropriate place to recheck scheduling instructions and system requirements before purchase.
The Database Upgrade Guide is technical reference material, not a promise that every listed topic appears in the examination. Likewise, a course or seminar can organize preparation but does not replace the official exam record or the certification requirements for your particular credential.
Source-use note
Prefer the current Oracle page when two sources appear to describe different routes or policies. Keep the exam identifier visible in your notes, distinguish 1Z0-067 from 1Z0-060, and do not carry forward unsupported details such as old prices, question counts, scores, or delivery claims.
Conclusion
The sensible path to 1Z0-067 begins with a credential check and ends with evidence-based readiness. Confirm whether the OCA-to-OCP route applies, verify SQL and hands-on requirements, study Oracle 12c upgrade decisions, and practise the complete lifecycle in a safe environment. Oracle’s official materials can supply the route, learning structure, and technical reference; your lab record and troubleshooting explanations should supply the confidence to decide when scheduling is justified.
