upgrade oracle 10.2.0.4 for aix
oracle 10.2.0.4 for aix
upgrade for aix升級步驟總的來說跟HPUX/Solaris等大相徑庭,不過感覺在Upgrading a Release 10.2 Database時間上稍長於其他unix平臺。
1、確認版本:
# su -root
# oslevel -r
5300-07
2、確認系統補丁安裝情況:
# lslpp -l | grep -i xlc
xlC.aix50.rte 11.1.0.1 COMMITTED XL C/C++ Runtime for AIX 5.3
xlC.cpp 9.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.cpp 9.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.rte 11.1.0.1 COMMITTED XL C/C++ Runtime
xlC.rte 11.1.0.1 COMMITTED XL C/C++ Runtime
3、將oracle補丁檔案(p6810189_10204_AIX64-5L.zip)以oracle登陸ftp,並傳至伺服器,解壓縮:
$ su - oracle
$ unzip p6810189_10204_AIX64-5L.zip
4、停止所有oracle相關服務:
$ stop_db.sh
######################################################
# Stoping the Listener #
######################################################
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 02-JUL-2010 10:59:03
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
######################################################
# Stoping the Instance #
######################################################
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 2 13:52:44 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> Connected.
SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
5、清除不再使用的記憶體資源
# /usr/sbin/slibclean
6、安裝oracle10g補丁:
$ su - oracle
$ cd Disk1
$ ./runInstaller
....安裝過程結束後執行root.sh....
7、開始Pre-Upgrade資料庫:
$sqlplus / as sysdba
SQL> STARTUP UPGRADE
SQL> @?/rdbms/admin/utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 02-04-2008 11:48:11
.
**********************************************************************
Database:
**********************************************************************
--> name: X102040
--> version: 10.2.0.1.0
--> compatible: 10.2.0.1
--> blocksize: 8192
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 505 MB
.... AUTOEXTEND additional space required: 15 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 401 MB
.... AUTOEXTEND additional space required: 376 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 265 MB
.... AUTOEXTEND additional space required: 15 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 58 MB
.... AUTOEXTEND additional space required: 38 MB
--> EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 69 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
WARNING: --> "shared_pool_size" needs to be increased to at least 167772160
WARNING: --> "java_pool_size" needs to be increased to at least 67108864
.
**********************************************************************
Components: [The following database components will be upgraded orinstalled]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> Oracle Data Mining [upgrade] VALID
--> Messaging Gateway [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> Oracle OLAP API [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Oracle Ultra Search [upgrade] VALID
--> Oracle Label Security [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Rule Manager [upgrade] VALID
PL/SQL procedure successfully completed.
....根據提示調整表空間或記憶體引數....
eg.alter system set shared_pool_size =150M scope=spfile;
8、開始Upgrade資料庫:
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP UPGRADE
SQL> @?/rdbms/admin/catupgrd.sql
....時間稍長...
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UPGRD_END 2010-07-02 13:43:01
.
Oracle Database 10.2 Upgrade Status Utility 07-02-2010 13:43:01
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:48:20
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:18:43
Oracle XDK VALID 10.2.0.4.0 00:03:07
Oracle Database Java Packages VALID 10.2.0.4.0 00:02:36
Oracle Text VALID 10.2.0.4.0 00:01:44
Oracle XML Database VALID 10.2.0.4.0 00:11:03
Oracle Workspace Manager VALID 10.2.0.4.3 00:03:12
Oracle Data Mining VALID 10.2.0.4.0 00:01:39
OLAP Analytic Workspace VALID 10.2.0.4.0 00:01:41
OLAP Catalog VALID 10.2.0.4.0 00:04:23
Oracle OLAP API VALID 10.2.0.4.0 00:03:51
Oracle interMedia VALID 10.2.0.4.0 00:23:47
Spatial VALID 10.2.0.4.0 00:08:33
Oracle Expression Filter VALID 10.2.0.4.0 00:00:57
Oracle Enterprise Manager VALID 10.2.0.4.0 00:06:59
Oracle Rule Manager VALID 10.2.0.4.0 00:00:47
.
Total Upgrade Time: 02:21:32
....升級完成....
...改回記憶體引數配置...
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7417660/viewspace-1034859/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 10g upgrade 10.2.0.2 -- 10.2.0.4Oracle 10g
- Oracle 10g upgrade from 10.2.0.1 to 10.2.0.4Oracle 10g
- upgrade CRS & Oracle 10g to 10.2.0.4 for Linux x86_64bitOracle 10gLinux
- Fedora14+Virtualbox4.0.10+Oracle10gr2+Clusterware+Raw-devices+10.2.0.4 upgradeOracledev
- aix 6.1上rac升級到10.2.0.4AI
- [Upgrade] Oracle 10.2.0.5 PSU upgradeOracle
- [Upgrade] Oracle 10.2.0.5 opatch utility upgradeOracle
- AIX6.1 HA5.5 ORACLE10.2.0.4 RAC EM無法啟動AIOracle
- 【江楓 】AIX平臺升級到Oracle10.2.0.4的幾個問題AIOracle
- Use Database Replay Feature to Help With Upgrade From 10.2.0.4 to 11g_748895.1Database
- [Upgrade] Oracle 10.2.0.1 --> 10.2.0.5 patchset Upgrade.Oracle
- 升級 upgrade ORACLE DBOracle
- 【Oracle】rman upgrade catalogOracle
- upgrade oracle rman catalogOracle
- ORACLE 10.2.0.4 RAC BUG IN HPOracle
- oracle cluster 10.2.0.1 for aix 6.1 升級到10.2.0.4會出現vip offline問題OracleAI
- ORA-00600 [qkacon:FJswrwo] on aix 5.3 10.2.0.4 bugJSAI
- aix 5.3l 中 10.2.0.4 中 sga_lock 設定AI
- Oracle10.2.0.4 bug list and patchOracle
- oracle rac 10.2.0.1 升級到 oracle 10.2.0.4Oracle
- oracle10.2.0.4 dbvault 安裝篇Oracle
- oracle 10.2.0.4 的emca配置錯誤Oracle
- Oracle 10.2.0.1 升級到 10.2.0.4Oracle
- 靜默升級oracle到10.2.0.4Oracle
- oracle 10.2.0.2升級到10.2.0.4Oracle
- rhel5上oracle10.2.0.4 silent配置oracleOracle
- 10.2.0.3 升級到 10.2.0.4 database upgrade 報ORA-03113錯誤解決方法Database
- Upgrade Oracle Database from 10.2.0.1 to 11.2.0.4OracleDatabase
- Oracle Doc list involved with upgrade issueOracle
- 近期oracle upgrade book and rac manual 手記Oracle
- CentOS6.4安裝Oracle10.2.0.4CentOSOracle
- oracle 10.2.0.4 patch的下載地址列表Oracle
- (轉)Oracle 10.2.0.1 升級到 10.2.0.4Oracle
- 升級Oracle 10g 到10.2.0.4Oracle 10g
- oracle RAC RDS on AIXOracleAI
- aix安裝oracleAIOracle
- Failed to upgrade Oracle Cluster Registry configurationAIOracle
- upgrade oracle version 9i to 10gOracle