SAP Note

2660017 - Oracle Database Software Installation on Unix

Component: BC-DB-ORA (Basis Components > Database Interface, Database Platforms > Oracle), Version: 30, Released On: 18.10.2024

Symptom
Oracle Database Software Installation on Unix
This SAP note describes the installation of Oracle Database software (Oracle Homes) on Unix in an SAP environment.
Applies to Unix platforms (AIX, HPUX, Linux, Solaris).
Does NOT apply to Engineered Systems (Exadata, ExaCS, ExaCC, ODA). See SAP note 2992680 for Engineered Systems.
Applies to Oracle Database 19c
Applies to Oracle Database 18c
For Oracle Database 12c see SAP note 1915301.
For Oracle Database 11g see SAP note 1524205.
News

2024-10-18 - Installation procedure from SAP Note 3296921 not restricted to OL9 / RHEL9
2024-Jul-09 - SAP RUNINSTALLER 19-031 available (see SAP Note 3296921)
2022-Mar-09 - Using '-invLoc <path>' and '-invPtrLoc <path>' option
2021-Jan-08 - Cloning an Oracle Database Home see SAP Note 3009807
2020-Dec-15 - SAP RUNINSTALLER 19-026 released: new option '-no_empty_dir_check'
2020-Nov-26 - Does NOT apply to Engineered Systems (Exadata, ExaCS, ExaCC, ODA).
2020-Nov-20 - SAP RUNINSTALLER only for on-prem and non-Oracle Engineered Systems
2020-Jul-21 - SAP RUNINSTALLER 19-024 available
2020-May-28 - Installation on Red Hat Enterprise Linux 8 and Oracle Linux 8
2020-Apr-02 - Installation Oracle Home path <IHRDBMS> must not contain symbolic links (symlink, softlink)
2020-Feb-12 - SAP RUNINSTALLER 19-018 available
2019-Nov-22 - 19c SLES15: Oracle Installer Bug 29742223: prereq check for libstdc++33
2019-Oct-10 - 19c SLES12: Oracle Installer Bug 29742223: prereq check for libstdc++33
2019-Aug-23 - rootpre.sh update #2 (AIX)
2019-Aug-13 - rootpre.sh update #1 (AIX)
2019-Jul-04 - updated for Oracle Database 19c
2019-Mar-01 - Released for Oracle Database 18c

Other Terms
RUNINSTALLER, runInstaller
Oracle Universal Installer, Oracle Database Setup Wizard
Oracle home, Installation Oracle Home (IHRDBMS), Runtime Oracle Home (OHRDBMS)
 Reason and Prerequisites
Prerequisites
Applies to Unix platforms (AIX, HPUX, Linux, Solaris).
Does NOT apply to Engineered Systems (Exadata, ExaCS, ExaCC, ODA).
Applies to Oracle Database 19c
Applies to Oracle Database 18c
Installation Concept
Starting Oracle Database Release 11.2, SAP introduced the installation concept for Oracle database homes with "Installation Oracle home" and "Runtime Oracle home".
"Installation Oracle Home" (IHRDBMS) denotes the path where the Oracle home is installed. This path is used for installation and patching of the Oracle home.
"Runtime Oracle home" denotes the path from which Oracle database instances are run. This path is set in the ORACLE_HOME environment variable.
With this approach environment variable ORACLE_HOME and other dependent environment variables like PATH remain unchanged when a new Oracle home of a higher patch set release or with a higher
patch level (minimal downtime patching) was installed. For more information, see SAP Note 1524205.
Use of Symbolic Links for <IHRDBMS>
Starting 19c, the path of Installation Oracle Home <IHRDBMS> must not contain symbolic links (symlinks, softlinks). For more information, see SAP Note 2604854.

Signifier Description

"Runtime Oracle Home" OHRDBMS Oracle Home path; used for runtime; value of env. var. $ORACLE_HOME; symbolic link points to IHRDBMS

"Installation Oracle Home" IHRDBMS Oracle Home path; used for installation (software management)

SAP Default Values for OHRDBMS / IHRDBMS

The following table contains the SAP default values for OHRDBMS / IHRDBMS for non-shared Oracle homes.

Release 19c Release 18c Release 12.2.0.1 Release 12.1.0.2 Release 11.2.0.4

OHRDBMS /oracle/<DBSID>/19 /oracle/<DBSID>/18 /oracle/<DBSID>/122 /oracle/<DBSID>/121 /oracle/<DBSID>/112_64

IHRDBMS /oracle/<DBSID>/19.0.0 /oracle/<DBSID>/18.0.0 /oracle/<DBSID>/12201 /oracle/<DBSID>/12102 /oracle/<DBSID>/11204

Advantages of this Approach

Environment variables PATH and ORACLE_HOME remain unchanged when you install new Oracle home of the same release e.g. for applying a new SAP Bundle Patch (SBP).
Environment variables OHRDBMS and IHRDBMS are temporarily set when Oracle homes are managed e.g. applying an SBP or installing a new Oracle home.
Notation
The following notation is used in this note:

Term Description Default Value

<DBNAME> name of the SAP database (upper case) -

<DBSID> / <dbsid> name of the SAP database (upper case / lower case) $DB_SID

<ORACLE_SID> name of the Oracle database instance SI: $DB_SID, RAC: ${DB_SID}001, ${DB_SID}002
 <IHRDBMS> Installation Oracle home = location where Oracle Database software is extracted. /oracle/<DBSID>/<YY>.0.0, see above

<OHRDBMS> Runtime Oracle home = value of $ORACLE_HOME /oracle/<DBSID>/<YY>, see above

<ora_swo> Oracle Software Owner ('oracle' or ora<dbsid>) depends on user concept

