As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the
new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?
A.
Start up the database instance by using the new location of the server parameter file and run the
catuppst.sqi script to generate informational messages and log files during the upgrade.B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl
script from the new Oracle home to use parallel upgrade options that reduce down time.
C.
Start up the database instance by using the STARTUP UPGRADE command and gather fixed object
statistics to minimize the time needed for recompilation.
D.
Start up the database instance by using the STARTUP UPGRADE command, which opens the existing
database, and then performs additional upgrade operations.
ans A?
Ans: D
https://docs.oracle.com/database/121/UPGRD/upgrade.htm#CHDBHAHE
Refer section 3.4 and Step 10
How about B’s answer?
Refer section 3.4 and Step 12
Not sure. I still think its D. Because catcl.pl is run only after issuing the STARTUP UPGRADE command. So the immediate next step is STARTUP UPGRADE command. Please advise if you think otherwise. This is little tricky. 🙁