linux下oracle RAC10.2.0.1升級到10.2.0.4
RAC升級分三步。
1. 升級clusterware -- > 升級包中安裝程式裡選擇CRS_HOME後安裝
2. 升級資料庫軟體 -- >升級包中安裝程式裡選擇ORACLE_HOME後安裝
3. 升級例項 -- > 可以使用指令碼 或者直接執行DBUA 實現。
1. 升級Clusterware
停止相關的程式
每個節點分別停止 EM和 isqlplus
[oracle@rac1 bin]$ emctl stop dbconsole
[oracle@rac1 bin]$ isqlplusctl stop
停止相關程式
這個可以用srvctl 命令來一個一個進行,也可以用crs_stop -all 進行。
[oracle@rac1 bin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application OFFLINE OFFLINE
ora....oltp.cs application OFFLINE OFFLINE
ora....cl1.srv application OFFLINE OFFLINE
ora....cl2.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application OFFLINE OFFLINE
ora.rac1.vip application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
停止每個節點上的CRS
[root@rac1 ~]# /u01/app/oracle/product/crs/bin/crsctl stop crs
進行升級包的目錄,執行runInstaller
這裡需要用到Xmanager,在伺服器端設定
export DISPLAY=192.168.0.214:0.0 214是我客戶端的IP
[oracle@rac1 p6810189_10204_Linux-x86]$ pwd
/mnt/OracleSoftware/p6810189_10204_Linux-x86
[oracle@rac1 p6810189_10204_Linux-x86]$ cd Disk1/
[oracle@rac1 Disk1]$ ls
10204_buglist.htm install patch_note.htm response runInstaller stage
[oracle@rac1 Disk1]$ ./runInstaller
The installer has detected that your Cluster Ready Services (CRS) installation is shared amongst the following nodes:
rac1
rac2
Because of the shared nature of this installation, you cannot perform. a rolling upgrade of your CRS software.
To complete the installation of this patchset, you must perform. the following tasks:
1. On each node, do the following:
a. Log in as the root user.
b. As root, shutdown the CRS daemons on the node
using the following command:
/u01/app/oracle/product/crs/bin/crsctl stop crs
Repeat this step until the CRS daemons on all the nodes are shutdown.
2. After all the CRS daemons on all the nodes are shutdown,
run the shell script. located at:
This script. will automatically start the CRS daemons on the
patched node upon completion.
3. Wait until the script. finishes and then proceed to the
next node and repeat step 2.
[root@rac1 ~]# /u01/app/oracle/product/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@rac1 ~]# /u01/app/oracle/product/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
.
10204 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node
node 2: rac1 rac1-priv rac1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
升級叢集軟體比較簡單 ,只是注意升級路徑別選錯就可以。
2.升級資料庫軟體
升級clusterware的時候,升級結束的時候會啟動CRS服務。 我們在升級資料庫的時候需要關閉這些服務。
停止相關程式
[oracle@rac1 bin]$ crs_stop -all
[oracle@rac1 bin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE OFFLINE
ora....oltp.cs application ONLINE OFFLINE
ora....cl1.srv application ONLINE OFFLINE
ora....cl2.srv application ONLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application OFFLINE OFFLINE
ora.rac1.vip application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
[oracle@rac1 ~]$ export DISPLAY=192.168.0.214:0.0
進行升級包的目錄,執行runInstaller
在視覺化的安裝視窗選擇ORACLE_HOME。注意,不要選錯了。然後一下步進行安裝。
安裝結束會提示用root使用者在所有節點上執行一個指令碼
/u01/app/oracle/product/10.2.0/db_1/root.sh
[root@rac1 ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
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.sh script.
Now product-specific root actions will be performed.
3.升級例項
兩種方式
1. DBUA 在一個節點執行就可以,視覺化介面操作。
2. 手動執行指令碼 (一個節點執行就可以)
$ srvctl start listener -n node
$ sqlplus /nolog
SQL> CONNECT SYS AS SYSDBA
Enter password: 123
SQL> STARTUP NOMOUNT
更改cluster_database引數為false,只允許一個節點啟動例項
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
Shut down the database:
SQL> SHUTDOWN
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql 升級指令碼
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql 重新編譯失效的物件
執行下面指令碼檢視是否升級成功
SQL> select comp_name,status,version from sys.dba_registry; COMP_NAME STATUS VERSION -------------------- ---------------------- ------------------------------ Oracle Enterprise Ma VALID 10.2.0.4.0 nager OLAP Catalog VALID 10.2.0.4.0 Oracle interMedia VALID 10.2.0.4.0 Oracle XML Database VALID 10.2.0.4.0 Oracle Expression Fi VALID 10.2.0.4.0 lter Oracle Rule Manager VALID 10.2.0.4.0 Oracle Workspace Man VALID 10.2.0.4.3 COMP_NAME STATUS VERSION -------------------- ---------------------- ------------------------------ ager Oracle Database Cata VALID 10.2.0.4.0 log Views Oracle Database Pack VALID 10.2.0.4.0 ages and Types JServer JAVA Virtual VALID 10.2.0.4.0 Machine COMP_NAME STATUS VERSION -------------------- ---------------------- ------------------------------ Oracle XDK VALID 10.2.0.4.0 Oracle Database Java VALID 10.2.0.4.0 Packages OLAP Analytic Worksp VALID 10.2.0.4.0 ace Oracle OLAP API VALID 10.2.0.4.0 Oracle Real Applicat VALID 10.2.0.4.0 ion Clusters 15 rows selected.
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;
SQL> SHUTDOWN
SQL> STARTUP
升級完成
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22418990/viewspace-722894/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle database 升級(文件)to 10.2.0.4 from 10.2.0.1OracleDatabase
- oracle 10 rac 升級 10.2.0.1升級到10.2.0.5Oracle
- oracle rac 11.2.0.3 升級到11.2.0.4Oracle
- ORACLE windows和linux環境下 10g升級到11.2.0.4 並安裝11.2.0.4.19補丁OracleWindowsLinux
- 靜默升級oracle 11g (從11.2.0.1升級到11.2.0.4)Oracle
- oracle資料庫11.2.0.3升級到11.2.0.4Oracle資料庫
- Oracle 18C升級到19COracle
- Oracle 12C升級到18COracle
- Oracle 11g升級到12COracle
- linux伺服器PHP升級到7Linux伺服器PHP
- Linux 核心準備升級到 Rust 1.77LinuxRust
- Linux環境下如何升級openssl?Linux
- Windows升級到oracle 11g的異機物理升級文件(冷備)WindowsOracle
- 【UP_ORACLE】Oracle 19c之從19.3升級到19.9Oracle
- ORACLE9I升級到10G(zt)Oracle
- Mac 下 Homestead 3.0.0 升級到 Homestead 6.3.0Mac
- Oracle 字符集從GBK升級到Utf8Oracle
- 從10.2.0.1升級到10.2.0.5操作實驗(下)
- 使用DBUA升級 Oracle 11.2.0.4到Oracle 19C的問題記錄Oracle
- Linux升級GCCLinuxGC
- Linux核心升級Linux
- Oracle從Windows 11.2.0.1升級並遷移到Linux 19cOracleWindowsLinux
- Oracle 10.2.0.5升級至11.2.0.4Oracle
- 【ASK_ORACLE】Linux從6升級到7導致Oracle產生大量Log file sync等待事件處理辦法OracleLinux事件
- MacOS下PHP7.1升級到PHP7.4.15MacPHP
- 【Oracle升級】Oracle指令碼升級11g to 19c non-CDBOracle指令碼
- ccproject升級到1135Project
- 【UPGRADE】升級到Oracle18c基本步驟參考(留存)Oracle
- 【RMAN】Oracle11g透過rman升級到12cOracle
- mongodb單機從3.2升級到4.0.4升級MongoDB
- A Oracle Data Guard Broker 升級和降級Oracle
- 12. Oracle版本、補丁及升級——12.3. 升級Oracle
- Linux openssh升級8.0Linux
- kali linux升級記Linux
- Oracle 12c升級指南Oracle
- Oracle:Oracle RAC 11.2.0.4 升級為 19cOracle
- Oracle從10g升級到11g詳細步驟Oracle
- Cocospod 升級到指定版本
- MySQL 5.7 升級到 8.0MySql