Hi,
I have a 9.2.0.8 database:
$> sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.8.0 - Production on Wed Jul 21 09:25:48 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL>select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name;
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ------------------------------
JServer JAVA Virtual Machine VALID 9.2.0.8.0
OLAP Analytic Workspace UPGRADED 9.2.0.8.0
OLAP Catalog VALID 9.2.0.8.0
Oracle Data Mining VALID 9.2.0.8.0
Oracle OLAP API UPGRADED 9.2.0.8.0
Oracle Text VALID 9.2.0.8.0
Oracle XDK for Java VALID 9.2.0.10.0
Oracle XML Database VALID 9.2.0.8.0
Oracle interMedia VALID 9.2.0.8.0
Oracle9i Catalog Views VALID 9.2.0.8.0
Oracle9i Java Packages VALID 9.2.0.8.0
Oracle9i Packages and Types VALID 9.2.0.8.0
Oracle9i Real Application Clusters VALID 9.2.0.8.0
Spatial VALID 9.2.0.8.0
14 rows selected.
SQL>exit
But when I issue an "opatch lsinventory -details" I see all the more components are in 9.2.0.7 version.... How is it possible?
oracle@gami7ot1:/grid/app/9.2.0/OPatch>opatch lsinventory -details
Oracle Interim Patch Installer version 1.0.0.0.62
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..
Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)
Oracle Home : /grid/app/9.2.0
Oracle Home Inventory : /grid/app/9.2.0/inventory
Central Inventory : /grid/app/9.2.0/OraInventory
from : /etc/oraInst.loc
OUI location : /grid/app/9.2.0/oui
OUI shared library : /grid/app/9.2.0/oui/lib/aix/liboraInstaller.so
Java location : /grid/app/9.2.0/jre/1.4.2/bin/java
Log file location : /grid/app/9.2.0/.patch_storage/<patch ID>/*.log
Creating log file "/grid/app/9.2.0/.patch_storage/LsInventory__07-21-2010_09-22-20.log"
Result:
PRODUCT NAME VERSION
============ =======
Advanced Queueing (AQ) API Patch 9.2.0.7.0
Advanced Queueing (AQ) API 9.2.0.1.0
Advanced Replication Patch 9.2.0.7.0
Advanced Replication 9.2.0.1.0
Agent Required Support Files Patch 9.2.0.7.0
Agent Required Support Files 9.2.0.1.0
Assistant Common Files Patch 9.2.0.7.0
Assistant Common Files 9.2.0.1.0
Bali Share 1.1.17.0.0
Character Set Migration Utility 9.2.0.1.0
Character Set Migration Utility 9.2.0.7.0
copyJDKHome 1.3.1.0.0b
Data Management Services Common Files Patch 9.2.0.7.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.7.0
Database SQL Scripts 9.2.0.1.0
Database Upgrade Assistant 9.2.0.1.0
Database Verify Utility Patch 9.2.0.7.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.7.0
DBJAVA Required Support Files 9.2.0.1.0
Documentaion Required Support Files Patch 9.2.0.7.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 Manager Base Classes 9.2.0.1.0
Enterprise Manager Minimal Integration 9.2.0.1.0
Enterprise Manager Translated Files 9.2.0.1.0
Export/Import Patch 9.2.0.7.0
Export/Import 9.2.0.1.0
Generic Connectivity Common Files Patch 9.2.0.7.0
Generic Connectivity Common Files 9.2.0.1.0
Generic Connectivity Using ODBC Patch 9.2.0.7.0
Generic Connectivity Using ODBC 9.2.0.1.0
Installation Common Files Patch 9.2.0.7.0
Installation Common Files 9.2.0.1.0
Installer SDK Component 10.1.0.4.0
Java Runtime Environment 1.4.2.0.0
JDBC Common Files Patch 9.2.0.7.0
JDBC Common Files 9.2.0.1.0
JDBC/OCI Common Files Patch 9.2.0.7.0
JDBC/OCI Common Files 9.2.0.1.0
LDAP Required Support Files Patch 9.2.0.7.0
LDAP Required Support Files 9.2.0.1.0
Migration Utility Patch 9.2.0.7.0
Migration Utility 9.2.0.1.0
New Database ID Patch 9.2.0.7.0
New Database ID 9.2.0.1.0
Object Type Translator Patch 9.2.0.7.0
Object Type Translator 9.2.0.1.0
Oracle 9iR2 Patchset 9.2.0.7.0
Oracle C++ Call Interface Patch 9.2.0.7.0
Oracle C++ Call Interface 9.2.0.1.0
Oracle Call Interface (OCI) Patch 9.2.0.7.0
Oracle Call Interface (OCI) 9.2.0.1.0
Oracle Client Required Support Files Patch 9.2.0.7.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.7.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 Connection Manager Patch 9.2.0.7.0
Oracle Connection Manager 9.2.0.1.0
Oracle Core Required Support Files Patch 9.2.0.7.0
Oracle Core Required Support Files 9.2.0.1.0
Oracle Data Mining Patch 9.2.0.7.0
Oracle Data Mining 9.2.0.1.0
Oracle Database Demos Patch 9.2.0.7.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.7.0
Oracle Database Utilities 9.2.0.1.0
Oracle Display Fonts 9.0.2.0.0
Oracle Dynamic Services Server 9.2.0.1.0
Oracle Extended Windowing Toolkit 3.4.13.0.0
Oracle Help For Java 3.2.13.0.0
Oracle Help For Java 4.1.13.0.0
Oracle Ice Browser 5.06.8.0.0
Oracle Installation Products 10.1.0.4.0
Oracle Intelligent Agent Base Component Files Patch 9.2.0.7.0
Oracle Intelligent Agent Base Component Files 9.2.0.1.0
Oracle Intelligent Agent Config Tool Patch 9.2.0.7.0
Oracle Intelligent Agent Config Tool 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.7.0
Oracle interMedia Client Compatibility Files Patch 9.2.0.7.0
Oracle interMedia Client Compatibility Files 9.2.0.1.0
Oracle interMedia Client Demos Patch 9.2.0.7.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.7.0
Oracle interMedia Common Files 9.2.0.1.0
Oracle interMedia Image 9.2.0.1.0
Oracle interMedia Image 9.2.0.7.0
Oracle interMedia Java Advanced Imaging Patch 9.2.0.7.0
Oracle interMedia Java Advanced Imaging 9.2.0.1.0
Oracle interMedia Java Client Patch 9.2.0.7.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.7.0
Oracle interMedia Locator 9.2.0.1.0
Oracle interMedia Video 9.2.0.1.0
Oracle interMedia Video 9.2.0.7.0
Oracle interMedia Web Client Patch 9.2.0.7.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.7.0
Oracle Internet Directory Client Common Files 9.2.0.1.0
Oracle Internet Directory Client Patch 9.2.0.7.0
Oracle Internet Directory Client 9.2.0.1.0
Oracle Internet Directory Tools Patch 9.2.0.7.0
Oracle Internet Directory Tools 9.2.0.1.0
Oracle Java Core Patch 9.2.0.7.0
Oracle Java Tools Patch 9.2.0.7.0
Oracle Java Tools 9.2.0.1.0
Oracle JDBC Development Drivers Patch 9.2.0.7.0
Oracle JDBC Development Drivers 9.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.1 Patch 9.2.0.7.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.7.0
Oracle JDBC Thin Driver for JDK 1.2 9.2.0.1.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 JDBC/OCI Interfaces 9.2.0.1.0
Oracle JFC Extended Windowing Toolkit 4.1.10.0.0
Oracle JVM Patch 9.2.0.7.0
Oracle JVM 9.2.0.1.0
Oracle Message Gateway Common Files 9.2.0.1.0
Oracle Net Configuration Assistant Patch 9.2.0.7.0
Oracle Net Configuration Assistant 9.2.0.1.0
Oracle Net Listener Patch 9.2.0.7.0
Oracle Net Listener 9.2.0.1.0
Oracle Net Manager Patch 9.2.0.7.0
Oracle Net Manager 9.2.0.1.0
Oracle Net Patch 9.2.0.7.0
Oracle Net Required Support Files Patch 9.2.0.7.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.7.0
Oracle OLAP API 9.2.0.1.0
Oracle OLAP CWM Lite Patch 9.2.0.7.0
Oracle OLAP CWM Lite 9.2.0.1.0
Oracle OLAP Patch 9.2.0.7.0
Oracle OLAP 9.2.0.1.0
Oracle One-Off Patch Installer 10.1.0.4.0
Oracle Partitioning Patch 9.2.0.7.0
Oracle Partitioning 9.2.0.1.0
Oracle Programmer 9.2.0.1.0
Oracle Required Support Files 32 bit Patch 9.2.0.7.0
Oracle Required Support Files 32 bit 9.2.0.1.0
Oracle Spatial Patch 9.2.0.7.0
Oracle Spatial 9.2.0.1.0
Oracle Starter Database 9.2.0.1.0
Oracle Text Patch 9.2.0.7.0
Oracle Text 9.2.0.1.0
Oracle Trace Patch 9.2.0.7.0
Oracle Trace Required Support Files Patch 9.2.0.7.0
Oracle Trace Required Support Files 9.2.0.1.0
Oracle Trace 9.2.0.1.0
Oracle UIX 2.0.21.0.0
Oracle Ultra Search Common Files Patch 9.2.0.7.0
Oracle Ultra Search Common Files 9.2.0.1.0
Oracle Ultra Search Middle-Tier Patch 9.2.0.7.0
Oracle Ultra Search Middle-Tier 9.2.0.1.0
Oracle Ultra Search Server Patch 9.2.0.7.0
Oracle Ultra Search Server 9.2.0.1.0
Oracle Universal Installer 10.1.0.4.0
Oracle Wallet Manager Patch 9.2.0.7.0
Oracle Wallet Manager 9.2.0.1.0
Oracle XML Developer's Kit Patch 9.2.0.9.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.7.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 Globalization Support Patch 9.2.0.7.0
Oracle9i Globalization Support 9.2.0.1.0
Oracle9i Patch 9.2.0.7.0
Oracle9i Real Application Clusters Guard Patch 9.2.0.7.0
Oracle9i Real Application Clusters Guard 9.2.0.1.0
Oracle9i Real Application Clusters Management 9.2.0.1.0
Oracle9i Real Application Clusters Patch 9.2.0.7.0
Oracle9i Real Application Clusters 9.2.0.1.0
Oracle9i Server 32 bit Patch 9.2.0.7.0
Oracle9i Server 32 bit 9.2.0.1.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
PL/SQL Embedded Gateway 9.2.0.1.0
PL/SQL Patch 9.2.0.7.0
PL/SQL Required Support Files Patch 9.2.0.7.0
PL/SQL Required Support Files 9.2.0.1.0
PL/SQL 9.2.0.1.0
Platform Required Support Files Patch 9.2.0.7.0
Platform Required Support Files 9.2.0.1.0
Precompiler Common Files Patch 9.2.0.7.0
Precompiler Common Files 9.2.0.1.0
Precompiler Required Support Files Patch 9.2.0.7.0
Precompiler Required Support Files 9.2.0.1.0
Pro*C/C++ Patch 9.2.0.7.0
Pro*C/C++ 9.2.0.1.0
Pro*COBOL Patch 1.8.77.7.0
Pro*COBOL Patch 9.2.0.7.0
Pro*COBOL 1.8.77.0.0
Pro*COBOL 9.2.0.1.0
Pro*FORTRAN Patch 1.8.77.7.0
Pro*FORTRAN 1.8.77.0.0
RDBMS Required Support Files Patch 9.2.0.7.0
RDBMS Required Support Files 9.2.0.1.0
Recovery Manager Patch 9.2.0.7.0
Recovery Manager 9.2.0.1.0
regexp 2.0.21.0.0
Required Support Files 9.2.0.1.0
Secure Socket Layer Patch 9.2.0.7.0
Secure Socket Layer 9.2.0.1.0
SQL*Loader Patch 9.2.0.7.0
SQL*Loader 9.2.0.1.0
SQL*Module Ada Patch 9.2.0.7.0
SQL*Module Ada 9.2.0.1.0
SQL*Module Common Files Patch 9.2.0.7.0
SQL*Module Common Files 9.2.0.1.0
SQL*Plus Patch 9.2.0.7.0
SQL*Plus Required Support Files Patch 9.2.0.7.0
SQL*Plus Required Support Files 9.2.0.1.0
SQL*Plus 9.2.0.1.0
SSL Required Support Files Patch 9.2.0.7.0
SSL Required Support Files 9.2.0.1.0
Sun JDK extensions 9.2.0.1.0
Utilities Common Files Patch 9.2.0.7.0
Utilities Common Files 9.2.0.1.0
Visigenics ORB 3.4.0.0.0
XDK Required Support Files Patch 9.2.0.7.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.7.0
XML Class Generator for Java 9.2.0.1.0
XML Class Generator for Java 9.2.0.7.0
XML Parser for C Patch 9.2.0.7.0
XML Parser for C++ Patch 9.2.0.7.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.7.0
XML Parser for Java 9.2.0.1.0
XML Parser for Oracle JVM Patch 9.2.0.7.0
XML Parser for Oracle JVM 9.2.0.1.0
XML Parser for PL/SQL Patch 9.2.0.7.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.7.0
XML Transx 9.2.0.1.0
XML Transx 9.2.0.7.0
XML 9.2.0.1.0
XML 9.2.0.7.0
XSQL Servlet 9.2.0.1.0
XSQL Servlet 9.2.0.7.0
There are 263 components installed.
Installed Patch List:
=====================
1) Patch 5496862 applied on Tue Jul 20 17:56:38 CEST 2010
[ Bug fixes: 5496862 ]
/skgfr.o --> /grid/app/9.2.0/lib/libgeneric9.a
/skgfr.o --> /grid/app/9.2.0/lib32/libgeneric9.a
2) Patch 4742607 applied on Fri Mar 27 13:08:32 CET 2009
[ Bug fixes: 4742607 ]
3) Patch 4741381 applied on Wed Oct 31 13:34:54 CET 2007
[ Bug fixes: 4741381 ]
4) Patch 4673610 applied on Thu Jul 19 19:41:32 CEST 2007
[ Bug fixes: 4673610 ]
5) Patch 4947798 applied on Sat May 06 15:07:53 CEST 2006
[ Bug fixes: 4658188 4947798 4778081 4923667 4632780 ]
6) Patch 3206617 applied on Sat May 06 14:48:56 CEST 2006
[ Bug fixes: 3206617 ]
7) Patch 4483951 applied on Sat May 06 14:42:40 CEST 2006
[ Bug fixes: 4483951 ]
8) Patch 4890227 applied on Sat May 06 14:34:40 CEST 2006
[ Bug fixes: 4890227 ]
9) Patch 4405509 applied on Sat May 06 14:25:35 CEST 2006
[ Bug fixes: 4405509 ]
OPatch succeeded.