11.2.0.3升級到11.2.0.4
1.備份/關庫/關監聽
rman 備份
shutdown immediate;
lsnrctl stop
2.安裝 11.2.0.4 軟件
圖片略
mkdir 新目錄
3.修改環境變量/監聽文件/dbs內容
修改 .bash_profile 內容
cp network/admin 下內容
cp dbs/ 下內容
4.數據庫執行升級腳本
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 5044088832 bytes
Fixed Size 2237048 bytes
Variable Size 922750344 bytes
Database Buffers 4110417920 bytes
Redo Buffers 8683520 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/utlu112i.sql ---執行升級前檢查
Oracle Database 11.2 Pre-Upgrade Information Tool 08-31-2017 22:39:24
Script Version: 11.2.0.3.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name: MYTEST
--> version: 11.2.0.3.0
--> compatible: 11.2.0.0.0
--> blocksize: 8192
--> timezone file: V14
.
Database already upgraded; to rerun upgrade use rdbms/admin/catupgrd.sql.
--這樣顯示是不正確的, 要把相關的 pmon kill 掉, 還要把 dbs 下的 lk<oracle_sid> 刪除,然后再啟庫
SQL> @?/rdbms/admin/catupgrd.sql ---執行腳本
SQL> startup;
ORACLE instance started.
Total System Global Area 5044088832 bytes
Fixed Size 2237048 bytes
Variable Size 939527560 bytes
Database Buffers 4093640704 bytes
Redo Buffers 8683520 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/utlrp --統計無效對象
