ORACLE 12.1.0.1 to 12.1.0.2 Upgrade document (standalone version Dbua mode)

Tag: Generate MOS log _id download Containe Style size nbsp

12C Dbua New Features

1. New pre-upgrade check tool.

2. Parallel upgrade.

3. When upgrading Dbua, the default degree of parallelism is the number of CPUs or 2. The degree of parallelism can be adjusted.

4. During the upgrade process, the Dbua tool can be called again (restarted).

5. A more detailed log to monitor the progress of the upgrade.

6. Both CDB and PDB will be upgraded at the same time.

7. The listener will be migrated to the new version.

8. All data files and temporary files will be changed to auto-expand.

As below, focus on the 12c pre-upgrade inspection tool:

Specific Reference MOS: How to Download and Run Oracle ' s Database pre-upgrade Utility (Doc ID 884522.1)

Attention:

1, if the CDB environment, all the PDB needs to be placed in the Read,write state.

2, if it is a CDB environment, pre-upgrade check scripts must be executed in both CDB and PDB.

Sql> show PDBs; con_id con_name OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 Pdb$seed READ only NO 3 PDB1 READ WRITE NO 4 PDB2 READ WRITE NO 5 PDB3 READ WRITE NO Sql>

Perform pre-upgrade Check script method One (catcon.pl):

Oracle have provided script catcon.pl to execute scripts at Container and pluggable database at once. In a CDB, the catcon.pl script was the best-run SQL scripts and SQL statements. It can run them in the root and in specified PDBs in the correct order, and it generates log files.

The catcon.pl script is a Perl script this must be run at an operating system prompt.

If neither THE-C nor the-c parameter is specified, then catcon.pl runs the script in all containers by default.

[Email protected] admin]$ CD $ORACLE _home/rdbms/admin [Email protected] admin]$ $ORACLE _home/perl/bin/perl catcon.pl-d/u01/software/precheck-l/home/oracle-b preupgrade_ Log_base_name Preupgrd.sql [Email protected] admin]$

Script-generated logs:

[Email protected] ~]$ cd/home/oracle [email protected] ~]$ LL Total 20 -rw-r--r--1 Oracle oinstall 5092 Nov 18:14 preupgrade_log_base_name0.log -rw-r--r--1 Oracle Oinstall 2822 Nov 18:14 preupgrade_log_base_name1.log -rw-r--r--1 Oracle Oinstall 2822 Nov 18:14 preupgrade_log_base_name2.log -rw-r--r--1 Oracle Oinstall 2822 Nov 18:14 preupgrade_log_base_name3.log [Email protected] ~]$

perform pre-upgrade Check Script method Two (enter all containers separately):

$ sqlplus "/as SYSDBA" Sql> <location of Preupgrade Scripts>/preupgrd.sql Sql> Alter session Set container=<pdb_name>; Sql> <location of Preupgrade Scripts>/preupgrd.sql Sql> Alter session Set container=<pdb_name>; Sql> <location of Preupgrade Scripts>/preupgrd.sql

The entire upgrade document is too large to be placed in the blog, if necessary, please click the link to download:

Http://files.cnblogs.com/files/missyou-shiyh/upgraded_to_12.1.0.2_using_dbua.rar

ORACLE 12.1.0.1 to 12.1.0.2 Upgrade document (standalone version Dbua mode)