11.2.0.4 Upgrade to 12.1.0.2

Before the database upgrade, the source database checks:

$ cd/u01/app/oracle12/product/12.1.0/dbhome_1/rdbms/Admin #进入12c软件的安装home目录 $ sqlplus'/as sysdba'SQL*plus:release11.2.0.4.0Production on Thu6  Geneva: the: +  -Copyright (c)1982, -, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition Release11.2.0.4.0-64bit Productionwith The partitioning, OLAP, Data Mining and Real application testing Optionssql>@preupgrd. sqlloading Pre-Upgrade Package ...***************************************************************************executing Pre-upgrade ChecksinchYB ...***************************************************************************      ************************************ ====>> ERRORS FOUND forYB <<====The following isERROR Level CONDITIONS * * *That must is addressed prior to attempting your upgrade. Failure to DoSo would resultincha failed upgrade. Must resolve the above errors prior to upgrade************************************************************      *************************************************** ====>> pre-upgrade RESULTS forYB <<====ACTIONS REQUIRED:1. Review results of the pre-Upgrade Checks:/u01/app/oracle/cfgtoollogs/yb/preupgrade/Preupgrade.log2. ExecuteinchThe SOURCE environment before upgrade:/u01/app/oracle/cfgtoollogs/yb/preupgrade/Preupgrade_fixups.sql3. ExecuteinchThe NEW environment after upgrade:/u01/app/oracle/cfgtoollogs/yb/preupgrade/Postupgrade_fixups.sql*************************************************************************************************************** ************************Pre-upgrade ChecksinchYB completed.*************************************************************************************************************** *************************************************************************************************************** ***SQL>

Execute the script that was generated in the previous step:/u01/app/oracle/cfgtoollogs/yb/preupgrade/preupgrade_fixups.sql

Sql> @/u01/app/oracle/cfgtoollogs/yb/preupgrade/Preupgrade_fixups.sqlpre-upgrade fixup Script Generated on -- ,- .  Geneva: -: onVersion:12.1.0.2Build:006Beginning Pre-Upgrade fixups ... ExecutinginchContainer YB**********************************************************************Check tag:default_process_countcheck summary:verify min PROCESS count isNot too lowfix summary:review and increaseifneeded, your PROCESSES value.**********************************************************************fixup returned information:warning:-process count May is too low Database have a maximum Process count of Maxwhich islower than thedefaultValue of -  for  Thisrelease. You should update your processes value prior to the upgrade to a value of at least -. For Example:alter SYSTEM SET PROCESSES= -Scope=SPFILE or update your Init.ora file.*************************************************************************************************************** *****************************Check Tag:em_presentcheck Summary:checkifEnterprise Manager isPresentfix Summary:execute emremove.sql prior to upgrade.**********************************************************************fixup returned information:warning:-Enterprise Manager Database Control repository foundinchthe database in Oracle database 12c, the database Control isremoved during the upgrade. To save time during the Upgrade, Thisaction can be do prior to upgradingusingThe following steps after copying RDBMS/admin/emremove.sql fromTheNewOracle Home-Stop EM Database Control: $>emctl Stop Dbconsole-Connect to the DatabaseusingThe SYS account as sysdba:set ECHO on;   SET serveroutput on; @emremove. SQL without theSetEcho and Serveroutput commands you are not being able to follow the progress of the script.*************************************************************************************************************** *****************************Check Tag:amd_existscheck Summary:check to seeifAmd isPresentinchThe databasefix summary:manually execute oracle_home/oraolap/admin/catnoamd.sql script to remove OLAP.**********************************************************************fixup returned information:information:--OLAP Catalog (AMD) existsinchdatabase starting with Oracle database 12c, OLAP Catalog component isdesupported. If You is notusingthe OLAP Catalog component and want to remove it, then execute the oracle_home/olap/admin/Catnoamd.sql script before or after the upgrade.*************************************************************************************************************** *****************************Check Tag:apex_upgrade_msgcheck Summary:check that APEX would need to be upgraded. Fix summary:oracle Application Express can be manually upgraded prior to database upgrade.**********************************************************************fixup returned information:information:-Oracle Application Express (APEX) can is manually upgraded prior to database upgrade APEX isCurrently at version3.2.1.00. Aand would need to being upgraded to APEX version4.2.5 inchTheNewrelease. Note1: To reduce Database upgrade time, APEX can is manually upgraded outside of and prior to database upgrade     . Note2: See MOS Note1088970.1  forinformation on APEX installation upgrades.*************************************************************************************************************** *****************************[Pre-Upgrade Recommendations]**********************************************************************                        **************************** Dictionary Statistics ********* ******************** *********************Please gather dictionary statistics -hours prior toupgrading the database. To gather dictionary statistics execute the following command whileConnected asSysdba:execute dbms_stats.gather_dictionary_stats;^^ ^ MANUAL ACTION suggested ^^ ^ ************************************************** ************* Fixup Summary ************4fixup routines generated informational messages that should be reviewed.pre-upgrade fixup Script Complete *********************SQL>

After executing the above script, there are some actions that need to be done manually. Refer to the above results for specific operations.

using Dbua for upgrades$ pwd
/u01/app/oracle12/product/12.1.0/dbhome_1/bin
$./dbua because there is no pre-manual upgrade of Apex, there are warning prompts. After you manually upgrade apex, continue with the following:

11.2.0.4 Upgrade to 12.1.0.2