靜默升級oracle(文件)to 10.2.0.4 from 10.2.0.1
靜默升級oracle(文件)
1、 停止所有服務
emctl stop dbconsole
isqlplus stop
lsnrctl stop
sqlplus /nolog
conn /as sysdba
shutdown immediate
export ORACLE_SID=+ASM
sqlplus /nolog
conn /as sysdba
shutdown immediate
# $ORACLE_HOME/bin/crsctl stop crs
2、 備份資料
備份:tar -zcvf full_tar.gz $ORACLE_BASE/
恢復:tar –zxvf full_tar.gz –C $ORACLE_BASE/
3、 靜默升級Opatch
a) 編輯responseFile檔案…/Disk1/response 目錄下的patchset.rsp
vi patchset.rsp 並新增以下內容
UNIX_GROUP_NAME=oinstall
FROM_LOCATION=/opt/Disk1/stage/products.xml
ORACLE_HOME=/opt/oracle/product/10.2.0/db_2
ORACLE_HOME_NAME=OraDb10g_home1
b) 執行靜默升級Opatch
$/opt/Disk1/runInstaller -silent -responseFile /opt/Disk1/response/patchset.rsp –force
root使用者執行指令碼:/opt/oracle/product/10.2.0/db_2/root.sh
c) 檢測Opatch升級情況
SQL> @?/rdbms/admin/utlu102i.sql
4、 升級資料庫
lsnrctl start
SQL> startup upgrade
SQL> @?/rdbms/admin/catupgrd.sql ---升級
SQL> startup
SQL> @?/rdbms/admin/utlrp.sql ---重新編譯無效的plsql包
5、 檢驗升級元件狀態
select comp_name, version, status from sys.dba_registry;
6、 如果使用了Oracle Recovery Manager catalog
$rman catalog username/password@alias
7、 升級EM
emca –upgrade db
附表:(升級全過程)
1、升級前資料庫狀態
sys@TEST> select comp_name, version, status from sys.dba_registry;
COMP_NAME VERSION STATUS
---------------------------------------- -------------------- --------------------
Oracle Database Catalog Views 10.2.0.1.0 VALID
Oracle Database Packages and Types 10.2.0.1.0 VALID
Oracle Workspace Manager 10.2.0.1.0 VALID
JServer JAVA Virtual Machine 10.2.0.1.0 VALID
Oracle XDK 10.2.0.1.0 VALID
Oracle Database Java Packages 10.2.0.1.0 VALID
Oracle Expression Filter 10.2.0.1.0 VALID
Oracle Data Mining 10.2.0.1.0 VALID
Oracle Text 10.2.0.1.0 VALID
Oracle XML Database 10.2.0.1.0 VALID
Oracle Rules Manager 10.2.0.1.0 VALID
Oracle interMedia 10.2.0.1.0 VALID
OLAP Analytic Workspace 10.2.0.1.0 VALID
Oracle OLAP API 10.2.0.1.0 VALID
OLAP Catalog 10.2.0.1.0 VALID
Spatial 10.2.0.1.0 VALID
Oracle Enterprise Manager 10.2.0.1.0 VALID
17 rows selected.
2、關閉所有程式
emctl stop dbconsole
isqlplus stop
lsnrctl stop
sqlplus /nolog
conn /as sysdba
shutdown immediate
export ORACLE_SID=+ASM
sqlplus /nolog
conn /as sysdba
shutdown immediate
# $ORACLE_HOME/bin/crsctl stop crs
3、備份資料
備份:tar -zcvf full_tar.gz $ORACLE_BASE/
恢復:tar –zxvf full_tar.gz –C $ORACLE_BASE/
4、靜默升級Opatch
a)編輯responseFile檔案…/Disk1/response 目錄下的patchset.rsp
vi patchset.rsp 並新增以下內容
UNIX_GROUP_NAME=oinstall
FROM_LOCATION=/opt/Disk1/stage/products.xml
ORACLE_HOME=/opt/oracle/product/10.2.0/db_3
ORACLE_HOME_NAME=OraDb10g_home1
b)執行靜默安裝Opatch
[ora@dg-ss response]$ /opt/Disk1/runInstaller -silent -responseFile /opt/Disk1/response/patchset.rsp -force
正在啟動 Oracle Universal Installer...
正在檢查安裝程式要求...
檢查作業系統版本: 必須是redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3
通過
所有安裝程式要求均已滿足。
準備從以下地址啟動 Oracle Universal Installer /tmp/OraInstall2012-10-29_10-42-39AM. 請稍候...[ora@dg-ss response]$ Oracle Universal Installer, 版本 10.2.0.4.0 正式版
版權所有 (c) 1999, 2008, Oracle。保留所有權利。
本次安裝會話的日誌可見於:
/opt/oraInventory/logs/installActions2012-10-29_10-42-39AM.log
.................................................................................................... 100% 已完成。
正在載入產品資訊
......................................................................................................... 100% 已完成。
開始執行先決條件...
Total No of checks: 2
Performing check for checkToInstallCCR
檢查 Oracle 主目錄中已安裝的元件
檢查完成。此次檢查的總體結果為: 通過
Check complete: 通過
=======================================================================
Performing check for CompatibilityChecks
正在檢查 Oracle 主目錄的不相容性...
檢查完成。此次檢查的總體結果為: 通過
Check complete: 通過
=======================================================================
PrereqChecks complete
分析相關性
............................................................................................................ 100% 已完成。
-----------------------------------------------------------------------------
概要
全域性設定
來源: /opt/Disk1/stage/products.xml
Oracle 主目錄: /opt/oracle/product/10.2.0/db_2 (OraDb10g_home1)
產品語言
簡體中文
英語
空間要求
/ 要求空間 1.09GB (包括 42MB 臨時空間) : 可用空間 3.06GB
新安裝元件 (80 個產品)
Oracle Notification Service Patch 10.2.0.4.0
Database Configuration and Upgrade Assistants Patch 10.2.0.4.0
Character Set Migration Utility Patch 10.2.0.4.0
Oracle Database 10g Patch 10.2.0.4.0
Oracle JDBC/OCI Instant Client Patch 10.2.0.4.0
Oracle Database 10g Patch 10.2.0.4.0
Enterprise Manager plugin Common Files Patch 10.2.0.4.0
SQL*Plus 10.2.0.4.0
HAS Common Files Patch 10.2.0.4.0
HAS Files for DB Patch 10.2.0.4.0
Oracle Java Client Patch 10.2.0.4.0
Oracle JVM Patch 10.2.0.4.0
Oracle Internet Directory Client Patch 10.2.0.4.0
iSQL*Plus 10.2.0.4.0
Oracle Advanced Security Patch 10.2.0.4.0
Oracle Net Patch 10.2.0.4.0
Oracle Net Listener Patch 10.2.0.4.0
Oracle Wallet Manager Patch 10.2.0.4.0
Precompiler Common Files Patch 10.2.0.4.0
Secure Socket Layer Patch 10.2.0.4.0
Oracle ODBC Driver Patch 10.2.0.4.0
Oracle OLAP Patch 10.2.0.4.0
Oracle OLAP API Patch 10.2.0.4.0
OLAP SQL Scripts Patch 10.2.0.4.0
Oracle interMedia Client Option Patch 10.2.0.4.0
Oracle Database 10g interMedia Files Patch 10.2.0.4.0
Oracle interMedia Patch 10.2.0.4.0
PL/SQL Embedded Gateway Patch 10.2.0.4.0
Oracle XML Development Kit Patch 10.2.0.4.0
Oracle Text Patch 10.2.0.4.0
Oracle Clusterware RDBMS Files Patch 10.2.0.4.0
Database SQL Scripts Patch 10.2.0.4.0
Oracle Data Mining RDBMS Files Patch 10.2.0.4.0
Generic Connectivity Common Files Patch 10.2.0.4.0
Installation Common Files Patch 10.2.0.4.0
Oracle Starter Database Patch 10.2.0.4.0
Sample Schema Data Patch 10.2.0.4.0
Oracle interMedia Locator RDBMS Files Patch 10.2.0.4.0
Oracle Call Interface (OCI) Patch 10.2.0.4.0
Oracle OLAP RDBMS Files Patch 10.2.0.4.0
Oracle Partitioning Patch 10.2.0.4.0
PL/SQL 10.2.0.4.0
Oracle Recovery Manager Patch 10.2.0.4.0
Oracle Database Utilities Patch 10.2.0.4.0
Oracle interMedia Locator Patch 10.2.0.4.0
XML Parser for Java Patch 10.2.0.4.0
Assistant Common Files Patch 10.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.2 Patch 10.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.4 Patch 10.2.0.4.0
Oracle interMedia Java Advanced Imaging Patch 10.2.0.4.0
SQLJ Runtime Patch 10.2.0.4.0
XML Parser for Oracle JVM Patch 10.2.0.4.0
Enterprise Manager Agent DB 10.2.0.4.0
Enterprise Manager Baseline 10.2.0.4.0
Oracle Enterprise Manager Console DB 10.2.0.4.0
XDK Required Support Files Patch 10.2.0.4.0
Agent Required Support Files Patch 10.2.0.4.0
DBJAVA Required Support Files Patch 10.2.0.4.0
LDAP Required Support Files Patch 10.2.0.4.0
Precompiler Required Support Files Patch 10.2.0.4.0
Oracle RAC Required Support Files-HAS Patch 10.2.0.4.0
RDBMS Required Support Files for Instant Client Patch 10.2.0.4.0
RDBMS Required Support Files Patch 10.2.0.4.0
SQL*Plus Required Support Files Patch 10.2.0.4.0
SSL Required Support Files for InstantClient Patch 10.2.0.4.0
Oracle Net Required Support Files Patch 10.2.0.4.0
Oracle Globalization Support Patch 10.2.0.4.0
Oracle Core Required Support Files Patch 10.2.0.4.0
Platform. Required Support Files 10.2.0.4.0
Oracle Message Gateway Common Files Patch 10.2.0.4.0
Enterprise Manager Agent Core Patch 10.2.0.4.0a
Enterprise Manager Common Core Patch 10.2.0.4.0a
Enterprise Manager Repository Core patch 10.2.0.4.0a
Oracle Containers for Java 10.2.0.4.0
Enterprise Manager Repository DB 10.2.0.4.0
Oracle LDAP administration patch 10.2.0.4.0
JDBC Common Files 10.2.0.4.0
Database Workspace Manager 10.2.0.4.0
Oracle Configuration Manager 10.2.7.1.0
Oracle Real Application Testing 10.2.0.4.0
升級元件 (5 個產品)
Oracle Universal Installer 10.2.0.4.0
Oracle One-Off Patch Installer 10.2.0.4.0
Installer SDK Component 10.2.0.4.0
Java Runtime Environment 1.4.2.14.0
Sun JDK 1.4.2.14.0
已安裝 (78 個產品)
Oracle Notification Service 10.1.0.3.0
Database Configuration and Upgrade Assistants 10.2.0.1.0
Character Set Migration Utility 10.2.0.1.0
Oracle Database 10g 10.2.0.1.0
Oracle JDBC/OCI Instant Client 10.2.0.1.0
Oracle Database 10g 10.2.0.1.0
Enterprise Manager plugin Common Files 10.2.0.1.0
SQL*Plus 10.2.0.1.0
HAS Common Files 10.2.0.1.0
HAS Files for DB 10.2.0.1.0
Oracle Java Client 10.2.0.1.0
Oracle JVM 10.2.0.1.0
Oracle Internet Directory Client 10.2.0.1.0
iSQL*Plus 10.2.0.1.0
Oracle Advanced Security 10.2.0.1.0
Oracle Net 10.2.0.1.0
Oracle Net Listener 10.2.0.1.0
Oracle Wallet Manager 10.2.0.1.0
Precompiler Common Files 10.2.0.1.0
Secure Socket Layer 10.2.0.1.0
Oracle ODBC Driver 10.2.0.1.0
Oracle OLAP 10.2.0.1.0
Oracle OLAP API 10.2.0.1.0
OLAP SQL Scripts 10.2.0.1.0
Oracle interMedia Client Option 10.2.0.1.0
Oracle Database 10g interMedia Files 10.2.0.1.0
Oracle interMedia 10.2.0.1.0
PL/SQL Embedded Gateway 10.2.0.1.0
Oracle XML Development Kit 10.2.0.1.0
Oracle Text 10.2.0.1.0
Oracle Clusterware RDBMS Files 10.2.0.1.0
Database SQL Scripts 10.2.0.1.0
Oracle Data Mining RDBMS Files 10.2.0.1.0
Generic Connectivity Common Files 10.2.0.1.0
Installation Common Files 10.2.0.1.0
Oracle Starter Database 10.2.0.1.0
Sample Schema Data 10.2.0.1.0
Oracle interMedia Locator RDBMS Files 10.2.0.1.0
Oracle Call Interface (OCI) 10.2.0.1.0
Oracle OLAP RDBMS Files 10.2.0.1.0
Oracle Partitioning 10.2.0.1.0
PL/SQL 10.2.0.1.0
Oracle Recovery Manager 10.2.0.1.0
Oracle Database Utilities 10.2.0.1.0
Oracle interMedia Locator 10.2.0.1.0
XML Parser for Java 10.2.0.1.0
Assistant Common Files 10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0
Oracle interMedia Java Advanced Imaging 10.2.0.1.0
SQLJ Runtime 10.2.0.1.0
XML Parser for Oracle JVM 10.2.0.1.0
Enterprise Manager Agent DB 10.2.0.1.0
Enterprise Manager Baseline 10.2.0.1.0
Oracle Enterprise Manager Console DB 10.2.0.1.0
XDK Required Support Files 10.2.0.1.0
Agent Required Support Files 10.2.0.1.0
DBJAVA Required Support Files 10.2.0.1.0
LDAP Required Support Files 10.2.0.1.0
Precompiler Required Support Files 10.2.0.1.0
Oracle RAC Required Support Files-HAS 10.2.0.1.0
RDBMS Required Support Files for Instant Client 10.2.0.1.0
RDBMS Required Support Files 10.2.0.1.0
SQL*Plus Required Support Files 10.2.0.1.0
SSL Required Support Files for InstantClient 10.2.0.1.0
Oracle Net Required Support Files 10.2.0.1.0
Oracle Globalization Support 10.2.0.1.0
Oracle Core Required Support Files 10.2.0.1.0
Platform. Required Support Files 10.2.0.1.0
Oracle Message Gateway Common Files 10.2.0.1.0
Enterprise Manager Agent Core 10.2.0.1.0
Enterprise Manager Common Files 10.2.0.1.0
Enterprise Manager Repository Core 10.2.0.1.0
Oracle Containers for Java 10.2.0.1.0
Enterprise Manager Repository DB 10.2.0.1.0
Oracle LDAP administration 10.2.0.1.0
JDBC Common Files 10.2.0.1.0
Database Workspace Manager 10.2.0.1.0
-----------------------------------------------------------------------------
正在進行卸裝 (2012年10月29日星期一 上午10時42分48秒 CST)
............................................................... 0% 已完成。
............................................................... 18% 已完成。
............................................................... 37% 已完成。
............................................................... 56% 已完成。
............................................................... 75% 已完成。
................. 100% 已完成。
卸裝成功
正在安裝 (2012年10月29日星期一 上午10時42分48秒 CST)
............................................................... 18% 已完成。
............................................................... 37% 已完成。
............................................................... 56% 已完成。
............................................................... 75% 已完成。
......................................... 88% 已完成。
安裝成功
正在進行連結 (2012年10月29日星期一 上午10時43分32秒 CST)
.. 88% 已完成。
連結成功
正在進行設定 (2012年10月29日星期一 上午10時43分53秒 CST)
........ 100% 已完成。
設定成功
安裝階段結束。(2012年10月29日 星期一上午10時43分55秒 CST)
WARNING:
以下配置指令碼需要以 "root" 使用者的身份執行。
#!/bin/sh
#Root script. to run
/opt/oracle/product/10.2.0/db_2/root.sh
要執行配置指令碼, 請執行以下操作:
1. 開啟終端視窗
2. 以 "root" 身份登入
3. 執行指令碼
Oracle Database 10g Release 2 Patch Set 3 的 安裝 已成功。
請檢視 '/opt/oraInventory/logs/silentInstall2012-10-29_10-42-39AM.log' 以獲取詳細資料。
c)root執行指令碼root.sh
[root@dg-ss ~]# /opt/oracle/product/10.2.0/db_2/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= ora
ORACLE_HOME= /opt/oracle/product/10.2.0/db_2
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
5、檢測升級的Opatch
[ora@dg-ss response]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Oct 29 10:45:01 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 457179136 bytes
Fixed Size 1268052 bytes
Variable Size 142608044 bytes
Database Buffers 310378496 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
SQL> spool upgrade_info.log
SQL> @?/rdbms/admin/utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 10-29-2012 10:45:17
**********************************************************************
Database:
**********************************************************************
--> name: TEST
--> version: 10.2.0.1.0
--> compatible: 10.2.0.1.0
--> blocksize: 8192
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 487 MB
.... AUTOEXTEND additional space required: 7 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
.... AUTOEXTEND additional space required: 375 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 250 MB
.... AUTOEXTEND additional space required: 10 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 58 MB
.... AUTOEXTEND additional space required: 38 MB
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No update parameter changes are required.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No obsolete parameters found. No changes are required
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> 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
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> Oracle OLAP API [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Rule Manager [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Database contains INVALID objects prior to upgrade.
.... USER DMSYS has 1 INVALID objects.
.... USER PUBLIC has 44 INVALID objects.
.... USER CTXSYS has 1 INVALID objects.
.... USER EXFSYS has 12 INVALID objects.
.... USER SYS has 138 INVALID objects.
PL/SQL procedure successfully completed.
SQL> spool off
6、升級資料庫
a)開啟監聽
lsnrctl start
[ora@dg-ss response]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 29-OCT-2012 10:45:34
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /opt/oracle/product/10.2.0/db_2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_2/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg-ss)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg-ss)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 29-OCT-2012 10:45:34
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/10.2.0/db_2/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/db_2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg-ss)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
b)升級資料字典
[ora@dg-ss response]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Oct 29 10:45:46 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn /as sysdba
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 457179136 bytes
Fixed Size 1268052 bytes
Variable Size 142608044 bytes
Database Buffers 310378496 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catupgrd.sql
。。。。。。。此處省略
Oracle Database 10.2 Upgrade Status Utility 10-29-2012 10:57:40
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:04:31
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:00:47
Oracle XDK VALID 10.2.0.4.0 00:00:15
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:08
Oracle Text VALID 10.2.0.4.0 00:00:10
Oracle XML Database VALID 10.2.0.4.0 00:00:35
Oracle Workspace Manager VALID 10.2.0.4.3 00:00:16
Oracle Data Mining VALID 10.2.0.4.0 00:00:09
OLAP Analytic Workspace VALID 10.2.0.4.0 00:00:08
OLAP Catalog VALID 10.2.0.4.0 00:00:25
Oracle OLAP API VALID 10.2.0.4.0 00:00:20
Oracle interMedia VALID 10.2.0.4.0 00:02:01
Spatial VALID 10.2.0.4.0 00:00:42
Oracle Expression Filter VALID 10.2.0.4.0 00:00:05
Oracle Enterprise Manager VALID 10.2.0.4.0 00:00:45
Oracle Rule Manager VALID 10.2.0.4.0 00:00:03
.
Total Upgrade Time: 00:11:28
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The above PL/SQL lists the SERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the status and version columns and look for
DOC> any errors in the spool log file. If there are errors in the spool
DOC> file, or any components are not VALID or not the current version,
DOC> consult the Oracle Database Upgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
SQL>spool off
7、升級結果檢驗
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 457179136 bytes
Fixed Size 1268052 bytes
Variable Size 176162476 bytes
Database Buffers 276824064 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
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
8、升級EM
[ora@dg-ss response]$ emca -upgrade db
OK 升級成功!!!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26442936/viewspace-756269/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle database 升級(文件)to 10.2.0.4 from 10.2.0.1OracleDatabase
- 靜默升級oracle到10.2.0.4Oracle
- 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
- 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
- oracle 10.2.0.1 rac 升級到10.2.0.4 rac時,dbua升級的元件列表Oracle元件
- Oracle 10g rac升級(10.2.0.1 Rac到10.2.0.4)Oracle 10g
- linux下oracle RAC10.2.0.1升級到10.2.0.4LinuxOracle
- windows 2003,oracle 10.2.0.1升級到10.2.0.4WindowsOracle
- Oracle10.2.0.1 升級到Oracle10.2.0.4 簡單步驟Oracle
- Oracle 10g upgrade from 10.2.0.1 to 10.2.0.4Oracle 10g
- linux平臺下oracle從10.2.0.1升級到10.2.0.4LinuxOracle
- 靜默安裝ORACLE(文件)Oracle
- oracle在linux平臺從10.2.0.1升級到10.2.0.4方法OracleLinux
- Oracle RAC ASM 例項 從10.2.0.1 升級到 10.2.0.4 說明OracleASM
- 靜默升級oracle 11g (從11.2.0.1升級到11.2.0.4)Oracle
- Oracle10.2.0.1升級到10.2.0.4碰到的Text file busy問題Oracle
- 升級Oracle10.2.0.1Oracle
- 靜默方式安裝、升級oracle(一): 安裝oracle軟體Oracle
- Linux下Oracle10.2.0.1升級到oracle10.2.0.4詳細操作記錄LinuxOracle
- 靜默方式安裝、升級oracle(二): 建立資料庫Oracle資料庫
- 靜默方式安裝database vault 10.2.0.4Database
- oracle 10 rac 升級 10.2.0.1升級到10.2.0.5Oracle
- Oracle10.2.0.1到10.2.0.4升級出現了ORA-01092故障Oracle
- oracle 10.2.0.2升級到10.2.0.4Oracle
- Redhat 5.4 Orcle RAC 資料庫 從10.2.0.1升級到 10.2.0.4Redhat資料庫
- 靜默方式安裝、升級oracle(三): 升級資料庫軟體及資料庫Oracle資料庫
- inux下靜默安裝,升級和刪除Oracle客戶端UXOracle客戶端
- oracle cluster 10.2.0.1 for aix 6.1 升級到10.2.0.4會出現vip offline問題OracleAI
- Vcenter上SuSE10 32位安裝10.2.0.1 並升級10.2.0.4
- 升級Oracle 10g 到10.2.0.4Oracle 10g
- Oracle10g RAC 資料庫升級為10.2.0.4 ,clusterware需要升級到10.2.0.4 ?Oracle資料庫
- oracle10.2.0.4(經10.2.0.1升級)利用runInstaller silent方式刪除oracle軟體相關錯誤Oracle