<ora_sapdvd> Mount point / Location of SAP DVD containing Oracle Database software -

<ora_image_file> Name of Oracle home image file containing the Oracle Database software <platform>_<release>_db_home.zip

Solution
New with 19c
New with 18c
Installing Oracle Database Software
Installing Oracle Database Software with SAP RUNINSTALLER
Installing SAP Bundle Patch with MOPatch
Installing Oracle Database Software Advanced Options
Removing Oracle Database Software
Cloning an Oracle Database Home
Appendix
A - About SAP RUNINSTALLER
B - Troubleshooting Oracle Database Software Installation
C - Installing Oracle Database Software Manually

New with 19c

Root Script Automation (Unix)
Starting 19c, you can specify root or sudo credentials to execute root scripts in Oracle installer.
For root script automation with sudo, run RUNINSTALLER as
OS> <path>/RUNINSTALLER -rsa sudo -rsasudouser <sudousername> [-rsasudopath <sudopath>]
For root script automation with root, run RUNINSTALLER as
OS> <path>/RUNINSTALLER -rsa root -rsarootuser <rootusername>
New with 18c
Simplified Image-based Oracle Database Installation
Starting Oracle Database 18c, the Oracle Database software is available as an image file for download and installation. You must extract the image software into the directory where you want your Oracle
home to be located, and then run the runInstaller script to start the Oracle Database installation. For more information, see 'Changes in this Release for Oracle Database' and 'Image-Based Oracle Database
Installation'.
New SAP DVD Structure
Starting Oracle Database 18c, the SAP DVD contains Oracle database software as compressed Oracle Home Image file (zip file, tool to extract: unzip). For releases 12.2 or earlier, the SAP DVD contains
Oracle database software as compressed Oracle stage directory (SAR file, tool to extract: SAPCAR).
New SAP RUNINSTALLER
SAP RUNINSTALLER extracts the Oracle home image file and starts the Oracle Database Setup Wizard (runInstaller) to configure and register the new Oracle home.
Unzip Utility
In order to extract the Oracle home image file and SAP Bundle Patch files (SBPs), unzip utility version 6.00 or later is required. For more information, see SAP Note 2599248.
Unzip utility is required to extract the image files of Oracle Database and Oracle Grid Infrastructure. For more information, see here Oracle Database Installation Guide, Installation Requirements:
AIX (18c): https://docs.oracle.com/en/database/oracle/oracle-database/18/axdbi/installation-requirements-for-programming-environments-for-ibm-aix.html
AIX (19c): https://docs.oracle.com/en/database/oracle/oracle-database/19/axdbi/installation-requirements-for-programming-environments-for-ibm-aix.html
HP-UX (18c): https://docs.oracle.com/en/database/oracle/oracle-database/18/hpdbi/installation-requirements-for-programming-environments-for-hp-ux-itanium-systems.html
HP-UX (19c): https://docs.oracle.com/en/database/oracle/oracle-database/19/hpdbi/installation-requirements-for-programming-environments-for-hp-ux-itanium-systems.html
Oracle Database Setup Wizard
The name of the tool that installs Oracle Database Software has been changed from 'Oracle Universal Installer' to 'Oracle Database Setup Wizard'. Starting Oracle Database 18c, you run the 'Oracle Database
Setup Wizard' to install the Oracle Database Software. In earlier releases, the name of this tool was 'Oracle Universal Installer (OUI)'.
Read-Only Oracle Homes
Starting Oracle Database 18c, you can configure an Oracle home in read-only mode. Read-Only Oracle Homes are currently (18c, 19c) not yet supported for SAP environments.
For more information, see Oracle Database Installation Guide, Configuring Read-Only Oracle Homes.

Installing Oracle Database Software

Installation Prerequisites
Starting Oracle Database 18c, the Oracle Database software is available as an image file. In order to extract the image file, you must have a valid unzip utility installed in the OS. If there is no 'unzip' installed,
ask your OS vendor. You should not use the unzip utility that is installed in Oracle homes of previous Oracle releases.
AIX only:
If this is the first time you install Oracle Database software on IBM AIX on Power Systems (64-Bit), then you must run rootpre.sh. For more information about running rootpre.sh, see below.
Installation Recommendations
SAP recommends to use user concept 'Oracle Standard' as 'SAP Classic' is deprecated since release 12.1. For more information, see SAP Note 1915323.
Installation Requirements
After the installation of the Oracle database software you must install the current SAP Bundle Patch (SBP). The current SBP contains important patches that are strongly recommended or required for SAP.
For more information, see below 'Installing SAP Bundle Patch with MOPatch'.
Installing Oracle Database Software with SAP RUNINSTALLER
To install a new Oracle Database Oracle Home on your database server you use SAP RUNSTALLER to ensure that the new Oracle home is installed and configured according to SAP standards.
Prerequisites

You can use Oracle Database Software (Oracle Home Gold Image) from SAP DVDs and SAP RUNINSTALLER to install a new Oracle home if the following prerequisites are met:
Oracle Single instance or Oracle RAC
SAP database on premise
 SAP database on Non-Oracle Engineered System
For Oracle Engineered Systems you must use the corresponding tool to download the database software and install a new database Oracle home:
On Exadata on premise (bare metal and virtual): dcli/oedacli, see SAP Note 1590515
On Exadata Cloud Service (ExaCS): dbaascli, see SAP Note 2614028
On Exadata Cloud Service (ExaCC): dbaascli, see SAP Note 2956661
Software Download
1. Go to SAP Support Portal -> Software Downloads -> Databases -> Oracle -> Oracle <release> Software.
2. Open the folder for your platform and download the Oracle Database software (SAP DVD) to your database server.
Preparation
1. Log on as Oracle software owner
2. Backup the Oracle central inventory before you install a new Oracle home (recommended).
3. Go to Oracle Database software location <ORA_SAPDVD>/<PLATFORM>/db_home/SAP
4. Set environment variable DB_SID.
5. Set environment variable DISPLAY (only for non-silent installation)
OS> id; pwd;
OS> cd <ORA_SAPDVD>/<PLATFORM>/db_home/SAP
OS> pwd
OS> echo "DB_SID=$DB_SID"
OS> echo "DISPLAY=$DISPLAY"
Installation of Oracle Database 19c according to SAP Note 3296921
When you install Oracle Database 19c (19.3 base release) on an new operating system version that is unknown to the Oracle installer (e.g. OL 9 or RHEL 9), you will get the following error:
[WARNING] [INS-08101] Unexpected error while executing the action at state:'supportedOSCheck'
CAUSE: No additional information available.
ACTION: Contact Oracle Support Services or refer to the software manual.
SUMMARY:
- java.lang.NullPointerException
SAP Note 3296921 describes a (workaround) procedure that uses the '-applyRU' option that avoids this error .
For new OS versions like Oracle Linux 9 (OL 9) or Red Hat Enterprise Linux (RHEL 9) you must follow the procedure from SAP Note 3296921.
However, the procedure is not restricted to Linux as operating system, not restricted to OL 9 or RHEL 9, and not restricted to new, unknown OS versions. The procedure can also be used to install Oracle
Database 19c on known OS versions of any Unix platform (AIX, HP-UX, Linux, Solaris). For more information see SAP Note 3296921.
Installation of Oracle Database 19c on RHEL 9 / OL9
SAP RUNINSTALLER 19-031 or higher checks setting of environment variable CV_ASSUME_DISTID.
For installation of Oracle Database 19c on RHEL 9 or OL 9, follow instructions of SAP Note 3296921.
Installation of Oracle Database 19c on RHEL 8 / OL8
Only for installation of Oracle Database 19c on Linux versions Red Hat Enterprise Linux 8 / Oracle Linux 8:
Set environment variable CV_ASSUME_DISTID = OL7

OS> setenv CV_ASSUME_DISTID OL7 C shell

OS> export CV_ASSUME_DISTID=OL7 Bourne shell / Bash

OS> echo "CV_ASSUME_DISTID=$CV_ASSUME_DISTID" Verification


For more information, see SAP Note 1915299 (Oracle Bug 30286976) and SAP Note 2936683.
Checking RUNINSTALLER Options
For help on SAP RUNINSTALLER, you can run:
OS> ./RUNINSTALLER -help
RUNINSTALLER Options '-invPtrLoc <path>' and '-invLoc <path>'
These options are only needed in special situations, when you install an Oracle home without registering this Oracle home in the default central inventory of the host.
The 'invPtrLoc' option can be used to specify the location of the Oracle Inventory Pointer file oraInst.loc.
This option has been removed from SAP RUNINSTALLER (19-024) because the Oracle runInstaller does not support '-invPtrLoc <path>' option any more. For more information, SAP Note 1915299.
The 'invLoc' option can be used to specify the location of the Oracle central inventory without Oracle inventory pointer file. Instead, it uses the response file parameter 'INVENTORY_LOCATION=<path>'.
This option is (still) supported by SAP RUNINSTALLER. In order to use this option, please note the following requirements:
Check /etc/oraInst.loc and /var/opt/oracle/oraInst.loc. Make sure that no Oracle inventory pointer file exists in these default locations. Otherwise the inventory pointer file has priority over '-invLoc'
option.
Do not use '-invPtrLoc' option at the same time when you use '-invLoc <path>' option.
Installing a New Oracle Home in One Run
To install the new Oracle home in one step, run the following command:
OS> ./RUNINSTALLER [-ohinstall] [-silent] [<options>]
This command will extract the Oracle home image file into the new Oracle home, then register the new Oracle home and finally configure the new Oracle home.
AIX only:
Oracle Database Setup Wizard prompts you:
Has 'rootpre.sh' been run by root? [y/n] (n)

If this is the first time you install Oracle Database software on IBM AIX on Power Systems (64-Bit), then you must run rootpre.sh before you continue. For more information about running rootpre.sh,
see below.
Oracle Database Setup Wizard Dialog
The following table shows Oracle Database Installer screens in a typical, SAP standard installation scenario for Unix platforms:

Step Step Name What you should see

1 Configuration Option Set Up Software Only

2 Database Installation Options  ingle Instance database installation for SI

S
Oracle Real Application Clusters database installation for RAC

3 Database Edition Enterprise Edition

4 Installation Location Oracle base: /oracle/<DBSID>

5 Operating System Groups OSOPER: oper

OSBACKUPDBA: oper
All other groups: dba

6 Prerequisite Checks Checks OS prerequisites. Make sure that all prerequisites are met.
 7 Summary Review installation settings, then click on 'Install' to register Oracle Home.

8 Install Product Monitor installation progress. When prompted, run root scripts orainstRoot.sh and/or root.sh as root.

<ORACLE_INVENTORY>/orainstRoot.sh configures Oracle Inventory pointer file oraInst.loc.

<ORACLE_HOME>/root.sh configures file permissions in <ORACLE_HOME>.

Answer the question "Do you want to setup Oracle Trace File Analyzer (TFA) now ?" with 'NO'.

9 Finish " The registration of Oracle Database was successful" indicates that the installation was successful.
Click 'Close' to exit from Oracle Database 18c Installer.

Registering a New Oracle Home without Extracting the Oracle Home Image File
The Oracle Home Image file has already been extracted successfully, but the Oracle Home is not yet registered. When you now run './RUNINSTALLER' without additional arguments, you will receive the
following error:
( ERROR ) - Oracle home directory is not empty - cannot extract.
(ERROR ) - Cannot extract Oracle home image file into Oracle home directory that is not empty.
(INFO ) - Option #1: skip extraction and continue with registration of Oracle home
(INFO ) - Rerun with option '-ohregister -ohsapcfg' to skip this step and continue the installation.
(INFO ) - Option #2: remove Oracle home directory, then rerun.
To continue the installation, you need to skip the extraction of the Oracle home image file using the following command:
OS> ./RUNINSTALLER -ohregister -ohsapcfg
Registering a New Oracle Home
Scenario: SAP System Copy or SAP System Rename
When you perform an SAP System Copy or SAP System Rename, the source Oracle home is cloned or renamed to the new target Oracle home. To finalize the installation of the Oracle home, you need to
register the Oracle home as follows:
1. Log on as oracle
2. Go to target Oracle home
OS> cd <ORACLE_HOME>
3. Set environment for RUNINSTALLER
OS> setenv DB_SID <DBSID>
OS> setenv DISPLAY <DISPLAY>
4. Run RUNINSTALLER to check:
OS> ./RUNINSTALLER -ohregister -ohsapcfg -q
5. Run RUNINSTALLER to register the Oracle home
OS> ./RUNINSTALLER -ohregister -ohsapcfg
6. Verify that the Oracle home is registered in the central inventory
OS> ./OPatch/opatch lsinventory
Note: if the SAP RUNINSTALLER script '<ORACLE_HOME>/RUNINSTALLER' does not exist, you need to run the Oracle Database Setup Wizard '<ORACLE_HOME>/runInstaller' to register the Oracle
home.
Performing Standalone Prerequisite Checks
In order to check the installation prerequisites without registration and configuration of the Oracle home, you must run the following separate steps:
 OS> ./RUNINSTALLER -ohextract # Step 1: Extract Oracle Home Image file
OS> ./RUNINSTALLER -ohcheck # Step 2: Check Installation Prerequisites
In order to complete the installation, run the following command:
OS> ./RUNINSTALLER -ohregister -ohsapcfg # Step 3: Register and configure the Oracle home
Installing a New Oracle Home Step-By-Step
To install the new Oracle home step-by-step, run the following commands:
OS> ./RUNINSTALLER -ohprepare
OS> ./RUNINSTALLER -ohverify
OS> ./RUNINSTALLER -ohextract
OS> ./RUNINSTALLER -ohcheck
OS> ./RUNINSTALLER -ohregister
OS> ./RUNINSTALLER -ohsapcfg
With these commands you install the new Oracle home step-by-step. For more information, run 'RUNINSTALLER -help'.
Installing a New Oracle Home in a RAC Environment (Real Application Clusters)
You can use RUNINSTALLER to install a new Oracle home in an RAC environment (custom installations, not on Oracle Engineered Systems like Exadata). After the installation, follow the RAC-specific
post-installation steps mentioned below.
Installing a New Oracle Home on AIX (rootpre.sh)
Reference:
'Database Installation Guide for IBM AIX on POWER Systems (64-Bit)'
https://docs.oracle.com/en/database/oracle/oracle-database/18/axdbi/running-the-rootpre-sh-script.html
https://docs.oracle.com/en/database/oracle/oracle-database/19/axdbi/running-the-rootpre-sh-script.html
Oracle Support Document 201622.1
AIX only: If you start the Oracle installer in interactive mode, you see the following message:
********************************************************************************
Your platform requires the root user to perform certain pre-installation
OS preparation. The root user should run the shell script 'rootpre.sh' before
you proceed with Oracle installation. The rootpre.sh script can be found at:
<ORACLE_HOME>/clone/rootpre.sh
Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.
********************************************************************************
Has 'rootpre.sh' been run by root in this machine? [y/n] (n)
When do you have to run rootpre.sh?
Run the rootpre.sh script only the first time you install Oracle Database on IBM AIX on POWER Systems (64-Bit). You do not have to run the rootpre.sh script on an IBM AIX on POWER Systems (64-Bit)
server that has an Oracle Database software already installed.
Where do you find rootpre.sh?
You find the script at <ORACLE_HOME>/clone/rootpre.sh of the extracted Oracle home.
How can you skip this dialog?
To skip the dialog in the Oracle installer you set SKIP_ROOTPRE=TRUE in the environment before you start the Oracle installer.
How can you run the Oracle installer in silent mode?
If you run the Oracle installer in silent mode without setting SKIP_ROOTPRE, the Oracle installer will hang (Oracle Bug 30258274). Therefore, for silent mode installation, use the following procedure:
1. Make sure that rootpre.sh has been run.
2. Set SKIP_ROOTPRE=TRUE in the environment
3. Start installation
If this is the first time you install Oracle Database on IBM AIX on POWER Systems (64-Bit), you can use the step-by-step installation procedure:
1. Extract the Oracle Home Image File
OS> ./RUNINSTALLER -ohprepare -ohverify -ohextract [-silent]
2. Switch to user root and run rootpre.sh
OS> su - root
OS> <ORACLE_HOME>/clone/rootpre.sh
OS> exit
3. Set SKIP_ROOTPRE
OS> setenv SKIP_ROOTPRE TRUE
OS> export SKIP_ROOTPRE=TRUE
4. Register and Configure Oracle Home
OS> ./RUNINSTALLER -ohregister -ohsapcfg [-silent]
Post-Installation
The new Oracle home is now successfully installed, but the Oracle home is not yet complete and ready-to-use for SAP.
1. Before you can use a new installed Oracle home to create a new SAP database or to upgrade an existing SAP database, you must install the current SAP Bundle Patch (SBP). For more information,
follow the instructions given in the corresponding SBP README.
2. For RAC installations: Check $ORACLE_HOME/install/orabasetab on remote RAC cluster nodes.
For more information, see SAP Note 1521371.
3. For RAC installations: Create <OHRDBMS> runtime Oracle home on remote RAC cluster nodes.
OS> ln -s <IHRDBMS> <OHRDBMS>
Example: OS> ln -s /oracle/$DB_SID/18.0.0 /oracle/$DB_SID/18
Installing SAP Bundle Patch with MOPatch
For SAP you must install an SAP Bundle Patch. In general we recommend to install the latest SBP.
The installation of an SBP consists of 2 steps:
1. Patching the Oracle Home
With MOPatch, you install the SBP into the Oracle Home. This updates the Oracle home software with the new SBP. You must perform this step before (!) you create or upgrade the database.
2. Patching the Database
The database must be adapted to the new SBP by performing certain SBP post-installation tasks (catsbp) and by adapting database parameters. When you install a new SAP database, it is
recommended to perform the SBP post-installation tasks before loading the SAP database. If this is not possible, then you must perform these tasks right after the installation of the new system is
completed.
SBP Installation Procedure
1. Download the current SBP from the SAP Support Portal.
2. Follow the SBP-specific instructions given in the corresponding SBP README to install the SBP.
Note: When you run 'mopatch.sh' to install the SBP, make sure that LD_LIBRARY_PATH (SHLIB_PATH, LIBPATH) is not set or does not contain a reference to another Oracle home to avoid linking
errors.
OS> env | grep LD_LIBRARY_PATH
OS> env | grep SHLIB_PATH
OS> env | grep LIBPATH
Using the new Oracle Home for SAP
After you have successfully installed the SBP, the new Oracle home is ready for SAP. You can either create a new SAP database (e.g. using SWPM), upgrade an existing SAP database to this release (e.g. using
DBUA) or patch an existing SAP database to this higher patch level.
After you have created a new SAP database from this new installed Oracle home, or after you have upgraded an existing SAP database to this new installed Oracle home, you must perform the SBP-specific
post-installation steps as described in the SAP Bundle Patch README (SBP README).
Installing Oracle Database Software Advanced Options
One Oracle Home Patching Strategy
You can run your SAP database <DB_SID> from one Oracle home. This Oracle home is installed in <IHRDBMS>=/oracle/<DB_SID>/18.0.0 which is the SAP default path for an Oracle home of release 18c.
New SAP Bundle Patches are installed into this Oracle home. Although the Oracle home directory says '18.0.0', the full release of the Oracle home depends on the current installed SAP Bundle Patch.
Minimum Downtime Patching Strategy
If you decide to install a new Oracle home with a new SAP Bundle Patch into a new, separate Oracle home directory, then we suggest to use the following Oracle home naming convention. With this strategy,
you can immediately identify the current installed Release Update from the name of the Installation Oracle home directory IHRDBMS.

SBP IHRDBMS RUNINSTALLER

SBP with Release Update 4 18.4.0 ./RUNINSTALLER -ihrdbms /oracle/<DBSID>/18.4.0

SBP with Release Update 5 18.5.0 ./RUNINSTALLER -ihrdbms /oracle/<DBSID>/18.5.0

SBP 18.4.0.0.181016 18.4.0.0.181016 ./RUNINSTALLER -ihrdbms /oracle/<DBSID>/18.4.0.0.181016

To install an Oracle Home into a dedicated Installation Oracle Home, run

OS> ./RUNINSTALLER -ihrdbms <IHRDBMS>
Removing Oracle Database Software
Use the deinstall command that is included in Oracle homes to remove Oracle software. Removal of individual products or components is not supported.
You can stop and remove Oracle Database software and components (e.g. databases, listeners) in an Oracle Database home with the deinstall command. The deinstall command is available in Oracle home
directories after installation in the $ORACLE_HOME/deinstall directory. deinstall stops Oracle software, and removes Oracle software and configuration files on the operating system for a specific Oracle
home.
You must run the deinstall command from the same release to remove Oracle software.
If the Oracle software was not successfully installed, then deinstall cannot determine the configuration, and you must provide all the configuration details manually (interactively or response file).
If the central inventory (oraInventory) contains no other registered homes besides the home that you are deconfiguring and removing, then deinstall removes all files and directories in the Oracle base
directory.
Remove Oracle Software and Components (Standard Procedure)
Use this procedure to remove Oracle software and components.
Preparation:
1. Log on as Oracle software owner
2. Set Environment (Bourne Shell)
export DB_SID=<name of the SAP database>
export IHRDBMS=/oracle/$DB_SID/18.0.0
export OHRDBMS=/oracle/$DB_SID/18
echo "Removing IHRDBMS: $IHRDBMS"
echo "Removing OHRDBMS: $OHRDBMS"
Procedure (non-silent):
 1. Remove Installation Oracle Home
Run deinstall from the <ORACLE_HOME>/deinstall directory. The deinstallation starts without prompting you for the Oracle home path.
OS> cd $IHRDBMS/deinstall; ./deinstall [-checkonly]
2. Remove Runtime Oracle Home (SAP Specific)
OS> rm $OHRDBMS
Procedure for silent deinstall:
1. Run deinstall from the <ORACLE_HOME>/deinstall directory and generate response file
OS> cd $IHRDBMS/deinstall
OS> ./deinstall -silent -checkonly
2. Review deinstall response file generated in /tmp/deinstall<timestamp>/response/deinstall_<OracleHomeName>.rsp
3. Run deinstall with response file
OS> ./deinstall -silent -paramfile <deinstall response file>
4. Remove Runtime Oracle Home
OS> rm $OHRDBMS
For more information, refer to the Oracle documentation for your database platform.

Platform 19c Oracle Database Installation Guide 18c

Linux Removing Oracle Database Software Removing Oracle Database Software

Solaris Removing Oracle Database Software Removing Oracle Database Software

AIX Removing Oracle Database Software Removing Oracle Database Software

HP-UX Removing Oracle Database Software Removing Oracle Database Software

Remove Oracle Software (Manual Procedure)

You can use this procedure to remove Oracle software. Components like listeners or databases that are configured in this Oracle home are not removed.
Preparation:
1. Log on as Oracle software owner
2. Set Environment (Bourne Shell)
export DB_SID=<name of the SAP database>
export IHRDBMS=/oracle/$DB_SID/18.0.0
export OHRDBMS=/oracle/$DB_SID/18
echo "Removing IHRDBMS: $IHRDBMS"
echo "Removing OHRDBMS: $OHRDBMS"
Procedure:
1. De-register the Oracle home from the central inventory (if registered there)
OS> $IHRDBMS/oui/bin/detachHome.sh
2. Remove Installation Oracle home
OS> rm -rf $IHRDBMS
3. Remove Runtime Oracle Home (SAP Specific)
OS> rm $OHRDBMS
Cloning Oracle Database Software
The clone.pl script is deprecated and can be removed in a future release. Hence, Oracle recommends to use the software-only installation option that is available in the Oracle software installer instead of
clone.pl.
For more information, see SAP Note 3009807.

Appendix
A - About SAP RUNINSTALLER
SAP RUNINSTALLER Scripts
'SAP RUNINSTALLER' is an SAP specific installation tool for Oracle database software to install new Oracle database homes in SAP environments. SAP RUNINSTALLER consists of 2 shell scripts. The
current version of SAP RUNINSTALLER is attached to this SAP Note.
Oracle Database 19c:
19-024: option '-invPtrLoc' removed;
19-018: available on SAP DVD
Oracle Database 18c:
18-021: available on SAP DVD
SAP RUNINSTALLER Default Values
SAP RUNINSTALLER uses the following SAP default values:

Release 19c Release 18c

OHRDBMS /oracle/<DBSID>/19 /oracle/<DBSID>/18

IHRDBMS /oracle/<DBSID>/19.0.0 /oracle/<DBSID>/18.0.0

Log files /oracle/<DBSID>/orainstall /oracle/<DBSID>/orainstall

The value for <DBSID> must be specified in the environment (env. var. $DB_SID).

SAP RUNINSTALLER Log File Directory

SAP RUNINSTALLER creates log files in the following locations:
1. /oracle/<DBSID>/orainstall (prerequisite: environment variable $DB_SID is set)
2. User home directory $HOME
3. /oracle/<DBSID> (prerequisite: environment variable $DB_SID is set)
4. Current directory
SAP RUNINSTALLER Usage
1. Log on as Oracle software owner <ora_swo>.
With user concept 'Oracle Standard', the Oracle software owner is 'oracle', with user concept 'SAP Classic', the Oracle software owner is 'ora<dbsid>'.
2. Go to the Oracle database software stage directory.
3. Run 'RUNINSTALLER' with appropriate command line options.
OS> ./RUNINSTALLER <options>
Starting SAP RUNINSTALLER
You can start SAP RUNINSTALLER from 3 locations:

Location
 From DVD SAP RUNINSTALLER automatically finds the Oracle home image file on the DVD.

From extracted Oracle home SAP RUNINSTALLER automatically finds the extracted Oracle home.

From any directory You can download a new SAP RUNINSTALLER version to your database server.
To install a new Oracle home, use the option '-oracle_stage <path>' to specify the location of the Oracle home image file.

SAP RUNINSTALLER Installation Options

The following options are new with 18c:

Command Description

RUNINSTALLER [-ohinstall] Install Oracle Home (Default)

RUNINSTALLER -ohnoinstall Verify installation settings, but do not install

RUNINSTALLER -ohprepare Prepare installation (Pre-Installation Checks)

RUNINSTALLER -ohverify Verify installation settings

RUNINSTALLER -ohextract Extract Oracle Home Image File (unzip)

RUNINSTALLER -ohcheck Check installation prerequisites (runInstaller)

RUNINSTALLER -ohregister Register Oracle Home (runInstaller)

RUNINSTALLER -ohsapcfg Configure Runtime Oracle Home for SAP

You perform the installation of a new Oracle home in one run (RUNINSTALLER [-ohinstall]), or you can run the steps one after the other separately.
SAP RUNINSTALLER Basic Options

Command Description

RUNINSTALLER -help Get usage information

RUNINSTALLER -version Get version information

RUNINSTALLER -verbose Enable verbose mode

RUNINSTALLER -nolog Enable nolog mode (disable logging)

RUNINSTALLER -query Enable test mode

RUNINSTALLER -log <path> Specify location for log file(s)

RUNINSTALLER -tmp <path> Specify location for temporary files

For more information, run 'RUNINSTALLER -help'.
SAP RUNINSTALLER Advanced Options
You can run SAP RUNINSTALLER in verbose mode, silent mode or query mode.
OS> ./RUNINSTALLER [-silent] [-ignorePrereqWarnings] [-ignoreWarnings] [-query] [-verbose]
In order to ignore non-FATAL warnings from prerequisite checks in silent mode, use the [-ignorePrereqWarnings] option.
In order to ignore any installation warnings, use the [-ignoreWarnings] option.
Example:
OS> ./RUNINSTALLER -silent -ignorePrereqWarnings
Run 'RUNINSTALLER -help' for more advanced options.
SAP RUNINSTALLER Prerequisites
To install a new Oracle home, you need at least 2Gb of free space for temporary files. SAP RUNINSTALLER uses the users home directory as default location for temporary files. If there is not enough free
space in the users home directory, you can start RUNINSTALLER with a different location for temporary files, e.g. 'RUNINSTALLER -tmp /tmp'.
SAP RUNINSTALLER Installation Scenarios

The following installation scenarios are supported:

Oracle single instance on filesystem (SI/FS)
Oracle single instance with ASM
Oracle Real Application Clusters (RAC)
Installing a new Oracle home on Oracle Engineered Systems (Oracle Exadata / Oracle Database Appliance (ODA), Oracle SuperCluster) or on Oracle ExaCS (Oracle Cloud) are not supported.
SAP RUNINSTALLER Version
Run 'RUNINSTALLER -version' to check the version of SAP RUNINSTALLER.
SAP RUNINSTALLER Installing a new Version
1. Download the package <sap_runinstaller_pkg_file> (attached to this SAP Note) to your database server.
2. Extract it to the Oracle database software stage directory '<stage>/db_home'.
OS> unzip -d <stage>/db_home <sap_runinstaller_pkg_file>
3. Go to <stage>/db_home/SAP.
OS> cd <stage>/db_home/SAP
4. Use the new RUNINSTALLER.
OS> ./RUNINSTALLER -version
OS> ./RUNINSTALLER <options>
B - Troubleshooting Oracle Database Software Installation
If the installation of Oracle Database software fails, you should first check SAP Note 1915299 for known issues and their workarounds/solutions.
Below you find some additional tips how to analyze and solve issues with Oracle database software installation.

Issue Recommended Procedure

OS prerequisites are not met? Check OS prerequisites: 'RUNINSTALLER -ohcheck'; check Oracle Database Installation Guide;

SAP RUNINSTALLER fails Check error message in RUNINSTALLER log file.

SAP RUNINSTALLER fails with <invalid option> Run 'RUNINSTALLER -help' for more information.
 Oracle Universal Installer (OUI) fails Check OUI log file(s) at <oraInventory>/logs. The default location of the central inventory is <ORACLE_BASE>/oraInventory.

Is this a known installation issue? Check SAP note 1915299 for solutions and workarounds of known installation issues.

Location of central Oracle inventory? Check Oracle configuration files /etc/oraInst.loc or /var/opt/oracle/oraInst.loc

SAP RUNINSTALLER too old? Ensure that you have installed the current SAP RUNINSTALLER version.

Known Issues

Issue Solution

RUNSTALLER does not extract into a non-empt Symptom

y Oracle Home
SAP RUNINSTALLER fails with the following error:
(ERROR ) - Cannot extract Oracle home image file into Oracle home directory that is not empty.

Cause

The Oracle Home has its own file system that contains the directory 'lost+found'.
Solution

Get SAP RUNINSTALLER 19-026 or higher version.

Use option '-no_empty_dir_check'. This option allows to install into a non-empty Oracle home.

$ ./RUNINSTALLER -no_empty_dir_check [options]

For more information, see 'RUNINSTALLER -help'.

runInstaller / runfixup.sh switches primary grou Symptom

p from 'oinstall' to 'dba'
Software owner is "oracle:oinstall", primary group of "oracle" is "oinstall".
runInstaller checks whether user "oracle" has "dba" as primary group.
runInstaller generates the runfixup.sh script.
The script changes the primary group from "oinstall" to "dba".

Cause

oraInst.loc exists an contains the following entry:

inventory_loc=/oracle/oraInventory
inst_group=dba

Solution

If this is the first Oracle software installation, remove the old oraInst.loc file. Otherwise change the entry as follows:

replace "inst_group=dba" to "inst_group=oinstall".

Oracle Installer hangs in silent mode (AIX, 19c) Platform/Release
AIX / 19c

Symptom

Oracle Installer hangs when started in silent mode

Cause

On AIX, dialog starts regarding rootpre.sh. In silent mode, you do not see this dialog.

Oracle Bug 30258274.

Workaround/Solution

Set environment variable SKIP_ROOTPRE=TRUE

Oracle Installer does not check for AIX package s Platform/Release

ecurity.pkcs
AIX 7.1/ 19c

Symptom

Oracle installer does not check whether package security.pkcs is installed

Cause

Oracle Bug 30258215 (Fixed in 20.1)

Workaround

Prerequisite is ignorable. You check manually.

 Oracle Installer checks for RPMs libstdc++33-** Release / Platform
*
19c on SUSE LINUX Enterprise Server 12 (SLES12) or SUSE LINUX Enterprise Server 15 (SLES15)

Symptom

Oracle Installer checks for RPMs libstdc++33***, but this package does not exist on SLES12 SP3 or later. Instead, package libstdc++6 (=new version of libstdc++33) mu
st be installed.

Installation Logfile

package libstdc++33 is not installed.

TASK_SUMMARY:FAILED:CRITICAL:VERIFICATION_FAILED

PRVF-7532 : Package "libstdc++33" is missing on node <node>.

Cause

Oracle Bug 29742223. For more information, see MOS Doc ID 2540685.1.

Workaround

Ignore this prereq check error. Ensure that libstdc++6 (new version of libstdc++33) package is installed instead.
$ rpm -q libstdc++
libstdc++6
$

Additional information

For Linux OS requirements (SLES12, SLES15), see SAP Note 2478541 or Oracle Database documentation here: https://docs.oracle.com/en/database/oracle/oracle-data
base/19/ladbi/operating-system-requirements-for-x86-64-linux-platforms.html.

