December 4, 2004
作者:eygle
对于DML操作来说，索引对于数据库是一个性能负担.如果索引没有被有效的使用,那么其存在性就值得从新考虑.
1. 从Oracle9i开始,Oracle允许你监视索引的使用:
SQL> connect scott/tiger@conner
Connected to Oracle9i Enterprise Edition Release 9.2.0.4.0
Connected as scott
SQL> select index_name from user_indexes;
INDEX_NAME
------------------------------
PK_DEPT
PK_EMP
开始监视pk_dept索引:
SQL> alter index pk_dept monitoring usage;
Index altered
在此过程中,如果查询使用索引,将会记录下来:
SQL> select * from dept where deptno=10;
DEPTNO DNAME LOC
------ -------------- -------------
10 ACCOUNTING NEW YORK
停止监视:
SQL> alter index pk_dept nomonitoring usage;
Index altered
查询索引使用情况,YES表示在监视过程中索引被使用到:
SQL> select * from v$object_usage;
INDEX_NAME TABLE_NAME MONITORING USED START_MONITORING END_MONITORING
----------------- ------------------ ---------- ---- ------------------- -------------------
PK_DEPT DEPT NO YES 10/28/2004 10:55:19 10/28/2004 10:55:47
SQL>
|
2.Oracle9i的Bug
在9205之前，如果你不慎监控了SYS.I_OBJAUTH1索引，并且不幸在重起数据库之前没有停止它，那么你的数据库将会无法启动，并且
不会给出任何错误信息。
以下这条简单的语句可以轻易再现这个问题:
'ALTER INDEX SYS.I_OBJAUTH1 MONITORING USAGE'
如果你有了足够好的备份(严重警告，请不要拿你的生产数据库进行测试)，你可以尝试一下:
[oracle@jumper oradata]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Dec 4 10:09:30 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> alter index SYS.I_OBJAUTH1 monitoring usage ;
Index altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 80811208 bytes
Fixed Size 451784 bytes
Variable Size 37748736 bytes
Database Buffers 41943040 bytes
Redo Buffers 667648 bytes
Database mounted.
|
此时，数据库挂起，而且不会有任何提示，在alert<sid>.log文件中，你可以看到:
[oracle@jumper bdump]$ tail -f alert_conner.log
Completed: ALTER DATABASE MOUNT
Sat Dec 4 10:09:49 2004
ALTER DATABASE OPEN
Sat Dec 4 10:09:49 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 54
Current log# 2 seq# 54 mem# 0: /opt/oracle/oradata/conner/redo02.log
Successful open of redo thread 1.
Sat Dec 4 10:09:49 2004
SMON: enabling cache recovery
Sat Dec 4 10:10:33 2004
Restarting dead background process QMN0
QMN0 started with pid=9
|
然后数据库将会停在此处。
如果不知道此bug存在，你可能会一筹莫展的。
现在你能做的就是从备份中恢复，或者升级到9.2.0.5。
Oracle已经Release了这个Bug，你可以参考Metalink:Note:2934068.8,Oracle声明在9.2.0.5 (Server Patch Set)和 10g Production Base Release中fixed了这个Bug。
[oracle@jumper oradata]$ rm -rf conner
[oracle@jumper oradata]$ cp -R connerbak/ conner
[oracle@jumper oradata]$ sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Dec 4 10:19:07 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 80811208 bytes
Fixed Size 451784 bytes
Variable Size 37748736 bytes
Database Buffers 41943040 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> |
3. 在特殊的情况下,你可能需要清除这个v$object_usage视图中的信息.
Oracle的说法是,在下一次收集该对象的索引使用情况时会自动覆盖上一次的信息,不提供清除手段.
稍微研究了一下.
v$object_usage是基于以下基表建立起来的:
create or replace view v$object_usage
(index_name, table_name, monitoring, used, start_monitoring, end_monitoring)
as
select io.name, t.name,
decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
ou.start_monitoring,
ou.end_monitoring
from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou
where io.owner# = userenv('SCHEMAID')
and i.obj# = ou.obj#
and io.obj# = ou.obj#
and t.obj# = i.bo#
/
|
注意到v$object_usage关键信息来源于OBJECT_USAGE表.
另外我们可以注意一下,此处v$object_usage的查询基于userenv('SCHEMAID')建立.
所以以不同用户登录,你是无法看到其他用户的索引监视信息的,即使是dba,但是可以从object_usage表中得到.
SQL> select * from v$object_usage;
INDEX_NAME TABLE_NAME MON USE START_MONITORING END_MONITORING
------------------------------ ------------------------------ --- --- ------------------- -------------------
PK_DEPT DEPT NO YES 10/28/2004 10:55:19 10/28/2004 10:55:47
SQL> select * from object_usage;
select * from object_usage
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> connect /as sysdba
Connected.
SQL> /
OBJ# FLAGS START_MONITORING END_MONITORING
---------- ---------- ------------------- -------------------
6288 1 10/28/2004 10:55:19 10/28/2004 10:55:47
|
实际上我们清除了object_usage表的记录,实际上也就清空了v$object_usage的信息.
|
SQL> delete from object_usage;
1 row deleted.
SQL> commit;
Commit complete.
SQL> select * from v$object_usage;
no rows selected
|
此操作对数据库没有潜在的影响,但是请谨慎使用.作为实验目的提供.
Posted by eygle at 10:17 AM
| Comments (1)
作者:eygle
很多时候，在推出一个完整的补丁集之前，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-
Posted by eygle at 10:08 AM
| Comments (0)
