Oracle 10g upgrade from 10.2.0.1 to 10.2.0.4
新安裝了一臺資料庫伺服器,版本是10.2.0.1的,因為現在最新的是10.2.0.4的。 版本低了,bug多。所以就對資料庫做了一個升級。
伺服器是windows 2003的系統,都是可視話操作。 下一步的問題。 10.2.0.4的patchset 裡面也有詳細的安裝說明。 之做個總結,是因為這次用了DBUA工具,以前做升級,都是用指令碼來的。 這次常個新鮮。基本步驟還是差不多。
升級步驟如下:
1. 從metalink上下載10.2.0.4 的patchset, 編號是:p6810189
2. 關閉資料庫, 做個冷備份,防止安裝失敗。
3. 安裝patchset 軟體, 這裡要注意,ORACLE_HOME 要和以前的一樣。
4. 執行指令碼 或者用 DBUA 工具
5. 檢查確認升級是否成功。
下面是readme上面的說明:
Upgrading a Release 10.2 Database
After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home:
Note: If you do not run the catupgrd.sql script as described in this section and you start up a database for normal operation, then ORA-01092: ORACLE instance terminated. Disconnection forced errors will occur and the error ORA-39700: database must be opened with UPGRADE option will be in the alert log. |
1. Log in with administrator privileges.
2. For Oracle RAC installations, start listener on each node of the cluster as follows:
C:/> ORACLE_BASE/ORACLE_HOME/bin/srvctl start listener -n node
3. If you are using Automatic Storage Management, start the Automatic Storage Management instance.
4. For single-instance installations, start the listener as follows:
C:/> lsnrctl start
5. For single-instance installations, use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
C:/> sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
Users of single-instance installations now proceed to step 7.
6. For Oracle RAC installations:
A. Use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
C:/> sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password: SYS_password
SQL> STARTUP NOMOUNT
B. Set the CLUSTER_DATABASE initialization parameter to FALSE:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
C. Shut down the database:
SQL> SHUTDOWN
7. Enter the following SQL*Plus commands:
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @ORACLE_BASE/ORACLE_HOME/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> @ORACLE_BASE/ORACLE_HOME/rdbms/admin/utlrp.sql
When the 10.2.0.4 patch set is applied to an Oracle Database 10g Standard Edition database, there may be 54 invalid objects after the utlrp.sql script runs. These objects belong to the unsupported components and do not affect the database operation. Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following: BIN$4lzljWIt9gfgMFeM2hVSoA==$0 |
12. Run the following command to check the status of all the components after the upgrade:
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:
C:/> rman catalog username/password@alias
RMAN> UPGRADE CATALOG;
14. For Oracle RAC installations:
A. Set the CLUSTER_DATABASE initialization parameter to TRUE:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;
B. Restart the database:
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
C. Start any database services that you want to use:
C:/> ORACLE_BASE/ORACLE_HOME/bin/srvctl start service -d db_name -s service_name
15. To configure and secure Enterprise Manager follow these steps:
Ensure the database and Listener are operational.
In the case of a single instance, execute
emca -upgrade db
In the case of Oracle Real Application Clusters (RAC), execute
emca -upgrade db -cluster
DBUA 工具提供了一個視覺化的介面,它的作用等同於執行catupgrd.sql等指令碼,dbua工具能升級Oracle 的一些元件。元件升級之後,該工具會自動編譯無效的物件, 這個功能還是挺方便的。 省得自己手動的去執行編譯指令碼了。
SQL>SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
COMP_NAME VERSION STATUS
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and Types 10.2.0.4.0 VALID
Oracle Workspace Manager 10.2.0.4.3 VALID
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
Oracle XDK 10.2.0.4.0 VALID
Oracle Database Java Packages 10.2.0.4.0 VALID
Oracle Expression Filter 10.2.0.4.0 VALID
Oracle Data Mining 10.2.0.4.0 VALID
Oracle Text 10.2.0.4.0 VALID
Oracle XML Database 10.2.0.4.0 VALID
Oracle Rule Manager 10.2.0.4.0 VALID
Oracle interMedia 10.2.0.4.0 VALID
OLAP Analytic Workspace 10.2.0.4.0 VALID
Oracle OLAP API 10.2.0.4.0 VALID
OLAP Catalog 10.2.0.4.0 VALID
Spatial 10.2.0.4.0 VALID
Oracle Enterprise Manager 10.2.0.4.0 VALID
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15880878/viewspace-723011/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Upgrade Oracle Database from 10.2.0.1 to 11.2.0.4OracleDatabase
- Oracle database 升級(文件)to 10.2.0.4 from 10.2.0.1OracleDatabase
- Oracle 10g upgrade 10.2.0.2 -- 10.2.0.4Oracle 10g
- 靜默升級oracle(文件)to 10.2.0.4 from 10.2.0.1Oracle
- Oracle 10g rac升級(10.2.0.1 Rac到10.2.0.4)Oracle 10g
- upgrade oracle 10.2.0.4 for aixOracleAI
- [Upgrade] Oracle 10.2.0.1 --> 10.2.0.5 patchset Upgrade.Oracle
- upgrade CRS & Oracle 10g to 10.2.0.4 for Linux x86_64bitOracle 10gLinux
- Oracle 10.2.0.1 升級到 10.2.0.4Oracle
- oracle rac 10.2.0.1 升級到 oracle 10.2.0.4Oracle
- (轉)Oracle 10.2.0.1 升級到 10.2.0.4Oracle
- Use Database Replay Feature to Help With Upgrade From 10.2.0.4 to 11g_748895.1Database
- Oracle RAC 10.2.0.1 升級 10.2.0.4 簡單描述Oracle
- Oracle 10.2.0.1 升級到 10.2.0.4--轉載Oracle
- windows 下oracle從10.2.0.1升級到10.2.0.4WindowsOracle
- oracle 之 安裝10.2.0.1 且 升級到 10.2.0.4Oracle
- Oracle10g RAC : 10.2.0.1 升級到 10.2.0.4Oracle
- Oracle10.2.0.1 升級到Oracle10.2.0.4 簡單步驟Oracle
- linux下oracle RAC10.2.0.1升級到10.2.0.4LinuxOracle
- windows 2003,oracle 10.2.0.1升級到10.2.0.4WindowsOracle
- 升級Oracle 10g 到10.2.0.4Oracle 10g
- upgrade oracle version 9i to 10gOracle
- linux平臺下oracle從10.2.0.1升級到10.2.0.4LinuxOracle
- oracle在linux平臺從10.2.0.1升級到10.2.0.4方法OracleLinux
- Oracle RAC ASM 例項 從10.2.0.1 升級到 10.2.0.4 說明OracleASM
- Oracle10.2.0.1升級到10.2.0.4碰到的Text file busy問題Oracle
- [zt] 使用snmp 監控 Oracle 10g(10.2.0.4) 時oracle 10g snmp的配置Oracle 10g
- Linux下Oracle10.2.0.1升級到oracle10.2.0.4詳細操作記錄LinuxOracle
- Migrate from SQL SERVER to Oracle 10GSQLServerOracle 10g
- oracle 10.2.0.1 rac 升級到10.2.0.4 rac時,dbua升級的元件列表Oracle元件
- [轉載]使用snmp 監控 Oracle 10g(10.2.0.4) --- 配置Oracle 10g
- Windows 下 oracle 10g升級到10.2.0.4的方法WindowsOracle 10g
- Fedora14+Virtualbox4.0.10+Oracle10gr2+Clusterware+Raw-devices+10.2.0.4 upgradeOracledev
- HP-UX 10.2.0.1 升級到 10.2.0.3 時報 ORA-20000: Upgrade re-run not supported from versionUX
- Oracle10.2.0.1到10.2.0.4升級出現了ORA-01092故障Oracle
- How To Upgrade ASM from 10.2 to 11.1 (RAC)ASM
- 滾動升級(rolling upgrade) Oracle 10g RACOracle 10g
- Oracle 10g 10.2.0.4 Patchset Server Install - Does Not Install ODBC DriverOracle 10gServer