Upgrade from oracle 11.2.0.1 to 11.2.0.4

Patch set version 11.2.0.4 seems to be available only to users who have purchased Oracle services.

I shared one with my classmate. Because version 11.2.0.1 was installed before, I upgraded it to version 11.2.0.4. Only two files were needed to upgrade:

Table 1 Installation Types and Associated Zip Files

Installation Type

Zip File

Oracle Database (includes Oracle Database and Oracle RAC)

Note: you must download both zip files to install Oracle Database.

P13390677_112040_platform_1of7.zip

P13390677_112040_platform_2of7.zip

Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart)

P13390677_112040_platform_3of7.zip

Oracle Database Client

P13390677_112040_platform_4of7.zip

Oracle Gateways

P13390677_112040_platform_5of7.zip

Oracle Examples

P13390677_112040_platform_6of7.zip

Deinstall

P13390677_112040_platform_7of7.zip

Let's start the upgrade installation:

Some installation steps are omitted here, because oracle is already installed, so various dependency packages, environment variables, and system optimizations are not needed.

(1) prepare the environment

(2) preparation before upgrade

Check the version, Recycle Bin, invalid object, then stop the database, check the listening status, turn off listening

(3) start upgrading

Extract the file first

Unzipp13390677_112040_Linux-x86-64_1of7.zip

Unzipp13390677_112040_Linux-x86-64_2of7.zip

Grant authority

Chown oracle:oinstall/home/oracle/database/-R

Configure vnc

Vncserver: 1

Installation

Remember to back up the data.

Verify the upgrade result