资讯专栏INFORMATION COLUMN

oracle小版本升级实战

IT那活儿 / 575人阅读
oracle小版本升级实战

oracle11.2.0.3升级至11.2.0.4单机版

前言:

由于客户的环境有的比较老,数据库版本还停留在11.2.0.3版本,随着数据库的更新换代,以及方便以后升级到12或者18,19乃至更高的数据库版本,客户决定先升级数据库版本到11.2.0.4,于是在升级之前先在测试环境做一个测试,同时可以发现一些需要特别注意的点,在实际操作中避免失误。


1

查看操作系统信息

uname-a

2

查看数据库各个组件版本信息

[oracle@lisai ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 1 13:13:59 2021
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select comp_name,status,version from dba_server_registry;
COMP_NAME--------------------------------------------------------------------------------STATUS VERSION-------------------------------------------- ------------------------------OWBVALID 11.2.0.3.0
Oracle Application ExpressVALID 3.2.1.00.12
Oracle Enterprise ManagerVALID 11.2.0.3.0

COMP_NAME--------------------------------------------------------------------------------STATUS VERSION-------------------------------------------- ------------------------------OLAP CatalogVALID 11.2.0.3.0
SpatialVALID 11.2.0.3.0
Oracle MultimediaVALID 11.2.0.3.0

COMP_NAME--------------------------------------------------------------------------------STATUS VERSION-------------------------------------------- ------------------------------Oracle XML DatabaseVALID 11.2.0.3.0
Oracle TextVALID 11.2.0.3.0
Oracle Expression FilterVALID 11.2.0.3.0

COMP_NAME--------------------------------------------------------------------------------STATUS VERSION-------------------------------------------- ------------------------------Oracle Rules ManagerVALID 11.2.0.3.0
Oracle Workspace ManagerVALID 11.2.0.3.0
Oracle Database Catalog ViewsVALID 11.2.0.3.0

COMP_NAME--------------------------------------------------------------------------------STATUS VERSION-------------------------------------------- ------------------------------Oracle Database Packages and TypesVALID 11.2.0.3.0
JServer JAVA Virtual MachineVALID 11.2.0.3.0
Oracle XDKVALID 11.2.0.3.0

COMP_NAME--------------------------------------------------------------------------------STATUS VERSION-------------------------------------------- ------------------------------Oracle Database Java PackagesVALID 11.2.0.3.0
OLAP Analytic WorkspaceVALID 11.2.0.3.0
Oracle OLAP APIVALID 11.2.0.3.0

18 rows selected.
SQL>


3

rman备份数据库

[oracle@lisai u02]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jan 1 13:23:49 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1588474417)
RMAN> run{allocate channel c1 type disk;allocate channel c2 type disk;backup filesperset 2 database format /u02/full_%d_%T_%s_%p;sql alter system archive log current;sql alter system archive log current;sql alter system archive log current;backup 2> 3> 4> 5> 6> 7> 8> archivelog all format /u02/arch_%d_%T_%s_%p delete input;backup current controlfile format /u02/ctl_%d_%T_%s_%p;BACKUP as compressed backupset FORMAT /u02/spfile_%s_%p_%t spfile;}9> 10> 11>
using target database control file instead of recovery catalogallocated channel: c1channel c1: SID=28 device type=DISK
allocated channel: c2channel c2: SID=27 device type=DISK
Starting backup at 01-JAN-21channel c1: starting full datafile backup setchannel c1: specifying datafile(s) in backup setinput datafile file number=00001 name=/u01/app/orcl/oradata/orcl/system01.dbfinput datafile file number=00004 name=/u01/app/orcl/oradata/orcl/users01.dbfchannel c1: starting piece 1 at 01-JAN-21channel c2: starting full datafile backup setchannel c2: specifying datafile(s) in backup setinput datafile file number=00002 name=/u01/app/orcl/oradata/orcl/sysaux01.dbfinput datafile file number=00003 name=/u01/app/orcl/oradata/orcl/undotbs01.dbfchannel c2: starting piece 1 at 01-JAN-21channel c1: finished piece 1 at 01-JAN-21piece handle=/u02/full_ORCL_20210101_13_1 tag=TAG20210101T132358 comment=NONEchannel c1: backup set complete, elapsed time: 00:00:03channel c1: starting full datafile backup setchannel c1: specifying datafile(s) in backup setchannel c2: finished piece 1 at 01-JAN-21piece handle=/u02/full_ORCL_20210101_14_1 tag=TAG20210101T132358 comment=NONEchannel c2: backup set complete, elapsed time: 00:00:03channel c2: starting full datafile backup setchannel c2: specifying datafile(s) in backup setincluding current SPFILE in backup setchannel c2: starting piece 1 at 01-JAN-21including current control file in backup setchannel c1: starting piece 1 at 01-JAN-21channel c2: finished piece 1 at 01-JAN-21piece handle=/u02/full_ORCL_20210101_16_1 tag=TAG20210101T132358 comment=NONEchannel c2: backup set complete, elapsed time: 00:00:00channel c1: finished piece 1 at 01-JAN-21piece handle=/u02/full_ORCL_20210101_15_1 tag=TAG20210101T132358 comment=NONEchannel c1: backup set complete, elapsed time: 00:00:01Finished backup at 01-JAN-21
sql statement: alter system archive log current
sql statement: alter system archive log current
sql statement: alter system archive log current
Starting backup at 01-JAN-21current log archivedchannel c1: starting archived log backup setchannel c1: specifying archived log(s) in backup setinput archived log thread=1 sequence=8 RECID=5 STAMP=1060694642input archived log thread=1 sequence=9 RECID=6 STAMP=1060694642channel c1: starting piece 1 at 01-JAN-21channel c2: starting archived log backup setchannel c2: specifying archived log(s) in backup setinput archived log thread=1 sequence=10 RECID=7 STAMP=1060694642input archived log thread=1 sequence=11 RECID=8 STAMP=1060694642channel c2: starting piece 1 at 01-JAN-21channel c1: finished piece 1 at 01-JAN-21piece handle=/u02/arch_ORCL_20210101_17_1 tag=TAG20210101T132402 comment=NONEchannel c1: backup set complete, elapsed time: 00:00:00channel c1: deleting archived log(s)archived log file name=/u01/app/orcl/product/11.2.3/dbhome_1/dbs/arch1_8_1060693684.dbf RECID=5 STAMP=1060694642archived log file name=/u01/app/orcl/product/11.2.3/dbhome_1/dbs/arch1_9_1060693684.dbf RECID=6 STAMP=1060694642channel c2: finished piece 1 at 01-JAN-21piece handle=/u02/arch_ORCL_20210101_18_1 tag=TAG20210101T132402 comment=NONEchannel c2: backup set complete, elapsed time: 00:00:00channel c2: deleting archived log(s)archived log file name=/u01/app/orcl/product/11.2.3/dbhome_1/dbs/arch1_10_1060693684.dbf RECID=7 STAMP=1060694642archived log file name=/u01/app/orcl/product/11.2.3/dbhome_1/dbs/arch1_11_1060693684.dbf RECID=8 STAMP=1060694642Finished backup at 01-JAN-21
Starting backup at 01-JAN-21channel c1: starting full datafile backup setchannel c1: specifying datafile(s) in backup setincluding current control file in backup setchannel c1: starting piece 1 at 01-JAN-21channel c1: finished piece 1 at 01-JAN-21piece handle=/u02/ctl_ORCL_20210101_19_1 tag=TAG20210101T132402 comment=NONEchannel c1: backup set complete, elapsed time: 00:00:01Finished backup at 01-JAN-21
Starting backup at 01-JAN-21channel c1: starting compressed full datafile backup setchannel c1: specifying datafile(s) in backup setincluding current SPFILE in backup setchannel c1: starting piece 1 at 01-JAN-21channel c1: finished piece 1 at 01-JAN-21piece handle=/u02/spfile_20_1_1060694644 tag=TAG20210101T132404 comment=NONEchannel c1: backup set complete, elapsed time: 00:00:01Finished backup at 01-JAN-21released channel: c1released channel: c2
RMAN>


