eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« Oracle诊断案例-Job任务停止执行 | Blog首页 | 在Oracle9i中,如何监视索引并清除监视信息 »

使用Opatch工具应用过渡性Patch

很多时候,在推出一个完整的补丁集之前,Oracle会依据Bug的严重程度发布一些过渡性或临时性Patch,修正一些Bug。
这些Patch通常没有setup安装程序,需要使用Oracle的opatch工具安装,本文就opatch的使用进行示范说明。

1.下载

Opatch的最新版本可以从Metalink下载,参考 Note:224346.1

2.使用

在NT/UNIX,Opatch都需要perl支持,所以,使用之前确认你安装了perl环境支持。

把下载的patch解压后,可以使用opatch调用安装,示范如下:

 

$ opatch apply 2990321
PERL5LIB=/opt/oracle/product/9.2.0/Apache/perl/lib/5.00503:./opatch_modules; export PERL5LIB
/opt/oracle/product/9.2.0/Apache/perl/bin/perl ./opatch.pl apply 2990321


OPatch Version 1.0.0.0.43
Perl Version 5.00503


Performing pre-patch installation checks.

general_options is set to 0

Using oraInst.loc to look up oui libs...

Parsing /opt/oracle/oraInventory/ContentsXML/comps.xml

Found "oracle.swd.oui" version "2.2.0.12.0"
  on "/opt/oracle/oui"

Found JRE version "1.3.1.0.0a"
  on "/opt/oracle/jre/1.3.1/bin/java"

Oracle Home = /opt/oracle/product/9.2.0
inventory_location = /opt/oracle/oraInventory
liboraInstaller_lib= /opt/oracle/oui/bin/solaris/liboraInstaller.so
path_to_java = /opt/oracle/jre/1.3.1/bin/java
path_to_oI_loc = /var/opt/oracle/oraInst.loc
oui_component_loc = /opt/oracle/oui
required_jar_file under oui = lib/OraInstaller.jar

Checking if this is a RAC system...

This is not a RAC system

Component Name: oracle.rdbms
Component Ver.: 9.2.0.3.0

Interim Patch ID: 2990321
Bugs fixed by this patch:
 2716764 2988114 
---Patch号,及修正的bug说明

Please shut down Oracle instances on this system
(Oracle Home = /opt/oracle/product/9.2.0)
Is this system ready for updating (are the instances down)?
Please respond Y|N > Y
Backing-up files before patching.

Applying patch 2990321.

Patching /opt/oracle/product/9.2.0/lib/libagent9.a
with hodmp.o.

Patching /opt/oracle/product/9.2.0/lib/libagent9.a
with homt.o.

Patching /opt/oracle/product/9.2.0/lib/libagent9.a
with horcr.o.

Running make for client_sharedlib.

ar: creating /opt/oracle/product/9.2.0/lib/libclntst9.a
ar: creating /opt/oracle/product/9.2.0/lib32/libclntst9.a
Running make for iextproc.

Performing post-patch inventory update and removing working files.

Patch 2990321 has been applied successfully.

Updating inventory...

OPatch succedded.
                      

3.通过opatch查看数据库各组件版本

 

 

cbash-2.03$ cd OPatch/
bash-2.03$ ls
2990321         README.txt      opatch          opatch.pl
Documentation   jlib            opatch.bat      opatch_modules
bash-2.03$ opatch
PERL5LIB=/opt/oracle/product/9.2.0/Apache/perl/lib/5.00503:./opatch_modules; export PERL5LIB
/opt/oracle/product/9.2.0/Apache/perl/bin/perl ./opatch.pl 

 Usage: opatch [ -h[elp] ] [ -r[eport] ] [ command ]

            command := apply
                       attach
                       lsinventory
                       query
                       rollback
                       version

  := -help       Displays the help message for the command.
                       -report     Print the actions without executing (deprecated).

                       


ERROR: OPatch failed because of cmd. args. problem.


