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

管理员 2023-06-25 08:19:11 互联网圈 9 ℃ 0 评论 11779字收藏

1、准备安装

查看当前oracle版本，肯定是比较旧的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 ~]$

上传11.2.0.4的安装包p13390677_112040_Linux-x86⑹4_1of7.zip、p13390677_112040_Linux-x86⑹4_2of7.zip到服务器上。Oracle11.2.0.4的安装包下载，请查阅我的blog地址，这上面有下载源：http://blog.csdn.net/mchdba/article/details/51418063

升级准备：

解紧缩：
[oracle@hch_test_121_90 oracle]$ unzip p13390677_112040_Linux-x86⑹4_1of7.zip
[oracle@hch_test_121_90 oracle]$ unzip p13390677_112040_Linux-x86⑹4_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⑴7_03⑴1⑵9PM. Please wait …[oracle@hch_test_121_90 database]$
[oracle@hch_test_121_90 database]$

2、开始升级

C:\pic\oracle\100.png，填写邮箱地址（也能够疏忽不填写），然后下一步

选择疏忽软件升级，下一步吗，如101.png

然后选择升级，以下102.png

然后继续进行，有个INS⑶5373毛病，选择Yes，以下

然后选择好语言种类，简体中文、繁体中文、英语、美式英语等，如104.png所示：

继续下一步，选择企业版，如

接下来，开始选择oracle目录了，是选择新建的目录呢或者选择原来的老版本11.2.0.1的目录呢？这里最好选择一个新的目录，由于万一升级失败了，老的oracle版本软件目录没有被覆盖掉，还可以继续使用的，否则升级失败，就基本只有完全暴力清除所有文件和注册信息，以后重新安装oracle了。

我这里就选择一个新的目录11.2.0.4的目录，如106.png、107.png所示

接下来，继续，选择新的的Inventory Directory目录，默许的会报错，如108.png所示

接下来选择用户组和操作组，如109.png所示：

接下来，会有checking各种lib包，一些比较偏的，缺少了也没事，直接Ignore疏忽掉就ok，如110.png所示：

下一步看安装的目录和基本信息，如111.png所示：

然后点击“”Install“”按钮，开始安装，如图112.png

中级需要履行配置脚本，如图112_1.png

重新打开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 ~]#