Monday Mar 03, 2014

ORAchk Health Checks for the Oracle Stack

ORAchk includes EXAchk’s functionality and replaces the popular RACcheck tool, extending the coverage based on prioritization of top issues reported by users, to proactively scan for known problems within:

  • E-Business Suite Financials Accounts Payables
  • Oracle Database
  • Sun Systems

ORAchk features:

  • Proactively scans for the most impactful known problems across your entire Engineered System as well as various layers of your stack
  • Simplifies and streamlines how to investigate and analyze which known issues present a risk to you
  • Lightweight tool runs within your environment; no data will be sent to Oracle
  • High level reports show your system health risks with the ability to drill down into specific problems and understand their resolutions
  • Can be configured to send email notifications when it detects problems
  • Collection Manager, a companion Application Express web app, provides a single dashboard view of collections across your entire enterprise

ORAchk will expand in the future with more high impact checks in existing and additional product areas. If you have particular checks or product areas you would like to see covered, please post suggestions in the ORAchk community thread accessed from the support tab on the below document.

For more details about ORAchk see Document 1268927.1

Friday Feb 21, 2014

Help! - Looking for Oracle Database support information and tools?

Help! - Looking for Oracle Database support information and tools?

• Want to ensure your system runs as smoothly as possible and you are alerted about potential issues before they actually occur?
• Looking for an interface that guides you through the issue analysis and provides resolution recommendations - fast and whenever you need it?
• Need a tool that guides you through specific symptoms and offers solutions or workarounds?
• Not being able to find the information at your finger tips when you need?

If you answered at least one of the above questions with YES, then have a look at
Oracle Database Resource Portfolio (Doc ID 1573428.2)

This index document references a great amount of resources using tabs for easy and quick navigation.

The Support Tools section provides links to tools for
• Proactive monitoring and verifying the 'health' of your system
• Collecting relevant information if and when an issue occurs that requires troubleshooting and analysis.

Each of the product related tabs offers access to relevant product area specific information such as
• Premium Knowledge Content
• Best Practices
• Troubleshooting tools and document
• Healthchecks

Go on! Review this document today and bookmark it, so you have it always at your finger tips.

Are we missing any important resources from this index document? Add a comment to let us know.

Wednesday Nov 17, 2010

Oracle Support Master Note for Troubleshooting Managed Distributed Transactions (Doc ID 100664.1)

[Read More]

Oracle Support Master Note for Troubleshooting Streams Apply Errors ORA-1403, ORA-26787 or ORA-26786 (Doc ID 265201.1)

[Read More]

Oracle Support Master Note for Troubleshooting Streams Capture 'WAITING For REDO' or INITIALIZING (Doc ID 313279.1)

[Read More]

Oracle Support Master Note for Streams Setup Scripts (Doc ID 789445.1)

[Read More]

Oracle Support Master Note for Streams Performance Recommendations (Doc ID 335516.1)

[Read More]

Thursday Sep 30, 2010

Master Note of Linux OS Requirements for Database Server

 

For the most current information, please refer to :
(Doc ID 851598.1) Master Note of Linux OS Requirements for Database Server

Applies to:

Oracle Server - Standard Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Oracle Server - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Generic Linux
IBM: Linux on POWER Systems
Linux x86-64
Linux Itanium
IBM: Linux on System z
Linux x86

Purpose

This Master Note is intended to provide an index and references to the most frequently used My Oracle Support  articles with respect to Linux OS Requirements for Oracle Database Software Installation.

The vast majority of software installation and relinking problems on Linux are caused by missing OS requirements.

If you are encountering a software installation or relinking problem, it is vital that you ensure your OS meets all of the minimum requirements documented in the appropriate article below before creating a new SR.

Scope

Only Linux articles are referenced in this article.  For an "all-in-one" article that covers OS requirements for most major OS platforms, please refer to...

Document 169706.1  Oracle Database ... Installation and Configuration Requirements Quick Reference

Where a My Oracle Support article for a given version/platform is "Not available", you should refer to the Installation Guide and the article referenced above.

Details

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Install/Upgrade.

Red Hat Enterprise Linux (RHEL)


Document 376183.1 Defining a "default RPMs" installation of the RHEL OS

Quick Links for RHEL

RHEL6:   x86_64
RHEL5:   x86 x86_64 Itanium zLinux Power
RHEL4:   x86 x86_64 Itanium zLinux Power
RHEL3:   x86 x86_64 Itanium zLinux Power




RHEL6 x86_64:

11.2.0 - Document 1441282.1 Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit (x86-64)


RHEL5 x86:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 419646.1 Requirements For Installing Oracle 10gR2 On RHEL 5 (x86)
11.1.0 - Document 438765.1 Requirements for Installing Oracle 11gR1 32bit RDBMS on RHEL 5
11.2.0 - Document 880936.1 Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on 32-bit x86


RHEL5 x86-64:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 421308.1 Requirements For Installing Oracle10gR2 On RHEL 5 (x86_64)
11.1.0 - Document 438766.1 Requirements for Installing Oracle 11gR1 RDBMS on RHEL 5 on AMD64/EM64T
11.2.0 - Document 880989.1 Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on AMD64/EM64T>


RHEL5 Itanium:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 748378.1 Requirements for Installing Oracle 10gR2 RDBMS on RHEL 5 on Linux Itanium (ia64)


RHEL5 zLinux:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 741646.1 Requirements for Installing Oracle 10gR2 RDBMS on RHEL 5 on zLinux (s390x)


RHEL5 Power:

10.2.0 - Document 341507.1 Oracle Database Server on Linux on IBM POWER


RHEL4 x86:

 9.2.0 - Document 303859.1 Requirements for Installing Oracle 9iR2 on RHEL 4
10.1.0 - Document 392940.1 Requirements for Installing Oracle 10.1.0.x RDBMS on RHEL 4 x86 platform
10.2.0 - Document 343431.1 Requirements for Installing Oracle 10gR2 RDBMS on RHEL 4 x86 platform
11.1.0 - Document 430653.1 Requirements for Installing Oracle 11gR1 32-bit on RHEL 4
11.2.0 - Document 880211.1 Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 4 x86


RHEL4 x86-64:

 9.2.0 - Document 353529.1 Requirements for Installing Oracle 9iR2 64-bit on RHEL 4 x86-64 (AMD64/EM64T)
10.1.0 - Document 390900.1 Requirements for Installing Oracle 10g (10.1.0.x) RDBMS on RHEL 4 on AMD64/EM64T (Linux x86-64)
10.2.0 - Document 339510.1 Requirements for Installing Oracle 10gR2 RDBMS on RHEL 4 on AMD64/EM64T
11.1.0 - Document 437123.1 Requirements for Installing Oracle 11gR1 RDBMS on RHEL 4 on AMD64/EM64T
11.2.0 - Document 880942.1 Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 4 on AMD64/EM64T


RHEL4 Itanium:

 9.2.0 - Not available
10.1.0 - Not available
10.2.0 - Not available


RHEL4 zLinux:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 420382.1 Requirements for Installing Oracle 10gR2 RDBMS on RHEL 4 on zLinux (s390x)


RHEL4 Power:

10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 341507.1 Oracle Database Server on Linux on IBM POWER


RHEL3 x86:

 9.2.0 - Document 252217.1 Requirements for Installing Oracle 9iR2 32-bit on RHEL 3
10.1.0 - Document 394360.1 Requirements for Installing Oracle 10g 32-bit on RHEL 3
10.2.0 - Not available
11.1.0 - Not certified, not supported, not planned.
11.2.0 - Not certified, not supported, not planned.


RHEL3 x86-64:

 9.2.0 - Document 308588.1 Requirements for Installing Oracle 9iR2 x86_64 on RHEL 3
10.1.0 - Document 351679.1 Requirements for RPM Arch. for 10g x86_64 on RHEL 3
10.2.0 - Document 353735.1 Requirements for RPM Arch. for 10gR2 x86_64 on RHEL 3
11.1.0 - Not certified, not supported, not planned.
11.2.0 - Not certified, not supported, not planned.


