这里有新鲜出炉的精品教程,程序狗速度看过来!
Oracle Database,又名 Oracle RDBMS,或简称 Oracle。是甲骨文公司的一款关系数据库管理系统。到目前仍在数据库市场上占有主要份额。
这篇文章主要介绍了 ORACLE 11g 从 11.2.0.1 升级到 11.2.0.4 详细实战教程, 非常不错,具有参考借鉴价值,需要的朋友可以参考下
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-64_1of7.zip、p13390677_112040_Linux-x86-64_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-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]$
2、开始升级
C:\pic\oracle\100.png,填写邮箱地址(也可以忽略不填写),然后下一步
选择忽略软件升级,下一步吗,如 101.png
然后选择升级,如下 102.png
然后继续进行,有个 INS-35373 错误,选择 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 ~]#
配置完后,前面的步骤重新来一遍,到此就会有下面的出现的 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 详细实战教程,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对 PHPERZ 网站的支持
来源: http://www.phperz.com/article/17/0609/332785.html