4

关库关监听

[oracle@lisai u02]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 1 13:26:23 2021
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL>

关闭监听

[oracle@lisai u02]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-JAN-2021 13:31:51
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lisai)(PORT=1521)))The command completed successfully[oracle@lisai u02]$


5

备份/u01目录

[root@lisai~]# tar -cvf u01.zip /u01

6

上传并解压缩OracleDatabase 11.2.0.4安装介质

6.1 取消oracle支持

6.2 跳过软件更新

6.3 选择最后一个选项"Upgradean existing database" 后下一步

6.4 选择语言然后下一步

6.5 选择升级的数据库版本下一步

6.6 选择新版本数据库安装目录然后下一步

6.7 选择数据库所属用户组然后下一步

6.8 检查前置条件后下一步

6.9 察看数据库配置信息后,点击Install开始进行新版本软件安装

6.10 执行root.sh脚本

6.11 继续执行软件升级

7

至此11.2.0.4的软件就已经装完了,修改Oracle环境变量


8

拷贝监听配置文件


9

执行SQL

运行catupgrd.sql进行实例升级

@?/rdbms/admin/catupgrd.sql

运行utlrp.sql编译失效对象

@?/rdbms/admin/utlrp

10

验证升级是否完成

查看各个组件版本

selectcomp_name,status,version from dba_server_registry;