bash-2.03$ opatch lsinventory
PERL5LIB=/opt/oracle/product/9.2.0/Apache/perl/lib/5.00503:./opatch_modules; export PERL5LIB
/opt/oracle/product/9.2.0/Apache/perl/bin/perl ./opatch.pl lsinventory
Using oraInst.loc to look up oui libs...

Parsing /opt/oracle/oraInventory/ContentsXML/comps.xml

Found "oracle.swd.oui" version "2.2.0.18.0"
  on "/opt/oracle/oui"

Found JRE version "1.3.1.0.0a"
  on "/opt/oracle/jre/1.3.1/bin/java"

Oracle Home = /opt/oracle/product/9.2.0
inventory_location = /opt/oracle/oraInventory
liboraInstaller_lib= /opt/oracle/oui/bin/solaris/liboraInstaller.so
path_to_java = /opt/oracle/jre/1.3.1/bin/java
path_to_oI_loc = /var/opt/oracle/oraInst.loc
oui_component_loc = /opt/oracle/oui
required_jar_file under oui = lib/OraInstaller.jar

Retrieving inventory.

PRODUCT NAME                                                        VERSION

============                                                        =======

Advanced Queueing (AQ) API Patch                                  9.2.0.4.0
Advanced Queueing (AQ) API                                        9.2.0.1.0
Advanced Replication Patch                                        9.2.0.4.0
Advanced Replication                                              9.2.0.1.0
Agent Required Support Files Patch                                9.2.0.4.0
Agent Required Support Files                                      9.2.0.1.0
Apache Configuration for Oracle Java Server Pages                 1.1.2.3.0
Apache Configuration for Oracle XML Developer's Kit               9.2.0.1.0
Apache JServ                                                     1.1.0.0.0g
Apache Web Server files                                         1.3.22.0.0a
Assistant Common Files Patch                                      9.2.0.4.0
Assistant Common Files                                            9.2.0.1.0
Authentication and Encryption 32-bit                              9.2.0.1.0
Authentication and Encryption 32-bit                              9.2.0.4.0
Authentication and Encryption Patch                               9.2.0.4.0
Authentication and Encryption                                     9.2.0.1.0
Bali Share                                                       1.1.17.0.0
BC4J Runtime for Database                                       9.0.2.692.1
Capacity Planner                                                  9.2.0.1.0
Change Management Common Files                                    9.2.0.1.0
Character Set Migration Utility                                   9.2.0.1.0
Character Set Migration Utility                                   9.2.0.4.0
Data Management Services Common Files Patch                       9.2.0.4.0
Data Management Services Common Files                             9.2.0.1.0
Database Configuration Assistant                                  9.2.0.1.0
Database SQL Scripts Patch                                        9.2.0.4.0
Database SQL Scripts                                              9.2.0.1.0
Database Upgrade Assistant                                        9.2.0.1.0
Database Verify Utility Patch                                     9.2.0.4.0
Database Verify Utility                                           9.2.0.1.0
Database Workspace Manager                                        9.2.0.1.0
DBJAVA Required Support Files Patch                               9.2.0.4.0
DBJAVA Required Support Files                                     9.2.0.1.0
Documentaion Required Support Files                               9.2.0.1.0
Enterprise Edition Options                                        9.2.0.1.0
Enterprise Login Assistant                                        9.2.0.1.0
Enterprise Manage Website Translated Files                        9.2.0.1.0
Enterprise Manager Base Classes                                   9.2.0.1.0
Enterprise Manager Client                                         9.2.0.1.0
Enterprise Manager Common Files                                   9.2.0.1.0
Enterprise Manager Console                                        9.2.0.1.0
Enterprise Manager Database Applications                          9.2.0.1.0
Enterprise Manager Events                                         9.2.0.1.0
Enterprise Manager Installation Prerequisite Checks               9.2.0.1.0
Enterprise Manager Integrated Applications                        9.2.0.1.0
Enterprise Manager Minimal Integration                            9.2.0.1.0
Enterprise Manager Paging and OMS Common Files                    9.2.0.1.0
Enterprise Manager Quick Tours                                    9.2.0.1.0
Enterprise Manager Translated Files                               9.2.0.1.0
Enterprise Manager Web Site                                       9.2.0.1.0
Enterprise Manager Webserver Integration                          9.2.0.1.0
Export/Import Patch                                               9.2.0.4.0
Export/Import                                                     9.2.0.1.0
External Naming: NIS Patch                                        9.2.0.4.0
External Naming: NIS                                              9.2.0.1.0
Generic Connectivity Common Files Patch                           9.2.0.4.0
Generic Connectivity Common Files                                 9.2.0.1.0
Generic Connectivity Using ODBC Patch                             9.2.0.4.0
Generic Connectivity Using ODBC                                   9.2.0.1.0
Installation Common Files Patch                                   9.2.0.4.0
Installation Common Files                                         9.2.0.1.0
iSQL*Plus Patch                                                   9.2.0.4.0
iSQL*Plus                                                         9.2.0.1.0
JDBC Common Files Patch                                           9.2.0.4.0
JDBC Common Files                                                 9.2.0.1.0
JDBC/OCI Common Files Patch                                       9.2.0.4.0
JDBC/OCI Common Files                                             9.2.0.1.0
JSDK                                                             2.0.0.0.0d
LDAP Required Support Files Patch                                 9.2.0.4.0
LDAP Required Support Files                                       9.2.0.1.0
Legato Networker Single Server                                    6.1.0.0.0
Migration Utility Patch                                           9.2.0.4.0
Migration Utility                                                 9.2.0.1.0
New Database ID Patch                                             9.2.0.4.0
New Database ID                                                   9.2.0.1.0
Object Type Translator Patch                                      9.2.0.4.0
Object Type Translator                                            9.2.0.1.0
Oracle 9iR2 Patchset                                              9.2.0.4.0
Oracle Advanced Security                                          9.2.0.1.0
Oracle Applications Extensions Patch                              9.2.0.4.0
Oracle Applications Extensions                                    9.2.0.1.0
Oracle C++ Call Interface Patch                                   9.2.0.4.0
Oracle C++ Call Interface                                         9.2.0.1.0
Oracle Caching Service for Java                                  2.1.0.0.0a
Oracle Call Interface (OCI) Patch                                 9.2.0.4.0
Oracle Call Interface (OCI)                                       9.2.0.1.0
Oracle Change Management Pack                                     9.2.0.1.0
Oracle Client Required Support Files Patch                        9.2.0.4.0
Oracle Client Required Support Files                              9.2.0.1.0
Oracle Code Editor                                               1.2.1.0.0A
Oracle Common Schema Demos Patch                                  9.2.0.4.0
Oracle Common Schema Demos                                        9.2.0.1.0
Oracle Complete DSS Starter Database                              9.2.0.1.0
Oracle Complete OLTP Starter Database                             9.2.0.1.0
Oracle Core Required Support Files Patch                          9.2.0.4.0
Oracle Core Required Support Files                                9.2.0.1.0
Oracle Data Mining Patch                                          9.2.0.4.0
Oracle Data Mining                                                9.2.0.1.0
Oracle Database Demos Patch                                       9.2.0.4.0
Oracle Database Demos                                             9.2.0.1.0
Oracle Database User Interface                                   2.2.11.0.0
Oracle Database Utilities Patch                                   9.2.0.4.0
Oracle Database Utilities                                         9.2.0.1.0
Oracle Developer Server Forms Manager                             9.2.0.1.0
Oracle Diagnostics Pack                                           9.2.0.1.0
Oracle Display Fonts                                              9.0.2.0.0
Oracle Dynamic Services Server                                    9.2.0.1.0
Oracle eBusiness Management Extensions Patch                      9.2.0.4.0
Oracle eBusiness Management Extensions                            9.2.0.1.0
Oracle EMD Agent Extensions Patch                                 9.2.0.4.0
Oracle EMD Agent Extensions                                       9.2.0.1.0
Oracle Enterprise Manager Products                                9.2.0.1.0
Oracle Extended Windowing Toolkit                                3.4.13.0.0
Oracle Forms Extensions                                           9.2.0.1.0
Oracle Help For Java                                             3.2.13.0.0
Oracle Help For Java                                             4.1.13.0.0
Oracle Help for the  Web                                          1.0.7.0.0
Oracle HTTP Server Extensions                                     9.2.0.1.0
Oracle HTTP Server                                                9.2.0.1.0
Oracle Ice Browser                                               5.06.8.0.0
Oracle Intelligent Agent Base Component Files Patch               9.2.0.4.0
Oracle Intelligent Agent Base Component Files                     9.2.0.1.0
Oracle Intelligent Agent Config Tool                              9.2.0.1.0
Oracle Intelligent Agent Extensions                               9.2.0.1.0
Oracle Intelligent Agent                                          9.2.0.1.0
Oracle interMedia Annotator                                       9.2.0.1.0
Oracle interMedia Audio                                           9.2.0.1.0
Oracle interMedia Audio                                           9.2.0.4.0
Oracle interMedia Client Compatibility Files Patch                9.2.0.4.0
Oracle interMedia Client Compatibility Files                      9.2.0.1.0
Oracle interMedia Client Demos Patch                              9.2.0.4.0
Oracle interMedia Client Demos                                    9.2.0.1.0
Oracle interMedia Client Option                                   9.2.0.1.0
Oracle interMedia Common Files Patch                              9.2.0.4.0
Oracle interMedia Common Files                                    9.2.0.1.0
Oracle interMedia Image                                           9.2.0.1.0
Oracle interMedia Image                                           9.2.0.4.0
Oracle interMedia Java Advanced Imaging Patch                     9.2.0.4.0
Oracle interMedia Java Advanced Imaging                           9.2.0.1.0
Oracle interMedia Java Client                                     9.2.0.1.0
Oracle interMedia Java Media Framework Client                     9.2.0.1.0
Oracle interMedia Locator Patch                                   9.2.0.4.0
Oracle interMedia Locator                                         9.2.0.1.0
Oracle interMedia Video                                           9.2.0.1.0
Oracle interMedia Video                                           9.2.0.4.0
Oracle interMedia Web Client                                      9.2.0.1.0
Oracle interMedia                                                 9.2.0.1.0
Oracle Internet Directory Client Common Files Patch               9.2.0.4.0
Oracle Internet Directory Client Common Files                     9.2.0.1.0
Oracle Internet Directory Client Patch                            9.2.0.4.0
Oracle Internet Directory Client                                  9.2.0.1.0
Oracle Internet Directory Tools                                   9.2.0.1.0
Oracle Java Core Patch                                            9.2.0.4.0
Oracle Java Layout Engine                                         2.0.1.0.0
Oracle Java Server Pages                                          1.1.3.1.0
Oracle Java Tools Patch                                           9.2.0.4.0
Oracle Java Tools                                                 9.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.1     Patch                     9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.1                               9.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.2     Patch                     9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.2                               9.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.4 Patch                         9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.4                               9.2.0.1.0
Oracle JDBC/OCI Driver for JDK 1.1                                9.2.0.1.0
Oracle JDBC/OCI Driver for JDK 1.2                                9.2.0.1.0
Oracle JFC Extended Windowing Toolkit                            4.1.10.0.0
Oracle JVM Patch                                                  9.2.0.4.0
Oracle JVM                                                        9.2.0.1.0
Oracle Management Pack for Oracle Applications                    9.2.0.1.0
Oracle Management Server                                          9.2.0.1.0
Oracle Message Gateway Common Files                               9.2.0.1.0
Oracle Mod PL/SQL Gateway                                        3.0.9.8.3b
Oracle Net Configuration Assistant Patch                          9.2.0.4.0
Oracle Net Configuration Assistant                                9.2.0.1.0
Oracle Net Listener Patch                                         9.2.0.4.0
Oracle Net Listener                                               9.2.0.1.0
Oracle Net Manager Patch                                          9.2.0.4.0
Oracle Net Manager                                                9.2.0.1.0
Oracle Net Patch                                                  9.2.0.4.0
Oracle Net Required Support Files Patch                           9.2.0.4.0
Oracle Net Required Support Files                                 9.2.0.1.0
Oracle Net Services                                               9.2.0.1.0
Oracle Net                                                        9.2.0.1.0
Oracle OLAP API Patch                                             9.2.0.4.0
Oracle OLAP API                                                   9.2.0.1.0
Oracle OLAP Cube Viewer                                           9.2.0.1.0
Oracle OLAP CWM Lite Patch                                        9.2.0.4.0
Oracle OLAP CWM Lite                                              9.2.0.1.0
Oracle OLAP Patch                                                 9.2.0.4.0
Oracle OLAP Worksheet                                             9.2.0.1.0
Oracle OLAP                                                       9.2.0.1.0
Oracle Partitioning Patch                                         9.2.0.4.0
Oracle Partitioning                                               9.2.0.1.0
Oracle Perl Interpreter                                      5.00503.0.0.0c
Oracle Programmer                                                 9.2.0.1.0
Oracle Required Support Files 32 bit                              9.2.0.1.0
Oracle Required Support Files 64 bit Patch                        9.2.0.4.0
Oracle SOAP Client                                               2.0.0.0.0a
Oracle SOAP for JServ                                            2.0.0.0.0a
Oracle SOAP Server                                               2.0.0.0.0a
Oracle Spatial Patch                                              9.2.0.4.0
Oracle Spatial                                                    9.2.0.1.0
Oracle SQLJ Patch                                                 9.2.0.4.0
Oracle SQLJ                                                       9.2.0.1.0
Oracle Starter Database                                           9.2.0.1.0
Oracle Text Patch                                                 9.2.0.4.0
Oracle Text                                                       9.2.0.1.0
Oracle Trace Patch                                                9.2.0.4.0
Oracle Trace Required Support Files Patch                         9.2.0.4.0
Oracle Trace Required Support Files                               9.2.0.1.0
Oracle Trace                                                      9.2.0.1.0
Oracle Transparent Gateways                                       9.2.0.1.0
Oracle Tuning Pack                                                9.2.0.1.0
Oracle UIX                                                       2.0.20.0.0
Oracle Ultra Search Common Files Patch                            9.2.0.4.0
Oracle Ultra Search Common Files                                  9.2.0.1.0
Oracle Ultra Search Middle-Tier Patch                             9.2.0.4.0
Oracle Ultra Search Middle-Tier                                   9.2.0.1.0
Oracle Ultra Search Server Patch                                  9.2.0.4.0
Oracle Ultra Search Server                                        9.2.0.1.0
Oracle Wallet Manager Patch                                       9.2.0.4.0
Oracle Wallet Manager                                             9.2.0.1.0
Oracle Workflow Manager                                           9.2.0.1.0
Oracle XML Developer's Kit Patch                                  9.2.0.4.0
Oracle XML Developer's Kit                                        9.2.0.1.0
Oracle XML Runtime Components                                     9.2.0.1.0
Oracle XML SQL Utility Patch                                      9.2.0.4.0
Oracle XML SQL Utility                                            9.2.0.1.0
Oracle9i Database                                                 9.2.0.1.0
Oracle9i Development Kit                                          9.2.0.1.0
Oracle9i for UNIX Documentation                                   9.2.0.1.0
Oracle9i Globalization Support Patch                              9.2.0.4.0
Oracle9i Globalization Support                                    9.2.0.1.0
Oracle9i Patch                                                    9.2.0.4.0
Oracle9i Server 32 bit                                            9.2.0.1.0
Oracle9i Server 64 bit Patch                                      9.2.0.4.0
Oracle9i Syndication Server                                       9.2.0.1.0
Oracle9i                                                          9.2.0.1.0
Parser Generator Required Support Files                           9.2.0.1.0
Performance Manager                                               9.2.0.1.0
PL/SQL Embedded Gateway                                           9.2.0.1.0
PL/SQL Patch                                                      9.2.0.4.0
PL/SQL Required Support Files Patch                               9.2.0.4.0
PL/SQL Required Support Files                                     9.2.0.1.0
PL/SQL                                                            9.2.0.1.0
Platform Required Support Files                                   9.2.0.1.0
Precompiler Common Files Patch                                    9.2.0.4.0
Precompiler Common Files                                          9.2.0.1.0
Precompiler Required Support Files Patch                          9.2.0.4.0
Precompiler Required Support Files                                9.2.0.1.0
Pro*C/C++ Patch                                                   9.2.0.4.0
Pro*C/C++                                                         9.2.0.1.0
Pro*COBOL Patch                                                  1.8.77.4.0
Pro*COBOL Patch                                                   9.2.0.4.0
Pro*COBOL                                                        1.8.77.0.0
Pro*COBOL                                                         9.2.0.1.0
Pro*FORTRAN Patch                                                1.8.77.4.0
Pro*FORTRAN                                                      1.8.77.0.0
RDBMS Required Support Files Patch                                9.2.0.4.0
RDBMS Required Support Files                                      9.2.0.1.0
Recovery Manager Patch                                            9.2.0.4.0
Recovery Manager                                                  9.2.0.1.0
regexp                                                           2.0.20.0.0
Reporting Framework                                               9.2.0.1.0
Required Support Files                                            9.2.0.1.0
Secure Socket Layer Patch                                         9.2.0.4.0
Secure Socket Layer                                               9.2.0.1.0
SQL*Loader Patch                                                  9.2.0.4.0
SQL*Loader                                                        9.2.0.1.0
SQL*Plus Patch                                                    9.2.0.4.0
SQL*Plus Required Support Files Patch                             9.2.0.4.0
SQL*Plus Required Support Files                                   9.2.0.1.0
SQL*Plus                                                          9.2.0.1.0
SQLJ Runtime Patch                                                9.2.0.4.0
SQLJ Runtime                                                      9.2.0.1.0
SQLJ Translator                                                   9.2.0.1.0
SQLServer Monitoring Option                                       9.2.0.1.0
SSL Required Support Files Patch                                  9.2.0.4.0
SSL Required Support Files                                        9.2.0.1.0
Sun JDK extensions                                                9.2.0.1.0
Sun JDK                                                          1.3.1.0.1a
Utilities Common Files Patch                                      9.2.0.4.0
Utilities Common Files                                            9.2.0.1.0
Visigenics ORB                                                    3.4.0.0.0
XDK Required Support Files Patch                                  9.2.0.4.0
XDK Required Support Files                                        9.2.0.1.0
XML Class Generator for C++                                       9.2.0.1.0
XML Class Generator for C++                                       9.2.0.4.0
XML Class Generator for Java                                      9.2.0.1.0
XML Class Generator for Java                                      9.2.0.4.0
XML Parser for C Patch                                            9.2.0.4.0
XML Parser for C++ Patch                                          9.2.0.4.0
XML Parser for C++                                                9.2.0.1.0
XML Parser for C                                                  9.2.0.1.0
XML Parser for Java Patch                                         9.2.0.4.0
XML Parser for Java                                               9.2.0.1.0
XML Parser for Oracle JVM Patch                                   9.2.0.4.0
XML Parser for Oracle JVM                                         9.2.0.1.0
XML Parser for PL/SQL Patch                                       9.2.0.4.0
XML Parser for PL/SQL                                             9.2.0.1.0
XML Transviewer Beans                                             9.2.0.1.0
XML Transviewer Beans                                             9.2.0.4.0
XML Transx                                                        9.2.0.1.0
XML Transx                                                        9.2.0.4.0
XML                                                               9.2.0.1.0
XML                                                               9.2.0.4.0
XSQL Servlet                                                      9.2.0.1.0
XSQL Servlet                                                      9.2.0.4.0




OPatch succedded.       

使用opatch的rollback选项,还可以回滚某个临时补丁,不再具体说明。


-The End-

历史上的今天...
    >> 2010-12-04文章:
    >> 2006-12-04文章:
           也谈关于 Blog 的版权
    >> 2005-12-04文章:
           Install MT plugins-Scode 1

无觅

By eygle on 2004-12-04 10:08 | Comments (0) | FAQ | 103 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com