Which step should you perform next to start the upgrade of the database?

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?

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.

Show Hint

Leave a Reply 16

Your email address will not be published. Required fields are marked *

Siegfried

Siegfried

B
http://docs.oracle.com/database/121/UPGRD/upgrade.htm#CHDBHAHE
10. Start the instance by issuing the following command in SQL*Plus:

SQL> startup upgrade pfile=pfile_name

12. Run the catctl.pl script from the new Oracle home as described in this step. The Parallel Upgrade Utility, catctl.pl, provides parallel upgrade options that reduce downtime.

Reply

Vonpire

Vonpire

I don’t know… For begin upgrade you have to issue startup upgrade at all times. I don’t see the startup upgrade in answer B.

I think D maybe is correct..

I don’t think C is correct because you should collect statistics prior to upgrade…

*****************************************
********* Dictionary Statistics *********
*****************************************

Please gather dictionary statistics 24 hours prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;

Reply

Anthony

Anthony

Vonpire,

I think is D too, but I have some doubts, because is necessary execute the script catctl.pl.

Reply

modi

modi

Can anyone confirm which answer worked?

Reply

Steve

Steve

B

STARTUP UPGRADE doesn’t perform “additional upgrade operations”, and the question is asking what you should do to start the upgrade process.

Reply

Vonpire

Vonpire

I understand the answer as I would perform aditional upgrade options.

I read , and them perform (the user) instead of and them performs (the command).

If answer is really that way B indeed seems most probable.

Reply

RNW

RNW

D is the safest bet. As obviously the database was just shut down – so what will u do next? Startup Upgrade – followed by other tasks.

Reply

Harry

Harry

That’s correct
Answer is B
Start the database in upgrade mode.

$ sqlplus / as sysdba

SQL> STARTUP UPGRADE;
SQL> EXIT;
Run the new Parallel Upgrade Utility (catctl.pl).

$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql

Reply