升級到資料庫到10.2.0.5.0版本

yhj20041128001發表於2013-03-18
原文網址 : http://blog.itpub.net/23757700/viewspace-756365/
資料庫
 
補丁：p8202632_10205_linux_x86-64.zip
 
1.export DISPLAY=localhost:0.0
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:
SQL> SPOOL upgrade_info.log
3.Run the Pre-Upgrade Information Tool:
SQL> @/rdbms/admin/utlu102i.sql
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.
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> @?/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;
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.
13.If you are using the Oracle Recovery Manager catalog, enter the following command:
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG
 
殺死佔用檔案的程式
fuser -k /ummis/mmisprd/mmisprddb/bin/oracle

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23757700/viewspace-756365/，如需轉載，請註明出處，否則將追究法律責任。

相關文章