升級到資料庫到10.2.0.5.0版本
補丁:p8202632_10205_linux_x86-64.zip
1.export DISPLAY=localhost:0.0
2.xhost +
3../runInstaller
2.xhost +
3../runInstaller
1.Start the database in the UPGRADE mode:
SQL> STARTUP UPGRADE
2.Set the system to spool results to a log file for later analysis:
2.Set the system to spool results to a log file for later analysis:
SQL> SPOOL upgrade_info.log
3.Run the Pre-Upgrade Information Tool:
3.Run the Pre-Upgrade Information Tool:
SQL> @/rdbms/admin/utlu102i.sql
4.Turn off the spooling of script. results to the log file:
4.Turn off the spooling of script. results to the log file:
SQL> SPOOL OFF
7.Enter the following SQL*Plus commands:
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
8.Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
8.Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.
This list provides the version and status of each SERVER component in the database.
9.If necessary, rerun the catupgrd.sql script. after correcting any problems.
10.Restart the database:
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
11.Run the utlrp.sql script. to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> STARTUP
11.Run the utlrp.sql script. to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> @?/rdbms/admin/utlrp.sql
12.Run the following command to check the status of all the components after the upgrade:
SQL>
col COMP_NAME for a35;
col VERSION for 99;
col STATUS for a10;
col VERSION for 99;
col STATUS for a10;
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
In the output of the preceding command, the status of all the components should be VALID for a successful upgrade.
In the output of the preceding command, the status of all the components should be VALID for a successful upgrade.
13.If you are using the Oracle Recovery Manager catalog, enter the following command:
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG
RMAN> UPGRADE CATALOG
殺死佔用檔案的程式
fuser -k /ummis/mmisprd/mmisprddb/bin/oracle
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23757700/viewspace-756365/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle資料庫11.2.0.3升級到11.2.0.4Oracle資料庫
- Cocospod 升級到指定版本
- Mac 升級 PHP 到 7.4 版本MacPHP
- 【MSSQL】MSSQL 從Express版本升級到Enterprise版本SQLExpress
- 如何將 Ubuntu 版本升級到新版本Ubuntu
- android資料庫如何進行版本升級?架構之資料庫框架升級Android資料庫架構框架
- Centos7 升級openssh到最高版本CentOS
- PHP版本升級:從php7.1升級到php7.2PHP
- npm node升級到最新版本NPM
- 從CentOS 7.0升級到7.7版本CentOS
- MacOs 升級 Git 到最新版本MacGit
- 應用升級SpringCloud版本時的注意事項(Dalston升級到Edgware)SpringGCCloud
- ubuntu18.4 升級Python到3.8版本UbuntuPython
- iOS CoreData (二) 版本升級和資料庫遷移iOS資料庫
- 【MOS】手動升級到資料庫 12c 版本1(12.1)的完整核對清單 (文件 ID 2047701.1)資料庫
- centos7 openssl升級版本到OpenSSL 1.1.1nCentOS
- win7如何升級到win10系統版本 win7免費升級到win10Win7Win10
- ccproject升級到1135Project
- 寶塔皮膚版本升級實戰教程—升級寶塔皮膚到最新版本
- 資料庫升級之-Dataguard滾動升級資料庫
- oracle 10 rac 升級 10.2.0.1升級到10.2.0.5Oracle
- 資料庫升級之-資料泵資料庫
- MySQL 5.7 升級到 8.0MySql
- 資料庫升級之-XTTS資料庫TTS
- 資料庫升級和工具資料庫
- mongodb單機從3.2升級到4.0.4升級MongoDB
- gitlab遷移到docker並升級大版本到10.1.1和漢化GitlabDocker
- 靜默方式安裝、升級oracle(三): 升級資料庫軟體及資料庫Oracle資料庫
- MongoDB升級--從3.4到3.6MongoDB
- 升級 ubuntu,從 18.04 到 22.04Ubuntu
- oracle rac 11.2.0.3 升級到11.2.0.4Oracle
- MySQL 5.6.47升級到5.7.20(一)MySql
- Centos升級到openssh9.7CentOS
- [kubernetes]-kubeadm升級1.14.2到1.18.2
- CentOS 7 升級到 CentOS 8CentOS
- Grafana的版本升級和資料遷移Grafana
- IOS 環信3.0升級到最新版本SDK填坑iOS
- 在Mac上使用Homebrew升級到PHP為最新版本MacPHP
- 雲圖說|雲資料庫MySQL核心小版本升級全攻略資料庫MySql