RHEL3 Itanium:

 9.2.0 - Not available
10.1.0 - Not available
10.2.0 - Not available
11.1.0 - Not certified, not supported, not planned.
11.2.0 - Not certified, not supported, not planned.


RHEL3 zLinux:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Not certified, not supported, not planned.
11.1.0 - Not certified, not supported, not planned.
11.2.0 - Not certified, not supported, not planned.


RHEL3 Power:

10.2.0 - Not certified, not supported, not planned.
11.1.0 - Not certified, not supported, not planned.
11.2.0 - Not certified, not supported, not planned.

SuSE Linux Enterprise Server (SLES)


Document 386391.1 Defining a "default RPMs" installation of the SLES OS

Quick Links for SLES

SLES11:   x86 x86_64
SLES10:   x86 x86_64 zLinux Power
SLES 9:   x86 x86_64 zLinux Power



SLES11 x86:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 842649.1 Requirements for Installing Oracle 10gR2 32-bit (x86) on SLES 11
11.1.0 - Document 849583.1 Requirements for Installing Oracle 11gR1 32-bit (x86) on SLES 11
11.2.0 - Document 881025.1 Requirements for Installing Oracle 11gR2 32-bit (x86) on SLES 11


SLES11 x86_64:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 956194.1 Requirements for Installing Oracle 10gR2 64-bit (AMD64/EM64T) on SLES 11
11.1.0 - Document 1081555.1 Requirements for Installing Oracle 11gR1 64-bit (AMD64/EM64T) on SLES 11
11.2.0 - Document 881044.1 Requirements for Installing Oracle 11gR2 64-bit (AMD64/EM64T) on SLES 11


SLES10 x86:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 387137.1 Requirements for Installing Oracle 10gR2 32-bit (x86) on SLES 10
11.1.0 - Document 452818.1 Requirements for Installing Oracle 11gR1 32-bit on SLES 10
11.2.0 - Document 763386.1 Requirements for Installing Oracle 11gR2 32-bit on SLES 10 (x86)


SLES10 x86-64:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Document 373681.1 Requirements for Installing Oracle 10gR2 64-bit (AMD64/EM64T) on SLES 10
11.1.0 - Document 457143.1 Requirements for Installing Oracle 11gR1 64-bit (AMD64/EM64T) on SLES 10
11.2.0 - Document 884435.1 Requirements for Installing Oracle 11gR2 64-bit (AMD64/EM64T) on SLES 10


SLES10 s390x (zLinux):

 9.2.0 - Not available
10.1.0 - Not available
10.2.0 - Document 1082253.1 Requirements for Installing Oracle 10gR2 RDBMS on SUSE SLES 10 on zLinux (s390x)
11.1.0 - Not certified, not supported, not planned.


SLES10 Power:

 10.2.0 - Document 341507.1 Oracle Database Server on Linux on IBM POWER


SLES9 x86:

 9.2.0 - Document 427976.1 Requirements for Installing Oracle 9iR2 32-bit on SLES 9
10.1.0 - Not available
10.2.0 - Document 400429.1 Requirements for Installing Oracle 10gR2 32-bit on SLES 9
11.1.0 - Not certified, not supported, not planned.


SLES9 x86-64:

 9.2.0 - Document 361169.1 Requirements for Installing Oracle 9iR2 64-bit on SuSE SLES 9 x86_64 (AMD64/EM64T)
10.1.0 - Not available
10.2.0 - Document 365607.1 Requirements for Installing Oracle 10gR2 RDBMS on SLES 9 on AMD/EM64T
11.1.0 - Not certified, not supported, not planned.


SLES9 s390x (zLinux):

 9.2.0 - Document 270577.1 Installing Oracle 9i on IBM z/Series - SLES8/9
10.1.0 - Not available
10.2.0 - Document 431443.1 Requirements for Installing Oracle 10gR2 RDBMS on SLES 9 on zLinux (s390x)
11.1.0 - Not certified, not supported, not planned.


SLES9 Power:

 10.2.0 - Document 341507.1 Oracle Database Server on Linux on IBM POWER

Oracle Enterprise Linux (OEL)


Document 401167.1 Defining a "default RPMs" installation of the Oracle EL OS

Quick Links for OEL

OL6:    x86_64
OEL5:   x86 x86_64
OEL4:   x86 x86_64



OL6 x86-64:

11.2.0 - Identical to RHEL6 x86-64.  See "RHEL6 x86-64:" section above.



OEL5 x86:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Identical to RHEL5 x86. See "RHEL5 x86:" section above.
11.1.0 - Identical to RHEL5 x86. See "RHEL5 x86:" section above.
11.2.0 - Identical to RHEL5 x86. See "RHEL5 x86:" section above.


OEL5 x86-64:

 9.2.0 - Not certified, not supported, not planned.
10.1.0 - Not certified, not supported, not planned.
10.2.0 - Identical to RHEL5 x86-64. See "RHEL5 x86-64:" section above.
11.1.0 - Identical to RHEL5 x86-64. See "RHEL5 x86-64:" section above.
11.2.0 - Identical to RHEL5 x86_64. See "RHEL5 x86_64:" section above.


OEL4 x86:

 9.2.0 - Identical to RHEL4 x86. See "RHEL4 x86:" section above.
10.1.0 - Identical to RHEL4 x86. See "RHEL4 x86:" section above.
10.2.0 - Identical to RHEL4 x86. See "RHEL4 x86:" section above.
11.1.0 - Identical to RHEL4 x86. See "RHEL4 x86:" section above.
11.2.0 - Identical to RHEL4 x86. See "RHEL4 x86:" section above.


OEL4 x86-64:

 9.2.0 - Identical to RHEL4 x86-64. See "RHEL4 x86-64:" section above.
10.1.0 - Document 436800.1 Requirements for Installing Oracle 10g RDBMS on OEL 4 on AMD64/EM64T
10.2.0 - Document 418890.1 Requirements for Installing Oracle 10gR2 RDBMS on OEL 4 update 4 on AMD64/EM64T
       - Document 435900.1 Requirements for Installing Oracle 10gR2 RDBMS on OEL 4 update 5 on AMD64/EM64T
11.1.0 - Identical to RHEL4 x86-64. See "RHEL4 x86-64:" section above.
11.2.0 - Identical to RHEL4 x86_64. See "RHEL4 x86_64:" section above.

Using My Oracle Support Effectively 

Document 747242.5 My Oracle Support Configuration Management FAQ
Document 868955.1 My Oracle Support Health Checks Catalog
Document 166650.1 Working Effectively With Global Customer Support
Document 199389.1 Escalating Service Requests with Oracle Support Services

Generic Links

Document 854428.1 Patch Set Updates for Oracle Products
Document 1061295.1 Patch Set Updates - One-off Patch Conflict Resolution
Document 881382.1 Critical Patch Update October 2009 Patch Availability Document for Oracle Products
Document 967472.1 Critical Patch Update January 2010 Patch Availability Document for Oracle Products
Document 1060989.1 Critical Patch Update April 2010 Patch Availability Document for Oracle Products
Document 756671.1 Oracle Recommended Patches -- Oracle Database
Document 268895.1 Oracle Database Server Patchset Information, Versions: 8.1. 7 to 11.2.0
Document 161549.1 Oracle Database Server and Networking Patches for Microsoft Platforms

Wednesday Sep 29, 2010

Master Note For Cloning Oracle Database Server ORACLE_HOME's Using the Oracle Universal Installer (OUI)

 

For the most current information, please refer to :
(Doc ID 1154613.1) Master Note For Cloning Oracle Database Server ORACLE_HOME's Using the Oracle Universal Installer (OUI)

 

Applies to:

Oracle Universal Installer - Version 2.2.0.18 and later
Oracle Server - Enterprise Edition - Version 9.2.0.8 and later
Oracle Server - Standard Edition - Version 9.2.0.8 and later
Information in this document applies to any platform.

Purpose

