Sunday Oct 12, 2014

ORAchk New Version 12.1.0.2.1

The new ORAchk release 12.1.0.2.1 is now available to download.

Easier to stay up to date with the most current version of ORAchk

ORAchk release versioning now aligns with and follows the same format used by the Oracle 12c Database Patch Set Updates (PSUs); this version is 12.1.0.2.1, the next will be 12.1.0.2.2.
It’s also now even easier to update ORAchk across multiple machines.
  1. Download the latest release of orachk.zip into a shared network staging directory
  2. Set the environment variable $RAT_UPGRADE_LOC to the staging directory
  3. The next time ORAchk is run it will prompt you to auto update

New ORAchk Support for Windows

ORAchk is now supported on Windows when run within a Cygwin environment. Instructions for configuring Cygwin can be found from Document 1268927.2. ORAchk now includes hundreds of database and application checks which will run on Windows. There are even more Windows specific checks in the pipeline.

Easier execution for environments with role separation

You no longer need to have different users execute different ORAchk profiles to workaround your company’s implementation of role separation. ORAchk can now be run once as root to execute all checks. Prior to executing checks that do not require root access, ORAchk will switch user to the lower level accounts.

Faster execution time

When running against multiple databases, ORAchk can now run database checks in parallel meaning it takes a fraction of the time to complete execution. Parallel database execution is now the default. It can be turned off, if you prefer to run checks serially.

Enhanced comparison of result output

Quickly find out what has changed on your system between two ORAchk runs. When ORAchk is run with the –diff command it will now not only compare check results but collection data too. Quickly compare and understand differences in kernel parameters or database initialization parameters.

Over 70 new EBS checks

ORAchk support for EBS has been enriched and broadened, with even more checks for Oracle Payables (R12) and Oracle Workflow and now with release 12.1.0.2.1 introduces new support for Oracle Order Management (R12) and Oracle Process Manufacturing (R12).

For more details and to download the latest release of ORAchk see Document 1268927.2

Sunday Sep 14, 2014

Introducing Oracle Support Engineer Initiated Chat for Existing Service Requests

My Oracle Support now offers a chat feature that enables Oracle Support engineers to contact you instantly online to discuss an open Service Request (SR). Oracle Support engineers may use this feature on an open SR to provide a status update, ask clarifying questions, share detailed commands and troubleshooting information, or confirm your issue is resolved. This feature is available to all My Oracle Support Customer Portal users and is another step towards leveraging preferred social technologies in our Support solutions.

Attend the webcast September 23, 2014 and September 24, 2014 and learn more at

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

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 Database - Enterprise Edition - Version 9.2.0.1 and later
Oracle Database - Standard Edition - Version 9.2.0.1 and later
Linux x86-64
Linux Itanium
IBM: Linux on System z
Linux x86
Generic Linux
IBM: Linux on POWER Systems

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

Red Hat Enterprise Linux (RHEL)


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

Quick Links for RHEL

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

RHEL6 x86_64:

 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 - Document 1441282.1 Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit (x86-64)
