oracle小版本升級實戰

IT那活兒發布于2023-01-11 13:20 / 802人閱讀

oracle小版本升級實戰

oracle11.2.0.3升級至11.2.0.4單機版

前言：

由于客戶的環境有的比較老，數據庫版本還停留在11.2.0.3版本，隨著數據庫的更新換代，以及方便以后升級到12或者18，19乃至更高的數據庫版本，客戶決定先升級數據庫版本到11.2.0.4，于是在升級之前先在測試環境做一個測試，同時可以發現一些需要特別注意的點，在實際操作中避免失誤。

查看操作系統信息

uname-a

查看數據庫各個組件版本信息

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

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>

關庫關監聽

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

備份/u01目錄

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

上傳并解壓縮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 繼續執行軟件升級

至此11.2.0.4的軟件就已經裝完了，修改Oracle環境變量

拷貝監聽配置文件

執行SQL

運行catupgrd.sql進行實例升級

@?/rdbms/admin/catupgrd.sql

運行utlrp.sql編譯失效對象

@?/rdbms/admin/utlrp

驗證升級是否完成

查看各個組件版本

selectcomp_name,status,version from dba_server_registry;

查看有無失效對象

select * fromdba_objects where status !=VALID;

補丁安裝完執行應用補丁

@catbundle.sql psuapply

總結（過程中需要特別注意的點）

1.升級前的準備

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

2.升級完以后的注意事項

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

END

GPU云服務器云服務器 PPAS oracle數據庫版本升級版本升級升級版本 oracle 升級

文章版權歸作者所有，未經允許請勿轉載,若此文章存在違規行為，您可以聯系管理員刪除。

轉載請注明本文地址：http://specialneedsforspecialkids.com/yun/129947.html

新書推薦 |《PostgreSQL實戰》出版(提供樣章下載)

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

Martin91 2019-07-25 12:36 評論0 收藏0
Java 9 被無情拋棄，Java 8 直接升級到 Java 10！！

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

guyan0319 2019-08-16 12:33 評論0 收藏0
DBASK問答集萃第四期

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

SKYZACK 2019-07-25 12:39 評論0 收藏0
# Oracle APEX 系列文章8：如何從 APEX 5.1.4 升級到最新的 APEX 18.

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

Hancock_Xu 2019-07-25 14:18 評論0 收藏0

發表評論

登陸后可評論

0條評論

IT那活兒

男|高級講師

我要關注我要私信

TA的文章

消息中間件故障分析一例

閱讀 1346·2023-01-11 13:20
RAC雙節點crash回復一例

閱讀 1684·2023-01-11 13:20
ORA-600處理一例

閱讀 1132·2023-01-11 13:20
雙節點RAC實例2 HANG 故障分析一例

閱讀 1858·2023-01-11 13:20
RAC集群節點1重啟分析一例

閱讀 4100·2023-01-11 13:20
CRS啟動報錯CRS-1656處理分享

閱讀 2704·2023-01-11 13:20
oracle 12CR2打補丁報錯處理一例

閱讀 1385·2023-01-11 13:20
分布式緩存組件故障分析及監控優化

閱讀 3597·2023-01-11 13:20

国产xxxx99真实实拍_久久不雅视频_高清韩国a级特黄毛片_嗯老师别我我受不了了小说

資訊專欄INFORMATION COLUMN

上云采購季！| 2核2G4M爆款云服務器低至59元/年，更有多臺、長期優惠，快來選購！

oracle小版本升級實戰

前言：

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 繼續執行軟件升級

相關文章

新書推薦 |《PostgreSQL實戰》出版(提供樣章下載)

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

DBASK問答集萃第四期

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

發表評論

0條評論

IT那活兒

男|高級講師

TA的文章

消息中間件故障分析一例

RAC雙節點crash回復一例

ORA-600處理一例

雙節點RAC實例2 HANG 故障分析一例

RAC集群節點1重啟分析一例

CRS啟動報錯CRS-1656處理分享

oracle 12CR2打補丁報錯處理一例

分布式緩存組件故障分析及監控優化

最新活動