Shulou(Shulou.com)06/01 Report--

1. Prepare for installation

Check the current oracle version and make sure it is the older 11.2.0.1

[oracle@hch_test_121_90] $rlwrap sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 17 15:20:45 2017 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL > exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@hch_test_121_90] $

Upload the installation packages p13390677_112040_Linux-x86-64_1of7.zip and p13390677_112040_Linux-x86-64_2of7.zip of 11.2.0.4 to the server. To download the installation package for Oracle11.2.0.4, please refer to my blog address, which has the download source: http://blog.csdn.net/mchdba/article/details/51418063

Upgrade preparation:

Decompress: [oracle@hch_test_121_90 oracle] $unzip p13390677_112040_Linux-x86-64_1of7.zip [oracle@hch_test_121_90 oracle] $unzip p13390677_112040_Linux-x86-64_2of7.zip Open the image interface [oracle@hch_test_121_90 oracle] $cd database/ [oracle@hch_test_121_90 database] $. / runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 6024 MB Passed Checking swap space: must be greater than 150 MB. Actual 1798 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed Preparing to launch Oracle Universal Installer from / tmp/OraInstall2017-03-17003-11-29PM. Please wait... [oracle@hch_test_121_90 database] $[oracle@hch_test_121_90 database] $

2. Start the upgrade

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

Choose to ignore the software upgrade, the next step, such as 101.png

Then select the upgrade, as follows: 102.png

Then proceed, there is an INS-35373 error, select Yes, as follows

Then choose a good language, simplified Chinese, traditional Chinese, English, American English, etc., as shown in 104.png:

To move on to the next step, select the enterprise version, such as

Next, start choosing the oracle directory. Should you choose the new directory or the old 11.2.0.1 directory? It is best to choose a new directory here, because in case the upgrade fails, the old oracle version of the software directory is not overwritten and can continue to be used, otherwise the upgrade fails, you will basically have to thoroughly violently remove all files and registration information, and then reinstall oracle.

I will choose a new directory 11.2.0.4 here, as shown in 106.png and 107.png

Next, go on, select a new Inventory Directory directory, which will report an error by default, as shown in 108.png

Next, select a user group and an action group, as shown in 109.png:

Next, there will be various lib packages for checking, some of which are partial, and it's okay if they are missing. Just ignore them and ok them by Ignore, as shown in 110.png:

Next, look at the installation directory and basic information, as shown in 111.png:

Then click the "Install" button to start the installation, as shown in figure 112.png

The intermediate level needs to execute the configuration script, as shown in figure 112_1.png

Reopen xshell,ssh to connect to the database and execute the command on the command line:

[root@hch_test_121_90 oracle] # bash-x/oracle/app/oraInventory11.2.0.4/ orainstRoot.sh [root @ hch_test_121_90 oracle] # bash-x/oracle/app/oracle/product/11.2.0.4/dbhome_1/root.sh

The execution process is as follows:

[root@hch_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 $1}'+ + / bin/awk-F ='{print $2}'+ 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 world. ' Changing permissions of / oracle/app/oraInventory11.2.0.4. Adding read,write permissions for group. Removing read,write,execute permissions for world. + / bin/chmod-R gongfurwjinghui RWX / oracle/app/oraInventory11.2.0.4 +'['0'! ='0']'+ / bin/echo 'Changing groupname of / oracle/app/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 execution of the script is complete.' The execution of the script is complete. [root@hch_test_121_90 oracle] # [root@hch_test_121_90 oracle] # [root@hch_test_121_90 ~] # sh / oracle/app/oracle/product/11.2.0.4/dbhome_1/root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= / oracle/app/oracle/product/11.2.0.4/dbhome_1 Enter the full pathname of the local bin directory: [/ usr/local/bin]: / oracle/app/oracle/product/11.2.0.4/dbhome_1/bin The contents of "dbhome" have not changed No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the / etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Finished product-specific root actions. [root@hch_test_121_90 ~] #

Then go back to the remote window of vnc, click OK in the interface, and you will be prompted to install Oracle Net Configuration Assistant: Welcome operation:

The next step is to configure the network, such as 113.png and 114.png

Set the sys password, as shown in 115.png

See here, the problem is that there is no database in the middle for you to choose to upgrade. What is the problem? there is no configuration in / etc/oratab, so configure it quickly:

[root@hch_test_121_90 ~] # more / etc/oratab # # This file is used by ORACLE utilities. It is created by root.sh # and updated by either Database Configuration Assistant while creating # a database or ASM Configuration 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,'#, are comments. # # Entries are of the form: # $ORACLE_SID:$ORACLE_HOME:: # # The first and second fields are 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", be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # powerdes:/hom/oracle/app/oracle/product/11.2.0/dbhome_1:Y [root@hch_test_121_90 ~] #

Once configured, the previous steps are repeated, and the following database options appear for us to choose, as shown in 116.png, 117.png, and 118.png:

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

Choose not to move data files during the upgrade process, as shown in figure 120.png

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

Next, prepare the enterprise manager by default. Of course, you can choose what you don't need and just ignore it, as shown in figure 122.png.

Next, click the "Finish" button (this will take a long time, at least 1 hour. I have used 1.5 hours here, which may be relatively short on ssd), as shown in figure 123.png, 124.png, 125.png.

OK, wait for the progress bar to change to 100%, and then the basic upgrade is complete. Remember to modify the ORACLE_HOME directory in .bash _ profile to the new 11.2.0.4 directory.

The above is the ORACLE 11g upgrade from 11.2.0.1 to 11.2.0.4. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply you in time. Thank you very much for your support for the website.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.