C - Installing Oracle Database Software Manually

You can install a new Oracle Database 18c Oracle Home on your database server manually using the following steps.
The -manual- installation of a new Oracle home consists of the following steps:
1. Create a new directory for the new Oracle home
2. Extract the Oracle Database 18c image file <ora_image_file> to the new Oracle home (unzip)
3. Configure and register the new Oracle home (runInstaller)
4. SAP-Specific Oracle Home Configuration
5. Install SAP Bundle Patch (MOPatch)
After successful registration (step 3) the new Oracle home is registered in the central inventory (inventory.xml). You can check the contents of the inventory with 'opatch lsinventory -all'.
Log on to the database server as Oracle software owner and perform the following steps:
Step 0: Preparation
#Set Environment (Bourne Shell)
export DB_SID=<name of the SAP database>
export IHRDBMS=/oracle/$DB_SID/18.0.0
export OHRDBMS=/oracle/$DB_SID/18
 #Verify/Check environment (optional)
echo DB_SID=$DB_SID
echo IHRDBMS=$IHRDBMS
echo OHRDBMS=$OHRDBMS
Step #1: Create a new directory for the new Oracle home
# Create Installation Oracle Home
mkdir -p /oracle/$DB_SID
mkdir -p $IHRDBMS

# Create Runtime Oracle Home (Symbolic Link, Symlink)

ln -s $IHRDBMS $OHRDBMS
Step #2: Extract the Oracle Database 18c image file to the new Oracle home
# Go to location of SAP DVD with Oracle Database 18c software <ora_sapdvd>
# Go to directory <platform>/db_home. Here you find the image file.
pwd; ls -l *.zip

# Extract into Installation Oracle Home

unzip <ora_image_file> -d $IHRDBMS
echo $?
Step #3: Configure and register the new Oracle home
# Set DISPLAY for Oracle Database Setup Wizard
export DISPLAY=<display>

# Register Installation Oracle Home

cd $IHRDBMS; ./runInstaller; echo return code is $?

Run the Oracle Database Setup Wizard with the following entries / values:
1. Configuration Option: Choose 'Set Up Software Only'
2. Database Installation Options: Single Instance or Real Application Clusters - leave the default and continue
3. Database Edition: Choose 'Enterprise Edition'
4. Installation Location: For ORACLE_BASE, set '/oracle/<DBSID>'
5. Operating System Groups: Choose OS group 'oper' for OSOPER and OSBACKUPDBA, OS group 'dba' for the rest
6. Prerequisite Checks: On this page verify that all prerequisites are met
7. Summary: Review summary page, click on 'install' if satisfied
8. Install Product: Monitor installation progress, run configuration scripts (root.sh) when prompted
Note: For SAP it is not needed to setup the Oracle Trace File Analyzer (TFA) when running root.sh. For more information, see SAP Note 1915299.
9. Finish: Confirm by clicking 'Close' button.
10. Verify the log file of this install session.
Step #4: SAP-Specific Oracle Home Configuration
# Create Runtime Oracle Home (if not yet done)
ln -s $IHRDBMS $OHRDBMS
# Configure orabasetab (OHRDBMS) - Reference: SAP Note 1521371 (orabtt.sh)
If the tool orabtt.sh is not yet installed, then you can copy it from another Oracle home or install the corresponding Oracle patch 22819075.
Step #5: Install SAP Bundle Patch (SBP)
This step is mandatory. For more information, see section 'Installing Oracle Database SAP Bundle Patch' below.
Example:

Step #0 Set Environment (Preparation) sh

export DB_SID=<name of the SAP database>; echo DB_SID=$DB_SID
export IHRDBMS=/oracle/$DB_SID/18.0.0; echo IHRDBMS=$IHRDBMS
export OHRDBMS=/oracle/$DB_SID/18; echo OHRDBMS=$OHRDBMS

Step #1 Create Installation Oracle Home and Runtime Oracle home mkdir -p $IHRDBMS && ln -s $IHRDBMS $OHRDBMS

Step #2 Extract Oracle Home Image File cd <ora_sapdvd>/<platform>/db_home; pwd; ls -l *.zip

unzip <ora_image_file> -d $IHRDBMS; echo unzip return code is $?

Step #3 Configure and register the new Oracle home export DISPLAY=<display>; cd $IHRDBMS; ./runInstaller; echo runInstaller return code is $?

Step #4 SAP-Specific Oracle Home Configuration Configure orabasetab with orabtt. For more information, see SAP Note 1521371

Step #5 Install SAP Bundle Patch (SBP) For more information, see SBP README.

Attributes
Key Value

Database System ORACLE

This document refers to

SAP Note/KBA Component Title

2992680 BC-DB-ORA

2660018 BC-DB-ORA Oracle Database Software Installation on Microsoft Windows

1915301 BC-DB-ORA Database Software 12c Installation on Unix

1524205 BC-DB-ORA Oracle 11.2.0: Database Software Installation

This document is referenced by

SAP Note/KBA Component Title

3296921 Installing Oracle Database 19c on Oracle Linux 9 and Red Hat Enterprise Linux 9

3009807 BC-DB-ORA Cloning an Oracle Database Home of 19c or higher

 Attachments
File Name File Size Mime Type

19cinstall-19-018-202002121652.zip 45 application/x-zip-compressed

19cinstall-19-031-202407021105.zip 50 application/x-zip-compressed

18cinstall-18-021-201902081553.zip 42 application/x-zip-compressed

19cinstall-19-024-202007211312.zip 47 application/x-zip-compressed

19cinstall-19-026-202012150956.zip 47 application/x-zip-compressed