System:
WINDOWS 2000
Database version:
*9.2.0.1.0*
opatch version:
OPatch Version: 1.0.0.0.61
Perl version:
5.005_03
Patch which I am trying to apply:
9.2.0.8.0
STEP :1
Downloaded latest version of opatch from Metalink:
D:\Downloads\OPatch>opatch version
Oracle Interim Patch Installer version 1.0.0.0.61
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)
OPatch Version: 1.0.0.0.61
OPatch returns with error code = 0
D:\Downloads\OPatch>
STEP 2:
Downloaded the latest version of oracle patch from Metalink.
D:\Downloads\p8300340_92080_WINNT\8300340>dir
Volume in drive D has no label.
Volume Serial Number is 201B-9310
Directory of D:\Downloads\p8300340_92080_WINNT\8300340
04/27/2009 04:07 PM <DIR> .
04/27/2009 04:07 PM <DIR> ..
04/27/2009 02:59 PM <DIR> custom
04/27/2009 02:59 PM <DIR> etc
04/27/2009 02:59 PM <DIR> files
04/27/2009 02:59 PM <DIR> ldap_scripts
04/27/2009 03:13 PM <DIR> locks
04/27/2009 04:07 PM <DIR> OPatch
04/12/2002 11:46 PM 2,924 patchmd.xml
04/08/2009 11:43 AM 61,715 README.html
09/04/2007 10:43 AM 43 README.txt
12/28/2006 12:35 PM 1,545 remove_demo.js
4 File(s) 66,227 bytes
8 Dir(s) 62,529,622,016 bytes free
D:\Downloads\p8300340_92080_WINNT\8300340>
STEP 3:
Changed the oracle_home parameter as follows:
D:\Downloads\p8300340_92080_WINNT\8300340>set oracle_home=D:\oracle\ora92New
STEP 4 :
Checking the inventory and applying the patch:
D:\Downloads\OPatch>opatch lsinventory -detail
Oracle Interim Patch Installer version 1.0.0.0.61
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 : D:\oracle\ora92New
Oracle Home Inventory : D:\Program Files\oracle\inventory
Central Inventory : D:\Program Files\oracle\inventory
from : N/A
OUI location : D:\Program Files\Oracle\oui
OUI shared library : D:\Program Files\Oracle\oui\bin\win32\oraInstaller.dll
Java location : "D:\Program Files\Oracle\jre\1.3.1\bin\java.exe"
Log file location : D:\oracle\ora92New/.patch_storage/<patch ID>/*.log
Creating log file "D:\oracle\ora92new\.patch_storage\LsInventory__05-01-2009_15
15-24.log"
Result:
PRODUCT NAME VERSION
============ =======
Advanced Queueing (AQ) API 9.2.0.1.0
Advanced Replication 9.2.0.1.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 9.2.0.1.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
Common Files For Generic Connectivity Using OLEDB 9.2.0.1.0
Data Management Services Common Files 9.2.0.1.0
Database Configuration Assistant 9.2.0.1.0
Database SQL Scripts 9.2.0.1.0
Database Upgrade Assistant 9.2.0.1.0
Database Verify Utility 9.2.0.1.0
Database Workspace Manager 9.2.0.1.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 Expert Common Files 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 Paging Server 9.2.0.1.0
Enterprise Manager Quick Tours 9.2.0.1.0
Enterprise Manager Shared Libraries 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
Enterprise Manager Win32 App Translated Files 9.2.0.1.0
Enterprise Manager Win32 Application Common Files 9.2.0.1.0
Enterprise Manager Win32 Apps Bridge 9.2.0.1.0
Expert 9.2.0.1.0
Export/Import 9.2.0.1.0
Generic Connectivity Common Files 9.2.0.1.0
Generic Connectivity Using ODBC 9.2.0.1.0
Generic Connectivity Using OLEDB - FS 9.2.0.1.0
Generic Connectivity Using OLEDB - SQL 9.2.0.1.0
Index Tuning Wizard 9.2.0.1.0
Installation Common Files 9.2.0.1.0
iSQL*Plus Extension for Windows 9.2.0.1.0
iSQL*Plus 9.2.0.1.0
JDBC Common Files 9.2.0.1.0
JDBC/OCI Common Files 9.2.0.1.0
JSDK 2.0.0.0.0d
LDAP Required Support Files 9.2.0.1.0
MIcrosoft SQLServer(TM) Extensions 9.2.0.1.0
Migration Utility 9.2.0.1.0
New Database ID 9.2.0.1.0
Object Type Translator 9.2.0.1.0
Oracle Administration Assistant for Windows NT 9.2.0.1.0
Oracle Advanced Security 9.2.0.1.0
Oracle Applications Extensions 9.2.0.1.0
Oracle C++ Call Interface 9.2.0.1.0
Oracle Caching Service for Java 2.1.0.0.0a
Oracle Call Interface (OCI) 9.2.0.1.0
Oracle Change Management Pack 9.2.0.1.0
Oracle Client Required Support Files 9.2.0.1.0
Oracle Code Editor 1.2.1.0.0A
Oracle COM Automation Feature 9.2.0.1.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 9.2.0.1.0
Oracle Data Mining 9.2.0.1.0
Oracle Database Demos 9.2.0.1.0
Oracle Database User Interface 2.2.11.0.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 Directory Manager 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 9.2.0.1.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 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 Client Compatibility Files 9.2.0.1.0
Oracle interMedia Client Demos 9.2.0.1.0
Oracle interMedia Client Option 9.2.0.1.0
Oracle interMedia Common Files 9.2.0.1.0
Oracle interMedia Image 9.2.0.1.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 9.2.0.1.0
Oracle interMedia Video 9.2.0.1.0
Oracle interMedia Web Client 9.2.0.1.0
Oracle interMedia 9.2.0.1.0
Oracle Internet Directory Client Common Files 9.2.0.1.0
Oracle Internet Directory Client 9.2.0.1.0
Oracle INTYPE File Assistant 9.2.0.1.0
Oracle Java Layout Engine 2.0.1.0.0
Oracle Java Server Pages 1.1.3.1.0
Oracle Java Tools 9.2.0.1.0
Oracle JDBC Development Drivers 9.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.1 9.2.0.1.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 Driver for JDK 1.4 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 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 9.2.0.1.0
Oracle Net Integration 9.2.0.1.0
Oracle Net Listener 9.2.0.1.0
Oracle Net Manager 9.2.0.1.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 Objects for OLE 9.2.0.4.4
Oracle ODBC Driver 9.2.0.1.0
Oracle OLAP API 9.2.0.1.0
Oracle OLAP Cube Viewer 9.2.0.1.0
Oracle OLAP CWM Lite 9.2.0.1.0
Oracle OLAP Worksheet 9.2.0.1.0
Oracle OLAP 9.2.0.1.0
Oracle Partitioning 9.2.0.1.0
Oracle Perl Interpreter 5.00503.0.0.0c
Oracle Programmer 9.2.0.1.0
Oracle Provider for OLE DB 9.2.0.1.0
Oracle Services For Microsoft Transaction Server 9.2.0.1.0
Oracle SNMP Agent 9.2.0.1.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 9.2.0.1.0
Oracle SQLJ 9.2.0.1.0
Oracle Starter Database 9.2.0.1.0
Oracle Text 9.2.0.1.0
Oracle Trace Required Support Files 9.2.0.1.0
Oracle Trace 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 9.2.0.1.0
Oracle Ultra Search Middle-Tier 9.2.0.1.0
Oracle Ultra Search Server 9.2.0.1.0
Oracle Wallet Manager 9.2.0.1.0
Oracle Windows Interfaces 9.2.0.1.0
Oracle Workflow Manager 9.2.0.1.0
Oracle XML Developer's Kit 9.2.0.1.0
Oracle XML Runtime Components 9.2.0.1.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 9.2.0.1.0
Oracle9i Syndication Server 9.2.0.1.0
Oracle9i Windows Documentation 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 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 9.2.0.1.0
Precompiler Required Support Files 9.2.0.1.0
RDBMS Required Support Files 9.2.0.1.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 9.2.0.1.0
SQL Analyze 9.2.0.1.0
SQL*Loader 9.2.0.1.0
SQL*Plus 9.2.0.1.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 9.2.0.1.0
Sun JDK extensions 9.2.0.1.0
Sun JDK 1.3.1.0.1a
Trace DataViewer 9.2.0.1.0
Utilities Common Files 9.2.0.1.0
Visigenics ORB 3.4.0.0.0
XDK Required Support Files 9.2.0.1.0
XML Class Generator for C++ 9.2.0.1.0
XML Class Generator for Java 9.2.0.1.0
XML Parser for C++ 9.2.0.1.0
XML Parser for C 9.2.0.1.0
XML Parser for Java 9.2.0.1.0
XML Parser for Oracle JVM 9.2.0.1.0
XML Parser for PL/SQL 9.2.0.1.0
XML Transviewer Beans 9.2.0.1.0
XML Transx 9.2.0.1.0
XML 9.2.0.1.0
XSQL Servlet 9.2.0.1.0
There are 220 components installed.
There is no Interim Patch
OPatch succeeded.
OPatch returns with error code = 0
D:\Downloads\OPatch>
*********************PATCH APPLY**************************
D:\Downloads\p8300340_92080_WINNT\8300340>D:\Downloads\OPatch\opatch apply
Oracle Interim Patch Installer version 1.0.0.0.61
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 : D:\oracle\ora92New
Oracle Home Inventory : D:\Program Files\oracle\inventory
Central Inventory : D:\Program Files\oracle\inventory
from : N/A
OUI location : D:\Program Files\Oracle\oui
OUI shared library : D:\Program Files\Oracle\oui\bin\win32\oraInstaller.dll
Java location : "D:\Program Files\Oracle\jre\1.3.1\bin\java.exe"
Log file location : D:\oracle\ora92New/.patch_storage/<patch ID>/*.log
Creating log file "D:\oracle\ora92new\.patch_storage\8300340\Apply_8300340_05-
-2009_15-14-00.log"
SKIPPING_COMPONENT=oracle.emprod.oemagent.base_oemagent,9.2.0.8.0
SKIPPING_COMPONENT=oracle.p2k.oo4o,9.2.0.7.0
SKIPPING_COMPONENT=oracle.p2k.oledb,9.2.0.7.0
MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 9.2.0.8.0
SKIPPING_COMPONENT=oracle.rsf.net_rsf,9.2.0.8.0
SKIPPING_COMPONENT=oracle.rdbms,9.2.0.8.0
SKIPPING_COMPONENT=oracle.rdbms.sqlplus,9.2.0.8.0
SKIPPING_COMPONENT=oracle.xml.transview,9.2.0.8.0
SKIPPING_COMPONENT=oracle.cartridges.context,9.2.0.8.0
SKIPPING_COMPONENT=oracle.options.intermedia.jai,9.2.0.8.0
SKIPPING_COMPONENT=oracle.cartridges.locator,9.2.0.8.0
SKIPPING_COMPONENT=oracle.isearch.is_common,9.2.0.8.0
SKIPPING_COMPONENT=oracle.isearch.server,9.2.0.8.0
SKIPPING_COMPONENT=oracle.rsf.oracore_rsf,9.2.0.8.0
SKIPPING_COMPONENT=oracle.java.javavm.javatools,9.2.0.8.0
SKIPPING_COMPONENT=oracle.rsf.ldap_rsf,9.2.0.8.0
SKIPPING_COMPONENT=oracle.rsf.xdk_rsf,9.2.0.8.0
SKIPPING_COMPONENT=oracle.oid.client_common,9.2.0.8.0
SKIPPING_COMPONENT=oracle.rsf.nlsrtl_rsf,9.2.0.8.0
SKIPPING_COMPONENT=oracle.ntoramts,9.2.0.8.0
This Oracle Home does not have components/versions required by the patch.
ERROR: OPatch failed during pre-reqs check.
OPatch returns with error code = 150
D:\Downloads\p8300340_92080_WINNT\8300340>