成人国产在线小视频_日韩寡妇人妻调教在线播放_色成人www永久在线观看_2018国产精品久久_亚洲欧美高清在线30p_亚洲少妇综合一区_黄色在线播放国产_亚洲另类技巧小说校园_国产主播xx日韩_a级毛片在线免费

資訊專欄INFORMATION COLUMN

oracle小版本升級實(shí)戰(zhàn)

IT那活兒 / 818人閱讀
oracle小版本升級實(shí)戰(zhàn)

oracle11.2.0.3升級至11.2.0.4單機(jī)版

前言：

由于客戶的環(huán)境有的比較老，數(shù)據(jù)庫版本還停留在11.2.0.3版本，隨著數(shù)據(jù)庫的更新?lián)Q代，以及方便以后升級到12或者18，19乃至更高的數(shù)據(jù)庫版本，客戶決定先升級數(shù)據(jù)庫版本到11.2.0.4，于是在升級之前先在測試環(huán)境做一個(gè)測試，同時(shí)可以發(fā)現(xiàn)一些需要特別注意的點(diǎn)，在實(shí)際操作中避免失誤。


1

查看操作系統(tǒng)信息

uname-a

2

查看數(shù)據(jù)庫各個(gè)組件版本信息

[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備份數(shù)據(jù)庫

[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

關(guān)庫關(guān)監(jiān)聽

[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>

關(guān)閉監(jiān)聽

[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安裝介質(zhì)

6.1 取消oracle支持

6.2 跳過軟件更新

6.3 選擇最后一個(gè)選項(xiàng)"Upgradean existing database" 后下一步

6.4 選擇語言然后下一步

6.5 選擇升級的數(shù)據(jù)庫版本下一步

6.6 選擇新版本數(shù)據(jù)庫安裝目錄然后下一步

6.7 選擇數(shù)據(jù)庫所屬用戶組然后下一步

6.8 檢查前置條件后下一步

6.9 察看數(shù)據(jù)庫配置信息后，點(diǎn)擊Install開始進(jìn)行新版本軟件安裝

6.10 執(zhí)行root.sh腳本

6.11 繼續(xù)執(zhí)行軟件升級

7

至此11.2.0.4的軟件就已經(jīng)裝完了，修改Oracle環(huán)境變量


8

拷貝監(jiān)聽配置文件


9

執(zhí)行SQL

運(yùn)行catupgrd.sql進(jìn)行實(shí)例升級

@?/rdbms/admin/catupgrd.sql

運(yùn)行utlrp.sql編譯失效對象

@?/rdbms/admin/utlrp

10

驗(yàn)證升級是否完成

查看各個(gè)組件版本

selectcomp_name,status,version from dba_server_registry;

查看有無失效對象

select * fromdba_objects where status !=VALID;


補(bǔ)丁安裝完執(zhí)行應(yīng)用補(bǔ)丁

@catbundle.sql psuapply


總結(jié)（過程中需要特別注意的點(diǎn)）

1.升級前的準(zhǔn)備

升級之前做好oracle之前安裝目錄以及數(shù)據(jù)庫的備份，升級過程中如果有問題，可以先回退，排查問題后再次升級。

2.升級完以后的注意事項(xiàng)

首先檢查各個(gè)組件的升級情況，沒問題后編譯失效對象。以及根據(jù)需要安裝新版本的補(bǔ)丁集。都做完以后，驗(yàn)證是否可以正常連接，正常使用。


END


文章版權(quán)歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載,若此文章存在違規(guī)行為，您可以聯(lián)系管理員刪除。

轉(zhuǎn)載請注明本文地址：http://systransis.cn/yun/129947.html

相關(guān)文章

  • 新書推薦 |《PostgreSQL實(shí)戰(zhàn)》出版(提供樣章下載)

    摘要：作者譚峰張文升出版日期年月頁數(shù)頁定價(jià)元本書特色中國開源軟件推進(jìn)聯(lián)盟分會(huì)特聘專家撰寫，國內(nèi)多位開源數(shù)據(jù)庫專家鼎力推薦。張文升中國開源軟件推進(jìn)聯(lián)盟分會(huì)核心成員之一。 很高興《PostgreSQL實(shí)戰(zhàn)》一書終于出版，本書大體上系統(tǒng)總結(jié)了筆者 PostgreSQL DBA 職業(yè)生涯的經(jīng)驗(yàn)總結(jié)，本書的另一位作者張文升擁有豐富的PostgreSQL運(yùn)維經(jīng)驗(yàn)，目前就職于探探科技任首席PostgreS...

    Martin91 評論0 收藏0

  • Java 9 被無情拋棄，Java 8 直接升級到 Java 10??！

    摘要：添加的新功能也是讓人咋舌強(qiáng)烈推薦所有使用的用戶升級到，剛出就強(qiáng)烈推薦，厲害了看樣子已經(jīng)被無情拋棄了，不管什么原因，肯定是趨勢了，畢竟已經(jīng)有了預(yù)覽版了。關(guān)于的新特性可以看往期文章，后面我們會(huì)陸續(xù)推出的更多新特性實(shí)戰(zhàn)。 showImg(https://segmentfault.com/img/remote/1460000015352808); 前幾天寫了一篇 Java 8 即將在 2019...

    guyan0319 評論0 收藏0

  • DBASK問答集萃第四期

    摘要：問題九庫控制文件擴(kuò)展報(bào)錯(cuò)庫的擴(kuò)展報(bào)錯(cuò)，用的是裸設(shè)備，和還是原來大小，主庫的沒有報(bào)錯(cuò)，并且大小沒有變，求解釋。專家解答從報(bào)錯(cuò)可以看出，控制文件從個(gè)塊擴(kuò)展到個(gè)塊時(shí)報(bào)錯(cuò)，而裸設(shè)備最大只支持個(gè)塊，無法擴(kuò)展，可以嘗試將參數(shù)改小，避免控制文件報(bào)錯(cuò)。 鏈接描述引言 近期我們在DBASK小程序新關(guān)聯(lián)了運(yùn)維之美、高端存儲知識、一森咖記、運(yùn)維咖啡吧等數(shù)據(jù)領(lǐng)域的公眾號，歡迎大家閱讀分享。 問答集萃 接下來，...

    SKYZACK 評論0 收藏0

  • # Oracle APEX 系列文章8：如何從 APEX 5.1.4 升級到最新的 APEX 18.

    摘要：停止當(dāng)前，服務(wù)。鋼哥注如果想把里的替換成別的，比如，需要在先將重命名為，然后再跑命令完成安裝和部署動(dòng)作。輸入對應(yīng)的賬號后，檢查之前的應(yīng)用也都能正常運(yùn)行，完美結(jié)語以上就是如何從之前的升級到最新的版本的實(shí)操，希望老鐵們喜歡。 showImg(https://segmentfault.com/img/remote/1460000015087005); 本文是鋼哥的 Oracle APEX 系...

    Hancock_Xu 評論0 收藏0

發(fā)表評論

0條評論

最新活動(dòng)
閱讀需要支付1元查看
<