12.1.0 - Document 1529864.1 Requirements for Installing Oracle Database 12.1 on RHEL6 or OL6 64-bit (x86-64)
RHEL6 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 - Document 1470834.1 Requirements for Installing Oracle 11.2.0.3/11.2.0.4 RDBMS on RHEL 6 on zLinux (s390x)
12.1.0 - Document 1574413.1 Requirements for Installing Oracle Database 12c Release 1 on RHEL 6 on IBM: Linux on System z (s390x)


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
12.1.0 - Document 1529433.1 Requirements for Installing Oracle Database 12.1 on RHEL5 or OL5 64-bit (x86-64)


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)
11.2.0 - Document 1306889.1 Requirements for Installing Oracle 11gR2 on RHEL 5 on IBM: Linux on System z (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 zlinux
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
12.1.0 - Document 1519770.1 Requirements for Installing Oracle Database 12.1 64-bit (AMD64/EM64T) on SLES 11
SLES11 zLinux:

10.2.0 - Document 1290360.1 Requirements for Installing Oracle 10gR2 RDBMS on SLES 11 on zLinux (s390x)
11.2.0 - Document 1290644.1 Requirements for Installing Oracle 11gR2 on SLES 11 on IBM: Linux on System z (s390x)
12.1.0 - Document 1574414.1 Requirements for Installing Oracle Database 12c Release 1 on SLES 11 on IBM: Linux on System z (s390x)


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 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 Database - Enterprise Edition - Version 9.2.0.8 and later
Oracle Database - 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 and higher

DETAILS

General

Note 565009.1 FAQs on RDBMS Oracle Home Cloning Using OUI

Note 458893.1 Oracle Universal Installer (OUI) FAQ

Note 757964.1 Oracle Universal Installer ( OUI ) Error Messages and Solution Reference List

Note 403212.1 Location Of Logs For OPatch And OUI

Oracle Universal Installer and OPatch User's Guide 11g Release 2 (11.2) for Windows and UNIX

Oracle Universal Installer and OPatch User's Guide 11g Release 1 (11.1) for Windows and UNIX

Oracle Universal Installer and OPatch User's Guide 10g Release 2 (10.2) for Windows and UNIX

(References for 9.2 and 10.1 cloning will be in the "How To" section below.)

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 1493677.1 Cloning An Existing Oracle Database 12c Release 1 (12.1.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

Note 1520299.1 Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC)

Note 1555012.1 Install/Deinstall/Cloning Assistant: Oracle Database/Client

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
Note 1511859.1 OUI:Attachhome fails with the Error "SEVERE: Abnormal program termination. An internal error has occured. Please provide the following files to Oracle Support

Using My Oracle Support Effectively

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
Note 1476075.1 FAQ: Downloading 9i, 10g, and 11g database software media
Note 1194734 Where do I find that on My Oracle Support (MOS) [Video]

Information on Security Patch Updates (SPU's)

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 Database - Standard Edition - Version 8.0.6.0 and later
Oracle Database - Enterprise 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 1561791.1 Upgrade / Downgrade Assistant: Oracle Database/Client
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 1515747.1 Oracle Database 12c Release 1 (12.1) Upgrade New Features
Note 1493645.1 Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA
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 733205.1 Migration Of An Oracle Database Across OS Platforms (Generic Platform)
Note 785351.1 Oracle 11gR2 Upgrade Companion
Note 601807.1 Oracle 11gR1 Upgrade Companion
Note 466181.1 10g Upgrade Companion

Oracle Database Upgrade Guide 12c Release 1 (12.1)

Oracle Database Upgrade Guide 11g Release 2 (11.2)

Oracle Database Upgrade Guide 11g Release 1 (11.1)

Oracle Database Upgrade Guide 10g Release 2 (10.2)

Oracle Database Upgrade Guide 10g Release 1 (10.1)

Oracle Database Upgrade Guide 9i Release 2 (9.2)

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 1503653.1 Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
Note 1516557.1 Complete Checklist for Upgrading to Oracle Database 12c Release 1 (12.1) using DBUA
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 previous 11.2.0.N version to the latest 11.2.0.N patchset.
Note 1377613.1 In-Place Upgrade on UNIX For Single Instance 11gR2 Database
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
Note 1516616.1 Oracle Database 12c Release 1 (12.1) DBUA in Silent mode

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?
Note 1543850.1 Post Upgrade Scripts - utlu112s.sql & catuppst.sql report many Errors after upgrading Database from 10.2.0.X to 11.2.0.X

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 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 Security Patch Updates (SPU's)


Master Note For OPatch

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


APPLIES TO:

Oracle Database - Standard Edition - Version 8.1.7.4 and later
Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Oracle Universal Installer - Version 1.0.0.0.50 and later
Siebel CRM - Version 8.1.1.11 SIA [23030] to 8.1.1.11 SIA [23030] [Release V8]
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

OPatch User Guides

General

Note 1561792.1 Patching Assistant: Oracle Database/Client
Note 1451669.1 FAQ : Understanding OPatch Tool And Patching
Note 224346.1 OPatch - Where Can I Find the Latest Version of OPatch?
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 1526322.1 11g : Can Examples CD Be Installed After Interim Patches Are Applied On The Base Version?

Note 1530108.1 Oracle Database 12.1 : FAQ on Queryable Patch Inventory
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?

Note 1520299.1 Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC)

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
Note 1543697.1 How To Use MOS Patch Planner Via Enterprise Manager 12c To Check for and Resolve Patch Conflicts

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 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 1475147.1 OPatch - Failed to load the patch object. Possible causes are: OPatch failed with error code = 73 LsInventorySession failed:
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 apply/rollback error: Prerequisite check "CheckActiveFilesAndExecutables" failed
Note 1475206.1 Patch <patch_number> requires OPatch version <opatch version>
Note 1629444.1 Opatch Fails Updating Archives with " No space left on device " Error

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 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)
Note 1525333.1 Relink error on target iKfed while patching Oracle 11.2.0.3 Client with 11.2.0.3.5 PSU
Note 1534583.1 OPatch fails to Rollback Patch due to relink errors.
Note 1539887.1 Undefined first referenced symbol ld: fatal: symbol referencing errors.

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

With SQLPatching (datapatch)

Note 1599479.1 Datapatch errors at "SYS.DBMS_QOPATCH"
Note 1632818.1 Datapatch may fail while patching a RAC+PDB environment

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 1331900.1 Prerequisite Check "CheckRollbackable" On Auto-rollback Patches Failed
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-6705
Note  244241.1 Rolling Patch - OPatch Support for RAC

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
Note 1530132.1 Applied Bundle patch 16 (16167942/16167941) but opatch lsinventory incorrectly showing as Bundle patch 15.
Note 1568694.1 OPatch throwing "Unable to lock Central Inventory" on Windows 7

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 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 1119703.1 Database PSU-CPU Cross-Reference List
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 Security Patch Updates (SPU's)

About

News and Troubleshooting tips for Oracle Database and Enterprise Manager

Search

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