This Master Note is intended to provide an index and references to the most frequently used My Oracle Support notes with respect to Oracle Database Server Cloning using the Oracle Universal Installer (OUI).
This includes the following categories:

General
How to
Known Issues
Using My Oracle Support Effectively
Generic Links

Scope

This note is intended for junior through expert level of expertise for Oracle software administration.

This note serves as a guide for Oracle Database Server Cloning using the Oracle Universal Installer (OUI).

It is applicable to cloning of the Oracle Database Server ORACLE_HOME

It is NOT applicable to cloning done via Rapid Clone (APPs) or Enterpirse Manager Provisioning cloning.

It is NOT applicable to database cloning.

It will cover the following versions:

Oracle Server - Version: 9.2.0.x though 11.2.0.x

Details

Community Discussions

Would you like to explore this topic further with other Oracle Customers and Specialists? 
Not finding the right information and considering opening a low priority Service Request?
Give the Database Install/Upgrade Community a try first to save time and connect with your peers and Oracle experts.
Database Install Community.

General

How To

Note 300062.1 How To Clone An Existing RDBMS Installation Using OUI

Note:559301.1 "Cloning An Existing Oracle10g Release 1 (10.1.0.x) RDBMS Installation Using OUI"

Note:559304.1 "Cloning An Existing Oracle10g Release 2 (10.2.0.x) RDBMS Installation Using OUI"

Note:559305.1 "Cloning An Existing Oracle11g Release 1 (11.1.0.x) RDBMS Installation Using OUI"

Note:1221705.1 "Cloning An Existing Oracle11g Release 2 (11.2.0.x) RDBMS Installation Using OUI"

Note.559863.1 An Example Of How To Clone An Existing Oracle9i Release 2 (9.2.0.x) RDBMS Installation Using OUI

Note.558478.1 Cloning A Database Home And Changing The User/Group That Owns It

Known Issues

