1Z0-062 Question #227: Real Exam Question with Answer & Explanation

The correct answer is A: running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file. Before a manual upgrade from Oracle Database 11g to 12c, you must run the pre-upgrade script, copy the initialization parameter file, and copy network configuration files to the new Oracle home.

Question

You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c. Which three tasks should be performed before a manual upgrade?

Options

Arunning preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file
Brunning utlu121s.sql from the new Oracle home to display information about the required
Ccopying the initialization parameter file to the new Oracle home
Dcopying the password file to the new Oracle home
Ecopying net configuration files to the new Oracle home

Explanation

Before a manual upgrade from Oracle Database 11g to 12c, you must run the pre-upgrade script, copy the initialization parameter file, and copy network configuration files to the new Oracle home.

Common mistakes.

B. The pre-upgrade utility must be executed from the source Oracle 11g home against the existing database, not from the new Oracle 12c home, because it needs to inspect the current database state and version-specific objects.
D. In Oracle 12c the password file format changed to support longer user names and case-sensitive passwords, so the old 11g password file should not simply be copied - a new one should be created in the new Oracle home using orapwd.

Concept tested. Oracle Database 11g to 12c manual upgrade pre-upgrade tasks

Reference. https://docs.oracle.com/database/121/UPGRD/preup.htm

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice