Thursday, July 8, 2021

Master Note For Oracle Database Server Installation (Doc ID 1156586.1)

  Document

Purpose
Scope
Details
 Ask Questions, Get Help, And Share Your Experiences With This Article
 Certification
 Installation Guides
 OS General Information and Known Issues
 Generic
 Solaris 
 Linux
 AIX
 HP
 WINDOWS
 Scripts
 Silent Install
 Deinstall/Removing Installations
 Diagnostic Tools
 General Information
 Using My Oracle Support Effectively
 Generic Links
References

APPLIES TO:

Oracle Universal Installer - Version 2.2.0.18 and later
Oracle Database - Standard Edition - Version 9.0.1.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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 Installation.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 INSTALLATION.This includes the following categories:

* Certification

* Installation Guides

* OS General Information and Known Issues

* Scripts

* Silent Install

* Diagnostic Tools

* General Information

* Using My Oracle Support Effectively

* Generic Link

SCOPE

This note guides you through the process of Oracle Database Installation.

This note applies to the following versions of these products:

Oracle Server - Enterprise Edition - Version: 8.1.7.1 to 8.1.7.x
Oracle Server - Enterprise Edition - Version: 9.0.1.1 to 9.0.1.x
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 9.2.0.x
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.x
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.x
Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 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?

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

Certification

For the latest Database Certification always refer to My Oracle Support (MOS) Certify.

At the same time the documentation listed below assists in understanding the Oracle Database Certification:

Note 1298096.1 Master Note For Database and Client Certification
Note 161818.1 Oracle Database (RDBMS) Releases Support Status Summary
Note 207303.1 Client / Server / Interoperability Support Between Different Oracle Versions
Note 1307745.1 Oracle Database Support on the Itanium Processor Architecture
Note 464754.1 Certified Software on Oracle VM
Note 1306539.1 Core Oracle Database Certification Information

Installation Guides

Oracle Database 12c Release 1 (12.1)
Installation manuals and platform-specific books are included in this link.

Oracle Database 11g Release 2 (11.2)
Installation manuals and platform-specific books are included in this link.

Oracle Database 11g Release 1 (11.1)
Installation manuals and platform-specific books are included in this link.

Oracle Database 10g Release 2 (10.2)
Installation manuals and platform-specific books are included in this link.

Oracle Database 10g Release 1 (10.1)
Installation manuals and platform-specific books are included in this link.

Oracle Database 9i Release 2 (9.2)
Installation manuals and platform-specific books are included in this link

Oracle Database 9i Release 1 (9.0.1)
Installation manuals and platform-specific books are included in this link

OS General Information and Known Issues

Most of the installation and relinking issues appear if you don't satisfy the minimum requirements for the installation. Therefore if you are raising any SR for installation issue it is better to ensure that you have all these requirements mentioned in the below articles before raising the SR.

The documentation listed below help you in understanding the OS Requirements for Oracle Database Installation:

Generic

Solaris

Linux

AIX

HP

WINDOWS

Generic

General

Note 1520299.1 Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment
Note 1483380.1 Changes For Oracle Database 12.1 Standalone Installation
Note 1555012.1 Install/Deinstall/Cloning Assistant: Oracle Database/Client
Note 1351051.1 Information Center: Install and Configure Database Server/Client Installations
Note 1476075.1 FAQ on downloading 9i, 10g, 11g software
Note 169706.1 Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
Note 742060.1 Release Schedule of Current Database Releases
Note 458893.1 Oracle Universal Installer (OUI) FAQ
Note 403212.1 Location Of Logs For OPatch And OUI
Note 454442.1 11g Install : Understanding about Oracle Base, Oracle Home and Oracle Central/Global Inventory locations
Note 1467060.1 Relinking Oracle Home FAQ ( Frequently Asked Questions)
Note 131321.1 How to Relink Oracle Database Software on UNIX
Note 883299.1 Oracle 11gR2 Relink New Feature
Note 444595.1 Is It Necessary To Relink Oracle Following OS Upgrade?
Note 556834.1 Steps To Recreate Central Inventory(oraInventory) In RDBMS Homes
Note 750540.1 What are the requirements for an Oracle Home Name in the Inventory?
Note 881063.1 Key RDBMS Install Differences in 11gR2
Note 884232.1 11gR2 Install (Non-RAC): Understanding New Changes With All New 11.2 Installer
Note 948061.1 How to Check and Enable/Disable Oracle Binary Options
Note 429074.1 Can You Run Different Releases Of The Oracle Database On The Same Computer At The Same Time?
Note 389678.1 Are Compilers Necessary for Oracle RDBMS Installation?
Note 401332.1 How To Identify A Server Which Has Itanium2 (Montecito, Montvale, Tukwila....) Processors Installed
Note 400227.1 How To Install Oracle RDBMS Software On Itanium Servers With Montecito Processors
Note 1474891.1 Is It Supported to Change Uid/Gid Of Oracle Database Software Owner After Installation?
Note 1469625.1 Can root.sh Be Run While Standalone Database Instances Are Up And Running?
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 1429678.1 How to interpret OS system traces

Known Issues Generic

Note 468771.1 Installing 11G on Any Platform : File Not Found Errors Running RunInstaller/Setup.exe
Note 883702.1 $ORACLE_HOME/lib32 does not exist in Oracle database 11gR2. Why?
Note 1245784.1 Installing Component using Installer from 11.2 ORACLE_HOME Fails with OUI-10150
Note 1091063.1 sqlplus /nolog is failing with errors : SP2-1503 SP2-0152
Note 1207849.1 Install Error: String Index Out Of Range: -1 Error Messages
Note 1325924.1 INS-32025 while installing 11.2 examples
Note 1367658.1 11.2 OUI does not use the $TEMP variable for CV_DESTLOC during a single instance installation
Note 1307782.1 Oracle 11.2 Installation Fails If OS Users Password Contains '%'
Note 1162824.1 Installing Oracle 10.2.0.1 On AIX Hangs At Prereqs Check
Note 1127135.1[INS-00001] Unknown irrecoverable error installing 11.2
Note 744512.1 Ora-12547: Tns:Lost Contact Creating Database After Clean Installation
Note 763143.1 Explanation and Options To Handle "Checking operating system version: must be ... Failed" OUI errors
Note 1268391.1 Installing 11gR2 Fails With [INS-30060] Check For Group Existence Failed
Note 1301113.1 "Invalid Entry Size" Error During Oracle Database Installation
Note 1471777.1 11.2.0.3 OUI Screen Not Coming Up Through Xmanager (Exceed)
Note 1475425.1 Oracle Universal Installer - Make issue While Installing 11gR2 Database
Note 1478832.1 Instaling 11.2 fails with error Error in invoking target 'rat_on part_on dm_on olap_on sdo_on' of makefile and echodo: Execute permission denied.
Note 1475482.1 ./runInstaller results in: [FATAL] [INS-32012] Unable to create directory: <directory path>
Note 1489892.1 OUI Screen Disconnected Before Prompts To Run Scripts As 'Root' User Have Been Responded
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 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"
Note 1536056.1 Execution of oraenv fails with error "0403-009 Invalid number for this command"
Note 1555453.1 Executing "relink all" resets permission of extjob, jssu, oradism, externaljob.ora
Note 1292347.1 [INS-10002] Inventory Initialization Failed or [INS-10102] Installer initialization failed During Installation
Note 1569962.1 "[INS-30131] The initial setup that is required to run the installation program validation was not successful" Error While Installing 12.1

Solaris 

General

Note 1525614.1 Requirements for Installing Oracle Database 12.1 on Solaris 11 SPARC
Note 1517948.1 Requirements for Installing Oracle Database 12.1 on Solaris 10 SPARC
Note 1496618.1 Requirements to Install Oracle 11gR2 RDBMS on Solaris 11 SPARC / X86_64
Note 1307041.1 Certification Information for Oracle Database on Solaris SPARC 64
Note 1307389.1 Certification Information for Oracle Database on Oracle Solaris x86-64
Note 743042.1 Requirements for Installing Oracle 11gR1 RDBMS on Solaris 10 SPARC 64-bit
Note 971464.1 FAQ - 11gR2 requires Solaris 10 update 6 or greater
Note 964976.1 Requirements for Installing Oracle 11gR2 RDBMS on Solaris 10 SPARC
Note 429191.1 Kernel setup for Solaris 10 using project files
Note 317257.1 Running Oracle Database in Solaris 10 Containers - Best Practices
Note 1557986.1 Defining Solaris 11 Standard Installation

Known Issues on Solaris

Note 1496746.1 Linking Of Oracle 12c Binaries on Solaris Failed with " ld: fatal: library -ldtrace: not found" Error
Note 1518334.1 INFO: ld: warning: symbol '_init' not found
Note 848700.1 11gR1 on Solaris failing at relink phase with errors like "ld fatal relocation error" and then "ld fatal library -lclntsh not found"
Note 966929.1 11gR2 INSTALL ERRORS on Solaris 10
Note 989727.1 11GR2 INSTALL ON SOLARIS FAILS MANY PREREQUISITE CHECKS
Note 969497.1 During An 11gR2 (11.2) Installation On Solaris, OUI Performs A Prerequisite Check For The Optional Patch 124861-15 And Fails If It Is Not Installed
Note 1325973.1 [INS-30060] Check for group existence failed - While installing 11gR2 on Solaris
Note 1477021.1 make: Fatal error: Command failed for target $ORACLE_HOME/precomp/lib/proc
Note 1471229.1 Installation of Oracle 11gR2 fails while checking for runlevel
Note 1477327.1 ROOT.SH Errors with mkdir: "/usr/local/bin": Read-only file system Solaris Container
Note 1446945.1 ld: warning: symbol `_start' has differing types: While Installing Or Patching 11gR2 On Oracle Solaris Platform
Note 1521751.1 11.2.0.3 Installation On Solaris Fails During Prerequisite Checks Reporting STATUS=OPERATION_FAILED
Note 1539888.1 PRVF-7530 Error During Oracle 11.2.0.3 Installation on Solaris
Note 1551669.1 11.2.0.3 installation fails with : /usr/ccs/bin/as: not found [No such file or directory] on Solaris 11 or Solaris 10

Linux

General

ORACLE Validated Configurations
Note 1307056.1 Certification Information for Oracle Database on Linux x86
Note 1304727.1 Certification Information for Oracle Database on Linux x86-64
Note 851598.1 Master Note of Linux OS Requirements for Database Server
Note 376183.1 Defining a "default RPMs" installation of the RHEL OS
Note 386391.1 Defining a "default RPMs" installation of the SLES OS
Note 401167.1 Defining a "default RPMs" installation of the Oracle Enterprise Linux (OEL) OS
Note 728346.1 Linux OS Installation with Reduced Set of Packages for Running Oracle Database Server
Note 1508516.1 Is It Mandatory To Install UEK Kernel Under RHEL?
Note 266043.1 Support of Linux and Oracle Products on Linux
Note 787705.1 How to identify correct Oracle Database software to install on Linux platform
Note 1075717.1 Installing 32-bit RDBMS Client software on x86_64 Linux.
Note 1315914.1 Install 11gr2 On Sles11 - Packages Required Not Mentioned In Installation Guide
Note 1350000.1 Database Client or Database Server Install on Red Hat 6 (RHEL6)
Note 444084.1 Multiple gcc / g++ Versions in Linux
Note 567506.1 Maximum SHMMAX values for Linux x86 and x86-64
Note 761261.1 Recommended metalink articles for Oracle Database 10gR2 installation on zLinux (s390x)
Note 415182.1 DB Install Requirements Quick Reference - zSeries based Linux
Note 341507.1 Oracle Database Server on Linux on IBM POWER
Note 786995.1 Troubleshooting The Relink Errors When Missing RPMs on Linux x86-64
Note 377217.1 What should the value of LD_ASSUME_KERNEL be set to for Linux?

Known Issues On Linux

Note 308788.1 While Installing Oracle Database on SUSE SLESx x86-64 Linking Errors Occur and NetCA/DBCA Fail With Error: UnsatisfiedLinkError exception loading native library: njni10
Note 317627.1 Error in invoking target 'agent emsubagent nmo nmb' of makefile '$ORACLE_HOME/sysman/lib/ins_sysman.mk'
Note 468977.1 UnsatisfiedLinkError exception loading native library: njni11
Note 1063952.1 11gR2 Database Server install fails with [INS-13001] Environment does not meet minimum requirements
Note 1220843.1 Getting __stack_chk_fail@GLIBC_2.4 makefile errors during Oracle 11.2 Install on Linux
Note 1313504.1 Error in invoking 'ntcontab.o' of makefile while installaing 11gr2 client on Linux x86-64 bit server
Note 1073332.1 /usr/bin/ld: Cannot Find -lxml11, Genclntsh: Failed To Link libclntsh.so.11.1
Note 460969.1 /usr/bin/ld: Cannot Find -lxml10, Genclntsh: Failed To Link Libclntsh.so.10.1
Note 443617.1 "Exception java.lang.UnsatisfiedLinkError: ../jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred" on RHEL5/OEL5 for 10.2 x86 or x86_64 install
Note 301830.1 Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device
Note 454196.1 ./sqlplus: error on libnnz11.so: cannot restore segment prot after reloc
Note 1454982.1 Installing 11.2.0.3 32-bit (x86) or 64-bit (x86-64) on RHEL6 Reports That Packages "elfutils-libelf-devel-0.97" and "pdksh-5.2.14" are missing (PRVF-7532)
Note 1543787.1 11.2.0.3 Installation failed on RHEL 6 with the error libraries: libmpfr.so.1: cannot open shared object file: No such file or directory
Note 1569369.1 libXi.so.6: cannot open shared object file: No such file or directory

AIX

General

Note 1307544.1 Certification Information for Oracle Database on IBM AIX on Power systems
Note 889464.1 Is Oracle 10g And 11g Database Compatible With AIX Version 6.1
Note 417451.1 How To Determine Whether an APAR has been Fixed in AIX Version/Maintenance Level
Note 739963.1 Using AIX commands genld, genkld and slibclean to avoid library file locking errors(libjox)
Note 458403.1 Why AIXTHREAD_SCOPE should be set to 'S' on AIX
Note 201622.1 Is It Still NecessaryTto Run the Rootpre.sh Script When Installing Oracle on AIX 5L and above?
Note 753601.1 SUPPORT FOR ORACLE DATABASE ON WPARS UNDER AIX 6.1
Note 1524569.1 Is IBM AIX Active Memory Expansion (AME) Certified or supported for Oracle Databases?

Known Issues On AIX

Note 832074.1 AIX 6.1 "Dependent module /usr/lib/libXpm.a(shr_64.o) could not be loaded" Error Attempting To Execute 11.1.0 runInstaller
Note 879102.1 Stand Alone 11.1.0.6 Silent Installation on AIX 5.3 Fails On Prerequisite Check For rsct.basic.rte(0.0) and rsct.compat.clients.rte(0.0)
Note 1439940.1 11gR2 OUI On AIX Pre-Requisite Check Gives Error "Patch IZ97457, IZ89165 Are Missing"
Note 980602.1 The Installer (OUI) Detects Processes Running on ORACLE_HOME on AIX 6.1 TL04 SP1
Note 985563.1 AIX: ERROR IN INVOKING TARGET 'LINKS PROC GEN_PCSCFG' OF MAKEFILE, ld: 0711-593 SEVERE ERROR: Symbol C_BSTAT
Note 1327608.1 INS-13001 Environment does not meet minimum requirements when installing 11.2.0.2 on AIX 7.1
Note 859842.1 Database Server Installation on AIX 6.1 Error: OUI-18001: 'AIX Version 6100.01' is not supported
Note 1364239.1 runInstaller Failed With "OUI: 0403-006 Execute permission denied" While Installing 11.2.0.x On AIX
Note 1506934.1 Oracle 11gR2 Install : Executing rootpre.sh fails with the error cldomain: file not found
Note 1525845.1 11gR2 Install fails with error OUI-10164:The Ownership For The File GeneralQueries.jar Could Not Be Changed To .

HP

General

Note 1307026.1 Certification Information for Oracle Database on HP-UX PA-RISC Platform
Note 1307745.1 Oracle Database Support on the Itanium Processor Architecture

Known Issues on HP

Note 1183545.1 OUI 10.2.0.4 and OUI 10.2.0.5 raise OUI-15038 "Unable to execute rule 'CheckCompatibility' .. [For input string: "11_11"]
Note 471476.1 32 Bit Libraries Are Not Installed With Oracle11g (11.1.0.6) On HP-UX Itanium
Note 287428.1 Oracle Universal Installer has detected that there are processes running in the currently selected
Note 819394.1 HP-UX: Sqlplus: ORA-12549: TNS:operating system resource quota exceeded
Note 1194973.1 Failure On Prerequisite Checks For 11gR2 Installation on HP-UX
Note 552358.1 Installation Of Oracle 10.2 Client Fails On HPUX Itanium Servers With Montecito Processors

WINDOWS

General

Note 1529702.1 FAQ: Oracle Database 12.1 Oracle Home User On Windows
Note 1307189.1 Certification Information for Oracle Database on Microsoft Windows x86 (32-bit)
Note 1307195.1 Certification Information for Oracle Database on Microsoft Windows
Note 952302.1 Is Microsoft Windows 7 certified to install/run Oracle Database Server/Client ?
Note 443813.1 Check List For Oracle On Windows.
Note 436299.1 Common reasons for OUI failures on the MS Windows platforms
Note 161549.1 Oracle Database Server and Networking Patches for Microsoft Platforms
Note 816893.1 How to Recreate the Windows Registry for Oracle, After reloading the Windows OS
Note 432713.1 How To Create a Service using oradim in Windows Vista
Note 1449665.1 How To Disable/Enable A Specific Component From A 11.1.0.7 Database Home On Windows Platforms
Note 870253.1 32-bit Client Install on 64-bit Windows Platform
Note 1151394.1 Running 32-bit and 64-bit Oracle Software On 64-bit Windows
Note 208256.1 WIN: How to Remove a Single ORACLE_HOME and Its Traces on Microsoft Windows Platforms
Note 124353.1 Manually Removing all Oracle Components on Microsoft Windows Platforms
Note 1069034.1 11.2: How to Manually Remove Oracle Server Software on Microsoft Windows Platforms
Note 1433144.1 What Is The Windows Service "Oracleremexecservice" ?

Known Issues on Windows

Note 1292921.1 While Installing 11.2, OUI Fails With "Error in starting the service. The service OracleMTSRecoveryService was not found"
Note 221545.1 Oracle Installation Issues in Windows Platforms
Note 418479.1 file in use Errors, when applying patches on Windows
Note 271569.1 Database creation using DBCA on WIN 2003 PDC fails with DIM-19
Note 334528.1 ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit
Note 1133495.1 Installation of 11gR2 on Windows Fails Checking Requirements
Note 1088324.1 11gR2 Deinstall fails on Windows 7
Note 1468882.1 Oracle Universal Installer Hangs While Installing Oracle 11g Client/Database On Windows
Note 958591.1 Oracle Install Crashed With Java Error in Windows Environment
Note 1530206.1 Cannot Install Oracle Client 11.2 64 Bit And Oracle Client 32 Bit On Same Windows 64 Bit Server
Note 1569064.1 Oracle Database 12.1 Installation on Windows Errors out with Missing File dr0ulib.sql.sbs

Scripts

Note.189256.1 UNIX Script to Verify Installation Requirements for Oracle 8.0.5 to 9.2 versions of RDBMS
Note 250262.1 RDA 4 - Health Check / Validation Engine Guide (Doc ID 250262.1)

Silent Install

General Information
Note 136660.1 Working Response files for a silent install of Oracle Server on MS-Windows- Part 1 of 3
Note 136661.1 Database Configuration Response file for performing silent install - Part 2 of 3
Note 136662.1 Network Configuration Reponse file for performing silent install - Part 3 of 3
Note 388451.1 How to create a Response File for Silent Installation?
Note 434315.1 How Can You Install Oracle Without Using The Oracle Universal Installer( runInstaller) GUI and Xserver especially When Doing A Remote Installation ?
Note 405124.1 How to Prevent a Silent Install from Prompting for User Input to Run the 'root.sh' Script
Note 885643.1 How To Install 11.2/12.1 Database/Client Software In Silent Mode Without Using Response File
Note 808275.1 How to install Oracle Database Patchset software in Silent mode without using response file
Note 782919.1 How to install Oracle Database Server software silently with customized listener configuration
Note 885643.1 How to install 11gR2 Database/Client Software in Silent mode without using response file
Note 782918.1 How to install/deinstall Oracle Database Server software silently without response file
Note 782923.1 How to install/deinstall Oracle Database Client software silently without response file
Note 435680.1 Response File Installation of Database Server 10.2 (Suppressed or Silent mode)

Known Issues
Note 1550832.1 Oracle Database 12.1 Silent Install Report Error With Null,null,null

Deinstall/Removing Installations

General Information

Note 208116.1 How to remove all traces of ORACLE_HOME on UNIX
Note 275493.1 Removing 10g Database and Software from AIX, HP-UX, Linux, Sun and Tru64 Platforms
Note 1363753.1 Behaviour of the Oracle De-install/Deinstall/Uninstall Utility in 11gR2
Note 886749.1 Oracle 11gR2 Deinstall And Deconfig Tool Options
Note 883743.1 How To Deinstall/Uninstall Oracle Home In 11gR2 
Note 1070610.1 How To De-install Oracle Home Using runinstaller
Note 435219.1 How To Clean Up The Inventory After Deleting The Oracle Home Manualy Using OS Commands("rm-rf " or other)?
Note 888934.1 Is it possible to deinstall/remove a specific component from already installed Oracle Database Home using OUI?
Note 1271072.1 Is it possible to deinstall/disable a specific licensable option from already installed Oracle Database 11gR2 Home ?

Known Problems

Note 885609.1 11gR2 OUI warning: Please run the command '/deinstall/deinstall' to deinstall this OracleHome
Note 1069028.1 Deinstall utility on 11.2 removes multiple ORACLE_HOMEs 
Note 1271661.1 Deinstall 11.2 32-bit Home Inadvertanly Removes 64-bit Homes and Vice Versa
Note 1067622.1 11.2 DEINSTALLER REMOVING LISTENERS RUNNING FROM OTHER ORACLE_HOMES
Note 1322509.1 11.2 Database Corrupted After Use of $ORACLE_HOME/deinstall/deinstall Script
Note 753929.1 Errors During Silent 11.1.0.6 Deinstallation
Note 1128464.1 Uninstall Of Oracle 11gR2 Home On Windows Does Not Recognize Non-English Response
Note 1374044.1 When deinstalling 11gR1 ,OUI greyed out the Remove button and getting message - You cannot deinstall at this time.
Note 1519494.1 The deinstall tool cannot determine the home type needed to deconfigure the selected home

Diagnostic Tools

Note 780551.1 How To Diagnose Linking Errors During Base Install of Oracle RDBMS
Note 757964.1 Oracle Universal Installer ( OUI ) Error Messages and Solution Reference List
Note 1812.1 TECH: Getting a Stack Trace from a CORE file

General Information

Note.738771.1 How to Log Good Service Request for Relink issues?
Note.736819.1 How to Log Good Service Request for Oracle Universal Installer (OUI) issues?

Using My Oracle Support Effectively

Note 166650.1 Working Effectively With Global Customer Support
Note 199389.1 Escalating Service Requests with Oracle Support Services

Generic Links

Note 1351051.1 Information Center: Install and Configure Database Server/Client Installations
Note 1476075.1 FAQ: Downloading 9i, 10g, and 11g database software media
Note 549617.1 How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 268895.1 Oracle Database Server Patchset Information, Versions: 8.1. 7 to 11.2.0
Note 783141.1 Reference List of Critical Patch Update Availability(CPU) and Patch Set Update (PSU) Documents For Oracle Database and Fusion Middleware Product
Note 1119703.1 Database PSU-CPU Cross-Reference List
Note 854428.1 Patch Set Updates for Oracle Products
Note 1061295.1 Patch Set Updates - One-off Patch Conflict Resolution
Information on Security Patch Updates (SPU's)

Master Note For OPatch (Doc ID 293369.1)

  Document

Purpose
Scope
Details
 Ask Questions, Get Help, And Share Your Experiences With This Article
 Please download the latest OPatch version from My Oracle Support (MOS) using the next reference:
 
 OPatch User Guides
 General
 How To
 Diagnostic Tools For OPatch
 Known Issues
 With Inventory
 With Java
 With Pre-Patching
 With Linking
 With Post-Patching
 With SQLPatching (datapatch)
 Miscellaneous
 Windows Specific
 Using My Oracle Support Effectively
 Generic Links
 Fusion Middle Ware
 
References

APPLIES TO:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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.

 

Please download the latest OPatch version from My Oracle Support (MOS) using the next reference:

Patch 6880880

Or using the next URL:

https://updates.oracle.com/download/6880880.html

 

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)

Note 2232156.1 OPatch: Behavior Changes starting in OPatch 12.2.0.1.9 and 11.2.0.3.16 releases

Note 2161861.1 OPatch: Behavior Changes starting in OPatch 12.2.0.1.5 and 11.2.0.3.14 releases

How To

Note 274526.1 How To Download And Install The Latest OPatch Version
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 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 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
Note 2039927.1 Source file <directory path>/<file> does not exists or is not readable

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 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 166650.1 Working Effectively With Global Customer Support

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

Fusion Middle Ware

Note 1587524.1 Using OPatch 13.1 for Oracle Fusion Middleware 12c (12.1.2+)
Note 1591487.1 Using OPatch 11.1 for Oracle Fusion Middleware 11g (11.1.1/11.1.2)
Note 283367.1 OPatch for Oracle Application Server 10g (10.1.2, 10.1.3, 10.1.4)

Information on Security Patch Updates (SPU's)

ORAPKI commands, oracle wallets ,OHS certificate import export update

ORAPKI commands, oracle wallets ,OHS certificate import export update Oracel wallets are used to store SSL certificates for producst as OID, OVD, OHS, think of it a combination of Keystore and Truststore which stores both Identity(termed 'User certificate') and Trust certificates . ORAPKI is the utility provided by oracle to manage public key infrastructure (PKI) elements, such as wallets , on the command line. this is available under MIDDLEWARE_HOME/ oracle_common/ bin path. **The other way will be to use EM console for OID or OVD, or to use Oracel Wallet Manager tool(OWM) , I'll have to check it after this** SSL for OID and SSL for OVD. The syntax for orapki is : orapki module command -parameter value module will be the object you're working with : wallet (Oracle wallet), crl (certificate revocation list), or cert (PKI digital certificate). Display a wallet : ./orapki wallet display -wallet /app/Oracle/Middleware/wallet-wam.xxx.com-2017 This will give you an update such as : User Certificates: Subject: CN=XXX.XXX.com,OU=TRC,O=XXX.,L=,ST=LA,C=IT Trusted Certificates: Subject: OU=Class 1 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US Subject: CN=XXX-SUBCA,DC=xxxnet,DC=xxx,DC=intranet Display a certificate : orapki cert display -cert certificate_location -summary(for brief info) | -complete Export a cert from a wallet : orapki wallet export -wallet wallet_location -dn certificate_dn -cert certificate_filename. ./orapki wallet export -wallet /apps/Oracle/Middleware/wallet-abc.xxx.com -dn "CN=XXX-SUBCA,DC=xxxnet,DC=xxx,DC=intranet"-cert /apps/Oracle/Middleware/NEW_CERTNAME.cer ERRORS : PKI-04006 : No matching private key in the wallet. Cause: Attempted to install a user certificate, but no matching private key was found in the wallet. Action: Make sure that the user certificate is being installed to the wallet where the certificate request was created. We can not export a user certificate and add it to another wallet since the certification request was not generated from the second wallet. PKI-02008 : Unable to modify a read-only Auto-login wallet. Cause: Attempted to update a read-only Auto-login wallet. Action: Specify the associated Password-protected wallet. For this error, you'll have to use the -pwd option with the password in the add command itself, if you don't , you'll be prompted to enter the password but it'll not work. If you don't already have a wallet, or just wanna create a new one : STEP 1 : Create a wallet : ./orapki wallet create -wallet /apps/Oracle/Middleware/wallet-abc.xxx.com/ -pwd xxx123 -auto_login This command creates a wallet with auto-login enabled, or it can also be used to enable auto-login on an existing wallet. If the wallet_location already contains a wallet, then auto-login will be enabled for it. To disable the auto-login feature, delete cwallet.sso. STEP 2 : Add a certificate request to an Oracle wallet : orapki wallet add -wallet wallet_location -dn user_dn -keySize 512|1024|2048 ./orapki wallet add -wallet /apps/Oracle/Middleware/wallet-wam.xxx.com-2017/ -dn "CN=abc.xxx.com,OU=ICT,O=xxx S.p.A.,L=San Donato Milanese,ST=Milano,C=IT" -pwd ***123 -keysize 2048 -validity 1024 STEP 3 : Export the certificate request and share it with you CA to generate a certificate : orapki wallet export -wallet wallet_location -dn certificate_request_dn -request certificate_request_filename ./orapki wallet export -wallet /apps/Oracle/Middleware/wallet-wam.xxx.com-2017/ -dn "CN=wam.xxx.com,OU=ICT,O=xxx S.p.A.,L=San Donato Milanese,ST=Milano,C=IT" -request /apps/Oracle/Middleware/wallet-wam.xxx.com-2017/wam.xxx.com.csr To add user certificate : orapki wallet add -wallet wallet_location -user_cert -cert certificate_location ./orapki wallet add -wallet /apps/Oracle/Middleware/wallet-wam.xxx.com-2017/ -user_cert -cert /apps/Oracle/Middleware/wallet-wam.xxx.com-2017/wam.cer -pwd xxx123 To add a trusted certificate to an Oracle wallet : (we must add all the trust certificates before adding an user certificate) orapki wallet add -wallet wallet_location -trusted_cert -cert certificate_location ./orapki wallet add -wallet /apps/Oracle/Middleware/wallet-wam.xxx.com-2017/ -trusted_cert -cert /apps/Oracle/Middleware/wallet-wam.xxx.com-2017/xxx_SUBCA.cer -pwd xxx123 To add a root certificate to an Oracle wallet : orapki wallet add -wallet wallet_location -dn certificate_dn -keySize 512|1024|2048 -self_signed -validity number_of_days Since I was working with OHS , the way to find the wallet is : Go to /Middleware_HOME/Oracle_WT1/instances/instance1/config/OHS/password_host1 open the ssl.conf look for SSLWallet entry , to find the wallet. As always, thanks for reading ! http://bitoshok-das.blogspot.com/2019/07/orapki-commands-oracle-wallets-ohs_24.html http://h2hdba.blogspot.com/2016/11/managing-oracle-wallets-and.html

Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)

  Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...