Oracle Database 12c: Installation and Administration — Question 53

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? (Choose three.)

Answer options

• A. running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file
• B. running utlu121s.sql from the new Oracle home to display information about the required initialization parameters
• C. copying the initialization parameter file to the new Oracle home
• D. copying the password file to the new Oracle home
• E. copying net configuration files to the new Oracle home

Correct answer: A, C, E

Explanation

The correct answer includes running preupgrad.sql to prepare for the upgrade, copying the initialization parameter file, and copying net configuration files, which are essential for the upgrade process. Option B is not necessary before the manual upgrade, and option D regarding the password file is not required for the upgrade preparation.