ORACLE 11g从 11.2.0.1升级到11.2.0.4 详细实战教程(2)-木庄网络博客

重新打开xshell，ssh连接到数据库，在命令行去执行命令：

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

之后回到vnc远程的窗口，点击界面的OK，会提示安装Oracle Net Configuration Assistant: Welcome操作：

接下来会配置网络，如下113.png、114.png

设置sys密码，如115.png所示

看到这里，问题来了，中间没有数据库让你选择去升级，问题在哪里呢，在/etc/oratab没有配置，所以赶紧去配置：

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

配置完后，前面的步骤重新来一遍，到此就会有下面的出现的database选择项让我们选择，如116.png、117.png、118.png所示：

接下来，选择升级时区以及备份数据库，如119.png所示：

选择升级过程中不移动数据文件，如图120.png

选择默认的闪回恢复区以及恢复区大小，也可以自己手动调整，如121.png

接下来默认下一步，准备企业管理器，当然也可以选择不需要的，直接忽略掉，如下图122.png

接下来，点击“Finish”按钮（这个时间会比较长，至少1个小时吧，我这里用了1.5个小时，可能在ssd上时间比较短），如图123.png、124.png、125.png所示

OK，等待进度条变成100%，然后基本的升级就好了，就完成了，后续记得修改.bash_profile里面的ORACLE_HOME目录为新的11.2.0.4目录即可。

以上所述是小编给大家介绍的ORACLE 11g从 11.2.0.1升级到11.2.0.4 详细实战教程，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对网站的支持

标签：Oracle

返回前面的内容