查看有无失效对象

select * fromdba_objects where status !=VALID;


补丁安装完执行应用补丁

@catbundle.sql psuapply


总结(过程中需要特别注意的点)

1.升级前的准备

升级之前做好oracle之前安装目录以及数据库的备份,升级过程中如果有问题,可以先回退,排查问题后再次升级。

2.升级完以后的注意事项

首先检查各个组件的升级情况,没问题后编译失效对象。以及根据需要安装新版本的补丁集。都做完以后,验证是否可以正常连接,正常使用。


END


文章版权归作者所有,未经允许请勿转载,若此文章存在违规行为,您可以联系管理员删除。

转载请注明本文地址:https://www.ucloud.cn/yun/129947.html

相关文章

  • 新书推荐 |《PostgreSQL实战》出版(提供样章下载)

    摘要:作者谭峰张文升出版日期年月页数页定价元本书特色中国开源软件推进联盟分会特聘专家撰写,国内多位开源数据库专家鼎力推荐。张文升中国开源软件推进联盟分会核心成员之一。 很高兴《PostgreSQL实战》一书终于出版,本书大体上系统总结了笔者 PostgreSQL DBA 职业生涯的经验总结,本书的另一位作者张文升拥有丰富的PostgreSQL运维经验,目前就职于探探科技任首席PostgreS...

    Martin91 评论0 收藏0
  • Java 9 被无情抛弃,Java 8 直接升级到 Java 10!!

    摘要:添加的新功能也是让人咋舌强烈推荐所有使用的用户升级到,刚出就强烈推荐,厉害了看样子已经被无情抛弃了,不管什么原因,肯定是趋势了,毕竟已经有了预览版了。关于的新特性可以看往期文章,后面我们会陆续推出的更多新特性实战。 showImg(https://segmentfault.com/img/remote/1460000015352808); 前几天写了一篇 Java 8 即将在 2019...

    guyan0319 评论0 收藏0
  • DBASK问答集萃第四期

    摘要:问题九库控制文件扩展报错库的扩展报错,用的是裸设备,和还是原来大小,主库的没有报错,并且大小没有变,求解释。专家解答从报错可以看出,控制文件从个块扩展到个块时报错,而裸设备最大只支持个块,无法扩展,可以尝试将参数改小,避免控制文件报错。 链接描述引言 近期我们在DBASK小程序新关联了运维之美、高端存储知识、一森咖记、运维咖啡吧等数据领域的公众号,欢迎大家阅读分享。 问答集萃 接下来,...

    SKYZACK 评论0 收藏0
  • # Oracle APEX 系列文章8:如何从 APEX 5.1.4 升级到最新的 APEX 18.

    摘要:停止当前,服务。钢哥注如果想把里的替换成别的,比如,需要在先将重命名为,然后再跑命令完成安装和部署动作。输入对应的账号后,检查之前的应用也都能正常运行,完美结语以上就是如何从之前的升级到最新的版本的实操,希望老铁们喜欢。 showImg(https://segmentfault.com/img/remote/1460000015087005); 本文是钢哥的 Oracle APEX 系...

    Hancock_Xu 评论0 收藏0

发表评论

0条评论

IT那活儿

|高级讲师

TA的文章

阅读更多
最新活动
阅读需要支付1元查看
<