ORACLE 11g从 11.2.0.1升级到11.2.0.4 详细实战教程

[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 ~]$ 

解压缩： [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 打开启动图像界面 [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-17_03-11-29PM. Please wait ...[oracle@hch_test_121_90 database]$ [oracle@hch_test_121_90 database]$ 

[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

[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 g+rw,o-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 ~]# 

[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:<N|Y>: # # 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 ~]#