Fleet Patching and Provisioning Administrators Guide
Fleet Patching and Provisioning Administrators Guide
Fleet Patching and Provisioning Administrators Guide
Provisioning
Oracle Fleet Patching and Provisioning
Administrator's Guide
21c
F30287-05
May 2022
Oracle Fleet Patching and Provisioning Oracle Fleet Patching and Provisioning Administrator's Guide, 21c
F30287-05
Contributors: Ludovico Caldara, Jonathan Creighton, Kamalesh Ramasamy, Kannan S. Viswanathan, Rahul
Desale, Ricardo A. Gonzalez, Ricardo Tamez Durandeau, Sampath Ravindhran, Siddharth Shankaran, Soo
Huey Wong
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on
behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,
any programs embedded, installed or activated on delivered hardware, and modifications of such programs)
and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end
users are "commercial computer software" or "commercial computer software documentation" pursuant to the
applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use,
reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or
adaptation of i) Oracle programs (including any operating system, integrated software, any programs
embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle
computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the
license contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloud
services are defined by the applicable contract for such services. No other rights are granted to the U.S.
Government.
This software or hardware is developed for general use in a variety of information management applications.
It is not developed or intended for use in any inherently dangerous applications, including applications that
may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you
shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its
safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this
software or hardware in dangerous applications.
Oracle, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may be
trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are
used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,
and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered
trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise
set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be
responsible for any loss, costs, or damages incurred due to your access to or use of third-party content,
products, or services, except as set forth in an applicable agreement between you and Oracle.
Contents
iii
Image Type 3-3
Provisioning Copies of Gold Images 3-4
Storage Options for Provisioned Software 3-6
Provisioning for a Different User 3-7
User Group Management in Fleet Patching and Provisioning 3-7
Provisioning Oracle Grid Infrastructure Homes 3-9
About Deploying Oracle Grid Infrastructure Using Oracle Fleet Patching and
Provisioning 3-10
Provisioning Oracle Grid Infrastructure Software 3-11
Provisioning Oracle Grid Infrastructure 21c With GIMR Configured 3-12
Provisioning Oracle Database Homes 3-13
iv
Downgrading Oracle Exadata InfiniBand Switches Patch 6-7
v
rhpctl modify audit A-4
rhpctl query audit A-4
client Commands A-5
rhpctl add client A-6
rhpctl allow client A-8
rhpctl delete client A-8
rhpctl disallow client A-9
rhpctl discover client A-10
rhpctl export client A-11
rhpctl modify client A-11
rhpctl query client A-12
rhpctl update client A-14
rhpctl verify client A-14
credentials Commands A-15
rhpctl add credentials A-16
rhpctl delete credentials A-16
database Commands A-16
rhpctl add database A-17
rhpctl addnode database A-19
rhpctl addpdb database A-21
rhpctl deletepdb database A-22
rhpctl delete database A-23
rhpctl deletenode database A-24
rhpctl move database A-26
rhpctl movepdb database A-30
rhpctl upgrade database A-31
rhpctl zdtupgrade database A-33
exadata Commands A-36
rhpctl update exadata A-36
gihome Commands A-38
rhpctl addnode gihome A-38
rhpctl deletenode gihome A-39
rhpctl move gihome A-40
rhpctl upgrade gihome A-44
image Commands A-46
rhpctl add image A-46
rhpctl allow image A-48
rhpctl delete image A-48
rhpctl deploy image A-49
rhpctl disallow image A-49
rhpctl import image A-50
vi
rhpctl instantiate image A-52
rhpctl modify image A-53
rhpctl query image A-53
rhpctl promote image A-55
rhpctl uninstantiate image A-56
imagetype Commands A-56
rhpctl add imagetype A-57
rhpctl allow imagetype A-57
rhpctl delete imagetype A-58
rhpctl disallow imagetype A-58
rhpctl modify imagetype A-59
rhpctl query imagetype A-59
job Commands A-60
rhpctl delete job A-61
rhpctl query job A-61
osconfig Commands A-63
rhpctl collect osconfig A-63
rhpctl compare osconfig A-63
rhpctl disable osconfig A-64
rhpctl enable osconfig A-64
rhpctl query osconfig A-65
peerserver Commands A-66
rhpctl query peerserver A-66
role Commands A-66
rhpctl add role A-67
rhpctl delete role A-68
rhpctl grant role A-69
rhpctl query role A-70
rhpctl revoke role A-71
series Commands A-72
rhpctl add series A-72
rhpctl delete series A-73
rhpctl deleteimage series A-73
rhpctl insertimage series A-74
rhpctl query series A-75
rhpctl subscribe series A-76
rhpctl unsubscribe series A-76
server Commands A-77
rhpctl export server A-77
rhpctl query server A-77
rhpctl register server A-78
vii
rhpctl unregister server A-78
user Commands A-79
rhpctl delete user A-79
rhpctl modify user A-80
rhpctl register user A-80
rhpctl unregister user A-81
useraction Commands A-81
rhpctl add useraction A-81
rhpctl delete useraction A-83
rhpctl modify useraction A-83
rhpctl query useraction A-84
workingcopy Commands A-85
rhpctl add workingcopy A-86
rhpctl addnode workingcopy A-92
rhpctl delete workingcopy A-93
rhpctl query workingcopy A-94
viii
Preface
Information in Oracle Fleet Patching and Provisioning Administrator's Guide applies to Oracle
Fleet Patching and Provisioning as it runs on all platforms unless otherwise noted. Where
necessary, this manual refers to platform-specific documentation.
This Preface contains these topics:
• Audience
• Documentation Accessibility
• #unique_11
• Conventions
• Audience
• Documentation Accessibility
• Diversity and Inclusion
• Set Up Java Access Bridge to Implement Java Accessibility
Install Java Access Bridge so that assistive technologies on Microsoft Windows systems
can use the Java Accessibility API.
• Command Syntax
Refer to these command syntax conventions to understand command examples in this
guide.
• Conventions
Audience
The Oracle Fleet Patching and Provisioning Administrator's Guide is intended for database
administrators and system administrators who provision and maintain Oracle homes.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility
Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
9
Set Up Java Access Bridge to Implement Java Accessibility
We are also mindful of the necessity to maintain compatibility with our customers'
existing technologies and the need to ensure continuity of service as Oracle's offerings
and industry standards evolve. Because of these technical constraints, our effort to
remove insensitive terms is ongoing and will take time and external cooperation.
Command Syntax
Refer to these command syntax conventions to understand command examples in this
guide.
Convention Description
$ Bourne or BASH shell prompt in a command example. Do not enter the
prompt as part of the command.
% C Shell prompt in a command example. Do not enter the prompt as part of
the command.
# Superuser (root) prompt in a command example. Do not enter the prompt
as part of the command.
monospace UNIX command syntax
backslash \ A backslash is the UNIX and Linux command continuation character. It is
used in command examples that are too long to fit on a single line. Enter
the command as displayed (with a backslash) or enter it on a single line
without a backslash:
.DEFINE {macro1}
10
Conventions
Convention Description
ellipses ... Ellipses indicate an arbitrary number of similar items:
italic Italic type indicates a variable. Substitute a value for the variable:
library_name
Conventions
The following text conventions are used in this document:
Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an
action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for which
you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code in
examples, text that appears on the screen, or text that you enter.
11
1
Oracle Fleet Patching and Provisioning
Oracle Fleet Patching and Provisioning is a software lifecycle management method for
provisioning and maintaining Oracle homes.
Oracle Fleet Patching and Provisioning (Oracle FPP) enables mass deployment and
maintenance of standard operating environments for databases, clusters, and user-defined
software types. With Oracle Fleet Patching and Provisioning, you can also install clusters and
provision, patch, scale, and upgrade Oracle Grid Infrastructure and Oracle Database 11g
release 2 (11.2), and later. Additionally, you can provision applications and middleware.
Note:
Starting with Oracle Grid Infrastructure 19c, the feature formerly known as Rapid
Home Provisioning (RHP) is now Oracle Fleet Patching and Provisioning (Oracle
FPP).
Note:
• Oracle does not support Oracle Fleet Patching and Provisioning on HP-UX or
Windows operating systems.
• The Oracle Fleet Patching and Provisioning Server does not manage operating
system images.
You can use Oracle Fleet Patching and Provisioning in either of the following modes:
1-1
Chapter 1
About Oracle Fleet Patching and Provisioning
• As a central server (Oracle Fleet Patching and Provisioning Server), that stores
and manages standardized images, called gold images. You can deploy gold
images to any number of nodes across a data center. You can use the deployed
homes to create new clusters and databases, and patch, upgrade, and scale
existing installations.
The server manages software homes on the cluster hosting the Oracle Fleet
Patching and Provisioning Server, itself, Oracle Fleet Patching and Provisioning
Clients, and can also manage installations running Oracle Grid Infrastructure 11g
release 2 (11.2.0.3 and 11.2.0.4), 12c release 1 (12.1.0.2), and later releases. The
server can also manage installations running no grid infrastructure.
An Oracle Fleet Patching and Provisioning Server can provision new installations
and can manage existing installations without any changes to the existing
installations (such as no agent, daemon, or configuration prerequisites). Oracle
Fleet Patching and Provisioning Servers also include capabilities for automatically
sharing gold images among peer Oracle Fleet Patching and Provisioning Servers
to support enterprises with geographically distributed data centers.
• As a client (Oracle Fleet Patching and Provisioning Client), that can be managed
from the central Oracle Fleet Patching and Provisioning Server or directly by
running commands on the Oracle Fleet Patching and Provisioning Client, itself. As
with the Oracle Fleet Patching and Provisioning Server, the Oracle Fleet Patching
and Provisioning Client is a service built in to Oracle Grid Infrastructure and is
available with Oracle Grid Infrastructure 12c release 2 (12.2.0.1), and later. The
Oracle Fleet Patching and Provisioning Client service can retrieve gold images
from the Oracle Fleet Patching and Provisioning Server, upload new images based
on policy, and apply maintenance operations to itself.
For patching operations, a third option is available with Oracle Database and Oracle
Grid Infrastructure 18c, and later. The procedures for updating database and grid
infrastructure homes have been modularized into independent automatons that are
included with Oracle Database and Oracle Grid Infrastructure, and can be run locally
without any central Oracle Fleet Patching and Provisioning Server in the architecture.
This provides an immediate entry point to the capabilities of Oracle Fleet Patching and
Provisioning as soon as you bring up an Oracle Database or cluster.
Note:
Combined Oracle FPP patching for Oracle Grid Infrastructure and Oracle
Database is not supported for standalone configurations.
1-2
Chapter 1
Oracle Fleet Patching and Provisioning Architecture
• Reduces maintenance risk with built-in validations and a dry run mode to test the
operations.
• Enables you to resume or restart the commands in the event of an unforeseen issue,
reducing the impact of maintenance operations.
• Minimizes and often eliminates the impact of patching and upgrades, with features that
include:
– Zero-downtime database upgrade with fully automated upgrade, executed entirely
within the deployment without requiring any extra nodes or external storage.
– Adaptive management of database sessions and OJVM during rolling patching.
– Options for management of consolidated deployments.
• The deployment and maintenance operations enable customizations to include
environment-specific actions into the automated workflow.
Note:
You can not configure Oracle FPP Server on an Oracle Restart server.
The Oracle Fleet Patching and Provisioning Server cluster is a repository for all data, of
which there are primarily two types:
• Gold images
• Working copies and clients
• Metadata related to users, roles, permissions, and identities
The Oracle Fleet Patching and Provisioning Server (FPPS) acts as a central server for
provisioning Oracle Database homes, Oracle Grid Infrastructure homes, and other application
software homes, making them available to the cluster hosting the Oracle Fleet Patching and
Provisioning Server and to the Oracle Fleet Patching and Provisioning Client (FPPC)
clusters, their targets, and non-client targets.
Users operate on the Oracle Fleet Patching and Provisioning Server or Oracle Fleet Patching
and Provisioning Client to request deployment of Oracle homes or to query gold images.
When a user makes a request for an Oracle home, specifying a gold image, the Oracle Fleet
Patching and Provisioning Client communicates with the Oracle Fleet Patching and
Provisioning Server to pass on the request. The Oracle Fleet Patching and Provisioning
Server processes the request by taking appropriate action to instantiate a copy of the gold
image, and to make it available to the Oracle Fleet Patching and Provisioning Client cluster
using available technologies such as Oracle Advanced Cluster File System (Oracle ACFS)
and local file systems.
1-3
Chapter 1
Oracle Fleet Patching and Provisioning Architecture
1-4
Chapter 1
Oracle Fleet Patching and Provisioning Architecture
Oracle Fleet Patching and Provisioning Servers can create new targets, and can also install
and configure Oracle Grid Infrastructure on targets with only an operating system installed.
Subsequently, Oracle Fleet Patching and Provisioning Server can provision database and
other software on those targets, perform maintenance, scale the target cluster, in addition to
many other operations. All Oracle Fleet Patching and Provisioning commands are run on the
Oracle Fleet Patching and Provisioning Server. Targets running the Oracle Fleet Patching
and Provisioning Client in Oracle Clusterware 12c release 2 (12.2), and later, may also run
many of the Oracle Fleet Patching and Provisioning commands to request new software from
the Oracle Fleet Patching and Provisioning Server and initiate maintenance themselves,
among other tasks.
Note:
The Oracle Fleet Patching and Provisioning Server communicates with Oracle Grid
Infrastructure Clusters at version 12.2.0.1 and later through an Oracle Fleet
Patching and Provisioning Client that can be configured and started up on the target
cluster. The Oracle Fleet Patching and Provisioning Client is not supported for
targets at Oracle Grid Infrastructure version 12.1 and earlier, on all versions of
Oracle Restart and database standalone targets, such as database homes without
an Oracle Grid Infrastructure home.
Note:
Oracle supports using other local file systems besides Oracle ACFS.
• Provides a list of available homes from the Oracle Fleet Patching and Provisioning
Server.
1-5
Chapter 1
Oracle Fleet Patching and Provisioning Architecture
• Has full functionality in Oracle Clusterware 12c release 2 (12.2) and can
communicate with Oracle Fleet Patching and Provisioning Servers from Oracle
Clusterware 12c release 2 (12.2), or later.
Related Topics
• Creating a Fleet Patching and Provisioning Client
Users operate on a Fleet Patching and Provisioning Client to perform tasks such
as requesting deployment of Oracle homes and querying gold images.
After you create and import a gold image, you can provision software by adding a copy
of the gold image (called a working copy) on the Fleet Patching and Provisioning
Server, on a Fleet Patching and Provisioning Client, or a target.
Related Topics
• Image State
Am image state is a way to restrict provisioning of an image for users with
specified roles.
1-6
Chapter 1
Oracle Fleet Patching and Provisioning Features
• Image Series
An image series is a convenient way to group different gold images into a logical
sequence.
• Image Type
When you add or import a gold image, you must specify an image type.
1-7
Chapter 1
Oracle Fleet Patching and Provisioning Features
See Also:
– rhpctl query image for information about the -drift option for this
command
– rhpctl query workingcopy for information about the -drift option for
this command
1-8
Chapter 1
Oracle Fleet Patching and Provisioning Features
• Configuration collection and reporting: The Oracle Fleet Patching and Provisioning
Server can collect and retain operating system configuration and the root file system
contents of specified Oracle Fleet Patching and Provisioning Clients. If an Oracle Fleet
Patching and Provisioning Client node is rendered unusable (for example, a user
accidentally deletes or changes operating system configuration or the root file system),
then it can be difficult to determine the problem and correct it. This feature automates the
collection of relevant information, enabling simple restoration in the event of node failure.
See Also:
Oracle Database REST API Reference
1-9
Chapter 1
Oracle Fleet Patching and Provisioning Features
configuration, and can also be used to patch and upgrade Oracle Grid
Infrastructure homes. In addition, there is a rollback capability that facilitates
undoing a failed patch procedure. While patching Oracle Grid Infrastructure, you
can use Oracle Fleet Patching and Provisioning to optionally patch any database
homes hosted on the cluster.
• Provision, scale, patch, and upgrade Oracle Database: You can use Oracle Fleet
Patching and Provisioning, you can provision, scale, and patch Oracle Database
11g release 2 (11.2.0.4), and later releases. You can also upgrade Oracle
Databases from 12c release 2 (12.2), 18c, and 19c to Oracle Database 21c.
When you provision such software, Oracle Fleet Patching and Provisioning offers
additional features for creating various types of databases (such as Oracle RAC,
single instance, and Oracle Real Application Clusters One Node (Oracle RAC One
Node) databases) on different types of storage, and other options, such as using
templates and creating container databases (CDBs). The Oracle Fleet Patching
and Provisioning Server can add nodes to an Oracle RAC configuration, and
remove nodes from an Oracle RAC configuration. Oracle Fleet Patching and
Provisioning also improves and makes more efficient patching of database
software, allowing for rapid and remote patching of the software, in most cases,
without any downtime for the database.
• Support for single-instance databases: You can use Oracle Fleet Patching and
Provisioning to provision, patch, and upgrade single-instance databases running
on clusters or Oracle Restart, or on single, standalone nodes.
• Advanced patching capabilities: When patching an Oracle Grid Infrastructure or
Oracle Database home, Oracle Fleet Patching and Provisioning offers a batch
mode that speeds the patching process by patching some or all nodes of a cluster
in parallel and/or a specific node order, rather than sequentially.
For Oracle Database homes, you can define disjoint sets of nodes. Each set of
nodes is updated sequentially. By defining sets with reference to the database
instances running on them, you can minimize the impact of rolling updates by
ensuring that services are never taken completely offline. A “smartmove” option is
available to help define the sets of batches to meet this goal.
Integration with Application Continuity is another enhancement to help eliminate
the impact of maintenance. This provides the ability to gracefully drain and
relocate services within a cluster, completely masking the maintenance from
users.
• Notifications:The Oracle Fleet Patching and Provisioning Server is the central
repository for the software homes available to the data center. Therefore, it is
essential that administrators throughout the data center be aware of changes to
the inventory which might impact their areas of responsibility.
Oracle Fleet Patching and Provisioning enables you and other users to subscribe
to image series events. Anyone subscribed will be notified by email of any
changes to the images available in a particular image series. Also, users can be
notified by email when a working copy of a gold image is added to or deleted from
a client.
• Custom workflow support: You can create actions for various Oracle Fleet
Patching and Provisioning operations, such as importing images, adding or
deleting working copies of the gold images, and managing a software home. You
can define different actions for each operation, and further differentiate by the type
of image to which the operation applies. Actions that you define can be executed
before or after the given operation, and are executed on the deployment the
operation applies to, whether it is the Oracle Fleet Patching and Provisioning
1-10
Chapter 1
Oracle Fleet Patching and Provisioning Features
Server, a target that is not running an Oracle Fleet Patching and Provisioning Client, or a
target that is running an Oracle Fleet Patching and Provisioning Client.
• Resume failed operations: If an operation, such as adding an image, provisioning a
working copy of a gold image, or performing a scale, patch or upgrade fails, then Oracle
Fleet Patching and Provisioning reports the error and stops. After the problem is
corrected (for example, a directory permissions or ownership misconfiguration on a target
node), you can rerun the RHPCTL command that failed, and it will resume from the point
of failure. This avoids redoing any work that may have been completed prior to the
failure.
• Audit command: The Oracle Fleet Patching and Provisioning Server records the
execution of all Oracle Fleet Patching and Provisioning operations and also records their
outcome (whether success or failure). An audit mechanism enables you to query the
audit log in a variety of dimensions, and also to manage its contents and size.
1-11
2
Oracle Fleet Patching and Provisioning
Configuration
Configuring Oracle Fleet Patching and Provisioning involves creating an Oracle Fleet
Patching and Provisioning Server, adding gold images to the server, and creating working
copies of gold images to provision software.
After you install and configure Oracle Grid Infrastructure, you can configure and start using
Oracle Fleet Patching and Provisioning. You must create an Oracle Fleet Patching and
Provisioning Server where you create and store gold images of database and other software
homes.
• Configuring Oracle Fleet Patching and Provisioning Server
Oracle Fleet Patching and Provisioning (Oracle FPP) Server configuration includes
configuring storage, network, GIMR, and creating an Oracle FPP resource.
• Upgrading Oracle Fleet Patching and Provisioning Server
Upgrade Oracle Fleet Patching and Provisioning Server to the latest release to use the
new features.
• Configuring Oracle Fleet Patching and Provisioning Clients
Oracle Fleet Patching and Provisioning (Oracle FPP) client configuration includes
configuring network, creating client data file, and creating an Oracle FPP client.
• Oracle Fleet Patching and Provisioning Local Mode
When you install Oracle Grid Infrastructure, the Oracle FPP Server is configured, by
default, in the local mode to support the local switch home capability.
2-1
Chapter 2
Configuring Oracle Fleet Patching and Provisioning Server
Table 2-1 Server Configuration Checklist for Oracle Fleet Patching and
Provisioning
Check Task
Oracle Grid Install Oracle Grid Infrastructure on a new cluster on which you want to
Infrastructure configure Oracle FPP.
installation
Note:
You can not configure Oracle FPP Server
on an Oracle Restart server.
Operating System Install or upgrade the operating system kernel to a version for which an
Kernel version Oracle ACFS kernel module is already built.
Grid Infrastructure Make sure that the Grid Infrastructure Management Repository (GIMR)
Management is configured and running on your cluster. If GIMR was not configured
Repository as part of the Oracle Grid Infrastructure installation, then add a new
configuration GIMR to your cluster as described in Oracle Grid Infrastructure
Installation and Upgrade Guide.
Oracle FPP server Allocate a minimum of 100 GB additional disk space to the Oracle
storage Automation Storage Management (Oracle ASM) disk group that is
used by the Oracle FPP Server.
Oracle FPP server Create one Grid Naming Service Virtual IP Address (GNS VIP) without
network zone delegation.
Firewall Make sure that the ports used by Oracle FPP Server and Client are not
filtered by firewalls. Please refer to Table 2-2 Fleet Patching and
Provisioning Communication Ports
Related Topics
• Oracle Grid Infrastructure Installation and Upgrade Guide for Linux
Table 2-2 Ports Open on Oracle FPP Server to Communicate with Oracle FPP Client
2-2
Chapter 2
Configuring Oracle Fleet Patching and Provisioning Server
Table 2-2 (Cont.) Ports Open on Oracle FPP Server to Communicate with Oracle FPP Client
Table 2-3 Ports Open on Oracle FPP Client to Communicate with Oracle FPP Server
Table 2-4 Ports Open on Oracle FPP Server to Communicate with Targets Without Client
2-3
Chapter 2
Configuring Oracle Fleet Patching and Provisioning Server
Table 2-5 Ports Open on Targets Without Client to Communicate with Oracle FPP Server
Table 2-6 Ports Open on Main Oracle FPP Server to Communicate with Peer Servers
Table 2-7 Ports Open on Peer Servers to Communicate With Main Oracle FPP Server
2-4
Chapter 2
Configuring Oracle Fleet Patching and Provisioning Server
Note:
When you install Oracle Grid Infrastructure, the Oracle Fleet Patching and
Provisioning Server is configured, by default, in the local mode to support the local
switch home capability. If you must configure the general Oracle Fleet Patching and
Provisioning Server product, then you must remove the current local-mode Oracle
Fleet Patching and Provisioning Server.
1. Use the Oracle ASM configuration assistant (ASMCA) to create an Oracle ASM disk
group on the Fleet Patching and Provisioning Server to store software.
$ Grid_home/bin/asmca
Because this disk group is used to store software, Oracle recommends a minimum of 100
GB for this disk group.
Note:
You must set Oracle ASM Dynamic Volume Manager (Oracle ADVM)
compatibility settings for this disk group to 19.0.
2. Provide a mount path that exists on all nodes of the cluster. The Fleet Patching and
Provisioning Server uses this path to mount gold images.
$ mkdir -p storage_path/images
4. If GIMR is not configured on your cluster, then as the grid user, add a GIMR to your
cluster.
a. For Oracle Database 19c Release Update (19.6) or earlier releases:
2-5
Chapter 2
Upgrading Oracle Fleet Patching and Provisioning Server
$ $ORACLE_HOME/bin/mgmtca createGIMRContainer [-
storageDiskLocation disk_location]
5. As the root user, add the Grid Naming Service Virtual IP Address (GNS VIP)
without zone delegation.
After you start the Fleet Patching and Provisioning Server, use the Fleet Patching and
Provisioning Control (RHPCTL) utility to further manage Fleet Patching and
Provisioning.
Related Topics
• Oracle Automatic Storage Management Administrator's Guide
• RHPCTL Command Reference
Use the Oracle Fleet Patching and Provisioning Control (RHPCTL) utility to
manage Oracle Fleet Patching and Provisioning in your cluster.
2-6
Chapter 2
Upgrading Oracle Fleet Patching and Provisioning Server
2. Add software only Oracle Grid Infrastructure 21c working copy on the Fleet Patching and
Provisioning Server 19c.
$ unset ORACLE_HOME
4. Run the upgrade gihome command from the software only Oracle Grid Infrastructure 21c
working copy using the rhpctl.sh script.
Related Topics
• Upgrading Oracle Grid Infrastructure
If you are using Fleet Patching and Provisioning, then you can use a single command to
upgrade an Oracle Grid Infrastructure home.
2-7
Chapter 2
Configuring Oracle Fleet Patching and Provisioning Clients
2. Enable the volume and the disk group on which you enabled the file system.
RHPCTL creates the client data file in the directory path you specify after the -
toclientdata flag. The name of the client data file is client_cluster_name.xml.
Note:
Oracle recommends that you specify a unique client_cluster_name
and it must match the cluster name of the client cluster where you run
step 4. If the client cluster name is not unique, then you can specify a
cluster name alias.
2. Copy the client data file that you created in the previous step to a directory on the
client cluster that has read/write permissions to the Grid home owner on the Fleet
Patching and Provisioning Client.
2-8
Chapter 2
Configuring Oracle Fleet Patching and Provisioning Clients
3. Create the Fleet Patching and Provisioning Client by running the following command as
root on the client cluster:
If you want to provision working copies to Oracle ACFS storage on this cluster, and you
have already created a disk group for this purpose, then specify this disk group in the
preceding command. In this case, also specify a storage path which will be used as a
base path for all mount points when creating Oracle ACFS file systems for storing
working copies.
Note:
Once you configure a disk group on a Fleet Patching and Provisioning Client,
you cannot remove it from or change it in the Fleet Patching and Provisioning
Client configuration. The only way you can do either (change or remove) is to
completely remove the Fleet Patching and Provisioning Client using the srvctl
remove client command, and then add it back with a different disk group, if
necessary. Before you remove a Fleet Patching and Provisioning Client, ensure
that you remove all registered users from this cluster and all working copies
provisioned on this cluster.
5. Check the status of the Fleet Patching and Provisioning Client, as follows:
Related Topics
• Oracle Clusterware Administration and Deployment Guide
• RHPCTL Command Reference
Use the Oracle Fleet Patching and Provisioning Control (RHPCTL) utility to manage
Oracle Fleet Patching and Provisioning in your cluster.
2-9
Chapter 2
Configuring Oracle Fleet Patching and Provisioning Clients
Note:
Disabling a Fleet Patching and Provisioning Client cluster does not disable
any existing working copies on the client cluster. The working copies will
continue to function and any databases in those working copies will continue
to run.
b. Delete each of the working copies listed in the output of the preceding
command.
Run the following command for each working copy and specify the name of
the working copy you want to delete:
c. Query the list of users from the Fleet Patching and Provisioning Client cluster.
Run the following command:
d. Delete the users listed in the output of the preceding command, as follows:
Run the following command and specify the name of the user you want to
delete and the name of the client:
2. On the Fleet Patching and Provisioning Client cluster, delete the client, as follows:
a. Stop the Fleet Patching and Provisioning Client daemon.
2-10
Chapter 2
Oracle Fleet Patching and Provisioning Local Mode
3. Delete the client site configuration on the Fleet Patching and Provisioning Server cluster.
Run the following command and specify the name of the client:
2-11
Chapter 2
Oracle Fleet Patching and Provisioning Local Mode
Note:
Fleet Patching and Provisioning Server 21c is started automatically when
patching command is invoked and the dependent resources are set up
during the automatic startup process.
To switch the Fleet Patching and Provisioning Server from local mode to the regular,
central mode (to manage remote targets), you must delete the current Fleet Patching
and Provisioning Server in local mode, as follows:
Proceed with the steps described in "Creating a Fleet Patching and Provisioning
Server" to create the central-mode Fleet Patching and Provisioning Server.
• The independent automaton for patching Oracle Grid Infrastructure performs all of
the steps necessary to switch from one home to another. Because the automaton
is not aware of gold images, moving the database requires two home paths, as
follows:
Use the following rhpctl move gihome command parameters for the patching
operation:
• -node: If the home you are moving is an Oracle Grid Infrastructure home installed
on more than one node, then the default operation is a rolling update on all nodes.
To apply a patch to just one node, specify the name of that node with this
parameter.
• -nonrolling: If the home you are moving is an Oracle Grid Infrastructure home
installed on more than one node, then the default operation is a rolling update on
all nodes. To patch all nodes in a nonrolling manner, use this parameter instead of
the -node parameter.
• -ignorewcpatches: By default, Fleet Patching and Provisioning will not perform
the move operation if the destination home is missing any patches present in the
source home. You can override this functionality by using this parameter, for
example, to move back to a previous source home if you must undo an update.
2-12
Chapter 2
Oracle Fleet Patching and Provisioning Local Mode
Related Topics
• Creating a Fleet Patching and Provisioning Server
The Fleet Patching and Provisioning Server uses a repository that you create in an
Oracle ACFS file system in which you store all the software homes that you want to make
available to clients and targets.
Use the following rhpctl move database command parameters for any of the patching
scenarios:
• -dbname: If the database home is hosting more than one database, you can move specific
databases by specifying a comma-delimited list with this parameter. Databases not
specified are not moved. If you do not use this parameter, then RHPCTL moves all
databases.
Note:
If you are moving a non-clustered (single-instance) database, then, for the
value of the -dbname parameter, you must specify the SID of the database
instead of the database name.
• -ignorewcpatches: By default, Oracle Fleet Patching and Provisioning will not perform
the move operation if the destination home is missing any patches present in the source
home. You can override this functionality by using this parameter, for example, to move
back to a previous source home if you must undo an update.
The following parameters apply only to clustered environments:
• -node: If the home you are moving is a database home installed on more than one node,
then the default operation is a rolling update on all nodes. To apply a patch to just one
node, specify the name of that node with this parameter.
• -nonrolling: If the home you are moving is a database home installed on more than one
node, then the default operation is a rolling update on all nodes. To patch all nodes in a
nonrolling manner, use this parameter instead of the -node parameter.
• -disconnect and -noreplay: Applies to single-instance Oracle Databases, and Oracle
RAC, and Oracle RAC One Node database. Use the -disconnect parameter to
disconnect all sessions before stopping or relocating services. If you choose to use -
disconnect, then you can choose to use the -noreplay parameter to disable session
replay during disconnection.
2-13
Chapter 2
Oracle Fleet Patching and Provisioning Local Mode
Note:
The rhpctl move database command is Oracle Data Guard-aware, and will
not run Datapatch if the database is an Oracle Data Guard standby.
Related Topics
• rhpctl move database
Moves one or more databases from a source working copy or any Oracle
Database home to a patched working copy.
2-14
3
Managing Gold Images and Working Copies
You can add new gold images to your Oracle Fleet Patching and Provisioning Server, create
working copies from the gold images, and provision Oracle homes.
• Adding Gold Images to the Fleet Patching and Provisioning Server
Use RHPCTL to add gold images for later provisioning of software.
• Provisioning Copies of Gold Images
Use RHPCTL to provision copies of gold images to Fleet Patching and Provisioning
Servers, Clients, and targets.
• Provisioning Oracle Grid Infrastructure Homes
When you create a working copy of a gold image as part of a move or upgrade operation,
Fleet Patching and Provisioning configures the operating system groups in the new
working copy to match those of the source software home.
• Provisioning Oracle Database Homes
Use the rhpctl add workingcopy command to provision a working copy of a database
home on a Fleet Patching and Provisioning Server, Client, or target.
Note:
Starting with Oracle Grid Infrastructure 19c Release Update (19.11), Oracle FPP
allows you to install the gold images without transferring them to the target host.
This feature is known as zipcopy and you can use it to provision Oracle Database
homes. You can also use this feature to provision Oracle Grid Infrastructure homes
that exists on the target hosts, but not to provision new Oracle Grid Infrastructure
homes.
You can import software to the Fleet Patching and Provisioning Server using any one of the
following methods:
3-1
Chapter 3
Adding Gold Images to the Fleet Patching and Provisioning Server
• You can import an image from an installed home on the Fleet Patching and
Provisioning Server using the following command:
The -zip parameter specifies the location from which you can import the image to
the Oracle FPP server. The -location parameter specifies a location where the
image is available on the target host as a zip file. The -location parameter also
instructs the Oracle FPP server to not copy the image-related files from the Oracle
FPP server to the target host.
You can make the image zip files available on the target hosts using either local or
shared storage. For shared storage, you can use NFS file system shared with
servers and targets. For local storage, you can copy the zip file using any option
that guarantees its consistency on the target because Oracle FPP does not verify
consistency of the zip file. You can use SFTP, SCP, or download the zip file using
curl or wget methods from a shared location. The file must be available at the
specified location.
• You can import an image from an installed home on a Fleet Patching and
Provisioning Client, using the following command run from the Fleet Patching and
Provisioning Client:
• You can create an image from an existing working copy using the following
command:
Use the first two commands in the preceding list to seed the image repository, and to
add additional images over time. Use the third command on the Oracle Fleet Patching
and Provisioning Server as part of the workflow for creating a gold image that includes
patches applied to a pre-existing gold image.
The preceding three commands also create an Oracle ACFS file system in the Oracle
Fleet Patching and Provisioning root directory, similar to the following:
/u01/rhp/images/images/RDBMS_121020617524
• Image State
Am image state is a way to restrict provisioning of an image for users with
specified roles.
3-2
Chapter 3
Adding Gold Images to the Fleet Patching and Provisioning Server
• Image Series
An image series is a convenient way to group different gold images into a logical
sequence.
• Image Type
When you add or import a gold image, you must specify an image type.
Related Topics
• Patching Oracle Database
To patch an Oracle database, you move the database home to a new home, which
includes the patches you want to implement.
• RHPCTL Command Reference
This section describes RHPCTL command usage information, and lists and describes
RHPCTL commands.
Image State
Am image state is a way to restrict provisioning of an image for users with specified roles.
You can set the state of an image to TESTABLE or RESTRICTED so that only users with the
GH_IMG_TESTABLE or GH_IMG_RESTRICT roles can provision working copies from this
image. Once the image has been tested or validated, you can change the state and make the
image available for general use by running the rhpctl promote image -image image_name
-state PUBLISHED command. The default image state is PUBLISHED when you add a new
gold image, but you can optionally specify a different state with the rhpctl add image and
rhpctl import image commands.
Image Series
An image series is a convenient way to group different gold images into a logical sequence.
Fleet Patching and Provisioning treats each image as an independent entity with respect to
other images. No relationship is assumed between images, even if they follow some specific
nomenclature. The image administrator may choose to name images in a logical manner that
makes sense to the user community, but this does not create any management grouping
within the Fleet Patching and Provisioning framework.
Use the rhpctl add series command to create an image series and associate one or more
images to this series. The list of images in an image series is an ordered list. Use the rhpctl
insertimage series and rhpctl deleteimage series to add and delete images in an image
series. You can also change the order of images in a series using these commands.
The insertimage and deleteimage commands do not instantiate or delete actual gold
images but only change the list. Also, an image can belong to more than one series (or no
series at all).
Image Type
When you add or import a gold image, you must specify an image type.
Oracle Clusterware provides the following built-in base image types:
ORACLEDBSOFTWARE
ORACLEGISOFTWARE
ORACLEGGSOFTWARE
3-3
Chapter 3
Provisioning Copies of Gold Images
EXAPATCHSOFTWARE
SOFTWARE
Every gold image must have an image type, and you can create your own image
types. A new image type must be based on one of the built-in types. The image type
directs Fleet Patching and Provisioning to apply its capabilities for managing Oracle
Grid Infrastructure and Oracle Database homes. Fleet Patching and Provisioning also
uses image type to organize the custom workflow support framework.
For example, to create an image type called DBTEST, which is based on the
ORACLEDBSOFTWARE image type:
Note:
When you create an image type that is based on an existing image type, the
new image type does not inherit any user actions (for custom workflow
support) from the base type.
Note:
Starting with Oracle Grid Infrastructure 19c Release Update (19.11), you can
add working copy as Zip files by using the -location parameter and make
the zip files available either on a local or a shared storage at the specified
location on all the targets. You must specify the -localmount parameter to
avoid transferring the image and to decompress the zip file on the local
storage.
3-4
Chapter 3
Provisioning Copies of Gold Images
• To create a working copy in a local file system on a Fleet Patching and Provisioning
Client:
• To create a working copy on a Fleet Patching and Provisioning Client from the Fleet
Patching and Provisioning Server:
• To create a working copy on the Fleet Patching and Provisioning Server using the image
file that you imported with the -zip option:
The -localmount option instructs the Oracle FPP server to skip the copy operation. The -
location option specifies where the zip image is available on the target host. By default,
Oracle FPP uses the location used to import the image.
Note:
3-5
Chapter 3
Provisioning Copies of Gold Images
• RHP_MANAGED: Choosing this value, which is available for Fleet Patching and
Provisioning Servers and Fleet Patching and Provisioning Clients, stores working
copies in an Oracle ACFS shared file system. The -path parameter is not used
with this option because Fleet Patching and Provisioning manages the storage
option.
Notes:
• LOCAL: Choosing this value stores working copies in a local file system that is not
managed by Fleet Patching and Provisioning.
When adding a database working copy, specifying a path is optional. If a path is
not specified, then a path under ORACLE_BASE is automatically chosen. This path is
displayed on the terminal.
3-6
Chapter 3
Provisioning Copies of Gold Images
In cases where you specify the -path parameter, if the file system is shared among all of the
nodes in the cluster, then the working copy gets created on this shared storage. If the file
system is not shared, then the working copy gets created in the location of the given path on
every node in the cluster.
Note:
The directory you specify in the -path parameter must be empty.
Related Topics
• rhpctl add workingcopy
Creates a working copy on a client cluster.
Note:
The default user is the user as which the RHPCTL command is being run.
When the provisioning is completed, all files and directories of the provisioned software are
owned by the user you specified. Permissions on files on the remotely provisioned software
are the same as the permissions that existed on the gold image from where you provisioned
the application software.
3-7
Chapter 3
Provisioning Copies of Gold Images
configured in the source home match those in the destination home. Fleet Patching
and Provisioning configures the groups as part of the add operation.
When you create a gold image of either the ORACLEGISOFTWARE or the
ORACLEDBSOFTWARE image type from a source software home (using the rhpctl
import image command) or from a working copy (using the rhpctl add image
command), the gold image inherits the Oracle user groups that were configured in the
source. You cannot override this feature.
You can define user groups for ORACLEGISOFTWARE and ORACLEDBSOFTWARE
working copies using the rhpctl add workingcopy command, depending on the
image type and user group, as discussed in the subsequent sections.
This section describes how Fleet Patching and Provisioning manages user group
configuration, and how the -groups command-line option of rhpctl add workingcopy
functions.
If you are provisioning only the Oracle Grid Infrastructure software using the -
softwareonly command parameter, then you cannot use the -groups parameter, and
Fleet Patching and Provisioning obtains OSDBA and OSASM user group information
from the active Grid home.
If you use the -local command parameter (which is only valid when you use the -
softwareonly command parameter) with rhpctl add workingcopy, then Fleet
Patching and Provisioning takes the values of the groups from the command line
(using the -groups parameter) or uses the default values, which Fleet Patching and
Provisioning obtains from the osdbagrp binary of the gold image.
If none of the preceding applies, then Fleet Patching and Provisioning uses the
installer default user group.
If you are provisioning and configuring a working copy using information from a
response file, then Fleet Patching and Provisioning:
1. Uses the value of the user group from the command line, if provided, for OSDBA
or OSASM, or both.
2. If you provide no value on the command line, then Fleet Patching and Provisioning
retrieves the user group information defined in the response file.
If you are defining the OSOPER Oracle group, then, again, you can either use the -
softwareonly command parameter or use a response file with the rhpctl add
workingcopy command.
If you use the -softwareonly command parameter, then you can provide the value on
the command line (using the -groups parameter) or leave the user group undefined.
3-8
Chapter 3
Provisioning Oracle Grid Infrastructure Homes
If you are provisioning and configuring a working copy of a gold image using information from
a response file, then you can provide the value on the command line, use the information
contained in the response file, or leave the OSOPER Oracle group undefined.
If any group picked up from the osdbagrp binary is not in the list of groups to which the
database user belongs (given by the id command), then Fleet Patching and Provisioning
uses the installer default user group. Otherwise, the database user is the user running the
rhpctl add workingcopy command.
3-9
Chapter 3
Provisioning Oracle Grid Infrastructure Homes
Oracle Fleet Patching and Provisioning also has commands for managing Oracle Grid
Infrastructure homes, such as switching to a patched home or upgrading to a new
Oracle Grid Infrastructure version. These are both single commands that orchestrate
the numerous steps involved. Reverting to the original home is just as simple. Also,
Oracle Fleet Patching and Provisioning can add or delete nodes from an Oracle Grid
Infrastructure configuration.
• About Deploying Oracle Grid Infrastructure Using Oracle Fleet Patching and
Provisioning
You can use Oracle Fleet Patching and Provisioning to provision and maintain
your Oracle Grid Infrastructure homes.
• Provisioning Oracle Grid Infrastructure Software
Fleet Patching and Provisioning has several methods to provision and, optionally,
configure Oracle Grid Infrastructure and Oracle Restart grid infrastructure homes.
• Provisioning Oracle Grid Infrastructure 21c With GIMR Configured
You can use Oracle Fleet Patching and Provisioning to provision Oracle Grid
infrastructure that has Grid Infrastructure Management Repository (GIMR)
configured.
3-10
Chapter 3
Provisioning Oracle Grid Infrastructure Homes
The preceding command provisions the GI_HOME_11204_WCPY working copy based on the
GI_HOME_11204 gold image to a target specified in the GI_11204_install.txt response
file. In addition to identifying the target nodes, the response file specifies information
about the Oracle Grid Infrastructure configuration, such as Oracle ASM and GNS
parameters.
3-11
Chapter 3
Provisioning Oracle Grid Infrastructure Homes
Note:
The oracle.install.crs.rootconfig.executeRootScript=xxx
response file parameter is overridden and always set to false for Fleet
Patching and Provisioning, regardless of what you specify in the
response file.
Related Topics
• Authentication Options for Oracle Fleet Patching and Provisioning Operations
Some RHPCTL commands show authentication choices as an optional parameter.
3-12
Chapter 3
Provisioning Oracle Database Homes
4. Add the Oracle Database working copy with the rhpctl add workingcopy command.
The owner of the database working copy must be the same as the owner of the Oracle
Grid Infrastructure working copy.
5. Add the GIMR database to the database working copy with the rhpctl add database
command using the -gimr flag.
Note:
This use of the rhpctl add database command is only used by GIMR, and
cannot be used to provision customer databases.
The preceding command example creates a working copy named wc_db122_1 on all
nodes of the Fleet Patching and Provisioning Client cluster named client_007. The gold
image db12c is the source of the workingcopy. The directory path locations that you
specify in the command must be empty.
Related Topics
• rhpctl add workingcopy
3-13
4
Patching and Upgrading Oracle Grid
Infrastructure
The Oracle Fleet Patching and Provisioning Server provides an efficient and secure platform
for patching and upgrading Oracle Grid Infrastructure.
• Patching Oracle Grid Infrastructure
Fleet Patching and Provisioning provides three methods to patch Oracle Grid
Infrastructure software homes: rolling, non-rolling, and in batches.
• Upgrading Oracle Grid Infrastructure
If you are using Fleet Patching and Provisioning, then you can use a single command to
upgrade an Oracle Grid Infrastructure home.
• Oracle Restart Patching and Upgrading
You can use Oracle Fleet Patching and Provisioning to patch and upgrade Oracle Restart
using gold images.
4-1
Chapter 4
Patching Oracle Grid Infrastructure
The preceding command moves the running Oracle Grid Infrastructure home from
the current managed home (the sourcewc) to the patched home (destwc) on the
specific client cluster. The patched home must be provisioned on the client.
• If the move operation fails at some point before completing, then you can rerun the
operation by running the command again and the operation will resume where it
left off. This enables you to fix whatever problem caused the failure and resume
processing from the point of failure. Or you can undo the partially completed
operation and return the configuration to its initial state, as follows:
4-2
Chapter 4
Patching Oracle Grid Infrastructure
Notes:
• You cannot move the Grid home to a home that Fleet Patching and Provisioning
does not manage. Therefore, rollback (to the original home) applies only to
moves between two working copies. This restriction does not apply when using
the independent automaton since it operates on unmanaged homes only.
• You can delete the source working copy at any time after moving a Grid home.
Once you delete the working copy, however, you cannot perform a rollback.
Also, use the rhpctl delete workingcopy command (as opposed to rm, for
example) to remove the source working copy to keep the Fleet Patching and
Provisioning inventory correct.
• If you use the -abort parameter to terminate the patching operation, then Fleet
Patching and Provisioning does not clean up or undo any of the patching steps.
The cluster, databases, or both may be in an inconsistent state because all
nodes are not patched.
Note:
You cannot patch both Oracle Grid Infrastructure and Oracle Database in
combination, with the independent automaton.
The following optional parameters of the rhpctl move gihome command are relevant to the
combined Oracle Grid Infrastructure and Oracle Database patching use case:
• -auto: Automatically patch databases along with patching Oracle Grid Infrastructure
• -dbhomes mapping_of_Oracle_homes: Mapping of source and destination working copies
in the following format:
sourcewc1=destwc1,...,source_oracle_home_path=destwcN
4-3
Chapter 4
Patching Oracle Grid Infrastructure
• GI121WC1: The active Grid home on the Oracle Grid Infrastructure 12c release 1
(12.1.0.2) cluster
• GI121WC2: A software-only Grid home on the Oracle Grid Infrastructure 12c release
1 (12.1.0.2) cluster
• DB121WC1: An Oracle RAC 12c release 1 (12.1.0.2.0) database home running
database instances
• DB121025WC1: An Oracle RAC 12c release 1 (12.1.0.2.5) database home with no
database instances (this is the patched home)
• DB112WC1: An Oracle RAC 11g release 2 (11.2.0.4.0) database home running
database instances
• DB112045WC1: An Oracle RAC 11g release 2 (11.2.0.4.5) database home with no
database instances (this is the patched home)
Further assume that you want to simultaneously move
• Oracle Grid Infrastructure from working copy GI121WC1 to working copy GI121WC2
• Oracle RAC Database db1 from working copy DB121WC1 to working copy
DB121025WC1
• Oracle RAC Database db2 in working copy DB112WC1 to working copy DB112045WC1
The following single command accomplishes the moves:
4-4
Chapter 4
Patching Oracle Grid Infrastructure
Notes:
• If you have an existing Oracle home that is not currently a working copy, then
specify the Oracle home path instead of the working copy name for the source
home. In the preceding example, if the Oracle home path for an existing
12.1.0.2 home is /u01/app/prod/12.1.0.2/dbhome1, then replace
DB121WC1=DB121025WC1 with /u01/app/prod/12.1.0.2/dbhome1=DB121025WC1.
• If the move operation fails at some point before completing, then you can either
resolve the cause of the failure and resume the operation by rerunning the
command, or you can undo the partially completed operation by issuing the
following command, which restores the configuration to its initial state:
In the preceding command example, the Oracle Grid Infrastructure 12c release 1 (12.1.0.2)
Grid home moves from working copy GI121WC1 to working copy GI121WC2, databases running
on working copy DB121WC1 move to working copy DB121025WC1, and databases running on
working copy DB112WC1 move to working copy DB112045WC1.
Related Topics
• rhpctl move gihome
Moves the Oracle Grid Infrastructure software stack from one home to another.
4-5
Chapter 4
Upgrading Oracle Grid Infrastructure
Note:
You can use zero-downtime patching only for out-of-place patching of Oracle
Grid Infrastructure 19c Release Update (RU) 19.8 or later releases with
Oracle RAC or Oracle RAC One Node databases of 19c or later releases. If
your Oracle RAC or Oracle RAC One Node database release is older than
19c, then the database instances stop during zero-downtime patching.
To enable zero-downtime Oracle Grid Infrastructure patching, use the rhpctl move
gihome command in a manner similar to the following:
To update the Grid Infrastructure OS system software on a single node, you must
completely stop the Grid Infrastructure software. To stop the Grid Infrastructure
software, you must stop the Oracle RAC databases on the single node. After stopping
the Oracle RAC databases, run root.sh -updateosfiles to update all the Grid
Infrastructure OS system software on the single node.
4-6
Chapter 4
Upgrading Oracle Grid Infrastructure
After provisioning a working copy version of Oracle Grid Infrastructure 21c (named GIOH21C in
this example) and GIMR (named GIMROH21c in this example), you can upgrade to that
working copy with this single command:
If the cluster that you are upgrading has a local GIMR, then follow the steps in the
Provisioning an Oracle Grid infrastructure 21c with GIMR configured section.
Fleet Patching and Provisioning is able to identify the cluster to upgrade based on the name
of the source working copy. If the target cluster was running on an unmanaged Oracle Grid
Infrastructure home, then you would specify the path of the source home rather than
providing a source working copy name, and you must also specify the target cluster.
Note:
You can delete the source working copy at any time after completing an upgrade.
Once you delete the working copy, however, you cannot perform a rollback. Also,
use the rhpctl delete workingcopy command (as opposed to rm, for example) to
remove the source working copy to keep the Fleet Patching and Provisioning
inventory correct.
4-7
Chapter 4
Oracle Restart Patching and Upgrading
5. Upgrade both the Oracle Grid Infrastructure and GIMR homes with a single rhpctl
upgrade gihome command using the -gimrwc gimr_wc option, where gimr_wc
specifies the working copy created in the previous step (step 4).
Related Topics
• Oracle Fleet Patching and Provisioning Self-upgrade
Perform these steps when upgrading Oracle Grid Infrastructure from 19c to 21c
using the Oracle Fleet Patching and Provisioning (Oracle FPP) self-upgrade
feature.
Use the RHPCTL utility similar to the following to upgrade Oracle Restart:
4-8
5
Patching and Upgrading Oracle Database
The Oracle Fleet Patching and Provisioning Server provides an efficient and secure platform
for patching and upgrading Oracle Database.
• Creating an Oracle Database
Create an Oracle Database on a working copy.
• Patching Oracle Database
To patch an Oracle database, you move the database home to a new home, which
includes the patches you want to implement.
• Upgrading Oracle Database
Fleet Patching and Provisioning provides two options for upgrading Oracle Database.
Both options are performed with a single command.
• Zero-Downtime Upgrade
Using Oracle Fleet Patching and Provisioning, which automates and orchestrates
database upgrades, you can upgrade an Oracle RAC or Oracle RAC One Node database
with no disruption in service.
5-1
Chapter 5
Patching Oracle Database
Note:
When you create a database using Fleet Patching and Provisioning, the
feature uses random passwords for both the SYS and SYSTEM schemas in
the database and you cannot retrieve these passwords. A user with the DBA
or operator role must connect to the database, locally, on the node where it is
running and reset the passwords to these two accounts.
For information about patching using batches, refer to Patching Oracle Grid
Infrastructure and Oracle Database Using Batches.
5-2
Chapter 5
Patching Oracle Database
Note:
Part of the patching process includes applying Datapatch. When you move an
Oracle Database 12c release 1 (12.1) or higher, Fleet Patching and Provisioning
completes this step for you. When you move to a version previous to Oracle
Database 12c release 1 (12.1), however, you must run Datapatch manually. Fleet
Patching and Provisioning is Oracle Data Guard-aware, and will not apply
Datapatch to Oracle Data Guard standbys.
Note:
The working copy you specify in the preceding command must be hosted on
the Fleet Patching and Provisioning Server in Fleet Patching and Provisioning-
managed storage.
5. Delete the patched working copy with the patched Oracle Database using the rhpctl
delete workingcopy command.
Note:
Do not remove directly using the rm command or some other method, because
this does not update the Fleet Patching and Provisioning inventory information.
Related Topics
• Patching Oracle Grid Infrastructure
• Provisioning Copies of Gold Images
• Adding Gold Images to the Fleet Patching and Provisioning Server
• RHPCTL Command Reference
5-3
Chapter 5
Upgrading Oracle Database
Note:
The version of Oracle Grid Infrastructure on which the pre-upgrade database
is running must be the same version or higher than the version of the
database to which you are upgrading.
The destination for the upgrade can be a working copy already provisioned, or you can
choose to create the working copy of gold image as part of this operation.
The pre-upgrade database can be running on a working copy (a managed home that
was provisioned by Fleet Patching and Provisioning) or on an unmanaged home. In
the first case, you can roll back the upgrade process with a single RHPCTL command.
Note:
You can delete the source working copy at any time after completing an
upgrade. Once you delete the working copy, however, you cannot perform a
rollback. Also, use the rhpctl delete workingcopy command (as opposed
to rm, for example) to remove the source working copy to keep the Fleet
Patching and Provisioning inventory correct.
5-4
Chapter 5
Zero-Downtime Upgrade
Note:
A general Oracle Database upgrade requires you to run Oracle Database Upgrade
Assistant (DBUA), but you can use the autoupg option with the rhpctl upgrade
database command to automate the upgrade.
Related Topics
• rhpctl upgrade database
• rhpctl zdtupgrade database
• Using AutoUpgade for Oracle Database Upgrades
Zero-Downtime Upgrade
Using Oracle Fleet Patching and Provisioning, which automates and orchestrates database
upgrades, you can upgrade an Oracle RAC or Oracle RAC One Node database with no
disruption in service.
Note:
A multitenant container database is the only supported architecture in Oracle
Database 21c. While the documentation is being revised, legacy terminology may
persist. In most cases, "database" and "non-CDB" refer to a CDB or PDB,
depending on context. In some contexts, such as upgrades, "non-CDB" refers to a
non-CDB from a previous release.
The zero-downtime upgrade process is resumable, restartable, and recoverable should any
errors interrupt the process. You can fix the issue then re-run the command, and Oracle Fleet
Patching and Provisioning continues from the error point. Oracle also provides hooks at the
beginning and end of the zero-downtime upgrade process, allowing call outs to user-defined
scripts, so you can customize the process.
You can use the zero-downtime upgrade process to upgrade databases that meet the
following criteria:
• Database upgrade targets: Oracle RAC and Oracle RAC One Node, with the following
upgrade paths:
11.2.0.4 to: 12.1.0.2, 12.2, 18c
12.1.0.2 to: 12.2, 18c - 21c
12.2 to: 18c - 21c
18c to: 19c - 21c
19c to: 21c
• Oracle Fleet Patching and Provisioning management: The source database home
can either be unmanaged (not provisioned by Oracle Fleet Patching and Provisioning
service) or managed (provisioned by Oracle Fleet Patching and Provisioning service)
• Database state: The source database must be in archive log mode
5-5
Chapter 5
Zero-Downtime Upgrade
5-6
Chapter 5
Zero-Downtime Upgrade
Note:
You can download the Oracle GoldenGate software for your platform from
Oracle eDelivery. The Oracle GoldenGate 12.3 installable kit contains the
required software for both Oracle Database 11g and Oracle Database 12c
databases.
If you download the Oracle GoldenGate software, then extract the software home and
perform a software only installation on the Fleet Patching and Provisioning Server.
Create gold images of the Oracle GoldenGate software for both databases, as follows:
In both of the preceding commands, path refers to the location of the Oracle GoldenGate
software home on the Fleet Patching and Provisioning Server for each release of the
database.
2. Prepare the target database.
Provision working copies of the Oracle GoldenGate software to the cluster hosting the
database, as follows:
If the database is hosted on the Fleet Patching and Provisioning Server, itself, then
neither the -targetnode nor -client parameters are required.
Note:
Working copy names must be unique, therefore you must use a different
working copy name on subsequent targets. You can create unique working
copy names by including the name of the target/client cluster name in the
working copy name.
3. Provision a working copy of the Oracle Database 12c software home to the target cluster.
5-7
Chapter 5
Zero-Downtime Upgrade
Note:
You can do this preparation ahead of the maintenance window without
disrupting any operations taking place on the target.
• You can run the upgrade command on the Fleet Patching and Provisioning Server
to upgrade a database hosted on the server, an Oracle Database 12c release 1
(12.1.0.2) target cluster, or a database hosted on a Fleet Patching and
Provisioning Client 12c release 2 (12.2.0.1) or 18c. You can also run the command
a Fleet Patching and Provisioning Client 18c to upgrade a database hosted on the
client, itself.
Use the upgrade command similar to the following:
5-8
Chapter 5
Zero-Downtime Upgrade
Gold Image stored on the Fleet Patching and Provisioning Server named
rhps.example.com):
5-9
Chapter 5
Zero-Downtime Upgrade
5-10
Chapter 5
Zero-Downtime Upgrade
You can specify run-time input to the plugins using the -useractiondata option of the
rhpctl zdtupgrade database command.
5-11
6
Updating Oracle Exadata Infrastructure
The Oracle Fleet Patching and Provisioning Server provides an efficient and secure platform
for updating Oracle Exadata Infrastructure.
• Updating Oracle Exadata Cell Server
Update Oracle Exadata Cell server or storage sever by importing and deploying a new
Cell server gold image.
• Rolling Back Oracle Exadata Cell Server Patch
Use this procedure to rollback an Oracle Exadata Cell server or storage sever patch, in
case of a failure or an error.
• Updating Oracle Exadata Database Node
Update Oracle Exadata Database nodes by importing and deploying a new database
gold image.
• Rolling Back Oracle Exadata Database Node Patch
Use this procedure to rollback an Oracle Exadata database node patch, in case of a
failure or an error.
• Combined Oracle Exadata Database Node and Grid Infrastructure Update
With combined Oracle Exadata database node and Oracle Grid Infrastructure update you
can utilize the functionality of multiple independent capabilities.
• Updating Oracle Exadata InfiniBand Switches
Update Oracle Exadata InfiniBand switches by importing and deploying a new InfiniBand
switch gold image.
• Downgrading Oracle Exadata InfiniBand Switches Patch
Use this procedure to downgrade an Oracle Exadata InfiniBand switch patch, in case of a
failure or an error.
6-1
Chapter 6
Rolling Back Oracle Exadata Cell Server Patch
When you import a Cell server image with this command, the version parameter
must be the version of the Cell server software required by the patchmgr on the
node. The path parameter should contain Cell server update zip files.
2. Deploy the Oracle Exadata Cell server image to the client cluster.
The following command deploys an Oracle Exadata Cell server image to a client
cluster. In the example, image specifies the name of the Oracle Exadata Cell
server image that you want to deploy, client specifies the name of the cluster to
which you want to deploy the image, and path specifies the absolute path location
for deploying the Oracle Exadata Cell server image on the target or client side.
3. Check the current version of the Oracle Exadata Cell server patch to make sure
that the rollback is successful.
6-2
Chapter 6
Updating Oracle Exadata Database Node
When you import an Oracle Exadata software home with this command, the version
parameter must be the version of the Oracle Exadata software required by the patchmgr
on the database node. The path parameter should contain Oracle Exadata update zip
files.
2. Deploy the Oracle Exadata Database node image to the client cluster.
The following command deploys an Oracle Exadata image to a client cluster. In the
example, image specifies the name of the Oracle Exadata image that you want to deploy,
client specifies the name of the cluster to which you want to deploy the image, and path
specifies the absolute path location for deploying the Oracle Exadata software home on
the target or client side.
The targetnode parameter is required if the node hosting the home is not a Oracle Fleet
Patching and Provisioning Client. If the target node or client option is not specified, then
the Oracle Exadata image is deployed to the Oracle Fleet Patching and Provisioning
Server.
3. Evaluate the current configuration and perform pre-upgrade checks.
The following command evaluates the current configuration and performs pre-upgrade
checks. In the example, image specifies the name of the Oracle Exadata image that you
want to use for update, iso_repo specifies the image in the ISO repository, pathmgrloc
specifies the patch manager location, client specifies the name of the cluster in which
you want to update database nodes, and batches specifies a comma-delimited list of
batches of nodes where each batch is a comma-delimited list of node names enclosed in
parentheses and node names are enclosed in double quotation marks ("") in the format:
"(nA,nB,...),(...,nY,nZ)".
6-3
Chapter 6
Rolling Back Oracle Exadata Database Node Patch
• If you do not specify the list of nodes for -dbnodes, then Oracle FPP
automatically discovers all active database nodes in the cluster.
• If the client option is not specified when issuing the command, then database
node update is performed on the Oracle Fleet Patching and Provisioning
Server.
4. Create a backup of the current configuration.
3. Check the current version of the Oracle Exadata database node patch to make
sure that the rollback is successful.
6-4
Chapter 6
Combined Oracle Exadata Database Node and Grid Infrastructure Update
into a single integrated patching process that requires only one sequence of shutdown and
startup of database instances on each node. The combined patching on multiple nodes in
batches further brings down the overall patching window.
Oracle FPP internally uses the patchmgr tool to patch Exadata database nodes. The
combined patching method uses an integrated flow of the inherent Oracle FPP
implementation for Oracle Grid Infrastructure patching and then invokes the patchmgr tool to
patch each Exadata database node.
To complete combined Oracle Exadata database node and Oracle Grid Infrastructure
patching, you must perform the operations discussed in the following:
• Creating the Oracle Exadata Image
• Deploying the Oracle Exadata Update Image
• Combined Oracle Grid Infrastructure Move and Database Node Update
Note:
Creating and deploying an Oracle Exadata image does not require any downtime
and you can perform both these operations before patching Oracle Grid
Infrastructure and Oracle Exadata database. You need to create an Oracle Exadata
image on the Oracle FPP server only once in a patching cycle, however, you need
to deploy Oracle Exadata image, and patch Oracle Grid Infrastructure and Oracle
Exadata database node on each target system.
When you import an Oracle Exadata software home with this command, the version
parameter must be the version of the Oracle Exadata software required by the patchmgr on
the database node. The path parameter should contain Oracle Exadata update zip files.
See Also:
rhpctl import image for the complete syntax of the rhpctl import image command
6-5
Chapter 6
Combined Oracle Exadata Database Node and Grid Infrastructure Update
The targetnode parameter is required if the node hosting the home is not a Oracle
Fleet Patching and Provisioning Client. If the target node or client option is not
specified, then the Oracle Exadata image is deployed to the Oracle Fleet Patching and
Provisioning Server.
See Also:
rhpctl deploy image for the complete syntax of the rhpctl deploy image
command
6-6
Chapter 6
Updating Oracle Exadata InfiniBand Switches
With each invocation of the rhpctl move gihome command, FPP patches the database node
first and then patches Oracle Grid Infrastructure. This is the processing order for each node
in the specified batch.
If the first batch includes more than one database node, then FPP invokes patchmgr in
parallel for all the nodes. As soon as a node completes the patchmgr operation, including the
post patchmgr operations, FPP starts the Oracle Grid Infrastructure patching on that node.
When the Oracle Grid Infrastructure patching completes on this node, FPP then begins
patching with Oracle Grid Infrastructure patching on the other nodes when the database node
patching completes on those nodes.
If rebooting a node is delayed because of a patchmgr failure or a patchmgr operation timeout,
the rhpctl move gihome command can be resumed after the node is back up.
See Also:
rhpctl move gihome for the complete syntax of the rhpctl move gihome command
1. Evaluate the current configuration and perform pre-upgrade checks for InfiniBand
switches.
The following command evaluates the current configuration and performs pre-upgrade
checks. In the example, image specifies the name of the Oracle Exadata InfiniBand
switch image that you want to use for update, client specifies the name of the cluster in
which you want to update database nodes, and batches specifies a comma-delimited list
of batches of nodes where each batch is a comma-delimited list of node names enclosed
in parentheses and node names are enclosed in double quotation marks ("") in the
format: "(nA,nB,...),(...,nY,nZ)".
6-7
Chapter 6
Downgrading Oracle Exadata InfiniBand Switches Patch
4. Check the current version of the Oracle Exadata InfiniBand switch patch to make
sure that the downgrade is successful.
6-8
7
Fleet Patching and Provisioning
Postinstallation Tasks
Complete these postinstallation tasks after you configure Oracle Fleet Patching and
Provisioning Server.
• Oracle Fleet Patching and Provisioning Security Postinstallation Tasks
Perform these postinstallation tasks to make your Oracle Fleet Patching and Provisioning
Server secure.
• Advanced Oracle Fleet Patching and Provisioning Configurations
Use these advanced configurations of Oracle Fleet Patching and Provisioning Server to
perform specialized tasks.
• Error Prevention and Automated Recovery Options
Fleet Patching and Provisioning has error prevention and automated recovery options to
assist you during maintenance operations.
• Fleet Patching and Provisioning Logs and Trace Files
Use Oracle Fleet Patching and Provisioning logs and traces to obtain more information
for identifying and debugging Oracle FPP Server and client errors.
7-1
Chapter 7
Oracle Fleet Patching and Provisioning Security Postinstallation Tasks
Note:
The steps to create that equivalence are platform-dependent and so not
shown in detail here. For Linux, see commands ssh-keygen to be run on the
target and ssh-copy-id to be run on the Oracle Fleet Patching and
Provisioning Server.
For example, assuming that you have established user equivalency between crsusr
on the Oracle Fleet Patching and Provisioning Server and root on the target node,
nonRHPClient4004.example.com, and saved the key information on the Oracle Fleet
Patching and Provisioning Server at /home/oracle/rhp/ssh-key/key -path,
then the following command will provision a copy of the specified gold image to the
target node with passwordless authentication:
7-2
Chapter 7
Oracle Fleet Patching and Provisioning Security Postinstallation Tasks
For equivalency between crsusr on the Oracle Fleet Patching and Provisioning Server and a
privileged user (other than root) on the target, the -auth portion of the command would be
similar to the following:
Related Topics
• rhpctl add credentials
• rhpctl delete credentials
• rhpctl add workingcopy
Creates a working copy on a client cluster.
7-3
Chapter 7
Oracle Fleet Patching and Provisioning Security Postinstallation Tasks
• GH_IMG_USER: A role that enables users to create an image using the rhpctl
add | import image commands. Users assigned this role do not have
administrative privileges and can only delete images that they create.
• GH_IMG_TESTABLE: A role that enables users to add a working copy of an
image that is in the TESTABLE state. Users assigned this role must also be
assigned either the GH_WC_ADMIN role or the GH_WC_USER role to add a
working copy.
• GH_IMG_RESTRICT: A role that enables users to add a working copy from an
image that is in the RESTRICTED state. Users assigned this role must also be
assigned either the GH_WC_ADMIN role or the GH_WC_USER role to add a
working copy.
• GH_IMG_PUBLISH: Users assigned this role can promote an image to another
state or retract an image from the PUBLISHED state to either the TESTABLE or
RESTRICTED state.
• GH_IMG_VISIBILITY: Users assigned this role can modify access to promoted or
published images using the rhpctl allow | disallow image commands.
• GH_AUTHENTICATED_USER: Users assigned to this role can execute any
operation in an Oracle Fleet Patching and Provisioning Client.
• GH_CLIENT_ACCESS: Any user created automatically inherits this role. The
GH_CLIENT_ACCESS role includes the GH_AUTHENTICATED_USER built-in role.
• GH_ROOT_UA_CREATE: A role that enables users to create a root user action.
Users assigned this role can run the rhpctl add useraction command with the -
runasroot option.
• GH_ROOT_UA_ASSOCIATE: A role that enables users to associate a root user
action with the -imagetype option. Users assigned this role can associate an
existing root user action to an image type.
• GH_ROOT_UA_USE: A role that enables users to execute a root user action
within the operation selected at user action creation.
7-4
Chapter 7
Oracle Fleet Patching and Provisioning Security Postinstallation Tasks
GH_IMG_USER. Users assigned this role can delete only images that they have created.
Consider a gold image called G1 that is available on the Oracle Fleet Patching and
Provisioning Server.
Further consider that a user, U1, on an Oracle Fleet Patching and Provisioning Client, Cl1,
has the GH_WC_USER role. If U1 requests to provision an Oracle home based on the gold
image G1, then U1 can do so, because of the permissions granted by the GH_WC_USER
role. If U1 requests to delete G1, however, then that request would be denied because the
GH_WC_USER role does not have the necessary permissions.
The Oracle Fleet Patching and Provisioning Server can associate user-role mappings to the
Oracle Fleet Patching and Provisioning Client. After the Oracle Fleet Patching and
Provisioning Server delegates user-role mappings, the Oracle Fleet Patching and
Provisioning Client can then modify user-role mappings on the Oracle Fleet Patching and
Provisioning Server for all users that belong to the Oracle Fleet Patching and Provisioning
Client. This is implied by the fact that only the Oracle Fleet Patching and Provisioning Server
qualifies user IDs from an Oracle Fleet Patching and Provisioning Client site with the client
cluster name of that site. Thus, the Oracle Fleet Patching and Provisioning Client CL1 will not
be able to update user mappings of a user on CL2, where CL2 is the cluster name of a
different Oracle Fleet Patching and Provisioning Client.
• Creating Users and Assigning Roles for Fleet Patching and Provisioning Client Cluster
Users
Oracle Fleet Patching and Provisioning (Oracle FPP) enables you to create users and
assign roles to them when you create an Oracle FPP client.
Creating Users and Assigning Roles for Fleet Patching and Provisioning Client
Cluster Users
Oracle Fleet Patching and Provisioning (Oracle FPP) enables you to create users and assign
roles to them when you create an Oracle FPP client.
When you create a Fleet Patching and Provisioning Client with the rhpctl add client
command, you can use the -maproles parameter to create users and assign roles to them.
You can associate multiple users with roles, or you can assign a single user multiple roles
with this command.
Note:
Starting with Oracle Grid Infrastructure 21c, the -maproles parameter is
deprecated. This parameter can be desupported in a future release.
After the client has been created, you can add and remove roles for users using the rhpctl
grant role command and the rhpctl revoke role, respectively.
7-5
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
1. Run the following command on the Fleet Patching and Provisioning Server cluster
to generate a new password and store it in the client credential:
$ rhpctl modify client -client client_name -password
2. Run the following command on the Fleet Patching and Provisioning Server cluster
to generate a credential file:
$ rhpctl export client -client client_name -clientdata file_path
For example, to generate a credential file for a Fleet Patching and Provisioning
Client named mjk9394:
$ rhpctl export client -client mjk9394 -clientdata /tmp/mjk9394.xml
3. Continuing with the preceding example, transport the generated credential file
securely to the Fleet Patching and Provisioning Client cluster and then run the
following command on any node in the Fleet Patching and Provisioning Client
cluster:
$ srvctl modify rhpclient -clientdata path_to_mjk9394.xml
4. Restart the Fleet Patching and Provisioning Client daemon by running the
following commands on the Fleet Patching and Provisioning Client cluster:
$ srvctl stop rhpclient
$ srvctl start rhpclient
7-6
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
User-Defined Actions
You can create actions for various Oracle Fleet Patching and Provisioning operations, such
as import image, add and delete working copy, and add, delete, move, and upgrade a
software home.
You can create actions for various Oracle Fleet Patching and Provisioning operations, such
as import image, add and delete working copy of a gold image, and add, delete, move, and
upgrade a software home. You can define different actions for each operation, which can be
further differentiated by the type of image to which the operation applies. User-defined
actions can be run before or after a given operation, and are run on the deployment on which
the operation is run, whether it be an Oracle Fleet Patching and Provisioning Server, an
Oracle Fleet Patching and Provisioning Client (12c release 2 (12.2), or later), or a target that
is not running an Oracle Fleet Patching and Provisioning Client.
User-defined actions are shell scripts which are stored on the Oracle Fleet Patching and
Provisioning Server. When a script runs, it is given relevant information about the operation
on the command line. Also, you can associate a file with the script. The Oracle Fleet Patching
and Provisioning Server will copy that file to the same location on the Client or target where
the script is run.
For example, perhaps you want to create user-defined actions that are run after a database
upgrade, and you want to define different actions for Oracle Database 11g and 12c. This
requires you to define new image types, as in the following example procedure.
1. Create a new image type, (DB11IMAGE, for example), based on the
ORACLEDBSOFTWARE image type, as follows:
When you add or import an Oracle Database 11g gold image, you specify the image type
as DB11IMAGE.
2. Define a user action and associate it with the DB11IMAGE image type and the upgrade
operation. You can have different actions that are run before or after upgrade.
3. To define an action for Oracle Database 12c, create a new image type (DB12IMAGE, for
example) that is based on the ORACLEDBSOFTWARE image type, as in the preceding
step, but with the DB12IMAGE image type.
7-7
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
Note:
If you define user actions for the base type of a user-defined image type
(in this case the base type is ORACLEDBSOFTWARE), then Oracle
Fleet Patching and Provisioning performs those actions before the
actions for the user-defined image type.
You can modify the image type of an image using the rhpctl modify image
command. Additionally, you can modify, add, and delete other actions. The following
two tables, Table 7-1 and Table 7-2, list the operations you can customize and the
parameters you can use to define those operations, respectively.
7-8
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
7-9
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
Parameter Description
RHP_OPTYPE The operation type for which the user action is being
executed, as listed in the previous table.
RHP_PHASE This parameter indicates whether the user action is
executed before or after the operation (is either PRE or
POST).
RHP_SOURCEWC The source working copy name for a patch of upgrade
operation.
RHP_SOURCEPATH The path of the source working copy home.
RHP_DESTINATIONWC The destination working copy name for a patch or upgrade
operation.
RHP_DESTINATIONPATH The path of the destination working copy home.
RHP_SRCGGWC The name of the version of the Oracle GoldenGate working
copy from which you want to upgrade.
RHP_SRCGGPATH The absolute path of the version of the Oracle GoldenGate
software home from which you want to upgrade.
RHP_DESTGGWC The name of the version of the Oracle GoldenGate working
copy to which you want to upgrade.
7-10
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
Parameter Description
RHP_DESTGGPATH The absolute path of the version of the Oracle GoldenGate
software home to which you want to upgrade.
RHP_PATH This is the path to the location of the software home. This
parameter represents the path on the local node from where
the RHPCTL command is being run for an IMPORT_IMAGE
operation. For all other operations, this path is present on
the site where the operation is taking place.
RHP_PATHOWNER The owner of the path for the gold image that is being
imported.
RHP_PROGRESSLISTENERHOST The host on which the progress listener is listening. You can
use this parameter, together with a progress listener port, to
create a TCP connection to print output to the console on
which the RHPCTL command is being run.
RHP_PROGRESSLISTENERPORT The port on which the progress listener host is listening. You
can use this parameter, together with a progress listener
host name, to create a TCP connection to print output to the
console on which the RHPCTL command is being run.
RHP_IMAGE The image associated with the operation. In the case of a
move operation, it will reflect the name of the destination
image.
RHP_IMAGETYPE The image type of the image associated with the operation.
In the case of a move operation, it will reflect the name of
the destination image.
RHP_VERSION The version of the Oracle Grid Infrastructure software
running on the Oracle Fleet Patching and Provisioning
Server.
RHP_CLI The exact command that was run to invoke the operation.
RHP_STORAGETYPE The type of storage for the home (either LOCAL or
RHP_MANAGED)
RHP_USER The user for whom the operation is being performed.
RHP_NODES The nodes on which a database will be created.
RHP_ORACLEBASE The Oracle base location for the provisioned home.
RHP_DBNAME The name of the database to be created.
RHP_CLIENT The name of the client cluster.
RHP_DATAPATCH This parameter is set to TRUE at the conclusion of the user
action on the node where the SQL patch will be run after the
move database operation is complete.
RHP_USERACTIONDATA This parameter is present in all of the operations and is used
to pass user-defined items to the user action as an
argument during runtime.
7-11
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
$ cat /scratch/apacheadmin/addapache_useraction.sh
#!/bin/sh
The script is registered to run at the start of rhpctl add workingcopy commands. The
add working copy operation aborts if the script fails.
The following command creates a user action called addapachepre:
The following command registers the user action for the APACHESW image type:
The registered user action is invoked automatically at the start of commands that
deploy a working copy of any image of the APACHESW type, such as the following:
7-12
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
sudopath
/usr/local/bin/sudo -node targetnode003 -user apacheadmin -useractiondata
"sample"
The sample script creates the /tmp/SAMPLEOUT.txt output file. Based on the example
command, the output file contains:
$ cat /tmp/SAMPLEOUT.txt
OPTYPE = ADD_WORKINGCOPY
PHASE = PRE
WORKINGCOPY = apachecopy001
PATH = /scratch/apacheadmin/apacheinstallloc
STORAGETYPE =
USER = apacheadmin
NODES = targetnode003
ORACLEBASE =
DBNAME =
PROGRESSLISTENERHOST = mds11042003.my.example.com
PROGRESSLISTENERPORT = 58068
IMAGE = apacheinstall
IMAGETYPE = APACHESW
RHPVERSION = 12.2.0.1.0
CLI = rhpctl__add__workingcopy__-image__apacheinstall__-path__/scratch/
apacheadmin
/apacheinstallloc__-node__targetnode003__-useractiondata__sample__
-sudopath__/usr/local/bin/sudo__-workingcopy__apachecopy__-
user__apacheadmin__
-sudouser__apacheadmin__USERACTIONDATA = sample
$
Notes:
• In the preceding output example empty values terminate with an equals sign
(=).
• The spaces in the command-line value of the RHP_CLI parameter are replaced
by two underscore characters (__) to differentiate this from other parameters.
7-13
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
Also, when a working copy of a gold image is added to or deleted from a target, the
owner of the working copy and any additional users can be notified by email. If you
want to enable notifications for additional Oracle Fleet Patching and Provisioning
events, you can create a user-defined action as described in the next section.
For example:
All commands are run in reference with the time zone of the server, according to the
ISO-8601 value, and RHPCTL displays the command result by specifying the same
time zone.
7-14
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
Command Results
RHPCTL stores any command that is run from the command queue on the Oracle Fleet
Patching and Provisioning Server. When you query a command result by specifying the
command identifier, then RHPCTL returns the path to the job output file, along with the
results.
Job Operation
When you run an RHPCTL command with the -schedule parameter, the operation creates a
job with a unique job ID that you can query to obtain the status of the job.
Job Status
At any point in time, a job can be in any of the following states:
Related Topics
• rhpctl delete job
• rhpctl query job
User-Defined Batches
When you use this method of patching, the first time you run the rhpctl move gihome
command, you must specify the source home, the destination home, the batches, and other
options, as needed. The command terminates after the first node restarts.
To patch Oracle Grid Infrastructure using batches that you define:
7-15
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
1. Define a list of batches on the command line and begin the patching process, as in
the following example:
The preceding command example initiates the move operation, and terminates
and reports successful when the Oracle Grid Infrastructure stack restarts in the
first batch. Oracle Grid Infrastructure restarts the batches in the order you
specified in the -batches parameter.
If your batches do not include all the nodes in the cluster, then Oracle FPP
automatically adds the excluded nodes as a new batch group at the end of the list
of batches. For example, if your cluster has four nodes n1, n2, n3, n4, and you
create two batches as "(n1),(n2)", then Oracle FPP automatically adds a third
batch group at the end as "(n1),(n2),(n3,n4)".
In the command example, node n1 forms the first batch, nodes n2 and n3 form the
second batch, and node n4 forms the last batch. The command defines the source
working copy as wc1 and the patched (destination) working copy as wc2.
Notes:
You can specify batches such that singleton services (policy-managed
singleton services or administrator-managed services running on one
instance) are relocated between batches and non-singleton services
remain partially available during the patching process.
2. You must process the next batch by running the rhpctl move gihome command,
again, as follows:
The preceding command example restarts the Oracle Grid Infrastructure stack on
the second batch (nodes n2 and n3). The command terminates by reporting that
the second batch was successfully patched.
3. Repeat the previous step until you have processed the last batch of nodes. If you
attempt to run the command with the -continue parameter after the last batch has
been processed, then the command returns an error.
If the rhpctl move gihome command fails at any time during the above sequence,
then, after determining and fixing the cause of the failure, rerun the command with
the -continue option to attempt to patch the failed batch. If you want to skip the
failed batch and continue with the next batch, use the -continue and -skip
parameters. If you attempt to skip over the last batch, then the move operation is
terminated.
Alternatively, you can reissue the command using the -revert parameter to undo
the changes that have been made and return the configuration to its initial state.
You can use the -abort parameter instead of the -continue parameter at any
point in the preceding procedure to terminate the patching process and leave the
cluster in its current state.
7-16
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
Notes:
$ rhpctl move gihome -sourcewc wc1 -destwc wc2 -smartmove -saf 50 [-eval]
If the move operation fails at some point before completing, then you can either rerun the
operation by running the command again, or you can undo the partially completed operation,
as follows:
Note:
If the server pool to which a resource belongs contains only one active server,
then that resource will go offline as relocation cannot take place.
7-17
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
7-18
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
Note:
Creating and deploying an Oracle Exadata image does not require any downtime
and you can perform both these operations before patching Oracle Grid
Infrastructure and Oracle Exadata database. You need to create an Oracle Exadata
image on the Oracle FPP server only once in a patching cycle, however, you need
to deploy Oracle Exadata image, and patch Oracle Grid Infrastructure and Oracle
Exadata database node on each target system.
7-19
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
EXAPATCHSOFTWARE for Oracle Exadata software, and version specifies the version of
the Oracle Exadata software.
When you import an Oracle Exadata software home with this command, the version
parameter must be the version of the Oracle Exadata software required by the
patchmgr on the database node. The path parameter should contain Oracle Exadata
update zip files.
See Also:
rhpctl import image for the complete syntax of the rhpctl import image
command
The targetnode parameter is required if the node hosting the home is not a Oracle
Fleet Patching and Provisioning Client. If the target node or client option is not
specified, then the Oracle Exadata image is deployed to the Oracle Fleet Patching and
Provisioning Server.
See Also:
rhpctl deploy image for the complete syntax of the rhpctl deploy image
command
7-20
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
Example 7-3 Moving an Oracle Grid Infrastructure home and updating a database
node
The following example performs a combined Oracle Grid Infrastructure move and database
node update on client cluster. In the example, sourcewc specifies the name of the source
working copy, destwc specifies the name of the destination working copy to which you want to
move the Oracle Grid Infrastructure home, image specifies the name of the Oracle Exadata
image, batches specifies a comma-delimited list of batches of nodes where each batch is a
comma-delimited list of node names enclosed in parentheses and node names are enclosed
in double quotation marks ("") in the format: "(nA,nB,...),(...,nY,nZ)", iso_repo
specifies the image in the ISO repository, and pathmgrloc specifies the patch manager
location.
With each invocation of the rhpctl move gihome command, FPP patches the database node
first and then patches Oracle Grid Infrastructure. This is the processing order for each node
in the specified batch.
If the first batch includes more than one database node, then FPP invokes patchmgr in
parallel for all the nodes. As soon as a node completes the patchmgr operation, including the
post patchmgr operations, FPP starts the Oracle Grid Infrastructure patching on that node.
When the Oracle Grid Infrastructure patching completes on this node, FPP then begins
patching with Oracle Grid Infrastructure patching on the other nodes when the database node
patching completes on those nodes.
If rebooting a node is delayed because of a patchmgr failure or a patchmgr operation timeout,
the rhpctl move gihome command can be resumed after the node is back up.
See Also:
rhpctl move gihome for the complete syntax of the rhpctl move gihome command
7-21
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
In the Oracle Fleet Patching and Provisioning architecture, one Oracle Fleet Patching
and Provisioning Server manages a set of Oracle Fleet Patching and Provisioning
Clients and targets within a given data center or network segment of a data center. If
you have more than one data center or a segmented data center, then you must have
more than one Oracle Fleet Patching and Provisioning Server to facilitate large-scale
standardization across multiple estates.
Oracle Fleet Patching and Provisioning Servers retain the ability to create and manage
gold images private to their scope, so local customizations are seamlessly supported.
You must first establish a peer relationship between two Oracle Fleet Patching and
Provisioning Servers. Registration uses the names of the Oracle Fleet Patching and
Provisioning Server clusters. The names of the two clusters can be the same but there
is one naming restriction: an Oracle Fleet Patching and Provisioning Server, such as
FPPS_1, cannot register a peer Oracle Fleet Patching and Provisioning Server if that
peer has the same name as an Oracle Fleet Patching and Provisioning Client or target
within the management domain of FPPS_1.
The following steps show how you can establish a peer relationship between two
Oracle Fleet Patching and Provisioning Servers. Note that super user or root
credentials are not required in this process.
1. On the first Oracle Fleet Patching and Provisioning Server (FPPS_1), create a file
containing the server configuration information.
2. Copy the server configuration file created on FPPS_1 to a second Oracle Fleet
Patching and Provisioning Server (FPPS_2).
3. On the second Oracle Fleet Patching and Provisioning Server (FPPS_2), complete
the registration of FPPS_2.
After you register an Oracle Fleet Patching and Provisioning Server as a peer, the
following command displays the peer (or peers) of the server:
7-22
Chapter 7
Advanced Oracle Fleet Patching and Provisioning Configurations
You can inspect the images on a peer Oracle Fleet Patching and Provisioning Server, as
follows:
The preceding command displays all images on a specific peer Oracle Fleet Patching and
Provisioning Server. Additionally, you can specify a peer server along with the -image
image_name parameter to display details of a specific image on a specific peer server.
An Oracle Fleet Patching and Provisioning Server can have multiple peers. Oracle does not
support chained relationships between peers, however, such as, if FPPS_1 is a peer of
FPPS_2, and FPPS_2 is also a peer of FPPS_3, then no relationship is established or implied
between FPPS_1 and FPPS_3, although you can make them peers if you want.
Retrieve a copy or copies of gold images from a peer Oracle Fleet Patching and Provisioning
Server, as follows:
To stop receiving updates that were established by the rhpctl instantiate image
command, run rhpctl uninstantiate image and specify the peer Oracle Fleet Patching and
Provisioning Server and one of the following: all, image name, image series name, or image
type.
End the peer relationship, as follows, on any one of the Oracle Fleet Patching and
Provisioning Servers:
Related Topics
• rhpctl export server
• rhpctl register server
• rhpctl query peerserver
• rhpctl query image
7-23
Chapter 7
Error Prevention and Automated Recovery Options
Error Prevention
Many RHPCTL commands include the -eval parameter, which you can use to run the
command and evaluate the current configuration without making any changes to
determine if the command can be successfully run and how running the command will
impact the configuration. Commands that you run using the -eval parameter run as
many prerequisite checks as possible without changing the configuration. If errors are
encountered, then RHPCTL reports them in the command output. After you correct
any errors, you can run the command again using -eval to validate the corrections.
Running the command successfully using –eval provides a high degree of confidence
that running the actual command will succeed.
You can test commands with the -eval parameter outside of any maintenance window,
so the full window is available for the maintenance procedure, itself.
7-24
Chapter 7
Fleet Patching and Provisioning Logs and Trace Files
Post-Update Issues
Even after a successful move operation to a new database or Oracle Grid Infrastructure
home, you still may need to undo the change and roll back to the prior home. You can do this
by rerunning the command with the source and destination homes reversed. This is,
effectively, a fresh move operation performed without reference to the previous move
operation.
Note:
For the independent automatons, the source and destination homes are always
unmanaged homes (those homes not provisioned by Fleet Patching and
Provisioning). When the move operation is run on a Fleet Patching and Provisioning
Server or Fleet Patching and Provisioning Client, the destination home must be a
managed home that was provisioned by Fleet Patching and Provisioning.
7-25
8
Oracle Fleet Patching and Provisioning Use
Cases
Review these topics for step-by-step procedures to provision, patch, and upgrade your
software using Oracle Fleet Patching and Provisioning.
Oracle Fleet Patching and Provisioning is a software lifecycle management solution and
helps standardize patching, provisioning, and upgrade of your standard operating
environment.
• Creating an Oracle Grid Infrastructure 21c Deployment
Provision Oracle Grid Infrastructure software on two nodes that do not currently have a
Grid home, and then configure Oracle Grid Infrastructure to form a multi-node Oracle
Grid Infrastructure installation.
• Provisioning an Oracle Database Home and Creating a Database
This procedure provisions Oracle Database 21c software and creates Oracle Database
instances.
• Provisioning a Pluggable Database
You can provision a pluggable database (PDB) on an existing container database (CDB)
running in a provisioned database working copy.
• Upgrading to Oracle Grid Infrastructure 21c
This procedure uses Fleet Patching and Provisioning to upgrade your Oracle Grid
Infrastructure cluster from 19c to 21c.
• Patching Oracle Grid Infrastructure and Oracle Databases Simultaneously
This procedure patches Oracle Grid Infrastructure and Oracle Databases on the cluster
to the latest patch level without cluster downtime.
• Patching Oracle Database 21c Without Downtime
This procedure explains how to patch Oracle Database 21c with the latest patching
without bringing down the database.
• Upgrading to Oracle Database 21c
This procedure describes how to upgrade an Oracle database from Oracle Database 19c
to 21c with a single command, using Fleet Patching and Provisioning, both for managed
and unmanaged Oracle homes.
• Provisioning an Oracle Database Using Zip Copy
Starting with Oracle Grid Infrastructure 19c Release Update (19.11), Oracle FPP allows
you to install the gold images without transferring them to the target host.
• Adding a Node to a Cluster and Scaling an Oracle RAC Database to the Node
You can add a node to your two-node cluster by using Fleet Patching and Provisioning to
add the node, and then extend an Oracle RAC database to the new node.
• Adding Gold Images for Fleet Patching and Provisioning
Create gold images of software home and store them on the Fleet Patching and
Provisioning Server, to use later to provision Oracle homes.
8-1
Chapter 8
Creating an Oracle Grid Infrastructure 21c Deployment
Note:
Member Clusters, which are part of the Oracle Cluster Domain architecture,
are desupported in Oracle Grid Infrastructure 21c.
Note:
Domain Services Cluster (DSC), which is part of the Oracle Cluster Domain
architecture, is deprecated in Oracle Grid Infrastructure 21c and can be
desupported in a future release.
Provide configuration details for storage, network, users and groups, and node
information for installing Oracle Grid Infrastructure in a response file. You can store the
response file in any location on the Fleet Patching and Provisioning Server.
You can provision an Oracle Standalone Cluster, Oracle Application Clusters, Oracle
Domain Services Cluster, or Oracle Member Clusters. Ensure that the response file
has the required cluster configuration details.
Ensure that you have storage, network, and operating system requirements configured
as stated in the Oracle Grid Infrastructure Installation Guide.
Procedure
• From the Fleet Patching and Provisioning Server, run the command:
8-2
Chapter 8
Provisioning an Oracle Database Home and Creating a Database
Oracle Grid Infrastructure 21c is provisioned as per the settings in the same response file.
During provisioning, if an error occurs, the procedure stops and allows you to fix the error.
After fixing the error, you can resume the provisioning operation from where it last stopped.
Procedure
1. From the Fleet Patching and Provisioning Server, provision the Oracle Database home
software:
The command provisions the working copy db21wc to the specified path on the cluster
client_001, from the image db21c.
2. Create the database instance:
The command creates an Oracle RAC database instance db . You can use the add
database command repeatedly to create more instances on the working copy.
• Use the rhpctl deletepdb database command to delete a PDB from an existing CDB
on a working copy.
8-3
Chapter 8
Upgrading to Oracle Grid Infrastructure 21c
The following command example deletes a PDB called pdb21c on a CDB called
raccdb21c, which is on a working copy called wc_db21c:
Procedure
1. Provision a working copy of the Oracle Grid Infrastructure 21c software:
Rapid Home Provisioning identifies the cluster to upgrade based on the name of
the source working copy, and upgrades to the working copy GI21c.
8-4
Chapter 8
Patching Oracle Grid Infrastructure and Oracle Databases Simultaneously
Procedure
1. Prepare target Oracle homes as follows:
a. Provision software-only Grid home on the cluster to be patched:
2. Patch Oracle Grid Infrastructure and all Oracle RAC Databases on node1 as follows:
When you run the command, you move your active Oracle Grid Infrastructure from
working copy GI_HOME_21c_WCPY to GI_HOME_21c_PATCHED_WCPY, Oracle RAC Database
db1 from DB_HOME_21c_WCPY to DB_HOME_21c_PATCHED_WCPY, and Oracle RAC Database
db2 from DB_HOME_19c_WCPY to DB_HOME_19c_PATCHED_WCPY.
8-5
Chapter 8
Patching Oracle Database 21c Without Downtime
Ensure that the working copy db21c_psu based on the image DB21c_PSU contains the
latest patches and is available.
Procedure
From the Fleet Patching and Provisioning Server, run one of the following commands
as per your source and destination database:
1. To patch an Oracle Database home managed by Fleet Patching and Provisioning,
and there exist working copies of the source and destination databases, run:
db21c is the working copy of the unpatched database to which you want to roll
back.
8-6
Chapter 8
Upgrading to Oracle Database 21c
db21c_psu is the working copy of the Oracle Database software with patches applied,
based on the image DB21c_PSU.
For all Oracle Databases, you can also specify these additional options with the move
database command:
• -keepplacement: For admin-managed Oracle RAC Databases (not Oracle RAC One
Node Database), Fleet Patching and Provisioning retains the services on the same nodes
after the move.
• -disconnect: Disconnects all sessions before stopping or relocating services.
• -drain_timeout: Specify the time, in seconds, allowed for resource draining to be
completed for planned maintenance operations. During the draining period, all current
client requests are processed, but new requests are not accepted. This option is
available only with Oracle Database 12c release 2 (12.2) or later.
• -stopoption: Stops the database.
• -nodatapatch: Ensures datapatch is not run for databases you are moving.
• From the Fleet Patching and Provisioning Server, run one of the following commands as
per your source and destination database:
1. To upgrade an Oracle home managed by Fleet Patching and Provisioning, and there
exist working copies of the source and destination databases, run:
8-7
Chapter 8
Provisioning an Oracle Database Using Zip Copy
The upgraded database is now managed by Fleet Patching and Provisioning. You can
ensure that your database is patched to the latest level, using Fleet Patching and
Provisioning.
Note:
During upgrade, if an error occurs, the procedure stops and allows you to fix
the error. After fixing the error, you can resume the upgrade operation from
where it last stopped.
8-8
Chapter 8
Adding a Node to a Cluster and Scaling an Oracle RAC Database to the Node
• -zip specifies the location from which you can import the image to the Oracle FPP
server.
• -location specifies a location where the image is available on the target host as a
zip file. Oracle FPP does not copy the zip file from the Oracle FPP server to the
target host.
Note:
You can make the image zip files available on the target hosts using either local
or shared storage.
2. Inspect the images on your Oracle Fleet Patching and Provisioning Server.
Make sure the Location on target value is available in the image query results.
3. Provision the working copy created using the zip file.
The Oracle RAC database home runs on the working copy DB_HOME_21c_WCPY.
Ensure that you have storage, network, and operating system requirements configured for
the new node as stated in Oracle Grid Infrastructure Installation Guide.
Procedure
1. From the Fleet Patching and Provisioning Server, run the following command to add a
node to the existing Oracle Grid Infrastructure working copy:
8-9
Chapter 8
Adding Gold Images for Fleet Patching and Provisioning
The command extends the database home on the node3 and creates database
db321 on this node.
Related Topics
• rhpctl addnode gihome
• rhpctl addnode database
Procedure
Create gold images of Oracle homes in any of the following ways and store them on
the Fleet Patching and Provisioning server:
1. Import an image from an installed Oracle home on the Fleet Patching and
Provisioning Server:
The gold image of imagetype Oracle Database 21c software is created and stored
on the Fleet Patching and Provisioning Server.
You can also create gold images of Oracle Grid Infrastructure or any other
software by specifying -imagetype as ORACLEGISOFTWARE, ORACLEGGSOFTWARE, or
SOFTWARE respectively.
2. Import an image from an installed Oracle home on a Fleet Patching and
Provisioning Client by running the following command from the Fleet Patching and
Provisioning Client:
The command creates and adds the image db21c based on the local Oracle home
installed in the specified path.
8-10
Chapter 8
User Actions for Common Fleet Patching and Provisioning Tasks
Note:
You cannot directly use images as software homes. Use images to create working
copies of software homes.
The preceding command adds the apachestart user action for the action script stored in
the specified directory. As per the specified properties, the user action runs after the
ADD_WORKINGCOPY operation and aborts if there is any error.
3. Create an image type and associate the user action with the image type, as follows:
The preceding command creates a new image type called apachetype, a derivative of the
basic image type, SOFTWARE, with an associated user action apachestart.
4. Create a gold image of the image type, as follows:
The preceding command creates a gold image, apacheinstall, with the script for
Apache Web server installation, in the specified path, based on the imagetype you
created earlier.
To view the properties of this image, run the rhpctl query image -image
apacheinstall command.
8-11
Chapter 8
User Actions for Common Fleet Patching and Provisioning Tasks
Fleet Patching and Provisioning provisions the software to the target and runs the
apachestart script specified in the user action. You can provide the Apache Web
server configuration details such as port number with the useractiondata option.
If the target is a Fleet Patching and Provisioning Client, then you need not specify
sudo credentials.
The wrapper script, wc_add.sh, extracts the pack.zip file into the script path, a
temporary path to which the user action scripts are copied. The wrapper script can
invoke any scripts contained in the file.
2. The following command creates an image type, sw_ua, for the ohadd_ua user
action:
3. The following command creates an image called swimgua from the software
specified in the path:
4. The following command adds a working copy called wcua and runs the wc_add.sh
script:
8-12
A
RHPCTL Command Reference
Use the Oracle Fleet Patching and Provisioning Control (RHPCTL) utility to manage Oracle
Fleet Patching and Provisioning in your cluster.
This appendix contains reference information for Oracle Fleet Patching and Provisioning
commands, including utility usage information and a comprehensive listing of the RHPCTL
commands.
• RHPCTL Overview
RHPCTL is a command-line utility with which you perform Oracle Fleet Patching and
Provisioning operations and manage Oracle Fleet Patching and Provisioning Servers and
Clients.
• Using RHPCTL Help
You can use the content sensitive help with RHPCTL to get uses and syntax information
of various commands.
• RHPCTL Command Reference
This section describes RHPCTL command usage information, and lists and describes
RHPCTL commands.
See Also:
Oracle Database REST API Reference for information about REST APIs for many
common RHPCTL operations, including provisioning, patching, upgrading, and
query operations.
RHPCTL Overview
RHPCTL is a command-line utility with which you perform Oracle Fleet Patching and
Provisioning operations and manage Oracle Fleet Patching and Provisioning Servers and
Clients.
RHPCTL uses the following syntax:
rhpctl command object [parameters]
In RHPCTL syntax:
• command is a verb such as add, delete, or query
• object (also known as a noun) is the target or object on which RHPCTL performs the
command, such as client or image.
• parameters extend the use of a preceding command combination to include additional
parameters for the command. Specify parameters as -keyword value. If the value field
contains a comma-delimited list, then do not use spaces between the items in the list.
A-1
Appendix A
Using RHPCTL Help
You can use RHPCTL commands to perform several Oracle Fleet Patching and
Provisioning operations, including:
• Oracle Fleet Patching and Provisioning Client operations, such as creating an
Oracle Fleet Patching and Provisioning Client configuration.
• Role operations, such as adding and deleting roles, and granting and revoking
roles for users.
• Site operations, such as obtaining configuration information for Oracle Fleet
Patching and Provisioning Servers.
• Image operations, such as adding, deleting, and importing images.
• Image series operations, such as adding and deleting image series.
• Working copy operations, such as adding and deleting working copies.
To see the command syntax and a list of parameters for each RHPCTL command,
from the command line enter:
rhpctl command (or verb) object (or noun) -help
Note:
A multitenant container database is the only supported architecture in Oracle
Database 21c. While the documentation is being revised, legacy terminology
may persist. In most cases, "database" and "non-CDB" refer to a CDB or
PDB, depending on context. In some contexts, such as upgrades, "non-CDB"
refers to a non-CDB from a previous release.
• audit Commands
Use commands with the audit keyword to delete, modify, and query audit records.
• client Commands
Use commands with the client keyword to add, delete, and manage Oracle Fleet
Patching and Provisioning clients.
• credentials Commands
Use commands with the credentials keyword to add credentials to and delete
credentials from the Oracle Cluster Registry (OCR).
A-2
Appendix A
RHPCTL Command Reference
• database Commands
Use commands with the database keyword to add, delete, move, and upgrade
databases.
• exadata Commands
Use commands with the exadata keyword to patch an Oracle Exadata system.
• gihome Commands
Use commands with the gihome keyword to add or delete nodes to Oracle Grid
Infrastructure home and, move and upgrade Oracle Grid Infrastructure home.
• image Commands
Use commands with the image keyword to add, delete, import, and manage gold images.
• imagetype Commands
Use commands with the imagetype keyword to add, delete, modify, and manage an
image type.
• job Commands
Use commands with the job keyword to delete or query schedule jobs.
• osconfig Commands
Use commands with the osconfig keyword to backup, compare, and manage operating
system configuration information.
• peerserver Commands
Use commands with the peerserver keyword to display information for a peer server.
• role Commands
Use commands with the role keyword to add, delete, and manage roles.
• series Commands
Use commands with the series keyword to add, delete, subscribe, and manage a series.
• server Commands
Use commands with the server keyword to export, register, unregister, and query Oracle
Fleet Patching and Provisioning Server.
• user Commands
Use commands with the user keyword to delete, modify, register, and unregister users.
• useraction Commands
Use commands with the useraction keyword to add, delete, and modify user actions.
• workingcopy Commands
Use commands with the workingcopy keyword to create, update, extend, and delete
working copies.
audit Commands
Use commands with the audit keyword to delete, modify, and query audit records.
A-3
Appendix A
RHPCTL Command Reference
Syntax
Usage Notes
Optionally, you can specify a date up to which audit records will be deleted, in the
format YYYY-MM-DD. Otherwise, this command deletes all audit records.
Syntax
Usage Notes
Specify the maximum number of audit records to store.
Syntax
A-4
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-operation {add | Specify the type of operation for which you want an audit query.
delete | modify |
grant | revoke | move
| verify | discover |
upgrade | allow |
disallow |
deleteimage |
insertimage | promote
| addnode |
deletenode | register
| unregister | export
| import | query |
subscribe |
unsubscribe}
-entity {client | Specify the entity for which you want an audit query.
role | image | series
| workingcopy |
database | server |
user | audit |
imagetype |
useraction}
-user user_name Optionally, you can choose to run a query audit on a particular user who
performed Fleet Patching and Provisioning operations.
-client cluster_name Optionally, you can choose to run a query audit on a particular client
cluster where Fleet Patching and Provisioning operations were
performed.
-from timestamp -to Optionally, you can specify a time interval for which to run an audit query.
timestamp Timestamps must be in the format YYYY-MM-DD.
-before timestamp Optionally, you can specify a time before which to run an audit query.
Timestamp must be in the format YYYY-MM-DD.
-since timestamp Optionally, you can specify a time after which to run an audit query.
Timestamp must be in the format YYYY-MM-DD.
-first number Optionally, you can specify a number of the first audit records for a given
time.
-last number Optionally, you can specify a number of the last audit records for a given
time.
-record record_id Optionally, you can specify a particular audit record ID.
–config You can choose this parameter to show the maximum record
configuration.
client Commands
Use commands with the client keyword to add, delete, and manage Oracle Fleet Patching
and Provisioning clients.
A-5
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-client client_name Specify the name of the cluster in which you want to create the
client.
Note:
Oracle recommends that you specify
a unique name for the client cluster.
-clusternamealias Optionally, you can specify the client cluster alias if the client cluster
name is not unique.
A-6
Appendix A
RHPCTL Command Reference
Parameter Description
-toclientdata path Optionally, you can specify the path to the XML file that is created
by the Fleet Patching and Provisioning Server (specific to the client
cluster), which contains the information the client needs to
configure its connection to the server.
-targetnode Optionally, you can specify the name of a node in a remote cluster
node_name that has no Fleet Patching and Provisioning Client.
-sudouser If you choose to use the -targetnode parameter, then you must
sudo_user_name - choose either sudo or root to access the remote node.
sudopath If you choose sudo, then you must use the –sudouser parameter
sudo_binary_location and specify a user name to run super-user operations, and a path
| -root | -cred to the location of the sudo binary.
cred_name
Optionally, you can choose to specify a credential name to
associate the user and password credentials to access a remote
node.
-auth plugin_name [- Alternative to –sudouser, –root, or –cred, you can use –auth to
arg1 specify an authentication plugin to access a remote node.
name1:value1...]
-maproles You can specify either built-in roles or roles that you have defined,
role=user_name[,...] and you can assign multiple uses to each role. Use commas to
separate multiple roles and users.
Note:
Starting with Oracle Grid
Infrastructure 21c, the -maproles
parameter is deprecated. This
parameter can be desupported in a
future release.
-version version Optionally, you can specify the version of the credentials file format,
such as 18.0.0.0.0.
Usage Notes
• Only clusters running Oracle Grid Infrastructure 12c release 2 (12.2) or later can be
configured and added as Fleet Patching and Provisioning Clients. Clusters running earlier
versions of Oracle Grid Infrastructure, and servers running no Oracle Grid Infrastructure,
can be managed directly by the Fleet Patching and Provisioning Server.
• You can only run this command on the Fleet Patching and Provisioning Server.
Examples
To add a client to the Fleet Patching and Provisioning Server:
A-7
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-client client_name Specify the name of the FPP client or remote cluster.
-user username Specify the name of the operating system (OS) user
-cluster Optionally, you can specify the name of a cluster.
cluster_name
-role role_name Specify the name of the role.
Usage Notes
• Specify the name of an Oracle Fleet Patching and Provisioning client or a remote
cluster.
• Specify the OS user and optionally a name of a cluster, or the name of a role.
For a list of roles, refer to rhpctl add role
• This command can only be run on an Oracle Fleet Patching and Provisioning
server
Examples
A-8
Appendix A
RHPCTL Command Reference
Syntax
Usage Notes
• Specify the name of the client cluster that you want to delete from the configuration.
• You must stop the Fleet Patching and Provisioning Client before you run this command or
use the -force option.
Example
To delete the Fleet Patching and Provisioning Client ClientCluster3:
Syntax
Parameters
Parameter Description
-client client_name Specify the name of the FPP client or remote cluster.
-user username Specify the name of the operating system (OS) user
-cluster cluster_name Optionally, you can specify the name of a cluster.
-role role_name Specify the name of the role.
Usage Notes
• Specify the name of an Oracle Fleet Patching and Provisioning client or a remote cluster.
• Specify the OS user and optionally a name of a cluster, or the name of a role.
For a list of roles, refer to rhpctl add role
• This command can only be run on an Oracle Fleet Patching and Provisioning server
Examples
A-9
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-image image_name Specify the name of the Oracle Grid Infrastructure Gold Image
which the resulting response file will support.
-generatepath Specify a file path where the response file that RHPCTL generates
response_file_path will be copied. The RHPCTL command generates name of the
response file and displays it while the command is running.
-responsefile If you have a partially complete response file and you want it to be
response_file_name completed with reference to the target nodes, then specify the
response file name using this parameter.
Note: The response file must include the node list, client name,
and Oracle home path.
-clusternodes Specify a comma-delimited list of nodes on which you plan to
node_list provision Oracle Clusterware (using the resulting response file) in
the following format: node_name:node_vip[:node_role]
[,node_name:node_vip[:node_role]...]
-client cluster_name Specify the name of the target cluster to be probed.
-oraclehome Specify the location of the Oracle home.
oracle_home_path
A-10
Appendix A
RHPCTL Command Reference
Parameter Description
-root | -sudouser You must choose either sudo or root to access the remote nodes.
sudo_username - If you choose sudo, then you must specify a user name to run
sudopath super-user operations, and a path to the location of the sudo
sudo_binary_path | - binary.
cred cred_name | -
Optionally, you can choose to specify a credential name to
auth plugin_name [- associate the user and password credentials to access a remote
arg1 node.
name1:value1...]
Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-user gi_user_name Specify the name of the Oracle Grid Infrastructure installation user.
-scan scan_name Specify the SCAN name.
Syntax
Parameters
Parameter Description
-client cluster_name Specify the name of the client cluster that you want to export.
-clientdata file_path Specify the path to the location of the client data file.
Usage Notes
You can only run this command on the Fleet Patching and Provisioning Server.
Example
To export repository data from a Fleet Patching and Provisioning Client named mjk9394 to a
client data file, /tmp/mjk9394.xml:
A-11
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
Specify the name of the client cluster that you want to modify.
-client
cluster_name
-maproles You can modify either built-in roles or roles that you have defined,
role=user_name[+user and you can assign multiple uses to each role.
_name...][,...] When you use the -maproles parameter, use a plus sign (+) to
map more than one user to a specific role. Separate additional role/
user pairs with commas.
Note:
Starting with Oracle Grid
Infrastructure 21c, the -maproles
parameter is deprecated. This
parameter can be desupported in a
future release.
Example
To disable an Oracle Fleet Patching and Provisioning Client named RHPClient001:
A-12
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-client cluster_name Specify the name of the client cluster in which the Fleet Patching and
Provisioning Client resides.
-detail Generate cluster information (HTML) for the cluster.
-node node_name Specify the name of a node in a remote cluster.
-displayhtml Display the HTML cluster information for the cluster.
-rhpserver rhps_regex Specify a regular expression to match the cluster name of the servers
where the operation must be executed.
Usage Notes
Specify the name of the client cluster in which the Fleet Patching and Provisioning Client
resides for which you want to display the configuration information.
When issuing a command for a peer server using the -rhpserver option, the user running the
command must be an existing user of the peer server and the user must have a required role.
To enable a user from a peer server to run commands on the local server, run the rhpctl
grant role command to grant a required role to the peer server user and to specify the
cluster name of the peer server to which the user belongs. For example:
For information about granting roles with RHPCTL, refer to rhpctl grant role
Example
This command displays output similar to the following:
A-13
Appendix A
RHPCTL Command Reference
Standalone: false
Managed: true
Syntax
Parameters
Parameter Description
-image image_name Specify the name of the image that you want to update.
-targetnode Specify the name of the node on which you want to update the
node_name Fleet Patching and Provisioning Client.
-batches Alternative to specifying a target node, you can specify batches of
'(node_name)' nodes.
Note: If you use this parameter for Oracle Database Appliance
nodes, then run the command twice, in succession, specifying any
one Oracle Database Appliance node for the first run, and another
Oracle Database Appliance node for the second run.
–root You must specify this parameter if you use either the –targetnode
or –batches parameters.
Usage Notes
You can only run this command from a Fleet Patching and Provisioning Server.
Examples
The following example uses the –targetnode parameter:
A-14
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-image image_name Specify the name of the image.
-responsefile Specify a response file to be used to provision Oracle Grid Infrastructure.
response_file_name
-clusternodes Specify a comma-delimited list of nodes on which Oracle Clusterware
node_list will be provisioned in the following format:
node_name:node_vip[:node_role]
[,node_name:node_vip[:node_role]...]
-root | -sudouser You must choose either sudo or root to access the remote nodes.
sudo_username - If you choose sudo, then you must specify a user name to run super-
sudopath user operations, and a path to the location of the sudo binary.
sudo_binary_path | -
Optionally, you can choose to specify a credential name to associate the
cred cred_name | -
user and password credentials to access a remote node.
auth plugin_name [-
arg1 name1:value1...] Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-user gi_user_name Specify the name of the Oracle Grid Infrastructure installation user.
-client cluster_name Specify the name of the cluster you want to verify.
-scan scan_name Specify the SCAN name.
-oraclehome Specify the location of the Oracle home.
oracle_home_path
-ignorewarn Use this parameter to ignore warnings during validation.
–fixup [-setupSSH] Use this parameter to run a fixup script, which automatically applies
changes to the nodes to satisfy changes that CVU recommends.
Optionally, you can use the -setupSSH parameter to set up
passwordless SSH user equivalence on the remote nodes for the
provisioning user.
credentials Commands
Use commands with the credentials keyword to add credentials to and delete credentials
from the Oracle Cluster Registry (OCR).
• rhpctl add credentials
• rhpctl delete credentials
A-15
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-cred cred_name Specify a credential name to associate the user and password
credentials to access a remote node.
-root | -sudouser You must choose either to provide root access to access a remote
sudo_user_name - node or a sudo user name and path to the sudo binary to perform
sudopath super user operations.
sudo_binary_location
Usage Notes
After you add credentials they can be used in the -cred cred_name parameter of other
commands to avoid those commands prompting for a password.
Syntax
Usage Notes
Specify only the name of the credentials you want to delete.
database Commands
Use commands with the database keyword to add, delete, move, and upgrade
databases.
• rhpctl add database
Creates a database using a specific working copy.
• rhpctl addnode database
• rhpctl addpdb database
• rhpctl deletepdb database
A-16
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-workingcopy Specify the name of an existing working copy for the database that you want to
workingcopy_name add.
-gimr Perform the operations required for a Grid Infrastructure Management Repository
(GIMR) database
-dbname unique_db_name Specify the unique name of the database (DB_UNIQUE_NAME without DB_DOMAIN)
that you are adding.
A-17
Appendix A
RHPCTL Command Reference
Parameter Description
-datafileDestination Specify the data file destination location or the name of the Oracle Automatic
datafileDestination_path Storage Management (Oracle ASM) disk group.
Note: You cannot specify a disk group for Oracle Database versions before
Oracle Database 11g release 2 (11.2).
-node node_list Specify a node or comma-delimited list of several nodes on which to create the
database.
-serverpool Specify the name of an existing server pool.
server_pool_name
-pqpool server_pool_name Specify the name of an existing server pool.
Note: This parameter is only applicable in an Oracle Flex Cluster environment
and refers to server pools (either already defined, as in this case, or to be created
when you use the -newpqpool parameter) running on non-Hub Nodes.
-newpqpool Optionally, you can create a new server pool to be used for parallel queries.
server_pool_name Specify a name for the new server pool.
Note: This parameter is only applicable in an Oracle Flex Cluster environment
because it refers to server pools running on non-Hub Nodes.
-pqcardinality If you create a new server pool, then you must specify a cardinality value for the
cardinality server pool.
Note: This parameter is only applicable in an Oracle Flex Cluster environment.
-newpool Optionally, you can create a new server pool. Specify a name for the new server
server_pool_name pool.
-cardinality cardinality If you create a new server pool, then you must specify a cardinality value for the
server pool.
-dbtype {RACONENODE | Specify whether the database is Oracle RAC One Node, Oracle RAC, or a
RAC | SINGLE} nonclustered database.
-dbtemplate file_path | Specify the absolute file path to a database template or the relative path to the
image_name:relative_file image home directory on a Fleet Patching and Provisioning Server.
_path
-cdb Optionally, use this parameter to create a database as a container database.
-pdbname pdb_prefix If you are creating one or more pluggable databases, then specify a pluggable
database name prefix.
-numberOfPDBs pdb_count Specify the number of pluggable databases you want to create.
-sudouser user_name - If you choose to use the -targetnode parameter, then you must choose either
sudopath sudo or root to access the remote node.
sudo_binary_path | -root If you choose sudo, then you must specify a user name to run super-user
| -cred cred_name | - operations, and a path to the location of the sudo binary.
auth plugin_name [-arg1
Optionally, you can choose to specify a credential name to associate the user and
name1:value1...]
password credentials to access a remote node.
Alternative to –sudouser, –root, or –cred, you can use –auth to specify an
authentication plugin to access a remote node.
-targetnode node_name Optionally, you can specify the name of a node in a remote cluster that has no
Oracle Fleet Patching and Provisioning Client.
–ignoreprereq Ignore prerequisites.
–fixup Execute a fixup script. This option is valid for Oracle Grid Infrastructure and
database provisioning.
A-18
Appendix A
RHPCTL Command Reference
Parameter Description
-useractiondata Optionally, you can pass a value to the useractiondata parameter of the user
user_action_data action script.
-schedule {timer_value | Optionally, you can use this parameter to schedule a time to run this operation, in
NOW} ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
If NOW is specified or the option is omitted, then the job is scheduled immediately.
–eval Optionally, you can use this parameter to evaluate the impact of this command on
the system without actually running the command.
Usage Notes
If you choose to use the -schedule parameter, then you must run this command on the Fleet
Patching and Provisioning Server.
Authentication plugins enable the easy addition of authentication methods without changes in
command line interfaces (CLIs). For information about authentication options, refer to
Authentication Options for Oracle Fleet Patching and Provisioning Operations.
Examples
To create a database on a working copy named prodhome:
Note:
You can create multiple databases on a working copy.
Syntax
A-19
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-workingcopy Specify the name of a working copy.
workingcopy_name
-dbname Specify the unique name of the database (DB_UNIQUE_NAME
unique_db_name without DB_DOMAIN) that you are adding.
-node node_list Specify a node or comma-delimited list of several nodes on which
to create the database.
-root | -cred If you choose to use the -targetnode parameter, then you must
cred_name | - choose either root, a credential name, sudo, or an authentication
sudouser plugin to access the remote node.
sudo_user_name - Choose -root to perform super user operations as root.
sudopath Alternatively, you can choose either to specify a credential name to
sudo_binary_location associate the user name and password credentials to access a
| -auth plugin_name remote node, to perform super user operations as a sudo user by
plugin_args specifying a sudo user name and the path to the sudo binary, or to
use an authentication plugin to access the remote node.
-useractiondata Optionally, you can pass a value to the useractiondata
user_action_data parameter of the user action script.
–eval Optionally, you can use this parameter to evaluate the impact of this
command on the system without actually running the command.
-schedule Optionally, you can use this parameter to schedule a time to run
timer_value | NOW} this operation, in ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
Usage Notes
• If the specified working copy is not installed on the nodes in the node list, then you
must first run rhpctl addnode workingcopy.
• If the working copy is on a Fleet Patching and Provisioning Client or on the Fleet
Patching and Provisioning Server, then credentials are not required. This is true
whether you run the command on the Server or the Client. Credentials are
required when you run the command on the Server and the working copy is on a
target that is not a Fleet Patching and Provisioning Client.
• If you choose to use the -schedule parameter, then you must run this command
on the Fleet Patching and Provisioning Server.
A-20
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-workingcopy Specify the name of an existing working copy for the pluggable database
workingcopy_name that you want to add.
-cdbname cdb_name Specify the name of the multitenant container database to which you
want to add the pluggable database.
-pdbname new_pdb_name Specify a name for the pluggable database you are adding.
- Optionally, you can specify the path to the data file destination location
pdbDatafileDestinatio for the pluggable database.
n
pdb_datafile_destinat
ion
-pdbadminusername Optionally, you can specify the name of the PDB's local administrator.
pdb_admin_user_name
-dbcaresponsefile Optionally, you can specify the name of the response file.
responsefilename
-root | -cred If you choose to use the -targetnode parameter, then you must choose
cred_name | -auth either sudo or root to access the remote node.
plugin_name [-arg1 If you choose sudo, then you must specify a user name to run super-
name1:value1...] | - user operations, and a path to the location of the sudo binary.
sudouser user_name -
Optionally, you can choose to specify a credential name to associate the
sudopath
user and password credentials to access a remote node.
sudo_binary_path
Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-targetnode node_name Optionally, you can specify the name of a node in the cluster on which
you want to run this operation.
A-21
Appendix A
RHPCTL Command Reference
Parameter Description
-useractiondata Optionally, you can pass a value to the useractiondata parameter of
user_action_data the user action script.
-schedule Optionally, you can use this parameter to schedule a time to run this
{timer_value | NOW} operation, in ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
Usage Notes
The working copy can be on Fleet Patching and Provisioning Server, a Fleet Patching
and Provisioning Client, or a non-Fleet Patching and Provisioning Client target.
Example
The following example creates a pluggable database called pdb183 on a container
database called raccdb183 on a working copy called wc_db183:
Syntax
Parameters
Parameter Description
-workingcopy Specify the name of an existing working copy for the pluggable
workingcopy_name database that you want to delete.
-cdbname cdb_name Specify the name of the multitenant container database from which
you want to delete the pluggable database.
-pdbname pdb_name Specify the name of the pluggable database you want to delete.
A-22
Appendix A
RHPCTL Command Reference
Parameter Description
-root | -cred If you choose to use the -targetnode parameter, then you must
cred_name | -auth choose either sudo or root to access the remote node.
plugin_name [-arg1 If you choose sudo, then you must specify a user name to run
name1:value1...] | - super-user operations, and a path to the location of the sudo
sudouser user_name - binary.
sudopath
Optionally, you can choose to specify a credential name to
sudo_binary_path associate the user and password credentials to access a remote
node.
Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-targetnode Optionally, you can specify the name of a node in the cluster on
node_name which you want to run this operation.
-useractiondata Optionally, you can pass a value to the useractiondata
user_action_data parameter of the user action script.
-schedule Optionally, you can use this parameter to schedule a time to run
{timer_value | NOW} this operation, in ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
Usage Notes
The working copy can be on Fleet Patching and Provisioning Server, a Fleet Patching and
Provisioning Client, or a non-Fleet Patching and Provisioning Client target.
Examples
The following example deletes a pluggable database called pdb183 from a container
database called raccdb183 on a working copy called wc_db183:
Note:
If the database is hosted on a working copy that is on the Oracle Fleet Patching and
Provisioning Server or on an Oracle Fleet Patching and Provisioning Client, then
credentials are not required. This is true whether you run the command on the
Server or the Client. Credentials are required when you run the command on the
Server and the working copy is on a target that is not an Oracle Fleet Patching and
Provisioning Client.
A-23
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-workingcopy Specify a name for the working copy for the database that you want
workingcopy_name to delete.
-dbname Specify the unique name of the database
unique_db_name (DB_UNIQUE_NAMEwithout DB_DOMAIN) that you are deleting.
-sudouser user_name If you choose to use the -targetnode parameter, then you must
-sudopath choose either sudo or root to access the remote node.
sudo_binary_path | - If you choose sudo, then you must specify a user name to run
root | -cred super-user operations, and a path to the location of the sudo
cred_name | -auth binary.
plugin_name [-arg1
Optionally, you can choose to specify a credential name to
name1:value1...] associate the user and password credentials to access a remote
node.
Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-targetnode Optionally, you can specify the name of a node in a remote cluster
node_name that has no Oracle Fleet Patching and Provisioning Client.
-useractiondata Optionally, you can pass a value to the useractiondata
user_action_data parameter of the user action script.
-schedule Optionally, you can use this parameter to schedule a time to run
{timer_value | NOW} this operation, in ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
A-24
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-workingcopy Specify the name of a working copy.
working_copy_name
-dbname Specify the unique name of the database (DB_UNIQUE_NAME without
unique_db_name DB_DOMAIN) that you are deleting.
-node node_list Specify a node or comma-delimited list of several nodes from which to
delete the database instance.
-root | -sudouser Choose either sudo or root to access the remote nodes.
sudo_username - If you choose sudo, then you must specify a user name to run super-
sudopath user operations, and a path to the location of the sudo binary.
sudo_binary_path | -
Optionally, you can choose to specify a credential name to associate the
cred cred_name | -
user and password credentials to access a remote node.
auth plugin_name [-
arg1 name1:value1...] Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-force Use -force to remove the instance after forcibly stopping the instance.
-failover Optionally, you can use this parameter to attempt to have services
running on the instance that want to delete fail over to another instance.
-drain_timeout Optionally, you can use -drain_timeout to specify the time, in
timeout seconds, allowed for resource draining to be completed. Accepted values
are an empty string (""), 0, or any positive integer. The default value is an
empty string, which means that this parameter is not set. If it is set to 0,
then draining occurs, immediately.
The draining period is intended for planned maintenance operations.
During the draining period, all current client requests are processed, but
new requests are not accepted.
-stopoption Optionally, you can specify a stop option for the database. Options
stop_option include: ABORT, IMMEDIATE, NORMAL, TRANSACTIONAL, and
TRANSACTIONAL_LOCAL.
-useractiondata Optionally, you can pass a value to the useractiondata parameter of
user_action_data the user action script.
-schedule Optionally, you can use this parameter to schedule a time to run this
(timer_value | NOW} operation, in ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
A-25
Appendix A
RHPCTL Command Reference
Parameter Description
–eval Optionally, you can use this parameter to evaluate the impact of this
command on the system without actually running the command.
Usage Notes
• If the working copy is on a Fleet Patching and Provisioning Client or on the Fleet
Patching and Provisioning Server, then credentials are not required. This is true
whether you run the command on the Server or the Client. Credentials are
required when you run the command on the Server and the working copy is on a
target that is not a Fleet Patching and Provisioning Client.
• If you choose to use the -schedule parameter, then you must run this command
on the Fleet Patching and Provisioning Server.
Syntax
Parameters
Parameter Description
-patchedwc Specify the name of the working copy to where you want to move the database.
workingcopy_name
A-26
Appendix A
RHPCTL Command Reference
Parameter Description
-sourcewc Specify the name of the working copy from which the database is to be moved.
workingcopy_name
-sourcehome Alternatively, you can specify the source Oracle home path.
Oracle_home_path
-oraclebase Specify the ORACLE_BASE path for provisioning the Oracle database home
Oracle_base_path (required only for ORACLEDBSOFTWARE image type).
-client cluster_name Specify the name of the client cluster.
-dbname db_name_list Specify the unique names of the databases (DB_UNIQUE_NAME without
DB_DOMAIN) that you want to move to the patched working copy.
Note: If you are moving a non-clustered (single-instance) database, then, for the
value of the -dbname parameter, you must specify the SID of the database
instead of the database name.
-excludedblist Alternative to using the -dbname parameter, you can use the -excludedblist
db_name_list parameter to patch all databases except specific databases.
-nonrolling [- Optionally, you can choose one of the three following methods to move a
skipprereq] | - database:
forcerolling | -batches • Use the -nonrolling parameter to move the database in a non-rolling
list_of_batches | - mode. By default, databases move in a rolling mode. Use the –skipprereq
smartmove [-saf option to skip the prerequisite checks and start the database in upgrade
availability] [– mode for patching.
separate] • Use the –forcerolling parameter to force the Oracle home to move in
rolling mode.
• Use the -batches parameter to specify a comma-delimited list of batches of
nodes (where each batch is a comma-delimited list of node names enclosed
in parentheses) enclosed in double quotation marks ("") in the format:
"(nA,nB,...),(...,nY,nZ)".
• Alternatively, use the -smartmove parameter. Use the -saf availability
parameter to specify a service availability factor, which is the minimum
percentage of instances on which a service must remain running during the
move.
Use the -separate parameter to process batches separately. When you use this
parameter, the move command returns after each batch. The move operation for
the first batch must specify the source home and other parameters that apply to
all batches (such as -nonrolling and -keepplacement). Control subsequent
batches using the -continue, -skip, and -abort parameters.
–eval Use the –eval parameter to print auto-generated batches of nodes and
sequence of moves without actually performing the move operation.
-ignoremissingpatches Perform the move and/or upgrade even though the specified patches, which are
patch_name1 present in the source path or working copy, may be missing from the destination
[,patch_name2...] path or working copy.
-ignorewcpatches Optionally, you can use this parameter to ignore if a patched working copy is
missing some patches which are present in the source path or working copy.
-keepplacement Use this parameter to ensure that services of administrator-managed Oracle RAC
or Oracle RAC One Node databases are running on the same instances before
and after the move operation.
A-27
Appendix A
RHPCTL Command Reference
Parameter Description
-disconnect [-noreplay] Optionally, use the -disconnect parameter to disconnect all sessions before
stopping or relocating services. If you choose to use -disconnect, then you can
choose to use the -noreplay parameter to disable session replay during
disconnection.
-drain_timeout timeout Specify the time, in seconds, allowed for resource draining to be completed.
Accepted values are an empty string (""), 0, or any positive integer. The default
value is an empty string, which means that this parameter is not set. If it is set to
0, then draining occurs, immediately.
The draining period is intended for planned maintenance operations. During the
draining period, all current client requests are processed, but new requests are
not accepted.
-stopoption stop_option Optionally, you can specify a stop option for the database. Options include:
ABORT, IMMEDIATE, NORMAL, TRANSACTIONAL, and TRANSACTIONAL_LOCAL.
–nodatapatch Use this parameter to indicate not to run datapatch for databases you are
moving.
-targetnode node_name Optionally, you can specify the name of a node in a remote cluster that has no
Fleet Patching and Provisioning Client.
-notify [-cc user_list] Optionally, you can supply a list of users to whom email notifications of the move
will be sent, in addition to the owner of the working copy.
-continue [-skip] If a batch-mode rhpctl move database command fails at any point, then, after
correcting the cause of the error, you can rerun the command with the -
continue parameter to attempt to patch the failed batch. If you want to skip the
failed batch and continue with the next batch, use the -continue and -skip
parameters together. If you attempt to skip over the last batch, then the move
operation is terminated.
—revert If a batch-mode or non-batch-mode rhpctl move database command fails,
then you can rerun the command with the -revert parameter to undo the
changes that have been made, and return the configuration to its initial state.
—abort If a batch-mode or non-batch-mode rhpctl move database command fails,
then you can rerun the command with the -abort parameter to terminate the
patching process and leave the cluster in its current state.
-root | -cred cred_name | - If you choose to use the -targetnode parameter, then you must choose either
sudouser sudo_user_name root, a credential name, sudo, or an authentication plugin to access the remote
-sudopath node.
sudo_binary_location | - Choose -root to perform super user operations as root. Alternatively, you can
auth plugin_name choose either to specify a credential name to associate the user name and
plugin_args password credentials to access a remote node, to perform super user operations
as a sudo user by specifying a sudo user name and the path to the sudo binary,
or to use an authentication plugin to access the remote node.
-useractiondata Optionally, you can pass a value to the useractiondata parameter of the user
user_action_data action script.
-schedule {timer_value | Optionally, you can use this parameter to schedule a time to run this operation, in
NOW} ISO-8601 format. For example: 2018-07-25T19:13:17+05
If NOW is specified, then the job is scheduled immediately.
-dbsinparallel Number of database instances that can be started in parallel on a given node.
number_of_instances
A-28
Appendix A
RHPCTL Command Reference
Parameter Description
-raconetimeout timeout RAC One Node database relocation timeout in minutes.
Usage Notes
• You can obtain context sensitive help for specific use cases for the rhpctl move
database command, as follows:
• If you choose to use the -schedule parameter, then you must run this command on the
Fleet Patching and Provisioning Server.
Examples
To move all the databases running from one working copy to another in a rolling fashion:
In the preceding example, the patched working copy, prodHomeV2, must exist.
To move a database named SampleDB from a working copy named myDB12Home1 to a working
copy named myDB12Home1patched (any other databases running on myDB12Home1 are not
affected by this move):
To move all databases running on a working copy named myDB12Home1 to a working copy
named myDB12Home1patched:
A-29
Appendix A
RHPCTL Command Reference
The preceding examples are the basic form of the command. You can also move
groups of databases in batches. The batch operations also support management of
session connections and recovery options.
Syntax
Parameters
Parameter Description
-sourcecdb source_cdb_name Specify the name of the Oracle Multitenant
container database from which you want to
move the pluggable database.
-destcdb destination_cdb_name Specify the name of the multitenant container
database to which you want to move the
pluggable database.
-pdbname pdb_name_list Specify a comma-separated list of names of
pluggable databases that you want to move.
-excludepdblist pdb_name_list Specify a list of pluggable databases that you
want to excluded from the move operation.
-root | -cred cred_name | -sudouser If you choose to use the -targetnode
sudo_user_name -sudopath parameter, then you must choose either root,
sudo_binary_location | -auth a credential name, sudo, or an authentication
plugin_name plugin_args plugin to access the remote node.
Choose -root to perform super user
operations as root. Alternatively, you can
choose either to specify a credential name to
associate the user name and password
credentials to access a remote node, to
perform super user operations as a sudo user
by specifying a sudo user name and the path
to the sudo binary, or to use an authentication
plugin to access the remote node.
-client client_name | -targetnode Optionally, you can specify either the name of
node_name the client cluster or the node on which the
operation is to be run.
A-30
Appendix A
RHPCTL Command Reference
Parameter Description
-useractiondata user_action_data Optionally, you can pass a value to the
useractiondata parameter of the user
action script.
-schedule {timer_value | NOW} Optionally, you can use this parameter to
schedule a time to run this operation, in
ISO-8601 format, as in the following example:
2019-01-07T19:13:17+05
Usage Notes
• The source and destination container databases can be running in a provisioned
database working copy. The working copy can be on the Oracle Fleet Patching and
Provisioning Server, an Oracle Fleet Patching and Provisioning Client, or a non-Fleet
Patching and Provisioning Client target, which is a target without an Oracle Fleet
Patching and Provisioning Client configured and running. The destination container
database can be at a higher patch level, which facilitates patching of a pluggable
database to a higher patch level.
• You can only use this command if both the source and destination container databases
are on the same node.
• This command does not currently support for Oracle RAC databases.
Examples
To move a pluggable database from a source container database to a destination container
database:
Syntax
A-31
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-sourcewc Specify the name of the source working copy from which you want to upgrade the
source_workingcopy_name database.
-sourcehome Alternative to specifying the name of the source working copy, you can specify
oracle_home_path the path to the source Oracle home.
-oraclebase If you use the -sourcehome parameter, then you can, optionally, specify a
oraclebase_path different ORACLE_BASE from the source Home.
-client cluster_name | - Specify either the name of the client cluster or the name of a node in a remote
targetnode node_name cluster with no Fleet Patching and Provisioning Client on which to provision a
working copy.
-root | -cred cred_name If you choose to use the -targetnode parameter, then you must choose either
| -sudouser root, a credential name, sudo, or an authentication plugin to access the remote
sudo_user_name -sudopath node.
sudo_binary_location | - Choose -root to perform super user operations as root. Alternatively, you can
auth plugin_name choose either to specify a credential name to associate the user name and
plugin_args password credentials to access a remote node, to perform super user operations
as a sudo user by specifying a sudo user name and the path to the sudo binary,
or to use an authentication plugin to access the remote node.
-destwc Specify the name of the destination working copy to which the database is to be
destination_workingcopy_ upgraded. If the destination working copy does not exist, then specify the gold
name [-image image_name image from which to create it, and optionally, the path to where to provision the
[-path where_path]] working copy.
-dbname unique_db_name Specify the name of the database you are upgrading.
-useractiondata Optionally, you can pass a value to the useractiondata parameter of the user
user_action_data action script.
–eval Optionally, you can use this parameter to evaluate the impact of this command on
the system without actually running the command.
-schedule {timer_value | Optionally, you can use this parameter to schedule a time to run this operation, in
NOW} ISO-8601 format, as in the following example: 2018-07-25T19:13:17+05
If NOW is specified, then the job is scheduled immediately.
-ignoremissingpatches Executes the move and/or upgrade although the specified patches, which are
present in the source path or working copy, could be missing from the destination
path or working copy.
-dbuaargs dbua_arguments Species a double-quoted string containing optional arguments for DBUA.
-autoupg Executes the upgrade database operation using the AutoUpgrade toolkit present
in the target working copy.
A-32
Appendix A
RHPCTL Command Reference
Parameter Description
-upgtimezone { YES | Enables or disables time zone upgrade as part of the AutoUpgrade process.
NO } Default is YES.
-runutlrp { YES | NO } Enables or disables the recompilation of invalid objects as part of the
AutoUpgrade process. Default is YES.
-fra Specifies the location of the flash recovery area.
db_recovery_file_dest
-ignoregroupcheck Skips the group check except for OSDBA and OSASM during the upgrade
database process.
-drain_timeout Specifies the service drain timeout in seconds.
session_drain_time
-abort Terminate the ongoing upgrade operation.
-revert Use this parameter to revert the failed upgrade of Oracle Database.
Usage Notes
If you choose to use the -schedule parameter, then you must run this command on the Fleet
Patching and Provisioning Server.
Example
The following example upgrades a database, testy, from Oracle Database 11g, which is on
working copy db112mbc143 to Oracle Database 12c, which is on working copy
db12102mbc143, both of which reside on the remote node bposvr141:
Syntax
A-33
Appendix A
RHPCTL Command Reference
[-targetnode node_name
{-root |
-cred credential name|
-sudouser sudouser name -sudopath sudo_binary_location|
-auth plugin_name
[arg1 name1:value1
[arg2 name2:value2. . . ]]}]
[-eval]
[-ignoreprereq]
[-useractiondata user_action_data]
[-dbuaargs dbua_arguments
Parameters
Parameter Description
-dbname Specify the unique name of the database that you want to upgrade.
unique_db_name
-converttopdb - (Optional) Specifies that you want to convert a non-container (non-
cdbname cdbname - CDB) Oracle Database to a pluggable database (PDB) during the
pdbname pdb_name upgrade.
If you select this option, then provide the following arguments:
-cdbname cdb_name, which defines the name of the existing
container database (CDB) on which you want to place the PDB
-pdbname pdb_name, which defines the name of the PDB that you
want to plug in to the CDB.
After the non-CDB source database is upgraded on the target
node, if you specify -converttopdb, and provide the existing
CDB's name, then Zero Downtime Upgrade performs the
conversion.
-destwc Specifies the name of the destination working copy to which the
destination_workingc database is to be upgraded.
opy_name
-sourcewc (Optional) You can specify the name of the source working copy
source_workingcopy_n from which you want to upgrade the database.
ame
-sourcehome Alternative to specifying the name of the source working copy, you
oracle_home_path can specify the path to the source Oracle home.
-ggsrcwc Specify the name of the Oracle GoldenGate source working copy.
golden_gate_source_w
orkingcopy_name
-ggdstwc Specify the name of the Oracle GoldenGate destination working
golden_gate_dest_wor copy.
kingcopy_name
-clonedatadg (Optional) You can specify the name of an Oracle ASM disk group
diskgroup_name to use as a data file location for the cloned database.
-cloneredodg (Optional) You can specify the name of an Oracle ASM disk group
diskgroup_name to use as a redo log location for the cloned database.
-clonerecodg (Optional) You can specify the name of an Oracle ASM disk group
diskgroup_name to use as a recovery area for the cloned database.
A-34
Appendix A
RHPCTL Command Reference
Parameter Description
clonedatafs (Optional) You can specify the mount point of an Oracle Advanced
acfs_mountpoint Cluster File System (Oracle ACFS) to use as a data file location for
the cloned database.
-cloneredofs (Optional) You can specify the name of an Oracle ACFS file system
acfs_mountpoint to use as a redo log location for the clone database.
-clonerecofs (Optional) You can specify the name of an Oracle ACFS file system
acfs_mountpoint to use as a recovery area for the clone database.
-rmanlocation (Optional) You can specify the source RMAN backup location.
backup_location
-sourcenode (Optional) You can specify the name of a source node in a remote
node_name cluster with no Fleet Patching and Provisioning Client on which to
provision a working copy, where the source database is running.
If you choose to use the -sourcenode parameter, then you must
choose either root, a credential name, sudo, or an authentication
plugin to access the remote node.
Choose -root to perform super user operations as root.
Alternatively, you can choose either to specify a credential name to
associate the user name and password credentials to access a
remote node, to perform super user operations as a sudo user by
specifying a sudo user name and the path to the sudo binary, or to
use an authentication plugin to access the remote node.
-targetnode (Optional) You can specify the name of a target node in a remote
node_name cluster with no Fleet Patching and Provisioning Client on which to
provision a working copy, where you want to run the upgraded
-root | -cred
database.
cred_name | -
sudouser If you choose to use the -targetnode parameter, then you must
sudo_user_name - choose either root, a credential name, sudo, or an authentication
sudopath plugin to access the remote node.
sudo_binary_location Choose -root to perform super user operations as root.
| -auth plugin_name Alternatively, you can choose either to specify a credential name to
plugin_args associate the user name and password credentials to access a
remote node, to perform super user operations as a sudo user by
specifying a sudo user name and the path to the sudo binary, or to
use an authentication plugin to access the remote node.
eval (Optional) You can specify eval to evaluate the Zero Downtime
Upgrade operation to see if it can succeed, but does not perform
the operation.
-ignoreprereq (Optional) You can use this parameter to instruct the zdtupgrade
database command to ignore system prerequisites during the
upgrade.
-useractiondata (Optional) You can use this parameter to specify a value to be
user_action_data passed to the useractiondata parameter of a user action script
A-35
Appendix A
RHPCTL Command Reference
Parameter Description
-dbuaargs (Optional) If you do not specify the AutoUpgrade Utility for the
upgrade with the -autoupg parameter, so that Database Upgrade
Assistant (DBUA) is used for the upgrade, then you can specify
arguments to pass to DBUA. If you specify -autoupg, then this
argument is not available.
For example, if the user account with which you are running Zero
Downtime Upgrade If your account does not have SYSDBA
privileges, or you do not have operating system authentication set
up, then you can use the following syntax to connect, where mydb
is your Oracle Database SID, username is a user name with
SYSDBA privileges, and password is that user name’s password:
-sysDBAUserName - username -sysDBAPassword -
password
[ -autoupg [ - (Optional) Specifies that you want to use the AutoUpgrade utility for
upgtimezone [yes|no] the upgrade. If you select this option, then provide the following
[-runutlrp [yes| arguments:
no] ] upgtimezone [yes|no] Specify yes to upgrade the timezone
during the upgrade, or no to skip the timezone upgrade.
If the Pre-Upgrade Information Tool instructs you to upgrade the
time zone files after completing the database upgrade, then you
can select this argument to enable the Zero Downtime Upgrade to
upgrade the time zone file after the upgrade completes.
runutlrp [yes|no] Specify yes to run the utlrp.sql script
after the upgrade to revalidate the packages again., or select no to
skip the timezone upgrade.
Oracle recommends that you run the utlrp.sql script after you
install, patch, or upgrade a database, to identify and recompile
invalid objects.
exadata Commands
Use commands with the exadata keyword to patch an Oracle Exadata system.
Syntax
A-36
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-dbnodes Specifies to patch Exadata database nodes.
-patchmgrloc Specifies the patch manager location.
patch_mgr_loc
-iso_repo iso_image_name Specifies the ISO image name.
-backup Performs backup of the Exadata database server.
-batches list_of_batches Optionally, you can specify a comma-delimited list of batches of nodes where
each batch is a comma-delimited list of node names enclosed in parentheses and
node names are enclosed in double quotation marks ("") in the format:
"(nA,nB,...),(...,nY,nZ)".
-continue Update Oracle Exadata on the next batch of nodes.
-abort Abort the ongoing update operation.
-cells Comma separated list of cell server nodes.
-ibswitches Specifies to patch the InfiniBand Network Fabric switches.
-ibnodes List of IB switch nodes in the format Ba,...,Bz
-downgrade Specify this option to downgrade the InfiniBand Network Fabric switches.
-image Specify the name of an Oracle Exadata image.
This image should have already been deployed to all the database nodes of the
target machine.
-fromnode Specify the name of the source node.
-patchmgargs Optionally specify the patch manager arguments in double quoted string.
-client client_name Specify the name of the cluster in which you want to update database nodes.
-rollback Specify this option to roll back the patch.
-smtpfrom The email address from which you want to send patch manager notifications.
-smtpto The email address to which you want to send patch manager notifications.
-schedule {timer_value | Optionally, you can use this parameter to schedule a time to run this operation, in
NOW } ISO-8601 format, as in the following example:
2020-07-25T19:13:17+05
If NOW is specified or the option is omitted, then the job is scheduled immediately
-eval Evaluate the command without actually running the command.
Usage Notes
Use the rhpctl update exadata command to perform only database node patching.
Example
The following example performs database node patching on a client cluster.
A-37
Appendix A
RHPCTL Command Reference
dbserver_patch_19.190306
-patchmgrargs "-ignore_alerts" -client CLIENT1 -batches
"(rac07box1)"
See Also:
Combined Oracle Exadata Database Node and Grid Infrastructure Update
for information about Oracle Exadata database node patching
gihome Commands
Use commands with the gihome keyword to add or delete nodes to Oracle Grid
Infrastructure home and, move and upgrade Oracle Grid Infrastructure home.
• rhpctl addnode gihome
• rhpctl deletenode gihome
• rhpctl move gihome
Moves the Oracle Grid Infrastructure software stack from one home to another.
• rhpctl upgrade gihome
Syntax
Parameters
Parameter Description
-workingcopy Specify the name of the working copy of the active Oracle Grid
workingcopy_name Infrastructure home that you want to install and configure on the
specified node.
-client cluster_name Alternatively, you can specify the name of the client cluster to which
to add cluster nodes.
A-38
Appendix A
RHPCTL Command Reference
Parameter Description
-newnodes Specify a comma-delimited list of nodes on which Oracle
node_name:node_vip[: Clusterware will be provisioned in the following format:
node_role] node_name:node_vip[:node_role]...]
If the target is a Flex Cluster, then node_role must be specified as
either HUB or LEAF. For example, -newnodes srv3:srv3-
vip:HUB
-root | -cred You must choose either root, a credential name, sudo, or an
cred_name | - authentication plugin to access the remote node.
sudouser Choose -root to perform super user operations as root.
sudo_user_name - Alternatively, you can choose either to specify a credential name to
sudopath associate the user name and password credentials to access a
sudo_binary_location remote node, to perform super user operations as a sudo user by
| -auth plugin_name specifying a sudo user name and the path to the sudo binary, or to
plugin_args use an authentication plugin to access the remote node.
-targetnode Optionally, you can specify the name of a node in a remote cluster
node_name that has no Fleet Patching and Provisioning Client.
–force Optionally, you can use this parameter to forcibly add nodes
ignoring any previously failed add-node operation.
-setupssh Sets up passwordless SSH user equivalence on the remote nodes
for the provisioning user.
-useractiondata Optionally, you can pass a value to the useractiondata
user_action_data parameter of the user action script.
–eval Optionally, you can use this parameter to evaluate the impact of this
command on the system without actually running the command.
-schedule Optionally, you can schedule a time to run this command in
{timer_value | NOW} ISO-8601 format. For example: 2018-01-21T19:13:17+05.
If NOW is specified, then the job is scheduled immediately.
Usage Notes
• You can specify the target for the operation using the working copy name or, if the target
is a Fleet Patching and Provisioning Client, then using the client cluster name.
• You must provide either root credentials, a credential name, a sudo user, or an
authentication plugin.
• A target node is required if the target cluster is an Oracle Clusterware 11g release 2
(11.2) or 12c release 1 (12.1) cluster and must be the node name of an existing cluster
node.
Syntax
A-39
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-workingcopy Specify the name of a working copy of the Oracle Grid
workingcopy_name Infrastructure home that you want to remove from the specified
node.
-client cluster_name Alternatively, you can specify the name of the client cluster from
which to remove cluster nodes.
–node node_list Specify a comma-delimited list of node names from which to delete
Oracle Grid Infrastructure.
-root | -sudouser You must choose either sudo or root to access the remote nodes.
sudo_username - If you choose sudo, then you must specify a user name to run
sudopath super-user operations, and a path to the location of the sudo
sudo_binary_path | - binary.
cred cred_name | -
Optionally, you can choose to specify a credential name to
auth plugin_name [- associate the user and password credentials to access a remote
arg1 node.
name1:value1...]
Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-targetnode Name of a node in a remote cluster with no Fleet Patching and
node_name Provisioning Client.
-useractiondata Optionally, you can pass a value to the useractiondata
user_action_data parameter of the user action script.
–eval Optionally, you can use this parameter to evaluate the impact of this
command on the system without actually running the command.
-schedule Optionally, you can schedule a time to run this command in
{timer_value | NOW} ISO-8601 format. For example: 2018-01-21T19:13:17+05.
If NOW is specified, then the job is scheduled immediately.
Usage Notes
• You can specify the target for the operation using the working copy name or, if the
target is a Fleet Patching and Provisioning Client, then using the client cluster
name.
• You must provide either root credentials or a sudo user.
• A target node is required if the target cluster is an Oracle Clusterware 11g release
2 (11.2) or 12c release 1 (12.1) cluster and must be the node name of an existing
cluster node.
A-40
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-destwc Specify the name of the destination working copy to which you want to
destination_workingco move Oracle Grid Infrastructure.
py_name
-desthome Alternative to specifying the name of the destination working copy, you
destination_oracle_ho can specify the path to the destination for the move of an Oracle home
me_path when you are moving the Oracle Grid Infrastructure home.
Note:
This option is valid only for local mode
execution of FPP automaton and not
available with regular FPP.
-sourcewc If you want to move Oracle Grid Infrastructure from a working copy, then
working_copy_name specify the name of the source working copy from which you want to
move the Grid home.
A-41
Appendix A
RHPCTL Command Reference
Parameter Description
-sourcehome If you are moving Oracle Grid Infrastructure from an unmanaged (not
oracle_home_path provisioned by Fleet Patching and Provisioning) Oracle home, then
specify the path to the Oracle home from which you want to move Oracle
Grid Infrastructure.
-usepatchedhome Specify this parameter to use patched home to run Oracle Fleet Patching
Provisioning Server and Client for Oracle Grid Infrastructure patching.
-targetnode Name of a node in a remote cluster with no Fleet Patching and
target_node_name Provisioning Client.
-ignorewcpatches Use this parameter to ignore if the patched working copy is missing
some patches which are present in the source path or working copy.
-nonrolling Use this parameter to move the Oracle home in a non-rolling fashion.
-keepplacement Specify this parameter to ensure that services of administrator-managed
Oracle RAC or Oracle RAC One Node databases are running on the
same instances before and after the move operation.
-auto -dbhomes Specify this parameter to automatically patch databases when you patch
mapping_of_Oracle_hom Oracle Grid Infrastructure.
es
-dblist db_name_list Specify the unique names of the databases (DB_UNIQUE_NAME without
DB_DOMAIN) that you want to move to the patched working copy.
Note: If you are moving a non-clustered (single-instance) database,
then, for the value of the -dbname parameter, you must specify the SID
of the database instead of the database name.
-excludedblist Alternative to using the -dbname parameter, you can use the -
db_name_list excludedblist parameter to patch all databases except specific
databases.
-nodatapatch Optionally, you can use this parameter to indicate not to run datapatch
for databases being moved.
-disconnect Optionally, you can use this parameter to disconnect all sessions before
stopping or relocating services.
-stopoption Optionally, you can choose one of the following stop options for the
stop_option database: ABORT, IMMEDIATE, NORMAL, TRANSACTIONAL, or
TRANSACTIONAL_LOCAL.
-drain_timeout Optionally, you can use this parameter to specify a service drain timeout,
session_drain_time in seconds.
-batches Optionally, you can specify a comma-delimited list of batches of nodes
list_of_batches (where each batch is a comma-delimited list of node names enclosed in
parentheses) enclosed in double quotation marks ("") in the format:
"(nA,nB,...),(...,nY,nZ)".
-smartmove [-saf Alternatively, you can use the -smartmove parameter to auto-generate a
availability] list of batches of nodes and move databases by restarting instances
after each batch.
Optionally, you can use the -saf parameter to specify the service
availability factor, which is the minimum percentage of instances on
which a service must remain running during the move.
-continue Use this parameter to continue restarting the Oracle Clusterware stack
on the next batch of nodes.
A-42
Appendix A
RHPCTL Command Reference
Parameter Description
-revert Use this parameter to revert back to before the move operation.
-abort Use this parameter to abort an ongoing move operation.
-forcecomplete Use this parameter to mark the move operation as complete after
completing it manually.
-root | -cred If you choose to use the -targetnode parameter, then you must choose
cred_name | -sudouser either root, a credential name, sudo, or an authentication plugin to
sudo_user_name - access the remote node.
sudopath Choose -root to perform super user operations as root. Alternatively,
sudo_binary_location you can choose either to specify a credential name to associate the user
name and password credentials to access a remote node, to perform
super user operations as a sudo user by specifying a sudo user name
and the path to the sudo binary, or you can use –auth to use an
authentication plugin to access the remote node.
-auth plugin-name [- Use an authentication plugin to access the remote node.
arg1 name1:value1 [- Optionally provide a list of arguments to the plugin.
arg2
name2:value2 ...]]
-cleanpids When using a persistent home path for both the source and destination
working copies, specify -cleanpids to ensure processes are stopped
completely on the source home.
-useractiondata Optionally, you can pass a value to the useractiondata parameter of
user_action_data the user action script.
-schedule Optionally, you can use this parameter to schedule a time to run this
{timer_value | NOW} operation, in ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
A-43
Appendix A
RHPCTL Command Reference
Parameter Description
-smtpfrom "address" Optionally, you can specify an email address enclosed in double
quotation marks ("") from which Oracle Fleet Patching and Provisioning
sends patch manager notifications.
-smtpto "addresse1 Optionally, you can specify several email address enclosed in double
addresse2 ..." quotation marks ("") to which Oracle Fleet Patching and Provisioning
sends patch manager notifications.
-iso_repo iso_image Specifies the image in the ISO repository.
-patchmgrloc Specifies the patch manager location.
patch_mgr_loc
-ignoredbstarterror Use this parameter to ignore the database startup errors during Oracle
Grid Infrastructure patching.
-excludedbs file_path Use this parameter to start all patched databases except for the
database names specified in the input file. This parameter accepts path
of a file that contains comma-separated list of database names, which is
DB_UNIQUE_NAME.
Usage Notes
If you choose to use the -schedule parameter, then you must run this command on
the Fleet Patching and Provisioning Server.
Example
Assume there is a target cluster running Oracle Grid Infrastructure 12c release 1
(12.1.0.2) from a working copy named grid12102wcpy, and one of the nodes in the
cluster is named bposvr141. After provisioning the patched working copy, called
grid12102PSU (using the -softwareonly parameter with the rhpctl add workingcopy
command), move the Grid home to the patched working copy, as follows:
Syntax
A-44
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-sourcewc Specify the name of the source working copy from which the Oracle Grid
source_workingcopy_na Infrastructure home needs to be upgraded.
me
-sourcehome Alternative to specifying the name of the source working copy, you can
oracle_home_path specify the path to the unmanaged Oracle Grid Infrastructure home.
-targetnode In addition to specifying the source Oracle Grid Infrastructure home, you
target_node_name must also specify a node that is in a remote cluster that has no Oracle
Fleet Patching and Provisioning Client.
-destwc Specify the name of the destination working copy to which the Oracle
destination_workingco Grid Infrastructure home is to be upgraded.
py_name
-revert Specify this option to downgrade after a failed upgrade of Oracle Grid
Infrastructure.
-root | -sudouser If you choose to use the -targetnode parameter, then you must choose
sudo_username - either sudo or root to access the remote node.
sudopath If you choose sudo, then you must specify a user name to run super-
sudo_binary_path | - user operations, and a path to the location of the sudo binary.
cred cred_name
Optionally, you can choose to specify a credential name to associate the
user and password credentials to access a remote node.
Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-auth plugin-name [- Use an authentication plugin to access the remote node.
arg1 name1:value1 [- Optionally provide a list of arguments to the plugin.
arg2
name2:value2 ...]]
-ignoreprereq Use this parameter to ignore the CVU prerequisite checks.
-schedule Optionally, you can schedule a time to run this command in ISO-8601
{timer_value | NOW} format. For example: 2018-01-21T19:13:17+05.
If NOW is specified, then the job is scheduled immediately.
-useractiondata Value to be passed to useractiondata parameter of the useraction
user_action_data script.
-eval Evaluate without executing the command.
-batches List of batches of nodes in the format: "(Ba),...,(Bz)".
list_of_batches
-abort | -continue Abort the ongoing move operation or continue restarting the CRS stack
on the next batch of nodes.
A-45
Appendix A
RHPCTL Command Reference
Parameter Description
-ignoremissingpatches Proceed with the move and/or upgrade although the specified patches,
patch_name1[,patch_na which are present in the source path or working copy, may be missing
me2...] from the destination path or working copy.
-gimrwc gimr_wc_name Name of the destination working copy to which the Grid Infrastructure
Management Repository database needs to be upgraded.
-ignorecvucheck Ignore errors during post Oracle Grid Infrastructure upgrade CVU check .
Note:
For self upgrade of FPPS to 21c, you must use the rhpctl.sh script from the
Oracle Grid Infrastructure 21c home. You should also specify the -gimrwc
parameter.
image Commands
Use commands with the image keyword to add, delete, import, and manage gold
images.
• rhpctl add image
Use the rhpctl add image command to create an image from an existing working
copy and add it to the list of existing images on the Fleet Patching and
Provisioning Server configuration.
• rhpctl allow image
• rhpctl delete image
Deletes a specific image.
• rhpctl deploy image
• rhpctl disallow image
• rhpctl import image
Creates an image on the Fleet Patching and Provisioning Server.
• rhpctl instantiate image
• rhpctl modify image
• rhpctl query image
• rhpctl promote image
• rhpctl uninstantiate image
A-46
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Note:
The working copy must be stored on ACFS
storage for this command to work. Oracle
FPP returns an error if the working copy is
stored on a local storage device.
-imagetype image_type Specify the software type. ORACLEDBSOFTWARE (default) for Oracle
Database software, ORACLEGISOFTWARE for Oracle Grid Infrastructure
software, ORACLEGGSOFTWARE for Oracle GoldenGate software,
LINUXOS for Linux operating system ISO, or SOFTWARE for all other
software. If you use custom image types, then specify the name of your
image type.
-series series_name If you want to add an image to an image series, then specify the name of
an image series.
-state {TESTABLE | Specify the state of the image.
RESTRICTED |
PUBLISHED}
Usage Notes
See Also:
Patching Oracle Database for details about how to use this command in the
workflow for creating patched Oracle Database software homes
Example
An example of this command is:
A-47
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-image image_name Specify the name of the image to which you want to allow access.
-user user_name [- Specify the either of the following:
client cluster_name • A user for which you want to allow access to the image and,
| -role role_name optionally, the cluster name of the client cluster with the user.
• The role for which you want to allow access to the image.
Examples
To allow access to an image named PRODIMAGE:
Syntax
Usage Notes
• Specify the name of the image you want to delete
• Optionally, you can use the -schedule parameter to schedule a time to run this
operation, in ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
If you choose to use this parameter, then you must run this command on the Fleet
Patching and Provisioning Server. If NOW is specified, then the job is scheduled
immediately.
• This command will fail if the image belongs to one or more series
A-48
Appendix A
RHPCTL Command Reference
• This command will fail if there are any provisioned working copies based on this image
Example
The following example deletes an image named PRODIMAGEV0:
Syntax
Parameters
Parameter Description
-image image_name Specify the name of the image you want to deploy.
-targetnode node_name Optionally, you can specify the name of a node to which you want to
deploy the image. This parameter is required if the node hosting the
home is not a Fleet Patching and Provisioning Client.
-sudouser If you use the -targetnode parameter, then you must specify either
sudo_user_name - sudo or root to perform super user operations.
sudopath
sudo_binary_path | -
root]
Usage Notes
You can only run this command from a Fleet Patching and Provisioning Server.
Example
The following example deploys an Oracle Database Appliance image to a node:
Syntax
A-49
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-image image_name Specify the name of the image to which you want to disallow
access.
-user user_name [- Specify either of the following:
client client_name | • A user for which you want to disallow access to the image and,
-role role_name optionally, the cluster name of the client cluster with the user.
• The role for which you want to disallow access to the image.
Examples
To disallow access to an image:
Syntax
Parameters
Parameter Description
-image image_name Specify the name of the image that you want to add.
-path path Specify the absolute path location of the software home that you
want to import. For Oracle Database images, this is the
ORACLE_HOME.
A-50
Appendix A
RHPCTL Command Reference
Parameter Description
-zip Specify the absolute path of the compressed software home to be
zipped_home_path imported (a ZIP or TAR file).
Note:
Do not use this option when importing
an image from another platform. This
option works only on the same
platform, for example, if you are on a
Linux platform, then you can use the
-zip option to import an image only
from another Linux system.
-location Specify the location of the compressed image file on the target.
zipped_home_path
-notify [-cc Send an email notification.
users_list] Specify a list of users to whom email notifications is sent (in
addition to the owner of working copy).
-imagetype Specify the software type. Use ORACLEDBSOFTWARE (default) for
image_type Oracle database software, ORACLEGISOFTWARE for Oracle Grid
Infrastructure software, ODAPATCHSOFTWARE for engineered
systems (Oracle Data Appliance), EXAPATCHSOFTWARE for Oracle
Exadata software, or SOFTWARE for all other software. For a custom
image type, use the image type name.
-version Optionally, you can specify the version of the software you are
software_version importing.
-pathowner user_name Specify the user with read access to the files and directories under
the specified path.
Note: This parameter is applicable only for non-Oracle database
software homes.
-state {TESTABLE | Specify whether the state of the image is testable, restricted, or
RESTRICTED | published.
PUBLISHED
-location Location of the compressed image file on the target.
zipped_home_path
-client cluster_name Specify the name of the client cluster.
-targetnode Specify the name of the node from which you want to import the
node_name image. This parameter is required if the node hosting the home is
not an Fleet Patching and Provisioning Client.
-sudouser If you use the -targetnode parameter, then you must specify
sudo_user_name - either sudo or root to perform super user operations.
sudopath
sudo_binary_path | -
root]
A-51
Appendix A
RHPCTL Command Reference
Parameter Description
-auth plugin-name [- Use an authentication plugin to access the remote node.
arg1 name1:value1 [- Optionally provide a list of arguments to the plugin.
arg2
name2:value2 ...]]
-useractiondata Optionally, you can pass a value to the useractiondata
user_action_data parameter of the user action script.
-series series_name The name of the series.
Usage Notes
• You can only run this command on a Fleet Patching and Provisioning Server.
• When you import an Oracle Database or Oracle Grid Infrastructure software home,
the version of the home must be one of the versions that Fleet Patching and
Provisioning supports for provisioning and patching.
Examples
The following example imports an image:
Syntax
Parameters
Parameter Description
-server Specify a Fleet Patching and Provisioning Server cluster from
server_cluster_name which you want to request images.
A-52
Appendix A
RHPCTL Command Reference
Parameter Description
-image image_name | You can request copies of gold images from a peer Fleet Patching
-series series_name and Provisioning Server, specifically, by image name, series name,
| -imagetype or image type. Alternatively, you can use the -all parameter to
image_type | -all request copies of all gold images from the peer Fleet Patching and
Provisioning server.
If you choose to request images by image type, then specify
ORACLEDBSOFTWARE (default) for Oracle Database software,
ORACLEGISOFTWARE for Oracle Grid Infrastructure software,
ORACLEGGSOFTWARE for Oracle GoldenGate software, and
SOFTWARE for all other software. For a custom image type, use the
image type name.
Usage Notes
• User actions associated with an image being copied are not themselves copied.
• Groups configuration of a gold image is replicated in copies sent to peers.
• Copies of gold images are in the PUBLISHED state.
Syntax
Parameters
Parameter Description
-image image_name Specify the name of the image that you want to modify.
-imagetype image_type You can modify the software type. Use ORACLEDBSOFTWARE (default)
for Oracle database software, ORACLEGISOFTWARE for Oracle Grid
Infrastructure software, or SOFTWARE for all other software. For a
custom image type, use the image type name.
Syntax
A-53
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-image image_name [- Specify the name of the image you want to query.
dbtemplate] Optionally, you can use the -dbtemplate parameter to display template file
names in the default template directory.
-imagetype image_type Specify the software type. Use ORACLEDBSOFTWARE (default) for Oracle
database software, ORACLEGISOFTWARE for Oracle Grid Infrastructure
software, or SOFTWARE for all other software. For a custom image type, use the
image type name.
–version version Specify the version of the image software you are querying.
-platform platform Specify the operating system platform to which the image corresponds.
-server Specify the name of the server cluster to which the image corresponds.
server_cluster_name
-client client_name If this paramenter is used with the -image option, the command checks if the
specified client has the given image instantiated on it. Otherwise, the use of the
parameter lists the images instantiated on the given client.
-local List the images stored on the current client.
-drift List the the bug fixes not included in the golden image.
-rhpserver rhps_regex Specify a regular expression to match the cluster name of the servers where the
operation must be executed.
Usage Notes
If you use the -version parameter, then the version must have five fields, such as
12.1.0.2.4.
If you use the -platform parameter, then you can use Linux_AMD64, Linux_S390,
Linux_PPC, IBM_AIX_PPC64, HP_IA64, Linux_Itanium, Solaris_SPARC64, Linux_LOP,
and Intel_Solaris_AMD64
The -rhpserver parameter indicates where the operation should be executed and the
-server parameter indicates what the operation should be about. When -rhpserver is
used, the command is executed on the servers whose name matches the regular
expression provided. When -server is used, the command is about the server
provided. For example:
• The following command executes locally and lists the images that have been
replicated to peerA
A-54
Appendix A
RHPCTL Command Reference
• The following command executes on peerA and lists the images have been configured on
peerA
• The following command executes on all servers and lists the images that each server has
replicated on peerA
When issuing a command for a peer server using the -rhpserver option, the user running the
command must be an existing user of the peer server and the user must have a required role.
To enable a user from a peer server to run commands on the local server, run the rhpctl
grant role command to grant a required role to the peer server user and to specify the
cluster name of the peer server to which the user belongs. For example:
For information about granting roles with RHPCTL, refer to rhpctl grant role
Syntax
Parameters
Parameter Description
-image image_name Specify the name of the image that you want to promote.
-state {TESTABLE | Specify one of the following as the name of the state of the image:
RESTRICTED | TESTABLE:
PUBLISHED}
RESTRICTED:
PUBLISHED:
A-55
Appendix A
RHPCTL Command Reference
Example
To promote an image named PRODIMAGE:
Syntax
Parameters
Parameter Description
-server Specify a Fleet Patching and Provisioning Server cluster from
server_cluster_name which you want to stop updates.
-image image_name | You can updates from a peer Fleet Patching and Provisioning
-series series_name Server, specifically, by image name, series name, or image type.
| -imagetype Alternatively, you can use the -all parameter to stop updates from
image_type | -all the peer Fleet Patching and Provisioning server.
If you choose to stop updates by image type, then specify
ORACLEDBSOFTWARE (default) for Oracle Database software,
ORACLEGISOFTWARE for Oracle Grid Infrastructure software,
ORACLEGGSOFTWARE for Oracle GoldenGate software, and
SOFTWARE for all other software. For a custom image type, use the
image type name.
imagetype Commands
Use commands with the imagetype keyword to add, delete, modify, and manage an
image type.
• rhpctl add imagetype
Configures a new image type and its associated user actions.
• rhpctl allow imagetype
• rhpctl delete imagetype
• rhpctl disallow imagetype
• rhpctl modify imagetype
• rhpctl query imagetype
A-56
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-imagetype image_type Specify the name of the image type you are creating.
-basetype {SOFTWARE | Specify a base image type on which the image type you are creating is
ORACLEGISOFTWARE | based. Use ORACLEDBSOFTWARE (default) for Oracle Database software,
ORACLEDBSOFTWARE | ORACLEGISOFTWARE for Oracle Grid Infrastructure software,
ORACLEGGSOFTWARE} ORACLEGGSOFTWARE for Oracle GoldenGate software, and SOFTWARE for
all other software.
-useractions Specify a comma-delimited list of names of user actions
user_action_list
Example
To add a new image type:
rhpctl add imagetype -imagetype DB122_PATCH_TYPE -basetype ORACLEDBSOFTWARE
Syntax
Parameters
Parameter Description
-imagetype image_type Specify the name of the image type to which you are granting access.
Use ORACLEDBSOFTWARE (default) for Oracle database software,
ORACLEGISOFTWARE for Oracle Grid Infrastructure software, or
SOFTWARE for all other software. For a custom image type, use the
image type name.
A-57
Appendix A
RHPCTL Command Reference
Parameter Description
-user user_name Specify an operating system user to whom you are granting access to
the image type. Either this parameter or the -role parameter is
required.
-client cluster_name Optionally, you can specify the name of the client cluster to which the
operating system user belongs, if you choose to use the -user
parameter.
-role role_name Alternative to the -user parameter, you can specify a particular role to
which to grant access to the image.
Syntax
Usage Notes
Specify an image type to delete. You cannot delete any of the built-in image types.
Syntax
Parameters
Parameter Description
-imagetype Specify the name of the image type from which you are revoking
image_type access. Use ORACLEDBSOFTWARE (default) for Oracle database
software, ORACLEGISOFTWARE for Oracle Grid Infrastructure
software, or SOFTWARE for all other software. For a custom image
type, use the image type name.
-user user_name Specify an operating system user from whom you are revoking
access to the image type. Either this parameter or the -role
parameter is required.
-client cluster_name Optionally, you can specify the name of the client cluster to which
the operating system user belongs, if you choose to use the -user
parameter.
A-58
Appendix A
RHPCTL Command Reference
Parameter Description
-role role_name Alternative to the -user parameter, you can specify a particular
role from which to revoke access to the image.
Syntax
Parameters
Parameter Description
-imagetype image_type Specify the name of the image type you want to modify. Use
ORACLEDBSOFTWARE (default) for Oracle database software,
ORACLEGISOFTWARE for Oracle Grid Infrastructure software,
ORACLEGGSOFTWARE for Oracle GoldenGate software, or SOFTWARE for
all other software. For a custom image type, use the image type name.
-useractions Specify a comma-delimited list of names of user actions
user_action_list
Syntax
Parameters
Parameter Description
-imagetype image_type Specify the name of the image type you want to query. Use ORACLEDBSOFTWARE
(default) for Oracle database software, ORACLEGISOFTWARE for Oracle Grid
Infrastructure software, ORACLEGGSOFTWARE for Oracle GoldenGate software, or
SOFTWARE for all other software. For a custom image type, use the image type
name.
-rhpserver rhps_regex Specify a regular expression to match the cluster name of the servers where the
operation must be executed.
A-59
Appendix A
RHPCTL Command Reference
Usage Notes
Specify the name of the image type you want to query. Use ORACLEDBSOFTWARE
(default) for Oracle database software, ORACLEGISOFTWARE for Oracle Grid
Infrastructure software, or SOFTWARE for all other software. For a custom image
type, use the image type name.
The -rhpserver parameter indicates where the operation should be executed and the
-server parameter indicates what the operation should be about. When -rhpserver is
used, the command is executed on the servers whose name matches the regular
expression provided. When -server is used, the command is about the server
provided. For example:
• The following command executes locally and lists the image types that have been
replicated to peerA
• The following command executes on peerA and lists the image types have been
configured on peerA
• The following command executes on all servers and lists the image types that
each server has replicated on peerA
When issuing a command for a peer server using the -rhpserver option, the user
running the command must be an existing user of the peer server and the user must
have a required role. To enable a user from a peer server to run commands on the
local server, run the rhpctl grant role command to grant a required role to the peer
server user and to specify the cluster name of the peer server to which the user
belongs. For example:
For information about granting roles with RHPCTL, refer to rhpctl grant role
job Commands
Use commands with the job keyword to delete or query schedule jobs.
A-60
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-jobid job_id Optionally, you can specify the job ID value for the job you want to delete
that you obtained while scheduling the job. If you choose not to use this
parameter, then RHPCTL deletes all jobs.
–force Use this parameter to forcibly delete a job.
Usage Notes
You must run this command on the Fleet Patching and Provisioning Server.
Example
To delete a job with a job ID of 1:
Syntax
Parameters
Parameter Description
-jobid job_id Optionally, you can specify the job ID value for the job you want to query.
The job Id is obtained while scheduling the job.
If you choose this parameter, then the only other option you can specify
is -summary. If you do not choose this parameter, then all jobs are
queried.
A-61
Appendix A
RHPCTL Command Reference
Parameter Description
-status {EXECUTED | Optionally, you can specify any of the following states of a job that you
TIMER_RUNNING | want to query:
EXECUTING | UNKNOWN | • EXECUTED: The job is complete.
TERMINATED } • TIMER_RUNNING: The timer for the job is still running.
• EXECUTING: The timer for the job has expired and is running.
• UNKNOWN: There is an unexpected failure due to issues such as a
target going down, nodes going down, or any resource failures.
• TERMINATED: There is an abrupt failure or the operation has
stopped.
-client client_namek Optionally, you can specify the name of a client cluster for which you
want to query jobs.
-user user_name Optionally, you can specify the user name of the user for whom a
software home is being provisioned.
-since timer_value Optionally, you can specify a date from which to query the jobs, in
ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
-summary Optionally, you can use this parameter to return only job details.
-eval Optionally, you can use this parameter to query only evaluation jobs.
-migrate Optionally, you can use this parameter to query only migration jobs.
Usage Notes
You must run this command on the Fleet Patching and Provisioning Server.
Example
To query a specified scheduled job:
Job ID: 1
User: fred
Client: fredlinux4
Scheduled job command: "rhpctl import image -image DB-Image1 -
imagetype ORACLEDBSOFTWARE -path /ade/fred_linux4/esw1 -schedule
2018-07-27T13:38:57Z"
Scheduled job execution start time: 2018-07-27T05:38:57-08. Equivalent
local time: 2018-07-27 05:38:57
Current status: EXECUTED
Result file path: "/scratch/rhp_storage/chkbase/scheduled/
job-1-2017-11-27-05:39:14.log"
Job execution start time: 2018-07-27 05:39:14
Job execution end time: 2018-07-27 05:43:09
A-62
Appendix A
RHPCTL Command Reference
osconfig Commands
Use commands with the osconfig keyword to backup, compare, and manage operating
system configuration information.
• rhpctl collect osconfig
• rhpctl compare osconfig
• rhpctl disable osconfig
• rhpctl enable osconfig
• rhpctl query osconfig
Syntax
Parameters
Parameter Description
-client cluster_name Specify the name of the client cluster.
-targetnode node_name Optionally, you can specify the name of a particular node in a cluster
from which to collect configuration information.
-sudouser If you use the -targetnode parameter, then you must specify either
sudo_user_name - sudo or root to perform super user operations.
sudopath
sudo_binary_path | -
root]
A-63
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-client cluster_name Specify the name of the client cluster in which you want to compare
operating system configurations.
-node node_name Specify the name of a node in a remote cluster.
-id1 identifier Specify an identifier of an operating system configuration to be
considered as a reference.
-id2 identifier Specify an identifier of an operating system configuration to be
compared.
Syntax
Usage Notes
• Optionally, you can specify a client cluster name on which you want to disable
collection of operating system configuration information.
• Optionally, you can use the –clean parameter to delete all operating system
configuration backups.
Syntax
A-64
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-client cluster_name Specify the name of the client cluster.
-retaincopies count Optionally, you can specify the number of scheduled backups you want
to be maintained. The default value is 37.
-start timer_value Optionally, you can specify a start date and time to run configuration
collection according to the following example: 2018-07-23T00:00:00-07
-frequency Optionally, you can specify the configuration collection interval in number
collect_frequency of days.
-collectnow Optionally, you can use this parameter to collect configuration
information, immediately.
-targetnode node_name Optionally, you can specify the name of a particular node in a cluster
from which to collect configuration information.
-sudouser If you use the -targetnode parameter, then you must specify either
sudo_user_name - sudo or root to perform super user operations.
sudopath
sudo_binary_path | -
root]
-force Optionally, you can use this parameter to forcibly modify the count for the
-retaincopies parameter previously set.
Syntax
Usage Notes
Provide the name of the client cluster that you want to query operating system configuration
collection information.
Example
This command returns output similar to the following:
A-65
Appendix A
RHPCTL Command Reference
peerserver Commands
Use commands with the peerserver keyword to display information for a peer server.
Syntax
Parameters
Parameter Description
-server Optionally, you can specify the name of the Fleet Patching and
server_cluster_name Provisioning Server cluster for which you want to view the
information.
-serverPolicy Optionally, you can specify the image policy for the peer Fleet
Patching and Provisioning Server for which you want to view the
information.
role Commands
Use commands with the role keyword to add, delete, and manage roles.
A-66
Appendix A
RHPCTL Command Reference
See Also:
Fleet Patching and Provisioning Roles
Syntax
Parameters
Parameter Description
–role role_name Specify a name for the role that you want to create.
A-67
Appendix A
RHPCTL Command Reference
Parameter Description
-hasRoles roles Specify a comma-delimited list of roles to include with the new role.
GH_ROLE_ADMIN
GH_AUDIT_ADMIN
GH_USER_ADMIN
GH_SITE_ADMIN
GH_WC_ADMIN
GH_WC_OPER
GH_WC_USER
GH_IMG_ADMIN
GH_IMG_USER
GH_SUBSCRIBE_USER
GH_SUBSCRIBE_ADMIN
GH_IMGTYPE_ADMIN
GH_IMGTYPE_ALLOW
GH_IMGTYPE_OPER
GH_SERIES_ADMIN
GH_SERIES_CONTRIB
GH_IMG_TESTABLE
GH_IMG_RESTRICT
GH_IMG_PUBLISH
GH_IMG_VISIBILITY
GH_JOB_USER
GH_JOB_ADMIN
GH_AUTHENTICATED_USER
GH_CLIENT_ACCESS
GH_ROOT_UA_CREATE
GH_ROOT_UA_ASSOCIATE
GH_ROOT_UA_USE
GH_OPER
GH_CA
GH_SA
OTHER
Usage Notes
• You can only run this command on the Fleet Patching and Provisioning Server.
• You must be assigned the GH_ROLE_ADMIN role to run this command.
Example
To add a role on the Fleet Patching and Provisioning Server:
A-68
Appendix A
RHPCTL Command Reference
Syntax
Usage Notes
• Specify the name of the role that you want to delete
• You cannot delete any built-in roles
• You can only run this command on the Fleet Patching and Provisioning Server
Example
To delete a role from the Fleet Patching and Provisioning Server:
Syntax
Note:
The -client option works only on the Oracle Fleet Patching and Provisioning
Server.
Parameters
Parameter Description
-role role_name Specify the name of the role that you want to grant clients or users.
A-69
Appendix A
RHPCTL Command Reference
Parameter Description
-user user_name [- Specify the name of a user. The user name that you specify must be in
client cluster_name] the form of user@rhpclient, where rhpclient is the name of the
Fleet Patching and Provisioning Client.
Optionally, you can specify the name of the client cluster to which the
user belongs.
Note:
The -client option works only on the
Oracle Fleet Patching and Provisioning
Server.
-grantee role_name Use this parameter to specify a role to which you want to grant another
role.
[-client You can map either built-in roles or roles that you have defined to either
cluster_name] - users on a specific client cluster or to specific users.
maproles When you use the -maproles parameter, use a plus sign (+) to map
role=user_name[+user_ more than one user to a specific role. Separate additional role/user pairs
name...] with commas.
[,role=user_name[+use
r_name...][,...]
Note:
Starting with Oracle Grid Infrastructure
21c, the -maproles parameter is
deprecated. This parameter can be
desupported in a future release.
Example
The following example grants a role, ABC, to four specific users.
Syntax
A-70
Appendix A
RHPCTL Command Reference
Usage Notes
• Specify the name of the role for which you want to display the configuration information
• You can only run this command on the Fleet Patching and Provisioning Server
Example
This command returns output similar to the following:
Syntax
Parameters
Parameter Description
–role role_name Specify the name of the role from which you want to revoke clients or
users.
-user user_name [- Specify the name of a user and, optionally, a client cluster from which
client cluster_name] you want to revoke a role. The user name that you specify must be in the
form of user@rhpclient, where rhpclient is the name of the Fleet
Patching and Provisioning Client.
-grantee role_name Specify the grantee role name.
A-71
Appendix A
RHPCTL Command Reference
Parameter Description
[-client client_name] You can map either built-in roles or roles that you have defined to specific
-maproles users. Use a plus sign (+) to map more than one user to a specific role.
role=user_name[+user_ Separate additional role/user pairs with commas. Optionally, you can
name...] also specify a client cluster.
Note:
Starting with Oracle Grid Infrastructure
21c, the -maproles parameter is
deprecated. This parameter can be
desupported in a future release.
series Commands
Use commands with the series keyword to add, delete, subscribe, and manage a
series.
• rhpctl add series
• rhpctl delete series
Deletes a series from the Fleet Patching and Provisioning Server configuration.
• rhpctl deleteimage series
• rhpctl insertimage series
Inserts an existing image into a series.
• rhpctl query series
• rhpctl subscribe series
• rhpctl unsubscribe series
Syntax
Parameters
Parameter Description
-series series_name Specify a name for the series that you want to add.
A-72
Appendix A
RHPCTL Command Reference
Parameter Description
-image image_name Optionally, you can specify the name of a configured image. This
image becomes the first in the series.
Example
To add a series:
Syntax
Usage Notes
• Specify the name of the series that you want to delete.
• Use -force to delete an image series even if the series includes images.
• Before deleting an image series, you must first remove all images from the series by
using the rhpctl deleteimage series command.
• This command does not delete images, only series.
Example
The following example deletes a series called PRODDBSERIES:
Syntax
Parameters
Parameter Description
-series series_name Specify the name of the series from which you want to delete an image.
A-73
Appendix A
RHPCTL Command Reference
Parameter Description
-image image_name Specify the name of the image that you want to delete from a series.
Example
The following command deletes an image called PRODIMAGEV0 from a series called
PRODDBSERIES:
Note:
A single image can belong to one or more series.
Syntax
Parameters
Parameter Description
Specify the name of the series into which you want to insert an
-series image.
series_name
Specify the name of the image that you want to insert into a series.
-image image_name
Optionally, you can specify the name of an image before which you
-before image_name want to insert the new image.
Example
To insert an image into a series:
A-74
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-series series_name Specify the name of the series for which you want to display the configuration.
-image image_name Alternatively, you can specify the name of a configured image.
-server Specify the name of the server cluster to which the image corresponds.
server_cluster_name
-rhpserver rhps_regex Specify a regular expression to match the cluster name of the servers where the
operation must be executed.
Usage Notes
If you do not specify a series or an image by name, then CRSCTL returns information for all
series.
The -rhpserver parameter indicates where the operation should be executed and -server
indicates who the operation should be about. When -rhpserver is used, the command is
executed on the servers whose name matches the regular expression provided. When -
server is used, the command will be about the server provided. For example:
• The following command executes locally and lists the series that have been replicated to
peerA
• The following command executes on peerA and lists the series have been configured on
peerA
• The following command executes on all servers and lists the series that each server has
replicated on peerA
When issuing a command for a peer server using the -rhpserver option, the user running the
command must be an existing user of the peer server and the user must have a required role.
To enable a user from a peer server to run commands on the local server, run the rhpctl
A-75
Appendix A
RHPCTL Command Reference
grant role command to grant a required role to the peer server user and to specify
the cluster name of the peer server to which the user belongs. For example:
For information about granting roles with RHPCTL, refer to rhpctl grant role
Example
This command returns output similar to the following:
Syntax
Parameters
Parameter Description
-series series_name Specify the image series to which you want to subscribe a user.
-user user_name Specify an operating system user to whom you are subscribing the
image series.
-client cluster_name Optionally, you can specify the name of the client cluster to which
the operating system user belongs.
A-76
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-series series_name Specify the image series from which you want to unsubscribe a user.
-user user_name Specify an operating system user from whom you are unsubscribing the
image series.
-client cluster_name Optionally, you can specify the name of the client cluster to which the
operating system user belongs.
server Commands
Use commands with the server keyword to export, register, unregister, and query Oracle
Fleet Patching and Provisioning Server.
• rhpctl export server
• rhpctl query server
Displays the configuration of a server.
• rhpctl register server
• rhpctl unregister server
Syntax
Usage Notes
• Specify the name of a peer server cluster.
• Specify the path to the file containing the Fleet Patching and Provisioning Server data.
Syntax
A-77
Appendix A
RHPCTL Command Reference
Usage Notes
This command has no parameters.
Example
This command displays output similar to the following:
Syntax
Parameters
Parameter Description
-server Specify the name of the Fleet Patching and Provisioning Server
server_cluster_name cluster that you want to register.
-serverdata file Specify the path to the file containing the Fleet Patching and
Provisioning Server data.
-root | -cred Choose -root to perform super user operations as root.
cred_name | - Alternatively, you can choose either to specify a credential name to
sudouser associate the user name and password credentials to access a
sudo_user_name - remote node, to perform super user operations as a sudo user by
sudopath specifying a sudo user name and the path to the sudo binary, or to
sudo_binary_location use an authentication plugin to access the remote node.
| -auth plugin_name
plugin_args
Syntax
A-78
Appendix A
RHPCTL Command Reference
Usage Notes
• Specify the name of the Fleet Patching and Provisioning Server you want to unregister as
a peer.
• Optionally, you can use the -force parameter to forcibly unregister the server.
user Commands
Use commands with the user keyword to delete, modify, register, and unregister users.
Syntax
Parameters
Parameter Description
-user user_name Specify the name of the user you want to delete from a Fleet Patching
and Provisioning Client.
-client cluster_name Optionally, you can specify the name of the client cluster from which you
want to delete from a specific user.
Usage Notes
• You can delete non built-in users only if that user does not own any working copies.
• If the user created an image or image series, then you can still delete the user, but the
creator of the image or image series is changed to internal-user@GHS.
• If the user was the owner of an image series, then you can delete the user, but the owner
of the image series will be changed to internal-user@GHS. You can still use the affected
image series as normal, such that you can still provision a working copy from the affected
image series, and you can still insert or delete images from the affected image series.
Example
The following example deletes the user named scott on the server cluster from the Fleet
Patching and Provisioning repository:
A-79
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-user user_name Specify an operating system user whose email address you want to
modify.
-email email_address Specify the email address of the operating system user in the RFC
822 format.
-client client_name Optionally, you can specify the name of the client cluster to which
the operating system user belongs.
Syntax
Parameters
Parameter Description
-user user_name Specify an operating system user whose email address you want to
register.
-email email_address Specify the email address of the operating system user in the RFC
822 format.
-client client_name Optionally, if you run the command on the Fleet Patching and
Provisioning Server, then you can specify the name of the client
cluster to which the operating system user belongs. Otherwise, the
command applies to a user on the cluster (either the Fleet Patching
and Provisioning Server or Client) where the command is run.
A-80
Appendix A
RHPCTL Command Reference
Example
An example of this command is:
Syntax
Parameters
Parameter Description
-user user_name Specify an operating system user whose email address you want to
unregister.
-client client_name Optionally, you can specify the name of the client cluster to which the
operating system user belongs.
useraction Commands
Use commands with the useraction keyword to add, delete, and modify user actions.
Syntax
A-81
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-useraction Specify the name of the user action you want to add.
user_action_name
-actionscript Associate a specific action script to run with the user action.
script_name
-actionfile Optionally, you can specify an action file that is required by the user
file_name action.
-pre | -post Use the -pre parameter to run the user action before the add
operation or the -post parameter to run the user action after.
-optype option Optionally, you can specify the operation for which the user action
is configured. Options include:
IMPORT_IMAGE
ADD_WORKINGCOPY
DELETE_WORKINGCOPY
ADD_DATABASE
DELETE_DATABASE
MOVE_DATABASE
ADD_PDB_DATABASE
DELETE_PDB_DATABASE
MOVE_GIHOME
UPGRADE_DATABASE
UPGRADE_GIHOME
ADDNODE_GIHOME
DELETENODE_GIHOME
ADDNODE_DATABASE
DELETENODE_DATABASE
ADDNODE_WORKINGCOPY
ZDTUPGRADE_DATABASE
ZDTUPGRADE_DATABASE_SNAPDB
ZDTUPGRADE_DATABASE_DBUA
ZDTUPGRADE_DATABASE_SWITCHBACK
MIGRATE_DATABASE
UPDATE_EXADATA
-phase Specify the phase of the operation for which the user action is
configured.
-onerror {ABORT | Optionally, you can choose whether to abort or continue the
CONTINUE} operation if the user action encounters an error while it is running.
-runscope {ONENODE | Optionally, you can specify the nodes where the user action is run.
ALLNODES | AUTO | Choose ONENODE to run the user action for each database on the
FIRSTNODEONRHPS | node on which a patch was applied to the database. Choose
LASTNODEONRHPS | ALLNODES to run the user action for each database on every cluster
ALLNODESONRHPS} node. Choose AUTO for a run scope based on the other command
options.
Specify FIRSTNODEONRHPS, LASTNODEONRHPS, or
ALLNODESONRHPS to run the user action script on FPPS when the
operation is performed on first node or last node or all nodes.
A-82
Appendix A
RHPCTL Command Reference
Parameter Description
-runasroot Run the rhpctl add useraction command as root user.
-runninginstance Specify this parameter to run the user action only on the nodes that
have a running database instance. You can use this parameter only
with the MOVE_DATABASE, MOVE_GIHOME, and UPGRADE_DATABASE
operation types.
Syntax
Usage Notes
Specify the name of a user action you want to delete.
Syntax
Parameters
Parameter Description
-useraction Specify the name of the user action you want to modify.
user_action_name
-actionscript Optionally, you can specify an action script to run.
script_name
-pre | -post Use the -pre parameter to run the user action before the modify
operation or the -post parameter to run the user action after.
A-83
Appendix A
RHPCTL Command Reference
Parameter Description
-optype option Optionally, you can specify the operation for which the user action is
configured. Options include:
IMPORT_IMAGE
ADD_WORKINGCOPY
DELETE_WORKINGCOPY
ADD_DATABASE
DELETE_DATABASE
MOVE_DATABASE
ADD_PDB_DATABASE
DELETE_PDB_DATABASE
MOVE_GIHOME
UPGRADE_DATABASE
UPGRADE_GIHOME
ADDNODE_GIHOME
DELETENODE_GIHOME
ADDNODE_DATABASE
DELETENODE_DATABASE
ADDNODE_WORKINGCOPY
ZDTUPGRADE_DATABASE
ZDTUPGRADE_DATABASE_SNAPDB
ZDTUPGRADE_DATABASE_DBUA
ZDTUPGRADE_DATABASE_SWITCHBACK
MIGRATE_DATABASE
UPDATE_EXADATA
-onerror {ABORT | Optionally, you can choose whether to abort or continue the operation if
CONTINUE} the user action encounters an error while it is running.
-runscope {ONENODE | Optionally, you can specify the nodes where the user action is run.
ALLNODES | AUTO | Optionally, you can specify the nodes where the user action is run.
FIRSTNODEONRHPS | Choose ONENODE to run the user action for each database on the node
LASTNODEONRHPS | on which a patch was applied to the database. Choose ALLNODES to run
ALLNODESONRHPS} the user action for each database on every cluster node. Choose AUTO
for a run scope based on the other command options.
Specify FIRSTNODEONRHPS, LASTNODEONRHPS, or ALLNODESONRHPS to
run the user action script on FPPS when the operation is performed on
first node or last node or all nodes.
-runninginstance Specify this parameter to run the user action only on the nodes that have
a running database instance. You can use this parameter only with the
MOVE_DATABASE, MOVE_GIHOME, and UPGRADE_DATABASE operation
types.
A-84
Appendix A
RHPCTL Command Reference
Syntax
Parameters
Parameter Description
-useraction Specify the name of the user action you want to query.
user_action_name
-imagetype image_type Alternatively, you can specify the software type. Use
ORACLEDBSOFTWARE (default) for Oracle database software,
ORACLEGISOFTWARE for Oracle Grid Infrastructure software, and
SOFTWARE for all other software. For a custom image type, use the
image type name.
-optype option Optionally, you can specify the operation for which to run the query.
Options include:
IMPORT_IMAGE
ADD_WORKINGCOPY
DELETE_WORKINGCOPY
ADD_DATABASE
DELETE_DATABASE
MOVE_DATABASE
ADD_PDB_DATABASE
DELETE_PDB_DATABASE
MOVE_GIHOME
UPGRADE_DATABASE
UPGRADE_GIHOME
ADDNODE_GIHOME
DELETENODE_GIHOME
ADDNODE_DATABASE
DELETENODE_DATABASE
ADDNODE_WORKINGCOPY
ZDTUPGRADE_DATABASE
ZDTUPGRADE_DATABASE_SNAPDB
ZDTUPGRADE_DATABASE_DBUA
ZDTUPGRADE_DATABASE_SWITCHBACK
MIGRATE_DATABASE
UPDATE_EXADATA
workingcopy Commands
Use commands with the workingcopy keyword to create, update, extend, and delete working
copies.
• rhpctl add workingcopy
Creates a working copy on a client cluster.
A-85
Appendix A
RHPCTL Command Reference
Syntax
To add a working copy to a client cluster:
A-86
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-workingcopy Specify a name for the working copy that you want to create.
workingcopy_name
{-image image_name | - Specify the name of a configured image from which to create a working copy or
series series_name} the name of an image series from which RHPCTL takes the latest image when
adding a working copy.
-oraclebase Specify an ORACLE_BASE path for provisioning an Oracle Database or Oracle
oracle_base_path Grid Infrastructure home. You can specify either an existing directory or a new
directory.
Note: This parameter is required only for the ORACLEDBSOFTWARE and
ORACLEGISOFTWARE image types.
-inventory Specify the location of the Oracle Inventory directory.
inventory_path
-path absolute_path Specify the absolute path for provisioning the software home on the client side
(this location must be empty). For Oracle Database images, this becomes the
ORACLE_HOME.
Note: This parameter is required for LOCAL storage types, and is invalid for
RHP_MANAGED.
-localmount Specify this option to provision the working copy using the locally mounted
compressed image file.
-location Specify the location of the compressed image file on the target.
zipped_home_path
-storagetype {LOCAL | Specify the type of storage for the software home.
RHP_MANAGED}
-user user_name Specify the name of the user that will own the working copy being provisioned.
If you do not specify this parameter, then the working copy is owned by the user
running the command. If you are provisioning to a remote cluster, then the user
name must be a valid user on the remote cluster. The user ID need not be the
same between the two clusters, but the user name must exist on both.
Note: You cannot use -user simultaneously with the -softwareonly
parameter.
-gimr Perform the operations required for a Grid Infrastructure Management Repository
(GIMR) database
-dbname unique_db_name Specify the unique name of the database (DB_UNIQUE_NAME without DB_DOMAIN)
that you are adding.
-dbtype {RACONENODE | Specify whether the database is Oracle RAC One Node, Oracle RAC, or a
RAC | SINGLE} nonclustered database.
-datafileDestination Specify the data file destination location or the name of the Oracle Automatic
datafileDestination_path Storage Management (Oracle ASM) disk group.
Note: You cannot specify a disk group for Oracle Database versions before
Oracle Database 11g release 2 (11.2).
-dbtemplate file_path | Specify the absolute file path to a database template or the relative path to the
image_name:relative_file image home directory on a Fleet Patching and Provisioning Server.
_path
A-87
Appendix A
RHPCTL Command Reference
Parameter Description
-node node_list Specify a node or comma-delimited list of several nodes.
Enter a node name for a single-instance Oracle home.
-serverpool Specify the name of an existing server pool.
server_pool_name
-newpqpool Optionally, you can create a new server pool to be used for parallel queries.
server_pool_name Specify a name for the new server pool.
Note: This parameter is only applicable in an Oracle Flex Cluster environment
because it refers to server pools running on non-Hub Nodes.
-newpool Optionally, you can create a new server pool. Specify a name for the new server
server_pool_name pool.
-pqcardinality If you create a new server pool, then you must specify a cardinality value for the
cardinality server pool.
Note: This parameter is only applicable in an Oracle Flex Cluster environment.
-cardinality cardinality If you create a new server pool, then you must specify a cardinality value for the
server pool.
-cdb Optionally, use this parameter to create a database as a container database.
-pdbName pdb_prefix If you are creating one or more pluggable databases, then specify a pluggable
database name prefix.
-numberOfPDBs pdb_count Specify the number of pluggable databases you want to create.
-client cluster_name Specify the name of the client cluster.
Note:
Oracle recommends that you specify a unique
name for the client cluster.
-clusternamealias Optionally, you can specify the client cluster alias if the client cluster name is not
unique.
-ignoreprereq | -fixup You can choose to ignore the Clusterware Verification Utility (CVU) checks or you
can choose to run the recommended fixup script.
Note: These parameters are valid only when you are provisioning Oracle Grid
Infrastructure.
-responsefile Specify a response file to use when you provision Oracle Grid Infrastructure.
response_file_path
-clusternodes Specify a comma-delimited list of cluster node information on which to provision
node_name:node_vip[:node Oracle Clusterware.
_role]
[,node_name:node_vip[:no
de_role]...]
A-88
Appendix A
RHPCTL Command Reference
Parameter Description
-groups "OSDBA|OSOPER| Specify a comma-delimited list of Oracle groups, enclosed in double quotation
OSASM|OSBACKUP|OSDG| marks (""), that you want to configure in the working copy.
OSKM| For example:
OSRAC=group_name[,...]"
-groups "OSDBA=dba,OSOPER=oper"
When you create a gold image from a source home or working copy, the gold
image inherits the groups configured in the source. When you create a working
copy from that gold image using rhpctl add workingcopy, by default, the new
working copy inherits the same groups as the gold image.
If you use the -groups parameter on the command line, then:
• Groups configured in the gold image that you do not specify on the command
line are inherited by the working copy.
• Groups configured in the gold image that you also specify on the command
line are set to the value that you specify on the command line (command line
parameters override the gold image).
• Groups that you specify on the command line that are not in the gold image
are added to the configured groups in the gold image (the command line
adds new groups).
Notes:
• When you move or upgrade a source home (unmanaged or working copy),
the groups in the destination working copy must match those of the source
home.
• You cannot use -groups simultaneously with the -softwareonly
parameter.
-root | -cred cred_name If you choose to use the -targetnode parameter, then you must choose either
| -sudouser root, a credential name, sudo, or an authentication plugin to access the remote
sudo_user_name -sudopath node.
sudo_binary_location | - Choose -root to perform super user operations as root. Alternatively, you can
auth plugin_name choose either to specify a credential name to associate the user name and
plugin_args password credentials to access a remote node, to perform super user operations
as a sudo user by specifying a sudo user name and the path to the sudo binary,
or to use an authentication plugin to access the remote node.
-notify [-cc user_list] Specify this parameter to have email notifications sent to the owner of the
working copy. Optionally, you can include a list of additional users who will receive
notifications.
-asmclientdata data_path Specify the path to a file that contains Oracle ASM client data.
-gnsclientdata data_path Specify the path to a file that contains the Grid Naming Service (GNS) data.
-clustermanifest Optionally, you can specify the location of cluster manifest file. You can use this
data_path parameter when the Fleet Patching and Provisioning Server is on a domain
services cluster and you are creating a member cluster.
-local Use this parameter to provision only Oracle Grid Infrastructure software on the
local node.
Note: You can only use this parameter in conjunction with the -softwareonly
parameter, and only when running the rhpctl add workingcopy command on
a Fleet Patching and Provisioning Server.
-softwareonly Use this parameter to provision only Oracle Grid Infrastructure software.
A-89
Appendix A
RHPCTL Command Reference
Parameter Description
-targetnode Specify the name of a node in a remote cluster with no Fleet Patching and
target_node_name Provisioning Client on which you want to provision a working copy.
-agpath read_write_path Use –agpath to specify the path to the read-write, site-specific configuration
-aupath gold_image_path changes to set the persistent home path, and use –aupath to specify the path for
the read-only gold image to set the persistent home path.
-setupssh Use this parameter to set up passwordless SSH user equivalence on the remote
nodes for the provisioning user.
-useractiondata Optionally, you can pass a value to the useractiondata parameter of the user
user_action_data action script.
–eval Optionally, you can use this parameter to evaluate the impact of this command on
the system without actually running the command.
-schedule {timer_value | Optionally, you can use this parameter to schedule a time to run this operation, in
NOW} ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
Usage Notes
Note:
Member Clusters, which are part of the Oracle Cluster Domain architecture,
are desupported in Oracle Grid Infrastructure 21c.
Note:
Domain Services Cluster (DSC), which is part of the Oracle Cluster Domain
architecture, is deprecated in Oracle Grid Infrastructure 21c and can be
desupported in a future release.
A-90
Appendix A
RHPCTL Command Reference
• You can obtain context sensitive help for specific use cases for the rhpctl add
workingcopy command, as follows:
• If you choose to use the -schedule parameter, then you must run this command on the
Fleet Patching and Provisioning Server.
Examples
• To create a working copy on a client cluster for yourself or another user:
• To provision a working copy on a node or a cluster where Oracle Fleet Patching and
Provisioning does not exist:
A-91
Appendix A
RHPCTL Command Reference
Note:
If you are provisioning Oracle database software to a Fleet Patching and
Provisioning Client that has been configured with an Oracle ASM disk group,
then do not specify the -path parameter, so as to enable the Fleet Patching
and Provisioning Client to use storage provided by Fleet Patching and
Provisioning.
If the Fleet Patching and Provisioning Client is not configured with an Oracle
ASM disk group, then specify the -storagetype parameter with LOCAL, in
addition to specifying the -path parameter.
Syntax
Parameters
Parameter Description
-workingcopy Specify the name of a working copy that contains the Oracle
workingcopy_name database you want to extend.
-node node_list Specify a node or a comma-delimited list of nodes to which you
want to extend the database.
-targetnode Optionally, you can specify a node on which to run this command.
node_name
-root | -sudouser If you choose to use the -targetnode parameter, then you must
sudo_username - choose either sudo or root to access the remote nodes.
sudopath If you choose sudo, then you must specify a user name to run
sudo_binary_path | - super-user operations, and a path to the location of the sudo
cred cred_name | - binary.
auth plugin_name [-
Optionally, you can choose to specify a credential name to
arg1 associate the user and password credentials to access a remote
name1:value1...] node.
Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-ignoreprereq Use this parameter to ignore the CVU prerequisite checks.
A-92
Appendix A
RHPCTL Command Reference
Parameter Description
-setupssh Sets up passwordless SSH user equivalence on the remote nodes
for the provisioning user.
-useractiondata Optionally, you can pass a value to the useractiondata
user_action_data parameter of the user action script.
–eval Optionally, you can use this parameter to evaluate the impact of this
command on the system without actually running the command.
-schedule Optionally, you can schedule a time to run this command in
{timer_value | NOW} ISO-8601 format. For example: 2018-01-21T19:13:17+05.
If NOW is specified, then the job is scheduled immediately.
Usage Notes
• If you are extending a policy-managed database, then the database automatically starts
on the new nodes.
• If you are extending an administrator-managed database, then you must also run the
rhpctl addnode database command to start the instance.
• If the target cluster is an Oracle Clusterware 11g release 2 (11.2) or 12c release 1 (12.1)
cluster, then you must provide either root credentials or provide a sudo user. You must
also specify a target node that must be the node name of one of the cluster nodes.
Syntax
Parameters
Parameter Description
-workingcopy Specify the name of a working copy that you want to delete.
workingcopy_name
-notify [-cc Name of a node in a remote cluster with no Fleet Patching and
user_list] Provisioning Client.
-targetnode node_name Optionally, you can specify a particular node from which you want to
delete a working copy.
-force Use this parameter to forcibly delete the database working copy.
A-93
Appendix A
RHPCTL Command Reference
Parameter Description
-root | -sudouser If you choose to use the -targetnode parameter, then you must choose
sudo_username - either sudo or root to access the remote node.
sudopath If you choose sudo, then you must specify a user name to run super-
sudo_binary_path | - user operations, and a path to the location of the sudo binary.
cred cred_name
Optionally, you can choose to specify a credential name to associate the
user and password credentials to access a remote node.
Alternative to –sudouser, –root, or –cred, you can use –auth to
specify an authentication plugin to access a remote node.
-useractiondata Optionally, you can pass a value to the useractiondata parameter of
user_action_data the user action script.
-schedule Optionally, you can use this parameter to schedule a time to run this
{timer_value | NOW} operation, in ISO-8601 format, as in the following example:
2018-07-25T19:13:17+05
Usage Notes
• This command will not delete the working copy if there are any databases
configured on it. Use the -force option to override this.
• This command will not not delete the working copy if there are any running
databases on it. The -force option will not override this.
• This command does not delete the Oracle base that was created when you ran
rhpctl add workingcopy.
• If you choose to use the -schedule parameter, then you must run this command
on the Fleet Patching and Provisioning Server.
Examples
To delete a working copy:
Syntax
A-94
Appendix A
RHPCTL Command Reference
Parameters
Parameter Description
-workingcopy Specify the name of a working copy for which you want to display the
workingcopy_name configuration information.
-metadataonly Use this paramter only when you use the -workingcopyy parameter to query
only the metadata of the working copy, which is located in the repository and not
run OPatch or connect to the target to query for extra information.
-image image_name [- Use this paramter to specify the name of a configured image that you want to
drift] query. If you specify an image name, then RHPCTL lists all the working copies
based on that image.
The -drift optipn lists the bug fixes not included in the golden image.
-client cluster_name Optionally, you can specify a client cluster on which to query working copies.
-rhpserver rhps_regex Specify a regular expression to match the cluster name of the servers where the
operation must be executed.
Usage Notes
When issuing a command for a peer server using the -rhpserver option, the user running the
command must be an existing user of the peer server and the user must have a required role.
To enable a user from a peer server to run commands on the local server, run the rhpctl
grant role command to grant a required role to the peer server user and to specify the
cluster name of the peer server to which the user belongs. For example:
For information about granting roles with RHPCTL, refer to rhpctl grant role
A-95