Note 1061788.1 Connect as SYSDBA on 11.2 Cloned Home Gives "ORA-1031: Insufficient Privileges" Error
Note 1367164.1 Relink Reports "Undefined Reference" Errors While Cloning 11.2
Note 836056.1 DBUA Failed With Java Not found Error In A Cloned Oracle Home
Note 1324423.1 Oracle Base Defaults To Wrong Value In Oui
Note 1321352.1 Libskgxnr.So: No Such File Or Directory When Running $ORACLE_HOME/clone/rootpre.sh
Note 416255.1 Cloning An Oracle10gR2 Standard Edition Installation Changes It To Enterprise Edition
Note 751827.1 Cloning An 11.1.0.7 Standard Edition Installation Changes It To Enterprise Edition
Note 553177.1 "Can't Locate English.Pm In @Inc Message" On Clone Of Oracle_home
Note 557681.1 During Cloning, clone.pl Fails With OUI-10197
Note 443733.1 Error in invoking target during Cloning A 10.2.0.2 or 10.2.0.3 Oracle_home
Note 945297.1 Java.Lang.Nullpointerexception On ccr.zip When Cloning 11.1.0.7 Client Home
Note 559859.1 While Cloning Oracle9i Release 2 (9.2.0.x), OUI Fails With "Exception in thread "main" java.lang.NoClassDefFoundError: oracle/sysman/oii/oiic/OiicInstaller"
Note 435943.1 Oui Not Reading Oracle_home_name Variable
Note 578805.1 The "root.sh" Script Generated While Cloning A 9.2 Home Contains Duplicate Actions
Note 560411.1 Cloning Fails With 'Java RunTime Environment was not found at ../..//apps/oracle/jre/1.4.2/bin/java'
Note 740486.1 Cloning Fails With The Error: Cannot fork the command "./runInstaller -clone ..."
Note 457719.1 Oracle Home cloning gives file copy error for three files
Note 415855.1 After Cloning A 9.2.0.x Installation Using A 9.2.0.8 Clonerstage Patch, The Local Inventory Of The Cloned Home Is Incorrect
Note 454943.1 Install Hangs At Checking Prerequisites (30%)
Note 344798.1 Cloning A 10.2 RDBMS Installation Reports The Error `Properties file /config/cs.properties was not found. Failed loading corresponding properties.'
Note 455528.1 Wrong Elf Class: Elfclass32 Link Error Following Db Home Cloning
Note 469637.1 Clone.pl Fails With Error "Exiting With Status 255"
Note 1462229.1 11gR2 Cloning Fails : "OUI-10080:The Pre-requisite For The Component Oracle Configuration Manager 10.3.3.1.1 Has Failed"
Note 1475985.1 Cloning ORACLE_HOME fails: java.lang.UnsatisfiedLinkError: /tmp/OraInstall2012-03-26_02-18-59PM/oui/lib/solaris/liboraInstaller.so: ld.so.1: java: fatal: /usr/lib/libxml2.so.2: wrong ELF class: ELFCLASS32

Using My Oracle Support Effectively

Note 747242.5 My Oracle Support Configuration Management FAQ
Note 868955.1 My Oracle Support Health Checks Catalog
Note 166650.1 Working Effectively With Global Customer Support
Note 199389.1 Escalating Service Requests with Oracle Support Services

Generic Links

Note 854428.1 Patch Set Updates for Oracle Products
Note 1061295.1 Patch Set Updates - One-off Patch Conflict Resolution
Note 268895.1 Oracle Database Server Patchset Information, Versions: 8.1. 7 to 11.2.0
Note 161549.1 Oracle Database Server and Networking Patches for Microsoft Platforms
Note 161818.1 Oracle Database (RDBMS) Releases Support Status Summary

Information on Critical Patch Updates (CPU's)

References

NOTE:1351051.2 - Information Center: Install and Configure Database Server/Client Installations

Master Note For Oracle Database Upgrades and Migrations

For the most current information, please refer to :
(Doc ID 1152016.1) Master Note For Oracle Database Upgrades and Migrations

 

Applies to:

Oracle Server - Enterprise Edition - Version 8.0.6.0 and later
Oracle Server - Standard Edition - Version 8.0.6.0 and later
Information in this document applies to any platform.

Purpose

This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Database Upgrade and Migration. This Master Note is subdivided into categories to allow for easy access and reference to notes that are applicable to your area of interest within Upgrade and Migration. This includes the following categories:

General
How to
Diagnostic Tools
Known Issues
    Preupgrade Tool Issues
    During Upgrade Issues
    Post Upgrade Issues
    DBUA Specific Issues

Scope

This note serves as a guide through the various stages of upgrading/migrating a database.

It is applicable to upgrade/migration done via DBUA or the manual method.

It assumes you have already Installed Oracle software.

The intended audience is from junior DBA's to senior DBA's

This will cover the following versions of these products:

Oracle Server - Version: 8.0.6.x though 11.2.0.x

Details

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.

Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Install/Upgrade.

General

Note 419550.1 Different Upgrade Methods For Upgrading Your Database
Note 551141.1 Database Server Upgrade/Downgrade Compatibility Matrix
Note 730365.1 Oracle Database Upgrade Path Reference List
Note 455744.1 Best Practices to Minimize Downtime During Upgrade
Note 739485.1 How to estimate the time required to upgrade a database ?
Note 757245.1 Can you Upgrade RDBMS and Convert From 32-bit to 64-bit Binaries Directly on Linux or Windows based Intel Platforms Using the Database Upgrade Assistant (DBUA)
Note 1320966.1 Things to Consider Before Upgrading to 11.2.0.2 to Avoid Poor Performance or Wrong Results
Note 1392633.1 Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
Note 785351.1 Oracle 11gR2 Upgrade Companion
Note 601807.1 Oracle 11gR1 Upgrade Companion
Note 466181.1 10g Upgrade Companion

11gR2 (11.2) Upgrade Guide

11gR1 (11.1) Upgrade Guide

10gR2 (10.2) Upgrade Guide

10gR1 (10.1) Upgrade Guide

9.2 Upgrade Guide

How To

Note 251.1 Database Upgrade Planner from 10.2 to 11.2
Note 264.1 Database Upgrade Planner from 9.2 to 11.2
Note 732897.1 How to Log Good Service Requests for Database Upgrade/Migration Issues
Note 837570.1 Complete Checklist for Manual Upgrades to 11gR2
Note 870814.1 Complete checklist to upgrade the database to 11gR2 using DBUA
Note.1276368.1 Complete checklist for out-of-place manual upgrade from 11.2.0.1 to 11.2.0.2
Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1
Note 556477.1 Complete Checklist for Upgrades to 11gR1 using DBUA
Note 316889.1 Complete Checklist for Manual Upgrades to 10gR2
Note 263809.1 Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
Note 159657.1 Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
Note 117048.1 How to Upgrade from Standard to Enterprise Edition
Note 139642.1 Converting An Enterprise Edition Database To Standard Edition
Note 1437019.1 How To Prevent Apex From Being Installed During DB Upgrade

Diagnostic Tools

DB Upgrade/Migration-Troubleshooting Tool

Note 884522.1 How to Download and Run Oracle's Database Pre-Upgrade Utility
Note 556610.1 Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)
Note 212588.1 How To Investigate/Diagnose Hanging Issues When Upgrading or Migrating (includes DBMA & DBUA)
Note 577775.1 Dbua or Migration Is Hanging What to do?
Note 428118.1 How to enable Java code tracing for DBUA, DBCA and NETCA?

Known Issues

Preupgrade Tool Issues

Note 437371.1 ERROR:" WARNING: --> Database contains stale optimizer statistics.Refer to the 10g Upgrade Guide for instructions to update"
Note 407031.1 ORA-01403 no data found while running utlu102i.sql/utlu102x.sql on 8174 database
Note 271733.1 ORA-600 [17069] During Upgrade Using Database Upgrade Assistant, Utlu101i.sql or Utlu102i.sql
Note 549276.1 Utlu102i.sql Shows "WARNING: The database has not been patched to release 10.1.0.4.2" Showed
Note 370825.1 UTLU102I.SQL Reports That Already-Installed Components Need To Be Installed
Note 797750.1 "WARNING: --> Database contains schemas with objects dependent on network packages" When Running utlu111i.sql
Note 803774.1 The Utlu111i.Sql Pre-Upgrade Script Reports Stale Sys Statistics
Note 1473478.1 Pre-upgrade script utlu112i.sql errors with ORA-06550 and ORA-00942
Note 843899.1 DB Upgrade Throws ORA-25153: Temporary Tablespace Is Empty

During Upgrade Issues

Note 412271.1 ORA-600 [22635] and ORA-600 [KOKEIIX1] Reported While Upgrading Or Patching Databases To 10.2.0.3
Note 579523.1 ORA-600 [22635], ORA-600 [KOKEIIX1], ORA-7445 [KOPESIZ] and OCI-21500 [KOXSIHREAD1] Reported While Upgrading To 11.1.0.6 Or 11.1.0.7
Note 1077748.1 Upgrading to 11.1.0.7 Crashes with ORA-600, arguments: [kokeeiix3], [3]
Note 1081627.1 Upgrade to 11.1.0.7 Cancels with ORA-07445. ORA-600[QCTOSTIIX1] Showed at the Alert file.
Note 761711.1 Upgrade From 10.2.0.3 To 11.1.0.7 Using DBUA Throws ORA-600 [kksfbc-reparse-infinite-loop] Error During Update to SYS.AQ_SRVNTFN_TABLE
Note 1067072.1 ORA-600 [kzdugt], [2147483629] While Upgrading From 11gR1 To 11gR2
Note 1077748.1 Upgrading to 11.1.0.7 or 11.2.0.1 Crashes with ORA-600, arguments: [kokeeiix3], [3] or ORA-07445: exception encountered: core dump [qmxdGetMatchingChildren_int]
Note 464716.1 ORA-1722 when running Oracle 11g DBUA utility
Note 730057.1 Upgrading to 11g Fails with ORA-01722 invalid number
Note 859576.1 Upgrading to 11gR1 Stops With ORA-01722 invalid number
Note 744693.1 ORA-00001 For SYS.DIANA_VERSION$ During RDBMS Upgrade From 11.1.0.6 To 11.1.0.7
Note 845768.1 ORA-19905 LOG_ARCHIVE_FORMAT During Upgrade
Note 293658.1 10.1 or 10.2 Patchset Install Getting ORA-29558 JAccelerator (NCOMP) And ORA-06512
Note 557242.1 Upgrade Gives Ora-29558 Error Despite of JAccelerator Has Been Installed
Note 472959.1 "Ora-20000 : Insufficient privileges to analyze an object in Dictionary" During Catupgrd.Sql
Note 734563.1 Upgrading To 10.2.0.4 Manually Or Using DBUA Fails With ORA-01437
Note 470667.1 ORA-1422 During Upgrade To 10.2 or 11.1
Note 554983.1 Error During Migration To 11gR1: Database Is Using An Old Timezone File Version
Note 788087.1 When Running Catupgrd.Sql, Exits With ORA-00904/ORA-00942
Note 802694.1 Catupgrd.Sql Hang While Running dbms_metadata_hack.load_xsd('kusmv.xsd')
Note 1070951.1 11.1.0.6.0->11.2.0.1.0 UPGRADE FAILS WITH ORA-22371 REFERENCING XDB.XDB$PROPERTY_T, VERSION 1
Note 1104643.1 Upgrading Database to 11.2 Fails with ORA-01422
Note 1100828.1 11gr2 Upgrade, Re-Running catupgrd.sql Causes Ora-00001 Errors
Note 1051368.1 Startup Upgrade Gives ORA-202 ORA-17505 ORA-15061 ORA-600 [kccgtt_1]
Note 1091252.1 ORA-31114 "XDB configuration has been deleted or is corrupted" during upgrade to 11.2
Note 1148285.1 "ORA-01166: File number 101 is larger than MAXDATAFILES (100)" While Upgrading To 11.1.0.7 Or 11.2
Note 1326522.1 ORA-7445 [qmxarFindPartition] during database upgrade to 11.2
Note 1329606.1 10.2 Upgrade to 11.2 Hangs While Running Catupgrd.sql
Note 1425763.1 During A Database Upgrade To 11.2, Gathering Dictionary Statistics Takes Too Long (catupgrd.sql, cmpupend.sql)
Note 1465852.1 ORA-00942 reports during upgrade to 11.2.0.3 using manual or DBUA
Note 1466082.1 ORA-02095: Specified Initialization Parameter Cannot Be Modified
Note 1486277.1 SELECT TO_NUMBER('MUST_PATCH_TIMEZONE_FILE_VERSION_ON_NEW_ORACLE_HOME')

Post Upgrade Issues

Note 438210.1 Synonyms Become Invalid Since Upgrading To 10g
Note 456845.1 UTLU102S.SQL May Show Different Results Than Select From DBA_REGISTRY
Note 753041.1 How To Diagnose Components With NON VALID Status In DBA_REGISTRY After an Upgrade
Note 578841.1 How To Find What Objects Are Keeping Catalog And Catproc In Dba_Registry Invalid
Note 443706.1 After Migrate From 9.2.0.7 To 10.2.0.3 We Get Ora-04065 On Plitblm
Note 730136.1 OCI-21500 When Running UTLRP After A Successful Upgrade.
Note 782735.1 Oracle Database Server Component Invalid After Upgrade To 10.2.0.4, 11.1.0.6 Or 11.1.0.7
Note 978040.1 ORA-04045 ORA-04064 ORA-06508 ORA-06512 ERRORS RUNNING utlu111s.sql DURING UPGRADE TO FROM 9.2.0 TO 11.1.0
Note 1313429.1 Is it required to re-install the UTL_* packages after an upgrade to 11.2?

DBUA Specific Issues

Note 315184.1 Database Upgrade Assistant Hangs On Collecting Server Information
Note 567037.1 DBUA hangs at 82% for More than an Hour When Upgrading APPS DB to 10GR2
Note 339887.1 Failed Upgrade ''Dbua Thinks This Is A Rerun Operation'' ORA-01507
Note 603015.1 DBUA Fails with ORA-32004 and "Dbua Thinks This Is A Rerun Operation"
Note 729909.1 Upgrading to 11.1.0 and DBUA reports ORA-4023 On SYS.STANDARD
Note 789779.1 DBUA Error ORA-04031 unable to allocate 4120 bytes of shared memory, ORA-01034 ORACLE not available, ORA-00600 internal error code, arguments [504]
Note 271733.1 ORA-600 [17069] During Upgrade Using Database Upgrade Assistant, Utlu101i.sql or Utlu102i.sql
Note 308377.1 "ORA-01031 Insufficient Privileges" During An Upgrade Using DBUA On Unix/Linux
Note.386855.1 'startup migrate' failed with ORA-64 while upgrading to 10.2.0.2 with DBUA
Note 816457.1 DBUA unable to connect to the database for upgrade
Note 431437.1 10g DBUA Failed To Bring Up 9i Database. ORA-00119 ORA-00132 ORA-01078
Note 604248.1 DBUA Fails with ORA-0119 ORA-0132 ORA-1078 Upgrading to 10gR2
Note 391283.1 ORA-27054 NFS error while using DBUA to upgrade to 10gR2
Note 444148.1 Upgrading to 10gr2 Using Dbua Stops With An Alarm Sign At Step1
Note 737400.1 Ora-01408 Error Upgrading from 9i to 11g using Dbua
Note 559075.1 Dbua Won't Find Init<SID>.Ora During Upgrade Although It Is At The Right Location
Note 1321814.1 Underscore (Hidden) Parameters will not be retained after upgrade using DBUA
Note 1078388.1 Upgrdade to 11.2 via DBUA fails on ASMCA error on a database with no RAC or ASM
Note 980693.1 11gR2 DBUA States "The CEP File does not provide the version directive"
Note 1066828.1 11GR2 DBUA ORA-06550 PLS-00201 IDENTIFIER SYS.DBMS_JAVA MUST BE DECLARED
Note 1067422.1 DBUA ERROR: DOES NOT PROVIDE VERSION DIRECTIVE
Note 1066116.1 DBUA RAISES ORA-942 WHILE UPGRADING EXPRESSION FILTER COMPONENT
Note 1304849.1 DBUA: Database Is Missing From List Of Candidate Databases To Be Upgraded
Note 1364808.1 DBUA fails with error "Database is not open, restart database in open mode and try again" when upgrading from 10.2 to 11.2
Note 1466447.1 Database Upgrade Assistant (DBUA) Displays A Dialog Box When There Are Special Characters In The Pfile
Note 1477555.1 DBUA FAILS WITH "FOR INPUT STRING: 8,192" ERROR
Note 1453545.1 Database Upgrade using DBUA failed with invalid specification for system parameter LOCAL_LISTENER
Note 1427179.1 11.2.0.3 DBUA Hangs While Specifying ASM Disk To FRA

Using My Oracle Support Effectively

Note 747242.5 My Oracle Support Configuration Management FAQ
Note 868955.1 My Oracle Support Health Checks Catalog
Note 166650.1 Working Effectively With Global Customer Support
Note 199389.1 Escalating Service Requests with Oracle Support Services

Generic Links

Note 854428.1 Patch Set Updates for Oracle Products
Note 1061295.1 Patch Set Updates - One-off Patch Conflict Resolution
Note 268895.1 Oracle Database Server Patchset Information, Versions: 8.1. 7 to 11.2.0
Note 161549.1 Oracle Database Server and Networking Patches for Microsoft Platforms
Note 161818.1 Oracle Database (RDBMS) Releases Support Status Summary

Information on Critical Patch Updates (CPU's)

References

NOTE:1151427.1 - Master Note For Oracle Database Downgrade
NOTE:1351051.2 - Information Center: Install and Configure Database Server/Client Installations
NOTE:1351112.2 - Information Center: Upgrading and Migration Oracle Database  


Master Note For OPatch

 

For the most current information, please refer to :
(Doc ID 293369.1) Master Note For OPatch

 

Applies to:

Oracle Universal Installer - Version 1.0.0.0.50 and later
Information in this document applies to any platform.

Purpose

To provide a comprehensive list of commonly used Opatch notes.

Scope

This is applicable to all levels of expertise for Opatch.

Details

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.

Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Install/Upgrade.

 General

Note 1451669.1 FAQ : Understanding OPatch Tool And Patching
Note 224346.1 OPatch - Where Can I Find the Latest Version of OPatch?
Note 374092.1 Which OPatch version to download to apply/rollback interim patches?
Note 453495.1 FAQs on OPatch Version : 11.1
Note.334108.1 OPatch version 10.2 - FAQ

Note 433218.1 Why Should You Install 32-Bit JDK/JRE When You Have 64-Bit Oracle and Operating System ?
Note 1475077.1 Can the $ORACLE_HOME/jdk and $ORACLE_HOME/jdk/jre Directories Be Removed?
Note 1449674.1 Is It Supported to Update /Upgrade the Default JDK/JRE in Oracle Home?

Note 1446582.1 Frequently Asked Questions (FAQ): Patching Oracle Database Server
Note 865255.1 Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch

Note 1376691.1 Composite Patches for Oracle Products [Video]
Note 761111.1 RDBMS Online Patching Aka Hot Patching
Note 1463390.1 Limits Of Online Patching

Note 563656.1 Different types of Patch Conflicts - Superset/Subset/Duplicate/Bug/File
Note 1321267.1 Database Patch conflict resolution
Note 1299688.1 Patch conflict resolution
Note 1061295.1 Patch Set Updates - One-off Patch Conflict Resolution

Note 418537.1 Significance of oraInst.loc When Installing Oracle Products and Applying Patches
Note 812874.1 Understanding and Diagnosing MISSING_COMPONENT and/or SKIPPING_COMPONENT messages during opatch apply
Note 551222.1 Why Does OPatch Backup The Same Library Multiple Times?
Note 283367.1 OPatch for Oracle Application Server 10g (10.1.2, 10.1.3, 10.1.4)
Note 403212.1 Location Of Logs For Opatch And OUI
Note 403218.1 Can You Delete $ORACLE_HOME/.patch_storage Directory?

Note 861152.1 Does  PSU Released For Oracle 10gR2 (10.2.0.4) ,11g R1 (11.1.0.7) and 11g R2( 11.2.0.1) Change The Database Version/Fifth Digit?

How To

Note 298906.1 How To Repair A Corrupted Inventory For RDBMS
Note 556834.1 Steps To Recreate Central Inventory(oraInventory) In RDBMS Homes
Note 406037.1 Using OPatch -report option, how to check for potential conflicts during patch apply without Database / Listener shutdown
Note 458485.1 How to find whether the one-off Patches will conflict or not?
Note 550522.1 How To Avoid Disk Full Issues Because OPatch Backups Take Big Amount Of Disk Space.
Note 749787.1 How to run opatch in silent mode?
Note 821263.1 How to confirm that a Critical Patch Update (CPU) has been installed in Linux / UNIX
Note 750350.1 How To Find The Description/Details Of The Bugs Fixed By A Patch Using Opatch?
Note 729384.1 How To Find If a Specific Patch Has Been Applied On Oracle 8i or 9.0.1 (or 9i R1)?
Note 470225.1 How To Use Truss With Opatch?
Note 312767.1 How to Rollback a Failed Interim Patch Installation
Note 966023.1 How to create a ocm response file for opatch silent installation.
Note 459360.1 How To Do The Prerequisite/Conflicts Checks Using OUI(Oracle Universal Installer) And Opatch Before Applying/Rolling Back A Patch
Note.739963.1 Using AIX commands genld, genkld and slibclean to avoid library file locking errors (libjox)
Note 1394537.1 How To Rollback An Online Patch If The Database Is Down Or Removed
Note 453399.1 How To Check if inventory.xml/comps.xml Or Any Oracle XML File Is Correct?
Note 1474666.1 How to apply OC4J patch (13705478) on RDBMS home

Diagnostic Tools For Opatch

Note 1430571.1 Script To Collect Opatch Diagnostic Information For Unix Platform (opatchdiag.sh)
Note 1441309.1 Oneoffsdiag.sh:Script To Verify The Existance Of $ORACLE_HOME/inventory/oneoffs/PATCH_ID and also actions.xml and actions.xml inventory.xml in $ORACLE_HOME/inventory/oneoffs/PATCH_ID/etc/config

Known Issues

With Inventory

Note 229773.1 ALERT Applying Multiple Interim Patches Using OPatch Can Cause Inventory Corruption
Note 401454.1 Opatch Lsinventory Raises An OPatchException While Accessing O2O
Note 413829.1 Opatch Fails With 'Can not get details for given Oracle Home'
Note 417275.1 OPatch Lsinventory Reports `Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/transform/Source` When Executed Against 9.2.0.x
Note 417694.1 "OUI-67124:Inventory check failed: Patch ID is not registered in Oracle Home Inventory" while applying one-off patches using opatch
Note 431783.1 Opatch Lsinventory Result Shows: * Warning: no filemap entries available.
Note 795452.1 Opatch reports Error when using multiple oracle users
Note 864117.1 Opatch error: "Inventory load failed... OPatch cannot load inventory for the given Oracle Home."
Note 821550.1 Opatch Lsinventory Error: " Unable To Parse The Xml File"
Note 861677.1 Opatch error : "Unable to lock Central Inventory"
Note 864803.1 Opatch error: "Apply Session failed: ApplySession failed to prepare the system. No detail available."
Note 437026.1 ERROR :"OPatch cannot find a valid oraInst.loc file to locate Central Inventory.OPatch failed with error code 104"
Note 728417.1 OPatch Fails With "LsInventorySession failed:OracleHomeInventory gets null oracleHomeInfo"
Note 751152.1 Opatch Lsinventory Fails With "Unable to create patchObject" OPatch failed with error code 73
Note 1086853.1 OPatch Lsinventory Reports "OUI-67076 : OracleHomeInventory was not able to create a lock file"
Note 876343.1 Patch conflict Error OUI-67301 on 11.1.0.7.0 due to one off in inventory
Note 1185246.1 OPatch Fails With "OUI-67028:Inventory load failed"
Note 1308866.1 Opatch Cannot Load Inventory For The Given Oracle Home
Note 1456247.1 The opatch apply failing with OPatch failed with error code 39 :This patch requires some components to be installed in the home. Either the Oracle Home doesn't have the components or this patch is not suitable for this Oracle Home.

With Java

Note 332698.1 OPatch was not able to locate executable jar
Note 417372.1 OPATCH Error " java.lang.UnsatisfiedLinkError: ... liboraInstaller.so: ... "
Note 808368.1 opatch: cannot open shared object file.  Possible cause: architecture word width mismatch
Note 974371.1 After Installing The 11.2.0.1 32-bit Client Software On SPARC Solaris, OPatch and OUI Fail With ELFCLASS32 Errors For liboraInstaller.so
Note 417177.1 ERROR : "Java could not be located. OPatch cannot proceed!.OPatch failed with error code = 1"
Note 1474852.1 UTE011: Active tracepoint array length for JVM is 7559; should be 7577 Could not create JVM.
Note 1475894.1 Opatch commands error: JVMJ9VM019E Fatal error: Unable to find and initialize required class java/lang/ClassCircularityError

With Pre-Patching

Note 943436.1 Opatch Prereq Checkapplicable Error: "Unable to create Patch Object. Check if the given patch location is correct"
Note 780858.1 OPatch Fails With `Prerequisite check "CheckActiveFilesAndExecutables" failed` And `Following executables are active : $ORACLE_HOME/lib/libnmemso.so`
Note 882932.1 Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed When Applied Generic Patch 8282506
Note 861507.1 PSU Opatch conflict check fails with "OPatch failed with error code 73"
Note 292946.1 Opatch Detecting Wrong Platform Id For Install Of Patch
Note 404473.1 OPatch Reports Error "Opatch detects your platform as... this patch...supports platforms: 0 (Generic Platform)"
Note 602334.1 Opatch Not Working, Reporting That It Is Obsolete
Note 729218.1 ERROR: "The Oracle Home does not meet OUI version requirement.OPatch failed with error code 73"
Note 257800.1 OPATCH: Interim Patch  is holding the lock from this patch
Note 312926.1 Opatch Apply Gives: Can't Locate English.Pm In @Inc
Note 1050819.1 OPatch Reports Missing Component and Prerequisite Check "CheckApplicable" Failed
Note 869945.1 Zop-40: The Patch(es) Has Conflicts/Supersets With Other Patches
Note 1231223.1 Opatch Fails With Error Code 255
Note 747049.1 Opatch rollback error: Prerequisite check "CheckActiveFilesAndExecutables" failed
Note 1475206.1 Patch <patch_number> requires OPatch version <opatch version>

With Linking

Note 417319.1 Getting Warnings While Applying Patches on Linux x86-64
Note 457126.1 Opatch Aborted After Relink Fails On Target Ioracle.
Note 789053.1 Cannot find or open library file: -l pls10 when applying a patch with 10.2
Note 402945.1 While installing one-off Patch on AIX systems, getting several WARNING messages: OUI-67215 - TOC overflow and/or xlC: not found / xlC: Execute permission denied
Note 1446945.1 "ld: warning: symbol `_start' has differing types:" While Installing Or Patching 11gR2 On Oracle Solaris Platform
Note 1457270.1 ld: warning: symbol `_start' has differing types
Note 1474762.1 WARNING:OUI-67200:Make failed to invoke "/usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=<path>"....'ld: fatal: file /<path to O_H>/lib/prod/lib/v9/crti.o: open failed: Permission denied
Note 1467060.1 Relinking Oracle Home FAQ ( Frequently Asked Questions)

With Post-Patching

Note 353150.1 OPatch Failing Validation Phase When Archiving Really Did Not Fail
Note 791187.1 OPatch Failing Validation Phase - OPatch versions 10.2.0.4.6 and 11.1.0.6.6
Note 1361802.1 Opatch Auto doesn't patch the RDBMS Home if no database exists

Miscellaneous

Note 799883.1 Opatch error: OUI-67160 Unexpected end of ZLIB input stream
Note 739815.1 OUI-67294 Warning During OPatch Apply
Note 553244.1 WARNING MESSAGE "OUI-67078" and "OUI-67620" FROM OPATCH WHEN APPLYING 10.2.X PATCHES
Note 751107.1 ERROR: "Copy Action: Source file <filename> does not exist.'oracle.rdbms, <version> Cannot copy file'"
Note 553263.1 Opatch Reports 'libclntsh.so.10.1 not removed. Text file busy'
Note 563356.1 OPatch error 'file not found' message on 11.1.0.6 32-bit
Note 1136432.1 OPatch fails with JVMXM008
Note 1066937.1 Apply Patch Fails with 'Patch ID is null' and Error Code 73
Note 1475147.1 Opatch - Failed to load the patch object. Possible causes are: OPatch failed with error code = 73 LsInventorySession failed:
Note 1108834.1 OUI-67073:ApplySession failed: Patch ID is null occurred when applying patch 9352179
Note 803097.1 OUI-67200:Make failed problem while applying a Patch
Note 730754.1 Opatch Gives Exception In Thread "Main" Unsatisfiedlinkerror: Haltimpl
Note 603465.1 OPatch Fails With "Jar not applied ... to $ORACLE_HOME/jdbc/lib/classes12.zip... 'invalid entry compressed size (expected x but got y bytes)'"
Note 1474874.1 Opatch Apply Fails - Jar Action: Source File "/<path to patch stage directory>/<filename> '<Oracle Product/Componet>': Cannot update file '/<path to ORACLE_HOME>/<directory>/<filename>' with '/<path>/<filename>'
Note.1085753.1 Opatch Failing With Error Code 74 While Applying PSU
Note 402945.1 While installing one-off Patch on AIX systems, getting several WARNING messages: OUI-67215 - TOC overflow and/or xlC: not found / xlC: Execute permission denied
Note 1055397.1 OPATCH NAPPLY HANGING
Note 1244414.1 opatch throws: Archive Action: Source file "$ORACLE_HOME/.patch_storage/........." does not exist.
Note 1269454.1 Opatch Failed With Error Code 73 Because Session Is Not Able to Create a Directory
Note 1355040.1 Online patching errors: use "OPatch util enableOnlinePatch" to add the SID(s)
Note 1462303.1 Opatch Fails With Error "No such file or directory"
Note 1474805.1 Opatch Log Shows - INFO:Skip patch patch number from list of patches to apply: This patch is not needed.
Note 1476964.1 OPatch Logging "Generic Conflict" Between Sub-Patches Of A Composite Patch
Note 1468097.1 Argument (s) Error ... Illegal File Format For Composite Patch. There Is No Composite.xml File.
Note 1435438.1 Multiple OUI Messages In OPatch Log : OUI-67161, OUI-67085, OUI-67047, OUI-67049, OUI-67048, OUI-67085 and OUI-67050

Windows Specific

Note 390761.1 Using OPatch On Windows When ORACLE_HOME Contains Space Characters
Note 416318.1 HOW TO Use Process Explorer to obtain a list of DLLs loaded by a Windows process
Note 418479.1 Files in Use errors, when running OPatch to apply patches on Windows
Note 791005.1 Opatch permissions problem on 64-bit windows 2008 and Oracle 10.2.0.3 and 10.2.0.4
Note 1446273.1 OPATCH 11.2.0.3.0 LOCKS SRVM.JAR WHEN APPLYING ANY 11.2.0.3 BUNDLE PATCH ON WINDOWS X64

Using My Oracle Support Effectively

Note 732697.1 What Information Oracle Support Need To Work On OPatch Service Requests?
Note 735257.1 What information Oracle Support needs to work on Critical Patch Update (CPU) Installation Service Requests
Note 747242.5 My Oracle Support Configuration Management FAQ
Note 868955.1 My Oracle Support Health Checks Catalog
Note 166650.1 Working Effectively With Global Customer Support
Note 199389.1 Escalating Service Requests with Oracle Support Services
Note 1194734.1 Where do I find that on My Oracle Support (MOS) [Video]

Generic Links

Note 1454618.1 Quick Reference To Patch Numbers For Database PSU, CPU And Bundle Patches
Note 854428.1 Patch Set Updates for Oracle Products
Note 268895.1 Oracle Database Server Patchset Information, Versions: 8.1. 7 to 11.2.0
Note 161549.1 Oracle Database Server and Networking Patches for Microsoft Platforms
Note 161818.1 Oracle Database (RDBMS) Releases Support Status Summary

Information on Critical Patch Updates (CPU's)

References

NOTE:1351112.2 - Information Center: Upgrading and Migration Oracle Database
NOTE:1351022.2 - Information Center: Overview Database Server/Client Installation and Upgrade/Migration
NOTE:1298096.1 - Master Note For Database and Client Certification
NOTE:1351428.2 - Information Center: Patching and Maintaining Oracle Database Server/Client Installations
NOTE:1351051.2 - Information Center: Install and Configure Database Server/Client Installations  

Sunday Jul 04, 2010

Oracle Gateway Master Note (Doc ID 1083703.1)

Master Note for Oracle Gateway Products

1. Concepts and Availability

Oracle Gateway products are based on Heterogeneous Services and allow access to non-Oracle databases from Oracle products.
Heterogeneous Services provides the generic technology for connecting to non-Oracle systems. As an integrated component of the database, Heterogeneous Services can exploit features of the database, such as the powerful SQL parsing and distributed optimization capabilities.
Heterogeneous Services extend the Oracle SQL engine to recognize the SQL and procedural capabilities of the remote non-Oracle system and the mappings required to obtain necessary data dictionary information.

There are dedicated Gateways for the following non-Oracle data sources -
- Microsoft SQL*Server - Database Gateway for SQL*Server (DG4Msql)
- Sybase - Database Gateway for Sybase (DG4Sybase)
- Informix - Database Gateway for Informix (DG4Ifmx)
- IBM DB2 - Database Gateway for DRDA (DG4DRDA)
- Teradata - Database Gateway for Teradata (DG4Teradata)
- Websphere MQ - Database Gateway for Websphere MQ (DG4MQ)
- Remote online transaction processors (OLTPs) - Database Gateway for APPC (DG4APPC)
- IMS - Database Gateway for IMS (DG4IMS)
- VSAM - Database Gateway for VSAM (Dg4VSAM)
- Adabas - Database Gateway for Adabas (DG4Adabas)

Non-Oracle datasources for which a dedicated gateway is not available can be accessed by using the following -

Database Gateway for ODBC (DG4ODBC)

which uses third party ODBC drivers to make the connection to non-Oracle data sources such as as MySQL, Progress, Ingres.
It can also be used to access non-Oracle databases for which a dedicated gateway is available.
Further details are available in this note -

Note.233876.1 Options for Connecting to Foreign Data Stores and Non-Oracle Databases - For example - DB2, SQL*Server, Sybase, Informix, Teradata, MySQL

There are differences in the functionality and licensing of the Database Gateway for ODBC and the other gateways which are discussed in these notes -
Note.252364.1 Functional Differences Between Generic Connectivity and Database Gateways
Note.232482.1 Gateway and Generic Connectivity Licensing Considerations

The following note has information about the desupport of earlier gateway versions -

Note.549796.1 Desupport of Oracle Transparent Gateways
Note.353723.1 Oracle Transparent Gateway for iWay
Note.353728.1 Oracle Transparent Gateway for INGRES
Note.353725.1 Oracle Transparent Gateway for Rdb
Note.353729.1 Oracle Transparent Gateway for RMS
Note.417250.1 Oracle Transparent Gateway for INFORMIX
Note.417253.1 Oracle Transparent Gateway for SYBASE
Note.417254.1 Oracle Transparent Gateway for MS SQL Server
Note.417251.1 Oracle Transparent Gateway for TERADATA
Note.420436.1 Oracle Transparent Gateway for DRDA - SNA Support desupport
Note.559947.1 Oracle Access Manager for AS/400
Note.559948.1 Oracle Transparent Gateway for DB2/400

Oracle's Software Error Correction Support policy document is available in this note -

Note.209768.1 Database, FMW, EM Grid Control, and OCS Software Error Correction Support Policy

Oracle's Lifetime Support Policy document is available here:

http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf

For information about the Gateway support policy refer to the section -

Oracle Gateway Release's

The certification matrix for the 11.1 and 11.2 Gateways is now available on OTN from the following URL -

http://www.oracle.com/technetwork/database/gateways/index.html

then -

Database Gateways Certification Matrix (PDF)
Mainframe Database Gateways Certification Matrix (PDF)
Legacy Database Gateways Certification Matrix (PDF)

Please note that the Legacy Gateways -
DG4IMS
DG4VSAM
DG4Adabas

can no longer be ordered. They will still be available on install media but will be decommissioned.

2. Downloading Gateway Products

Before trying to download a Gateway please refer to the certification matrix to make sure it is available for your platform and version.

Oracle Gateway products can be downloaded from the following -

1. Oracle Technology Network - OTN -

http://www.oracle.com/technology/software/products/database/index.html

Choose the relevant platform and version then the 'See All' option.
Under that there will be an option to download the Gateway products, for example -

Oracle Database Gateways 11g Release 2 (11.2.0.1.0) for Microsoft Windows (32-bit)

Please note that only 11.2 versions of the Gateway products are available on Windows 64-bit.  The earlier versions are not available on that platform.

2. Oracle Software Delivery Cloud


http://edelivery.oracle.com/

- go through the Terms & Restriction proces
- on the next screen ' Media Pack Search' screen choose -
 Select a Product Pack - Oracle database
- then choose your platform
- choose the 'Oracle database' media pack for the version you need - 11.1 or 11.2
- on the next screen there will be a gateway media pack to download.

The following note has links to a video showing how to download gateways -

Note.1279746.1 Where Can I Find And Download the Latest Gateways Available From Oracle?

3. My Oracle Support - 11.2.0.2 and 11.2.0.3

The 11.2.0.2  and 11.2.0.3 versions of the gateways are included in the Oracle Database patch sets 10098816 and 10404530.
Starting with the 11.2.0.2 patch set, Oracle Database patch sets are full installations of the Oracle Database software. This means that you do not need to install a 11.2.0.1 release of a gateway  before installing the 11.2.0.2 or 11.2.0.3 versions. The later versions can be installed in completely separate ORACLE_HOME directories from any existing installs.
To download the latest 11.2.0.3 gateways -

- logon to My Oracle Support
- go to Patches & Updates section
- search for patch number 10404530 and choose your platform
- click on the patch number
- for most platforms for the gateways you only need to download -
p10404530_112030_platform_5of7.zip
for example -
p10404530_112030_Linux-x86-64_5of7.zip
but for Windows 32-bit this is -
p10404530_112030_WINNT_4of6.zip



To confirm which file is needed for the Gateways review the 'README' file which details which download files contain which software.

The 11.2.0.3 patch is also available for some platforms and can be found as patch 10404530 on My Oracle Support.

3. Installation and Configuration

The installation and configuration for each gateway is described in the documentation.
This is available from -

http://www.oracle.com/technology/documentation/index.html

Click on the version required - 11.1 or 11.2  - then 'View Library'
The Gateway documentation is available from the 'Information Integration' option under the 'Heterogeneous Connectivity' heading.

The following note gives an overview of the Gateway install process -

Note.1351618.1 Installation Overview For Oracle Database Gateway Products


There are also notes available in My Oracle Support (MOS) to help with the install and configuration -

- logon to MOS -

http://support.oracle.com

- Knowledge tab
- Oracle Database Products
- Oracle Database
- Gateways
- then choose the relevant gateway

Examples are -

Note.437374.1 How to Configure DG4MSQL (Oracle Database Gateway for MS SQL Server) Release 11 on Linux x86 32bit post install
Note.466267.1 How to Configure DG4MSQL (Database Gateway for MS SQL Server) on Windows 32bit post install
Note.562509.1 How to Configure DG4MSQL (Oracle Database Gateway for MS SQL Server) 64bit Unix OS (Linux, Solaris, AIX,HP-UX) post install
Note.1086365.1
How to Configure DG4MSQL (Database Gateway for MS SQL Server) on a 64bit Windows post install
Note.466228.1 How to Configure DG4ODBC on Linux x86 32bit to Connect to Non-Oracle Databases post install
Note.561033.1 How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX) to Connect to Non-Oracle Databases Post Install
Note.466225.1 How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on Windows 32bit to Connect to Non-Oracle Databases Post Install
Note.1266572.1 How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows Operating Systems to Connect to Non-Oracle Databases Post Install
Note.945879.1 How to Setup DG4DRDA (Oracle Database Gateway for DRDA) Release 11.2 on Unix (Linux, AIX, HP-UX Itanium and Solaris) to Connect to DB2
Note.1086359.1 How to Setup DG4DRDA (Oracle Database Gateway for DRDA) on Windows x86 (32bit and 64bit) to Connect to DB2
Note.437689.1 How to Setup DG4IFMX (Oracle Database Gateway for Informix) Release 11 on Linux
Note.437696.1 How to Setup DG4SYBS (Oracle Database Gateway for Sybase) Release 11 on Linux
Note.554402.1 How to Setup DG4TERA (Oracle Database Gateway for TeraData) on Windows 32bit
Note.823534.1 How to Setup DG4Tera (Oracle Database Gateway for TeraData) on 64bit Unix
Note.437680.1How to Setup DG4Tera (Oracle Database Gateway for TeraData) Release 11 on Linux
Note.467947.1Setting up Legacy Gateways DG4ADABAS, DG4VSAM, DG4IMS)
Note.564299.1 How to Install DG4MQ on Linux

but new notes are continually being added.

The following notes have details of a configuration utility for the relevant gateway -

Note.1274157.1 Gateway Configuration Utility for Database Gateway For SQL Server
Note.1274143.1 Gateway Configuration Utility for Database Gateway for ODBC - DG4ODBC - to Connect to Non-Oracle Databases For Example - DB2, SQL*Server, Sybase, Informix, MySQL
Note.1286444.1 Gateway Configuration Utility for Database Gateway for DRDA - DG4DRDA - to Connect to DB2
Note.1286435.1 Gateway Configuration Utility for Database Gateway for Sybase



4. Troubleshooting

The following note details some of the common errors and solutions for Gateway issues -

Note.234517.1 How to Resolve Common Errors Encountered while using Transparent Gateways or Generic Connectivity

The following note details causes of some ORA-7445 errors -

Note.1420697.1 ORA-7445 Error Messages Using an Oracle Database Gateway (DG4DRDA, DG4IFMX, DG4MSQL, DG4ODBC, DG4SYBS, DG4TERA)


If you need to raise a service request with Oracle Support then the following information is needed to help speed up resolution -

- name and full version of the gateway being used
- platform and version where the gateway is installed
- version of the Oracle RDBMS being used to access the gateway
- name and full version of the non-Oracle data source being accessed
- configuration files and information -
gateway listener.ora
gateway init<sid>.ora
tnsnames.ora
create database link statement
- statement causing the error
- full error being received from SQLPLUS when running the problem statement
- a gateway debug trace file from running the problem statement. This is created by adding the following to the gateway init<sid..ora file -
HS_FDS_TRACE_LEVEL=debug
and running the problem statement from a new session. It is not necessary to stop and start the listener for this to take effect.
- note that for DG4DRDA 11.1 there is a different procedure for setting up debug tracing which is described in the documentation and also in these notes -
Note.221136.1 How To Trace DRDA Gateway (TG4DRDA or DG4DRDA) On Unix platforms
Note.428387.1 How To Trace The Transparent Gateway For DRDA (TG4DRDA) On Windows Platforms

Common Gateway error messages are -

ORA-28545 error diagnosed by Net8 when connecting to an agent
ORA-28500 connection from ORACLE to a non-Oracle system returned this message:
ORA-02063 preceding <str> from <name>
ORA-28511 lost RPC connection to heterogeneous remote agent using
ORA-02085 database link %s connects to %s
ORA-02062 distributed recovery received DBID <num>, expected <num >
ORA-02019 connection description for remote database not found
ORA-28513 internal error in heterogeneous remote agent
ORA-28500 connection from ORACLE to a non-Oracle system returned this message

5. Alerts

Alert notes for Gateway products are available in My Oracle Support.
To access alert notes do the following -

- logon to My Oracle Support
- choose the Knowledge tab
- In 'Knowledge Articles' click the pencil icon
- in the 'Product' option enter - gateway
- choose the gateway you want to see
- a list will be displayed if there is an alert
- there will also be a list of recently updated articles for the gateway


Who to contact for more information?


Gateway information is available from My Oracle Support (MOS) -

http://support.oracle.com

- Knowledge tab
- make sure you have enabled 'Browse Knowledge' in Customize
- in 'Find a Product by Name' enter 'gateway' - without the quotes
- then choose the relevant gateway
- continue in the 'What do you want to do' section

There is a My Oracle Support Database Gateways Community, a place to collaborate with peers in the industry and with Oracle experts which is live now at:

https://communities.oracle.com/portal/server.pt/community/database_gateways/299

There is also an Oracle Technology Network forum available at -

http://forums.oracle.com/forums/forum.jspa?forumID=63





















About

News and Troubleshooting tips for Oracle Database and Enterprise Manager

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today