ORACLE 11g upgrade from 11.2.0.1 to 11.2.0.4 detailed combat process

1, ready to install

View the current version of Oracle and make sure it is older 11.2.0.1

[[Email protected]_test_121_90 ~]$ rlwrap sqlplus/as sysdba sql*plus:release 11.2.0.1.0 Production on Fri Mar 17 15:20: Copyright (c) 1982, Oracle.  All rights reserved.  Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit productionwith The partitioning, OLAP, Data Mining and Real Application testing options sql> exitdisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Productionwith The partitioning, OLAP, Data Mining and Real application testing Options[[email PROTECTE D]_test_121_90 ~]$

Upload the 11.2.0.4 installation package P13390677_112040_linux-x86-64_1of7.zip, p13390677_112040_linux-x86-64_2of7.zip to the server. Oracle11.2.0.4 installation package download, please check my blog address, which has the download source: http://blog.csdn.net/mchdba/article/details/51418063

Prepare for Upgrade:

Decompression: [[email protected]_test_121_90 oracle]$ Unzip P13390677_112040_linux-x86-64_1of7.zip[[email protected]_test_121 _90 oracle]$ Unzip p13390677_112040_linux-x86-64_2of7.zip  open Start Image interface [[Email protected]_test_121_90 oracle]$ CD Database/[[email protected]_test_121_90 database]$./runinstallerstarting Oracle Universal Installer ... Checking Temp space:must be greater than MB.   Actual 6024 MB    passedchecking swap space:must be greater than.   Actual 1798 MB    passedchecking Monitor:must is configured to display at least.    Actual 16777216    passedpreparing to launch Oracle Universal Installer from/tmp/orainstall2017-03-17_03-11-29pm. Please wait ... [Email protected]_test_121_90 database]$[[email protected]_test_121_90 database]$

2, start the upgrade

C:\pic\oracle\100.png, fill in the email address (you can also ignore it), and then next

100.png

Select Ignore software upgrade, next, such as 101.png

101.png

Then select Upgrade, as follows 102.png

102.png

Then proceed, there is a INS-35373 error, select Yes, as follows 103.png

Then choose a good language type, Simplified Chinese, Traditional Chinese, English, American English, etc., as shown in 104.png:

104.png

Continue to the next step, select Enterprise Edition, such as 105.png

105.png

Next, start selecting the Oracle directory, choose the new directory or the old version of the original 11.2.0.1 directory? It is best to choose a new directory, because in case the upgrade fails, the old Oracle version of the software catalog is not overwritten, you can continue to use, otherwise the upgrade fails, basically only completely violent clean up all files and registration information, and then reinstall Oracle.

I'm going to choose a new directory 11.2.0.4 directory, as shown in 106.png, 107.png

Next, continue, select the new inventory directory, default will be error, as shown in 108.png

Next select the user Group and Action group, as shown in 109.png:

Next, there will be a variety of checking lib package, some of the more biased, missing also nothing, direct ignore ignore off on OK, as shown in 110.png:

Next look at the installed directory as well as the basic information, as shown in 111.png:

Then click on the "Install" button to start the installation, 112.png

Intermediate need to execute configuration script, 112_1.png

Reopen the XSHELL,SSH connection to the database and execute the command at the command line:

[Email protected]_test_121_90 oracle]# bash-x/oracle/app/orainventory11.2.0.4/orainstroot.sh

[Email protected]_test_121_90 oracle]# bash-x/oracle/app/oracle/product/11.2.0.4/dbhome_1/root.sh

The execution process is as follows:

[[Email protected]_test_121_90 oracle]# bash-x/oracle/app/orainventory11.2.0.4/orainstroot.sh+ AWK=/bin/awk+ chmod=/bin/chmod+ chgrp=/bin/chgrp+ cp=/bin/cp+ echo=/bin/echo+ mkdir=/bin/mkdir++/usr/bin/id++/bin/awk '-f (' { print ' + ' +/bin/awk-f= ' {print $} ' + ruid=0+ ' [' 0 '! = ' 0 '] ' + ' ['-d/etc '] ' +/bin/chmod 755/etc+ ' ['-f/oracle/app /orainventory11.2.0.4/orainst.loc ' +/bin/cp/oracle/app/orainventory11.2.0.4/orainst.loc/etc/orainst.loc+/bin/ chmod 644/etc/orainst.loc+/bin/echo ' changing permissions of/oracle/app/orainventory11.2.0.4.adding read,write Permissions for group. Removing Read,write,execute permissions for the world. ' Changing permissions of/oracle/app/orainventory11.2.0.4.adding read,write permissions for group. Removing Read,write,execute permissions for the world. +/bin/chmod-r g+rw,o-rwx/oracle/app/orainventory11.2.0.4+ ' [' 0 '! = ' 0 '] ' +/bin/echo ' changing groupname of/oracle/ap p/orainventory11.2.0.4 to Oinstall. ' changing groupname OF/ORACLE/APP/ORAINVentory11.2.0.4 to oinstall.+/bin/chgrp-r oinstall/oracle/app/orainventory11.2.0.4+ ' [' 0 '! = ' 0 '] ' +/bin/echo ' the EXE Cution of the script is complete. ' The execution of the script is complete. [[Email protected]_test_121_90 oracle]#[[email protected]_test_121_90 Oracle]#[[email protected]_ Test_121_90 ~]# sh/oracle/app/oracle/product/11.2.0.4/dbhome_1/root.shperforming Root user operation for Oracle 11g the Following environment variables is set as:oracle_owner= ORACLE oracle_home=/oracle/app/oracle/product/11.2.0.4/d Bhome_1 Enter The full pathname of the local bin directory: [/usr/local/bin]:/oracle/app/oracle/product/11.2.0.4/dbhome_ 1/binthe contents of "Dbhome" has not changed. No need to overwrite. The contents of "oraenv" has not changed. No need to overwrite. The contents of "coraenv" has not changed. No need to overwrite. Entries'll be added to The/etc/oratab file as needed bydatabase Configuration Assistant when a database is Createdfinis Hed RunNing generic part of root script. Now product-specific root actions would be performed. Finished product-specific root actions. [[Email protected]_test_121_90 ~]#

Then go back to VNC remote window, click on the interface OK, will prompt to install the Oracle Net Configuration assistant:welcome operation:

Next, you will configure the network as follows 113.png, 114.png

Set the SYS password, as shown in 115.png

See here, the problem comes, in the middle no database let you choose to upgrade, the problem is where, in/etc/oratab no configuration, so hurry to configure:

[[email   protected]_test_121_90 ~]# more/etc/oratab# # This file was used by ORACLE utilities. It is created by root.sh# and updated by either database Configuration Assistant while creating# a database or ASM Configu Ration Assistant while creating ASM instance.  # A Colon, ': ', is used as the field terminator.  A New Line terminates# the entry. Lines beginning with a pound sign, ' # ', is comments.## Entries is of the form:# $ORACLE _sid: $ORACLE _home:<n|  y>:## the first and second fields is the system identifier and home# directory of the database respectively. The third filed indicates# to the Dbstart utility that the database should, "Y", or should not,# "N", being brought up at Sy Stem boot time.## multiple entries with the same $ORACLE _sid is not allowed. #powerdes:/HOM/ORACLE/APP/ORACLE/PRODUCT/11. 2.0/dbhome_1:y [[Email protected]_test_121_90 ~]# 

Once the configuration is complete, the previous steps are repeated, and there will be the following database selection that we chose, as shown in 116.png, 117.png, and 118.png:

Next, select upgrade time zone and back up the database, as shown in 119.png:

Choose not to move data files during the upgrade process, 120.png

Select the default flashback recovery area and the recovery area size, or you can manually adjust, such as 121.png

Next, the next default, prepare Enterprise Manager, of course, you can choose not to, directly ignore, such as 122.png

Next, click on the "Finish" button (this time will be longer, at least 1 hours, I have spent 1.5 hours, may be on the SSD time is relatively short), 123.png, 124.png, 125.png, shown

OK, wait for the progress bar to become 100%, and then the basic upgrade is good, finished, follow-up remember to modify. Bash_profile The Oracle_home directory is the new 11.2.0.4 directory.

ORACLE 11g upgrade from 11.2.0.1 to 11.2.0.4 detailed combat process