Upgrade Oracle 11.2.0.1 to 11.2.0.3

Upgrade Oracle 11.2.0.1 to 11.2.0.3

[Note] Generally, production databases do not use similar version 1 or R1 such as Oracle 11.2.0.1. 11.2.0.1 is the basic version, this version has more feature updates than the previous version, and feature Updates also mean that there is a higher possibility of bugs than other versions.

[Scenario description] a bug has recently been detected in a rarely used system and needs to be upgraded from 11.2.0.1 to 11.2.0.3.

[Principle] database upgrades are more like database migration. For example, upgrading from 11.2.0.1 to 11.2.0.3 adds software for installing the database 11.2.0.3 on the operating system of the database, then, use some scripts in 11.2.0.3 to refresh the files in the original database.

[Preparations before Upgrade]

Determine the version and number of digits of the Operating System

Determine the database version and number of digits. Script: SELECT * FROM PRODUCT_COMPONENT_VERSION;

Back up databases

Back up the configuration file:

ORACLE_HOME/dbs parameter file

ORACLE_HOME/network/admin listening File

ORACLE_HOME/hostname_dbname

ORACLE_HOME/Solaris/j2ee/OC4J_DBConsole_hostname_dbname

Copy the ORACLE Database Upgrade package to the server, ORACLE 11.2.0.3 has 7 installation packages, upgrade only p10404530_112030_Linux-x86-64_1of7 and p10404530_112030_Linux-x86-64_2of7 useful, upload these two files to the server.

Create a new ORACLE_BASE and ORACLE_HOME directory

The upgrade of databases for large applications is not as simple as it is mentioned here. It requires a lot of repeated tests and can be updated to the official environment only after confirmation, the operations here are also carried out in the test environment. (I upgraded a formal system Office OA environment and organized business personnel modules in the testing environment to test various scenarios in daily work. The whole process took three months .)

Procedure]

1. First shut down the database and server listening

2. Set environment variables and run./runlnstaller.

Select the second option to install ORACLE11.2.0.3. The third option is the upgrade option;

Select the database language. Remember to add Chinese Characters in China.

Here, the path is displayed according to the set environment variables.

Select the database to be upgraded. Two databases are installed on this host.

Sets the degree of parallelism to remind you to back up data before the upgrade;

Select the location of the file to facilitate subsequent management;

Check the database name, version, and path again;

Observe the output information of the database at all times to check whether an error is reported. The entire process takes about 40 minutes.

[Check]

1. Check the error message during the upgrade process;

2. Check whether the database components are successfully upgraded. Script: SELECT COMP_NAME, VERSION, status from sys. DBA_REGISTRY;

3. The above is the database-level check, but the upgrade is not successful. It mainly depends on application and business feedback;