Database Reference
In-Depth Information
For example, if the existing Database version is 11.2.0.1, you need to upgrade it to 11.2.0.2 or higher first and then
proceed with 12c upgrade.
Deploying Manual Database Upgrade
In this section, you will learn all the mandatory steps that are required to perform a manual database upgrade to
Oracle 12c. The following demonstrates the procedure to upgrade an Oracle 11.2.0.3 database, named PRDDB ,
to Oracle 12c:
Back up the source database, if no recent backup exists.
Connect to the source database as/sysdba and execute the pre-upgrade script from the Oracle 12c home.
This is a mandatory step when you perform a manual database upgrade; on the flip side, if the script doesn't run, the
post-database upgrade step ultrp.sql script will be failed. Figure 13-13 shows how to run the pre-upgrade script on
the source database:
export ORACLE_SID=PRDDB1
SQL> sqlplus / as sysdba
SQL> @/u01/app/oracle/product/12.0.1/rdbms/admin/preupgrd.sql
You are likely to see the following output on running the pre-upgrade tool:
Figure 13-13. Pre-upgrade screenshot
Unlike earlier Oracle database releases, the pre-upgrade output is written to a log file. You will have to review the
preupgrd.log file generated by the pre-upgrade tool for any warnings and recommendations. Similarly, review and
apply the recommendations stated in the preupgrade_fixups.sql andpostupgrade_fixups.sql scripts to fix any
pre- and post-database upgrade issues recommended by the pre-upgrade tool on the source database, for example,
collecting dictionary and fixed-objects statistics, database initialization parameter adjustments, invalid object
details, tablespace size adjustments, etc. The log file and script files will typically be created under the
$ORACLE_BASE/cfgtoolslogs/PRDDB/preupgrade location. If no $ORACLE_BASE variable is set on the server, the files
in the context will be created under the $ORACLE_HOME/cfgtoolslogs/PRDDB/preupgrade location. The DBUA tool uses
the pre-upgrade tool by default. The following shows the existence of the files under the $ORACLE_HOME location:
-rw-r--r-- 1 oracle dba 1444 Apr 13 09:34 postupgrade_fixups.sql
-rw-r--r-- 1 oracle dba 2491 Apr 13 09:34 preupgrade_fixups.sql
-rw-r--r-- 1 oracle dba 6397 Apr 13 09:34 preupgrade.log
 
Search WWH ::




Custom Search