Upgrade to Oracle Database 19c Windows - SAP
[Pages:11]PUBLIC Document Version: 2.2 ? 2022-02-14
Upgrade to Oracle Database 19c Windows
THE BEST RUN
? 2022 SAP SE or an SAP affiliate company. All rights reserved.
Content
1
Document History. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
2
Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
2.1 SAP Notes for the Oracle Database Upgrade. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
2.2 More Support Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
3
Planning. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
3.1 Identifying the Supported Upgrade Path. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
3.2 Checking the Original Version of Your Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
3.3 Checking Hardware and Software Requirements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
3.4 Using Multiple Oracle Homes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
3.5 SAP Specific Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
4
Preparation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
4.1 Creating an Oracle Installation User. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
4.2 Configuring Secure Storage in File System. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13
4.3 Downloading the Software for the Upgrade. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
4.4 MSCS Only: Removing the Database from the Cluster Group. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
4.5 Installation of the Oracle Database Software. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Installing the New Oracle Database Server Software. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Installing Required Patches. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
4.6 MSCS Only: Installing OFS 4.2.1 or Higher. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
MSCS Only: Installing the Latest Oracle Fail Safe Patch Set. . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
5
Oracle Database Upgrade. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
6
Post-Upgrade Steps. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
6.1 Changing Environment Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
6.2 Performing SAP Bundle Patch Post-Installation Steps. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
6.3 Performing Post-Upgrade Checks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .23
6.4 MSCS Only: Setting Up a Shared Database Directory in Oracle Home for OFS 4.2.1. . . . . . . . . . . . . . 24
6.5 MSCS Only: Changing the Registry Value of Oracle Autostart. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
6.6 Checking the Startup Type of the Oracle Services. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
6.7 MSCS Only: Adding the Database to the Cluster Group. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .26
6.8 Checking and Updating the Database Parameters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
6.9 Updating the Oracle Instant Client. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
6.10 Updating BR*Tools Executables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
6.11 Updating Database Statistics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .30
2
PUBLIC
Upgrade to Oracle Database 19c Windows Content
6.12 Backing Up the Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 6.13 Updating the SAP Executables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 6.14 Uninstalling the Old Oracle Software. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
7
Common Administration Tasks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
7.1 Starting and Stopping the Database in an MSCS Configuration. . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
7.2 Starting and Stopping Services. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
7.3 Moving Groups or Services and Applications for MSCS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .36
7.4 Starting and Stopping the SAP System. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
A
Appendix. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
A.1 Using PowerShell. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Upgrade to Oracle Database 19c Windows Content
PUBLIC
3
1 Document History
Note
Before you start the implementation, make sure you have the latest version of this document, which is available at .
The following table provides an overview on the most important document changes:
Version 2.2 2.1
2.0 1.0
Date 2022-02-14 2020-08-13
2020-03-02 2019-12-19
Description
Minor update
Minor update (see MSCS Only: Adding the Database to the Cluster Group [page 26])
Updated Version OFS for 19c
Initial Version for 19c
4
PUBLIC
Upgrade to Oracle Database 19c Windows Document History
2 Introduction
This documentation explains how to upgrade the Oracle database for the SAP system on the Windows operating system to Oracle Database 19c. The upgrade path depends on your current Oracle database version: If you are currently running 11.2.0.4,12.1.0.2, or 12.2.0.1, you can upgrade directly to 19c. If you are running an Oracle database release 11.2.0.3 or earlier, a direct upgrade to 19c is not supported. Oracle supports the manual database upgrade and the upgrade with the Database Upgrade Assistant (DBUA). In this document only, the recommended upgrade procedure with DBUA is described.
Caution
SAP products running with SAP BASIS 7.00 and above, and SAP kernel release 7.21 EXT and above, are certified for Oracle Database 19c.
Caution
User Account Control on Windows: As of Windows Server 2008, the Windows standard security settings only grant administrative privileges to an account that is a member of the local administrators group, if the process was started with elevated privileges, that is, using "Run as Administrator". This means that during the installation and upgrade process of an Oracle database software, most of the statements must be executed with administrative privileges. Therefore, when you are asked to open a command prompt (cmd.exe) or a Powershell prompt (powershell.exe), or other tools like the Oracle Failsafe Manager, you have to do so in elevated mode (right-click on cmd.exe, and choose Run as Administrator). For more information about User Account Control (UAC), see the Windows documentation.
Implementation Considerations
For more information about implementation considerations, including the most important SAP Notes for the upgrade, see Planning [page 8].
Be sure to read the relevant SAP Notes before beginning the upgrade. These notes contain the most recent information about the upgrade, as well as corrections to the documentation. You can find the most recent version of the SAP Notes at
You use the tools Oracle Universal Installer (OUI), Opatch, Oracle SQL*Plus, and Oracle Database Upgrade Assistant (DBUA) to perform the upgrade.
The database server and database client must be in the same Windows domain. For information on permitted domain names see SAP Note 314671 .
Upgrade to Oracle Database 19c Windows Introduction
PUBLIC
5
Terminology and Naming Conventions
We use for the database name and for the SAP system name. To have a common documentation layout for UNIX and Windows in this documentation, we use / (slash)
in SQL commands. Do not use / (slash) in command prompts for path separation. We use the terms "central instance" and "dialog instance" in this document. As of SAP NetWeaver 7.1,
these terms have been replaced by "primary application server instance" and "additional application server instance". refers to the new Oracle home path of the new database release. refers to the old Oracle home path before the upgrade.
2.1 SAP Notes for the Oracle Database Upgrade
Make sure that you read the following SAP Notes:
Number 2817074 2799920 2800001 279900 2660018 2599248 2540847 2470718 2087004 1598594 998004 839182
Title Oracle Database 19c: Integration in SAP environment Patches for 19c: Database Upgrading to Oracle Database 19c Central Technical Note for Oracle Database 19c Oracle Database 19c Installation on Windows Oracle 19c: No unzip utility delivered in $ORACLE_HOME/bin SAP Guides for Oracle Database Upgrade
Oracle Database Parameters (12.2) BR*Tools support for Oracle 12c BR*Tools Configuration for Oracle installation using user "oracle" Update the Oracle Instant Client on Windows Oracle patch installation with OPatch
6
PUBLIC
Upgrade to Oracle Database 19c Windows Introduction
2.2 More Support Information
You can find more information as follows:
Description
Internet Address
Oracle database software, including patches - at SAP Support Portal
Oracle
SAP Notes - at SAP Support Portal
Resources for SAP systems on the Oracle database - at SAP on Oracle Community
SAP Software Distribution Center - at SAP Support Portal
SAP Database Administration for Oracle Databases - at SAP on Oracle Community
Oracle
DBA Overview Getting Started SAP Database Guide: Oracle
Upgrade to Oracle Database 19c Windows Introduction
PUBLIC
7
3 Planning
Recommendation
Before the production upgrade, make sure that you perform a test upgrade on your backup system.
1. You identify the supported upgrade path [page 8]. 2. You check the original version of your database [page 8]. 3. You check the hardware and software requirements [page 9]. 4. You decide whether you want to use multiple Oracle homes [page 9]. 5. You use the Oracle upgrade checklist for production use [page 10].
3.1 Identifying the Supported Upgrade Path
To upgrade directly to Oracle Database 19c, your source release must be Oracle Database 11g Release 2 (11.2.0.4), Oracle Database 12c Release 1 (12.1.0.2) or Oracle Database 18c Release 2 (12.2.0.1). If you are running another Oracle database release, a direct upgrade to 19c is not supported. For more information, see SAP Note 2800001 .
3.2 Checking the Original Version of Your Database
Use
You can check the original version of the database you want to upgrade and, if necessary, obtain more information.
Process
To check the original version of your database, enter these commands from the environment of the source database as the appropriate database user: SQL> select version from v$instance;
8
PUBLIC
Upgrade to Oracle Database 19c Windows Planning
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- this is a temporary pdf document for download
- temp file cleaner v3
- e シリーズ
- recover old word document version immi
- how to transfer files to from remote machine mobaxterm
- gw series lcd monitor user manual microsoft
- gw2406z lcd monitor user manual
- how to install temptale manager desktop sensitech
- what you didn t know about xml external entities attacks
- where is the file located aadhaar retail
Related searches
- upgrade to windows 10 free download
- free upgrade to windows 10
- upgrade to windows 10 free
- free upgrade to windows 11
- upgrade to latest windows version
- oracle database 19c install
- oracle 19c windows client
- oracle client 19c windows
- oracle 19c windows download
- oracle 19c windows 2019
- oracle database download for windows 10
- oracle database 19c installation guide