Upgrading the Oracle Database Protector on RAC system
The Oracle Database Protector build provides an automated script to manage the upgrade process in a multi-node environment. The master script internally calls the scripts to install and upgrade the components. The master script installs and upgrades the components in the following order:
- Log Forwarder
- RPAgent
- Policy Enforcement Point (Database Protector)
The master script is available in the directory where the installation files are extracted. It provides the following arguments:
install- installs the components in an interactive mode.upgrade- installs a newer version of the protector with minimal downtime.silent- installs the components in a non-interactive mode.install.ini- installs the components as per the parameters provided in the file.help- lists the arguments available for the script.
During the upgrade process, the master script:
- Verifies the existing configuration.
- Creates a backup of the existing configuration.
- Stops the required services.
- Drops the existing UDFs.
- Installs the new version.
- Starts the required services.
- Creates the new UDFs and retains the existing configuration.
In addition, the master script will rollback the upgrade process if any errors are encountered. The script will revert the changes and restore the previous working version of the Oracle Database Protector.
Viewing the Arguments for the Script
- Log in to the instance where the installation package is extracted.
- Navigate to the directory containing the installation scripts.
- To view the arguments, run the following command:
./Install_OracleProtector_Linux_x64_<DBP_version>.sh --help - Press ENTER.
The script lists the available arguments.
Options: --install Use this option when installing the solution for the first time on a machine/host. (i.e., there is no previous installation present) --upgrade Use this option when upgrading an existing installation on the machine/host. --install-ini <file> (Optional) Provide a path to an install.ini file for silent or pre-configured installations. This option works with --install only. It must not be used with --upgrade or --silent. You can pass this either as: --install-ini /path/to/install.ini or --install-ini=/path/to/install.ini Refer to the product documentation for details about the configuration options available in install.ini. The documentation describes all supported keys, required fields, and example configurations. --silent (Optional) Runs the installation/upgrade in silent mode with minimum interactive prompts. --help, -h Display this help message and exit.
Upgrading the Protector using the Interactive Mode
- Log in to the instance where the installation package is extracted.
- Navigate to the directory containing the installation scripts.
- To execute the upgrade script, run the following command:
./Install_OracleProtector_Linux_x64_<DBP_version>.sh --upgrade - Press ENTER.
The prompt to select the silent mode of installation appears.
2025-12-30 06:55:19 - [INFO] If silent mode is selected, the default base directory (/opt/protegrity) will be used as the location of the existing installation for each component (Logforwarder, RPAgent and DatabaseProtector). Do you want silent installation? (yes/no) [no]: - To use the interactive mode, type
no. - Press ENTER.
The prompt to enter the location of the existing installation appears.
Enter existing installation directories: Existing LogForwarder installation directory [/opt/protegrity]: - Enter the directory path where the existing version of the Log Forwarder is installed.
- Press ENTER.
The prompt to enter RPAgent installation directory appears.
Existing RPAgent installation directory [/opt/protegrity]: - Enter the directory path where the existing version of the RPAgent is installed.
- Press ENTER.
The prompt to enter the Database Protector installation directory appears.
Existing DatabaseProtector installation directory [/opt/protegrity]: - Enter the directory path where the existing version of the Database Protector is installed.
- Press ENTER.
The prompt to select a single installation directory for the components appears.
Do you want to install the new LogForwarder, RPAgent, and DatabaseProtector together in a single directory? (yes/no) [no]: - To install the new components in a single directory, type
yes. - Press ENTER.
The prompt to enter the installation directory for the new version appears.
Enter new installation directory [/opt/protegrity]: - Enter the location where the components must be installed.
- Press ENTER.
The script detects and lists the configuration and a prompt to confirm appears.
2025-12-30 06:55:48 - [INFO] Verifying previous installation directories for all components... 2025-12-30 06:55:48 - [INFO] Existing LogForwarder directory: /opt/protegrity1/logforwarder 2025-12-30 06:55:48 - [INFO] Existing RPAgent directory: /opt/protegrity1/rpagent 2025-12-30 06:55:48 - [INFO] Existing DatabaseProtector directory: /opt/protegrity1/databaseprotector 2025-12-30 06:55:48 - [INFO] All existing component directories verified successfully. 2025-12-30 06:55:48 - [INFO] Discovering Grid Infrastructure home dynamically... 2025-12-30 06:55:48 - [INFO] Discovered GRID_HOME: /u01/app/21.3.0./grid 2025-12-30 06:55:48 - [INFO] Grid home found: /u01/app/21.3.0./grid 2025-12-30 06:55:48 - [INFO] RAC setup detected 2025-12-30 06:55:48 - [INFO] Current node: <node_name> (<node_name>.localdomain.com) 2025-12-30 06:55:48 - [INFO] Other nodes: <node_name> <node_name> 2025-12-30 06:55:48 - [INFO] Checking for required tools... 2025-12-30 06:55:48 - [INFO] All required tools are available 2025-12-30 06:55:48 - [INFO] Going to configure environment for upgrade 2025-12-30 06:55:48 - [INFO] Discovered ORACLE_SID=orcl1, ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1 2025-12-30 06:55:48 - [INFO] Oracle environment set: 2025-12-30 06:55:48 - [INFO] ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1 2025-12-30 06:55:48 - [INFO] ORACLE_SID=orcl1 2025-12-30 06:55:48 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/21.3.0/db_1/lib 2025-12-30 06:55:48 - [INFO] PATH=/u01/app/21.3.0./grid/bin:/sbin:/bin:/usr/sbin:/usr/bin:/u01/app/oracle/product/21.3.0/db_1/bin 2025-12-30 06:55:48 - [INFO] Environment configured successfully... 2025-12-30 06:55:48 - [INFO] ************************************************************************** 2025-12-30 06:55:48 - [INFO] Upgrade will be done with following configuration: 2025-12-30 06:55:48 - [INFO] Oracle Instance ID: orcl1 2025-12-30 06:55:48 - [INFO] Mode: upgrade 2025-12-30 06:55:48 - [INFO] Existing Logforwarder Installation Directory: /opt/protegrity1 2025-12-30 06:55:48 - [INFO] Existing RPAgent Installation Directory: /opt/protegrity1 2025-12-30 06:55:48 - [INFO] Existing DatabaseProtector Installation Directory: /opt/protegrity1 2025-12-30 06:55:48 - [INFO] New Logforwarder Installation Directory: /opt/protegrity 2025-12-30 06:55:48 - [INFO] New RPAgent Installation Directory: /opt/protegrity 2025-12-30 06:55:48 - [INFO] New DatabaseProtector Installation Directory: /opt/protegrity 2025-12-30 06:55:48 - [INFO] Audit Store Endpoints: <IP_Address>:9200 <IP_Address>:9200 <IP_Address>:9200 2025-12-30 06:55:48 - [INFO] Upstream (ESA) Hostname or IP Address for RPAgent: <IP_Address> 2025-12-30 06:55:48 - [INFO] Upstream (ESA) Port for RPAgent: 25400 (Default) 2025-12-30 06:55:48 - [INFO] This is an upgrade. 2025-12-30 06:55:48 - [INFO] Previous installations will be backed up before upgrade. 2025-12-30 06:55:48 - [INFO] Existing Logforwarder and RPAgent configurations will be retained 2025-12-30 06:55:48 - [INFO] RAC setup detected with nodes: <node_name> <node_name> <node_name> 2025-12-30 06:55:48 - [INFO] ************************************************************************** 2025-12-30 06:55:48 - [WARN] ************************************************************************** 2025-12-30 06:55:48 - [WARN] IMPORTANT: Any queries currently running may be impacted during upgrade. 2025-12-30 06:55:48 - [WARN] It is recommended to perform the upgrade during a maintenance window. 2025-12-30 06:55:48 - [WARN] ************************************************************************** 2025-12-30 06:55:48 - [INFO] Please verify the above configuration before proceeding. Do you want to continue? (yes/no) [no]: - To proceed with the upgrade, type
yes. - Press ENTER.
The script creates a backup of the existing configuration, installs the Log Forwarder, RPAgent, and the Oracle objects. The prompt to select a common username for the node appears.
2025-12-30 06:55:50 - [INFO] Continuing with upgrade... 2025-12-30 06:55:50 - [INFO] Backing up /opt/protegrity1/logforwarder to /opt/protegrity1/logforwarder_backup_20251230065550... 2025-12-30 06:55:50 - [INFO] Backup of /opt/protegrity1/logforwarder completed Successfully... 2025-12-30 06:55:50 - [INFO] Backing up /opt/protegrity1/rpagent to /opt/protegrity1/rpagent_backup_20251230065550... 2025-12-30 06:55:50 - [INFO] Backup of /opt/protegrity1/rpagent completed Successfully... 2025-12-30 06:55:50 - [INFO] Backing up /opt/protegrity1/databaseprotector to /opt/protegrity1/databaseprotector_backup_20251230065550... 2025-12-30 06:55:50 - [INFO] Backup of /opt/protegrity1/databaseprotector completed Successfully... 2025-12-30 06:55:50 - [INFO] Backing up /etc/protegrity to /etc/protegrity_backup_20251230065550... 2025-12-30 06:55:50 - [INFO] Backup of /etc/protegrity completed Successfully... 2025-12-30 06:55:50 - [INFO] Existing Logforwarder is currently running. 2025-12-30 06:55:50 - [INFO] Existing RPAgent is currently running. 2025-12-30 06:55:50 - [INFO] Installing/Upgrading LOGFORWARDER... 2025-12-30 06:55:50 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh... Unpacking... Extracting files... Protegrity Log Forwarder installed in /opt/protegrity/logforwarder. 2025-12-30 06:55:51 - [INFO] Retaining existing Logforwarder configuration... 2025-12-30 06:55:51 - [INFO] Logforwarder configuration retained successfully. 2025-12-30 06:55:51 - [INFO] Updating configuration files in /opt/protegrity/logforwarder/data to use new installation directory. 2025-12-30 06:55:51 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully. 2025-12-30 06:55:51 - [INFO] Installing/Upgrading RPAGENT... 2025-12-30 06:55:51 - [INFO] Executing ./RPAgentSetup_Linux_x64_<DBP_version>.sh... Unpacking... Extracting files... Since --nocert was provided certificates are not downloaded automatically. Protegrity RPAgent installed in /opt/protegrity/rpagent. 2025-12-30 06:55:51 - [INFO] Retaining existing RPAgent configuration... 2025-12-30 06:55:51 - [INFO] RPAgent configuration retained successfully. 2025-12-30 06:55:51 - [INFO] Updating configuration files in /opt/protegrity/rpagent/data to use new installation directory. 2025-12-30 06:55:51 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully. 2025-12-30 06:55:51 - [INFO] Installing/Upgrading DBP... 2025-12-30 06:55:51 - [INFO] Executing ./PepOracleSetup_Linux_x64_<DBP_version>.sh... ***************************************************** Welcome to the Database Protector Setup Wizard ***************************************************** This will install the oracle objects on your computer Do you want to continue? [yes or no] Enter installation directory. A new directory will be created in the installation directory. [/opt/protegrity]: Unpacking... Extracting files... oracle objects installed in /opt/protegrity/databaseprotector/oracle. 2025-12-30 06:55:51 - [INFO] Retaining existing Database Protector configuration... 2025-12-30 06:55:51 - [INFO] Database Protector configuration retained successfully. 2025-12-30 06:55:51 - [INFO] Updating configuration files in /opt/protegrity/databaseprotector/oracle/data to use new installation directory. 2025-12-30 06:55:51 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully. 2025-12-30 06:55:51 - [INFO] Going to stop existing Logforwarder instance 2025-12-30 06:56:01 - [INFO] Existing Logforwarder successfully stopped 2025-12-30 06:56:01 - [INFO] Going to launch <DBP_version> version Logforwarder 2025-12-30 06:56:03 - [INFO] Successfully launched <DBP_version> version Logforwarder 2025-12-30 06:56:03 - [INFO] Going to stop existing RPAgent instance 2025-12-30 06:56:04 - [INFO] Existing RPAgent successfully stopped 2025-12-30 06:56:04 - [INFO] Going to launch <DBP_version> version RPAgent 2025-12-30 06:56:04 - [INFO] Successfully launched <DBP_version> version RPAgent 2025-12-30 06:56:04 - [INFO] Configuring extproc.ora 2025-12-30 06:56:04 - [INFO] Backed up existing /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora 2025-12-30 06:56:04 - [INFO] Updated EXTPROC_DLLS in /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora to only include /opt/protegrity/databaseprotector/oracle/lib/peporacle.plm 2025-12-30 06:56:04 - [INFO] Updated extproc.ora at /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora 2025-12-30 06:56:04 - [INFO] Detected separate runtime home: /u01/app/oracle/homes/OraDB21Home1 2025-12-30 06:56:04 - [INFO] Runtime extproc.ora symlink already points to canonical: /u01/app/oracle/homes/OraDB21Home1/hs/admin/extproc.ora -> /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora 2025-12-30 06:56:04 - [INFO] Synchronized extproc.ora in runtime home /u01/app/oracle/homes/OraDB21Home1/hs/admin 2025-12-30 06:56:04 - [INFO] Configuring RAC nodes... 2025-12-30 06:56:04 - [INFO] Performing pre-check on all RAC nodes before making changes... Do you want to enter one remote username to be used for all nodes? (yes/no) [no]: - To use the same username for all the nodes, type
yes. - Press ENTER.
The prompt to enter the username appears.
Enter remote username for all nodes (must be in sudoers): - Enter the username.
- Press ENTER.
The script establishes a connection to every node. The prompt to enter the password appears.
2025-12-30 06:56:09 - [INFO] Opening SSH connection to <node_name> for precheck... 2025-12-30 06:56:09 - [INFO] Opening SSH master connection to <node_name>... Warning: Permanently added '<node_name>,<IP_address>' (ECDSA) to the list of known hosts. <user_name>@<node_name>'s password: - Enter the password.
- Press ENTER.
The script validates the credentials. The prompt to enter the password for the next node appears.
2025-12-30 06:56:14 - [INFO] SSH master connection to <node_name> ready 2025-12-30 06:56:14 - [INFO] Checking sudo access for <node_name>... 2025-12-30 06:56:14 - [INFO] Precheck OK for <node_name> 2025-12-30 06:56:14 - [INFO] Opening SSH connection to <node_name> for precheck... 2025-12-30 06:56:14 - [INFO] Opening SSH master connection to <node_name>... Warning: Permanently added '<node_name>,<IP_address>' (ECDSA) to the list of known hosts. <user_name>@<node_name>'s password: - Enter the password.
- Press ENTER.
The script completes the configuration. The prompt to create the UDF appears.
2025-12-30 06:56:18 - [INFO] SSH master connection to <node_name> ready 2025-12-30 06:56:18 - [INFO] Checking sudo access for <node_name>... 2025-12-30 06:56:18 - [INFO] Precheck OK for <node_name> 2025-12-30 06:56:18 - [INFO] Precheck complete. Starting RAC node configuration... 2025-12-30 06:56:18 - [INFO] Stopping existing Logforwarder on <node_name> 2025-12-30 06:56:34 - [INFO] Syncing /opt/protegrity/logforwarder to <node_name>... 2025-12-30 06:56:37 - [INFO] Starting new Logforwarder on <node_name> 2025-12-30 06:56:39 - [INFO] Stopping existing RPAgent on <node_name> 2025-12-30 06:56:40 - [INFO] Syncing /opt/protegrity/rpagent to <node_name>... 2025-12-30 06:56:42 - [INFO] Starting new RPAgent on <node_name> 2025-12-30 06:56:42 - [INFO] Syncing /opt/protegrity/databaseprotector to <node_name>... 2025-12-30 06:56:43 - [INFO] Syncing /etc/protegrity to <node_name>... 2025-12-30 06:56:43 - [INFO] Updating extproc.ora on <node_name> 2025-12-30 06:56:43 - [INFO] Updating runtime extproc.ora symlink on <node_name> 2025-12-30 06:56:43 - [INFO] Node <node_name> configured successfully. 2025-12-30 06:56:43 - [INFO] Stopping existing Logforwarder on <node_name> 2025-12-30 06:56:59 - [INFO] Syncing /opt/protegrity/logforwarder to <node_name>... 2025-12-30 06:57:02 - [INFO] Starting new Logforwarder on <node_name> 2025-12-30 06:57:04 - [INFO] Stopping existing RPAgent on <node_name> 2025-12-30 06:57:06 - [INFO] Syncing /opt/protegrity/rpagent to <node_name>... 2025-12-30 06:57:07 - [INFO] Starting new RPAgent on <node_name> 2025-12-30 06:57:07 - [INFO] Syncing /opt/protegrity/databaseprotector to <node_name>... 2025-12-30 06:57:08 - [INFO] Syncing /etc/protegrity to <node_name>... 2025-12-30 06:57:08 - [INFO] Updating extproc.ora on <node_name> 2025-12-30 06:57:08 - [INFO] Updating runtime extproc.ora symlink on <node_name> 2025-12-30 06:57:08 - [INFO] Node <node_name> configured successfully. Do you want to continue and create UDFs? To create the UDFs, provide the database credentials (yes/no) [no]: - To create the UDFs, type
yes. - Press ENTER.
The prompt to enter the database username appears.
Enter Oracle database username: - Enter the username to connect to the database.
- Press ENTER.
The prompt to enter the database password appears.
Enter Oracle database user's password: - Enter the password.
- Press ENTER.
The prompt to confirm the username appears.
Was a different Oracle database user used for creation of existing UDFs? (yes/no) [no]: - To confirm whether a different user was used to create the existing UDFs, type
yes. - Press ENTER.
The prompt to enter the previous username appears.
Enter previous Oracle database username (for dropping existing UDFs): - Enter the database username that was used to create the existing UDFs.
- Press ENTER.
The prompt to enter the password for the previous username appears.
Enter previous Oracle database user's password: - Enter the password.
- Press ENTER.
The script drops the existing UDFs, creates the new UDFs, and completes the upgrade process.
2025-12-30 06:57:32 - [INFO] Dropping existing types and UDFs 2025-12-30 06:57:32 - [INFO] Using username '<user_name>' for database connection and dropping existing types and UDFs. 2025-12-30 06:57:32 - [INFO] Running SQL script: Drop existing types and UDFs (/opt/protegrity1/databaseprotector_backup_20251230065550/oracle/sqlscripts/dropobjects.sql) 2025-12-30 06:57:33 - [INFO] sqlplus output: Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Package body dropped. Package dropped. Library dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. 2025-12-30 06:57:33 - [INFO] Drop existing types and UDFs executed successfully. 2025-12-30 06:57:33 - [INFO] Existing types and UDFs dropped successfully. 2025-12-30 06:57:33 - [INFO] Going to create new types and UDFs. 2025-12-30 06:57:33 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs. 2025-12-30 06:57:33 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity/databaseprotector/oracle/sqlscripts/createobjects.sql) 2025-12-30 06:57:33 - [INFO] sqlplus output: Library created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Package created. Package body created. Grant succeeded. Grant succeeded. Synonym created. Synonym created. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. 2025-12-30 06:57:33 - [INFO] Create new types and UDFs executed successfully. 2025-12-30 06:57:33 - [INFO] New types and UDFs created successfully. 2025-12-30 06:57:33 - [INFO] Testing UDFs installation... 2025-12-30 06:57:34 - [INFO] Test UDFs output: <DBP_version> 2025-12-30 06:57:34 - [INFO] UDFs installation tested successfully. 2025-12-30 06:57:34 - [INFO] Removing previous installation directories. 2025-12-30 06:57:34 - [INFO] Removing previous Logforwarder directory /opt/protegrity1/logforwarder 2025-12-30 06:57:34 - [INFO] Removing previous RPAgent directory /opt/protegrity1/rpagent 2025-12-30 06:57:34 - [INFO] Removing previous DatabaseProtector directory /opt/protegrity1/databaseprotector 2025-12-30 06:57:34 - [INFO] Removing previous installation directories on <node_name>. 2025-12-30 06:57:34 - [INFO] Removing previous Logforwarder directory /opt/protegrity1/logforwarder on <node_name> 2025-12-30 06:57:34 - [INFO] Removing previous RPAgent directory /opt/protegrity1/rpagent on <node_name> 2025-12-30 06:57:34 - [INFO] Removing previous DatabaseProtector directory /opt/protegrity1/databaseprotector on <node_name> 2025-12-30 06:57:34 - [INFO] Removing previous installation directories on <node_name>. 2025-12-30 06:57:34 - [INFO] Removing previous Logforwarder directory /opt/protegrity1/logforwarder on <node_name> 2025-12-30 06:57:34 - [INFO] Removing previous RPAgent directory /opt/protegrity1/rpagent on <node_name> 2025-12-30 06:57:34 - [INFO] Removing previous DatabaseProtector directory /opt/protegrity1/databaseprotector on <node_name> 2025-12-30 06:57:34 - [INFO] Removing backups... 2025-12-30 06:57:34 - [INFO] Removing Logforwarder backup directory /opt/protegrity1/logforwarder_backup_20251230065550 2025-12-30 06:57:34 - [INFO] Removing RPAgent backup directory /opt/protegrity1/rpagent_backup_20251230065550 2025-12-30 06:57:34 - [INFO] Removing Database Protector backup directory /opt/protegrity1/databaseprotector_backup_20251230065550 2025-12-30 06:57:34 - [INFO] Removing User configuration backup directory /etc/protegrity_backup_20251230065550 2025-12-30 06:57:34 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora.bak_2025-12-30_06:56:04 2025-12-30 06:57:34 - [INFO] Closing SSH master connections... 2025-12-30 06:57:34 - [INFO] Connection to <node_name> closed. 2025-12-30 06:57:34 - [INFO] Connection to <node_name> closed. 2025-12-30 06:57:34 - [INFO] Upgrade successful. 2025-12-30 06:57:34 - [INFO] All components upgraded successfully.
Upgrading the Protector using the Silent Mode
- Log in to the instance where the installation package is extracted.
- Navigate to the directory containing the installation scripts.
- To execute the upgrade script, run the following command:
./Install_OracleProtector_Linux_x64_<DBP_version>.sh --upgrade - Press ENTER.
The prompt to select the silent mode of installation appears.
2025-12-30 06:55:19 - [INFO] If silent mode is selected, the default base directory (/opt/protegrity) will be used as the location of the existing installation for each component (Logforwarder, RPAgent and DatabaseProtector). Do you want silent installation? (yes/no) [no]: - To use the silent mode, type
yes. - Press ENTER.
The script detects and lists the configuration and a prompt to confirm appears.
2025-12-30 06:59:12 - [INFO] You have chosen silent mode. Therefore, /opt/protegrity is considered as base directory for new installation. 2025-12-30 06:59:12 - [INFO] This is an upgrade and you have chosen silent mode. Therefore, /opt/protegrity is considered as base directory for existing installation. 2025-12-30 06:59:12 - [INFO] Verifying previous installation directories for all components... 2025-12-30 06:59:12 - [INFO] Existing LogForwarder directory: /opt/protegrity/logforwarder 2025-12-30 06:59:12 - [INFO] Existing RPAgent directory: /opt/protegrity/rpagent 2025-12-30 06:59:12 - [INFO] Existing DatabaseProtector directory: /opt/protegrity/databaseprotector 2025-12-30 06:59:12 - [INFO] All existing component directories verified successfully. 2025-12-30 06:59:12 - [INFO] Discovering Grid Infrastructure home dynamically... 2025-12-30 06:59:12 - [INFO] Discovered GRID_HOME: /u01/app/21.3.0./grid 2025-12-30 06:59:12 - [INFO] Grid home found: /u01/app/21.3.0./grid 2025-12-30 06:59:12 - [INFO] RAC setup detected 2025-12-30 06:59:12 - [INFO] Current node: <node_name> (<node_name>.localdomain.com) 2025-12-30 06:59:12 - [INFO] Other nodes: <node_name> <node_name> 2025-12-30 06:59:12 - [INFO] Checking for required tools... 2025-12-30 06:59:12 - [INFO] All required tools are available 2025-12-30 06:59:12 - [INFO] Going to configure environment for upgrade 2025-12-30 06:59:12 - [INFO] Discovered ORACLE_SID=orcl1, ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1 2025-12-30 06:59:12 - [INFO] Oracle environment set: 2025-12-30 06:59:12 - [INFO] ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1 2025-12-30 06:59:12 - [INFO] ORACLE_SID=orcl1 2025-12-30 06:59:12 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/21.3.0/db_1/lib 2025-12-30 06:59:12 - [INFO] PATH=/u01/app/21.3.0./grid/bin:/sbin:/bin:/usr/sbin:/usr/bin:/u01/app/oracle/product/21.3.0/db_1/bin 2025-12-30 06:59:12 - [INFO] Environment configured successfully... 2025-12-30 06:59:12 - [INFO] ************************************************************************** 2025-12-30 06:59:12 - [INFO] Upgrade will be done with following configuration: 2025-12-30 06:59:12 - [INFO] Oracle Instance ID: orcl1 2025-12-30 06:59:12 - [INFO] Mode: upgrade 2025-12-30 06:59:12 - [INFO] Existing Logforwarder Installation Directory: /opt/protegrity 2025-12-30 06:59:12 - [INFO] Existing RPAgent Installation Directory: /opt/protegrity 2025-12-30 06:59:12 - [INFO] Existing DatabaseProtector Installation Directory: /opt/protegrity 2025-12-30 06:59:12 - [INFO] New Logforwarder Installation Directory: /opt/protegrity 2025-12-30 06:59:12 - [INFO] New RPAgent Installation Directory: /opt/protegrity 2025-12-30 06:59:12 - [INFO] New DatabaseProtector Installation Directory: /opt/protegrity 2025-12-30 06:59:12 - [INFO] Audit Store Endpoints: <IP_Address>:9200 <IP_Address>:9200 <IP_Address>:9200 2025-12-30 06:59:12 - [INFO] Upstream (ESA) Hostname or IP Address for RPAgent: <IP_Address> 2025-12-30 06:59:12 - [INFO] Upstream (ESA) Port for RPAgent: 25400 (Default) 2025-12-30 06:59:12 - [INFO] This is an upgrade. 2025-12-30 06:59:12 - [INFO] Previous installations will be backed up before upgrade. 2025-12-30 06:59:12 - [INFO] Existing Logforwarder and RPAgent configurations will be retained 2025-12-30 06:59:12 - [INFO] RAC setup detected with nodes: <node_name> <node_name> <node_name> 2025-12-30 06:59:12 - [INFO] ************************************************************************** 2025-12-30 06:59:12 - [WARN] ************************************************************************** 2025-12-30 06:59:12 - [WARN] IMPORTANT: Any queries currently running may be impacted during upgrade. 2025-12-30 06:59:12 - [WARN] It is recommended to perform the upgrade during a maintenance window. 2025-12-30 06:59:12 - [WARN] ************************************************************************** 2025-12-30 06:59:12 - [INFO] Please verify the above configuration before proceeding. Do you want to continue? (yes/no) [no]: - To proceed with the configuration, type
yes. - Press ENTER.
The script installs the components. The prompt to enter the username to access the node appears.
2025-12-30 06:59:14 - [INFO] Continuing with upgrade... 2025-12-30 06:59:14 - [INFO] Backing up /opt/protegrity/logforwarder to /opt/protegrity/logforwarder_backup_20251230065914... 2025-12-30 06:59:14 - [INFO] Backup of /opt/protegrity/logforwarder completed Successfully... 2025-12-30 06:59:14 - [INFO] Backing up /opt/protegrity/rpagent to /opt/protegrity/rpagent_backup_20251230065914... 2025-12-30 06:59:14 - [INFO] Backup of /opt/protegrity/rpagent completed Successfully... 2025-12-30 06:59:14 - [INFO] Backing up /opt/protegrity/databaseprotector to /opt/protegrity/databaseprotector_backup_20251230065914... 2025-12-30 06:59:14 - [INFO] Backup of /opt/protegrity/databaseprotector completed Successfully... 2025-12-30 06:59:14 - [INFO] Backing up /etc/protegrity to /etc/protegrity_backup_20251230065914... 2025-12-30 06:59:14 - [INFO] Backup of /etc/protegrity completed Successfully... 2025-12-30 06:59:14 - [INFO] Existing Logforwarder is currently running. 2025-12-30 06:59:14 - [INFO] Existing RPAgent is currently running. 2025-12-30 06:59:14 - [INFO] Installing/Upgrading LOGFORWARDER... 2025-12-30 06:59:14 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh... Unpacking... Extracting files... Protegrity Log Forwarder installed in /opt/protegrity/logforwarder. 2025-12-30 06:59:14 - [INFO] Retaining existing Logforwarder configuration... 2025-12-30 06:59:14 - [INFO] Logforwarder configuration retained successfully. 2025-12-30 06:59:14 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully. 2025-12-30 06:59:14 - [INFO] Installing/Upgrading RPAGENT... 2025-12-30 06:59:14 - [INFO] Executing ./RPAgentSetup_Linux_x64_<DBP_version>.sh... Unpacking... Extracting files... Since --nocert was provided certificates are not downloaded automatically. Protegrity RPAgent installed in /opt/protegrity/rpagent. 2025-12-30 06:59:14 - [INFO] Retaining existing RPAgent configuration... 2025-12-30 06:59:14 - [INFO] RPAgent configuration retained successfully. 2025-12-30 06:59:14 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully. 2025-12-30 06:59:14 - [INFO] Installing/Upgrading DBP... 2025-12-30 06:59:14 - [INFO] Executing ./PepOracleSetup_Linux_x64_<DBP_version>.sh... ***************************************************** Welcome to the Database Protector Setup Wizard ***************************************************** This will install the oracle objects on your computer Do you want to continue? [yes or no] Enter installation directory. A new directory will be created in the installation directory. [/opt/protegrity]: Unpacking... Extracting files... oracle objects installed in /opt/protegrity/databaseprotector/oracle. 2025-12-30 06:59:14 - [INFO] Retaining existing Database Protector configuration... 2025-12-30 06:59:14 - [INFO] Database Protector configuration retained successfully. 2025-12-30 06:59:14 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully. 2025-12-30 06:59:14 - [INFO] Going to stop existing Logforwarder instance 2025-12-30 06:59:30 - [INFO] Existing Logforwarder successfully stopped 2025-12-30 06:59:30 - [INFO] Going to launch <DBP_version> version Logforwarder 2025-12-30 06:59:32 - [INFO] Successfully launched <DBP_version> version Logforwarder 2025-12-30 06:59:32 - [INFO] Going to stop existing RPAgent instance 2025-12-30 06:59:33 - [INFO] Existing RPAgent successfully stopped 2025-12-30 06:59:33 - [INFO] Going to launch <DBP_version> version RPAgent 2025-12-30 06:59:33 - [INFO] Successfully launched <DBP_version> version RPAgent 2025-12-30 06:59:33 - [INFO] Configuring extproc.ora 2025-12-30 06:59:33 - [INFO] Backed up existing /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora 2025-12-30 06:59:33 - [INFO] Updated EXTPROC_DLLS in /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora to only include /opt/protegrity/databaseprotector/oracle/lib/peporacle.plm 2025-12-30 06:59:33 - [INFO] Updated extproc.ora at /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora 2025-12-30 06:59:33 - [INFO] Detected separate runtime home: /u01/app/oracle/homes/OraDB21Home1 2025-12-30 06:59:33 - [INFO] Runtime extproc.ora symlink already points to canonical: /u01/app/oracle/homes/OraDB21Home1/hs/admin/extproc.ora -> /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora 2025-12-30 06:59:33 - [INFO] Synchronized extproc.ora in runtime home /u01/app/oracle/homes/OraDB21Home1/hs/admin 2025-12-30 06:59:33 - [INFO] Configuring RAC nodes... 2025-12-30 06:59:33 - [INFO] Performing pre-check on all RAC nodes before making changes... Do you want to enter one remote username to be used for all nodes? (yes/no) [no]: - To use different usernames for each of the nodes, type
no. - Press ENTER.
The prompt to enter the username for the node appears.
Enter remote username for node <node_name> (must be in sudoers): - Enter the username.
- Press ENTER.
The script validates the username and the prompt to enter the password appears.
2025-12-30 06:59:55 - [INFO] Opening SSH connection to <node_name> for precheck... 2025-12-30 06:59:55 - [INFO] Opening SSH master connection to <node_name>... Warning: Permanently added '<node_name>,<IP_Address>' (ECDSA) to the list of known hosts. root@<node_name>'s password: - Enter the password.
- Press ENTER.
The script validates the credentials and the prompt to enter the username for the next node appears.
2025-12-30 06:59:59 - [INFO] SSH master connection to <node_name> ready 2025-12-30 06:59:59 - [INFO] Checking sudo access for <node_name>... 2025-12-30 06:59:59 - [INFO] Precheck OK for <node_name> Enter remote username for node <node_name> (must be in sudoers): - Enter the username.
- Press ENTER.
The script validates the username and the prompt to enter the password appears.
2025-12-30 07:00:01 - [INFO] Opening SSH connection to <node_name> for precheck... 2025-12-30 07:00:01 - [INFO] Opening SSH master connection to <node_name>... Warning: Permanently added '<node_name>,<IP_Address>' (ECDSA) to the list of known hosts. root@<node_name>'s password: - Enter the password.
- Press ENTER.
The script validates the credentials, performs the required actions, and the prompt to create the UDF appears.
2025-12-30 07:00:05 - [INFO] SSH master connection to <node_name> ready 2025-12-30 07:00:05 - [INFO] Checking sudo access for <node_name>... 2025-12-30 07:00:05 - [INFO] Precheck OK for <node_name> 2025-12-30 07:00:05 - [INFO] Precheck complete. Starting RAC node configuration... 2025-12-30 07:00:05 - [INFO] Stopping existing Logforwarder on <node_name> 2025-12-30 07:00:15 - [INFO] Syncing /opt/protegrity/logforwarder to <node_name>... 2025-12-30 07:00:16 - [INFO] Starting new Logforwarder on <node_name> 2025-12-30 07:00:18 - [INFO] Stopping existing RPAgent on <node_name> 2025-12-30 07:00:19 - [INFO] Syncing /opt/protegrity/rpagent to <node_name>... 2025-12-30 07:00:19 - [INFO] Starting new RPAgent on <node_name> 2025-12-30 07:00:19 - [INFO] Syncing /opt/protegrity/databaseprotector to <node_name>... 2025-12-30 07:00:20 - [INFO] Syncing /etc/protegrity to <node_name>... 2025-12-30 07:00:20 - [INFO] Updating extproc.ora on <node_name> 2025-12-30 07:00:20 - [INFO] Updating runtime extproc.ora symlink on <node_name> 2025-12-30 07:00:20 - [INFO] Node <node_name> configured successfully. 2025-12-30 07:00:20 - [INFO] Stopping existing Logforwarder on <node_name> 2025-12-30 07:00:36 - [INFO] Syncing /opt/protegrity/logforwarder to <node_name>... 2025-12-30 07:00:36 - [INFO] Starting new Logforwarder on <node_name> 2025-12-30 07:00:38 - [INFO] Stopping existing RPAgent on <node_name> 2025-12-30 07:00:39 - [INFO] Syncing /opt/protegrity/rpagent to <node_name>... 2025-12-30 07:00:39 - [INFO] Starting new RPAgent on <node_name> 2025-12-30 07:00:40 - [INFO] Syncing /opt/protegrity/databaseprotector to <node_name>... 2025-12-30 07:00:40 - [INFO] Syncing /etc/protegrity to <node_name>... 2025-12-30 07:00:40 - [INFO] Updating extproc.ora on <node_name> 2025-12-30 07:00:40 - [INFO] Updating runtime extproc.ora symlink on <node_name> 2025-12-30 07:00:40 - [INFO] Node <node_name> configured successfully. Do you want to continue and create UDFs? To create the UDFs, provide the database credentials (yes/no) [no]: - To create the UDFs, type
yes. - Press ENTER.
The prompt to enter the database username appears.
Enter Oracle database username: - Enter the username.
- Press ENTER.
The prompt to enter the database password appears.
Enter Oracle database user's password: - Enter the password.
- Press ENTER.
The prompt to confirm the username appears.
Was a different Oracle database user used for creation of existing UDFs? (yes/no) [no]: - To confirm the usage of a different user, type
yes. - Press ENTER.
The prompt to enter the previous username appears.
Enter previous Oracle database username (for dropping existing UDFs): - Enter the username.
- Press ENTER.
The prompt to enter the password for the previous username appears.
Enter previous Oracle database user's password: - Enter the password.
- Press ENTER.
The script drops the existing UDFs, upgrades the protector, and completes the upgrade process.
2025-12-30 07:00:59 - [INFO] Dropping existing types and UDFs 2025-12-30 07:00:59 - [INFO] Using username '<user_name>' for database connection and dropping existing types and UDFs. 2025-12-30 07:00:59 - [INFO] Running SQL script: Drop existing types and UDFs (/opt/protegrity/databaseprotector_backup_20251230065914/oracle/sqlscripts/dropobjects.sql) 2025-12-30 07:01:00 - [INFO] sqlplus output: Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Package body dropped. Package dropped. Library dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. Synonym dropped. 2025-12-30 07:01:00 - [INFO] Drop existing types and UDFs executed successfully. 2025-12-30 07:01:00 - [INFO] Existing types and UDFs dropped successfully. 2025-12-30 07:01:00 - [INFO] Going to create new types and UDFs. 2025-12-30 07:01:00 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs. 2025-12-30 07:01:00 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity/databaseprotector/oracle/sqlscripts/createobjects.sql) 2025-12-30 07:01:01 - [INFO] sqlplus output: Library created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Package created. Package body created. Grant succeeded. Grant succeeded. Synonym created. Synonym created. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. 2025-12-30 07:01:01 - [INFO] Create new types and UDFs executed successfully. 2025-12-30 07:01:01 - [INFO] New types and UDFs created successfully. 2025-12-30 07:01:01 - [INFO] Testing UDFs installation... 2025-12-30 07:01:01 - [INFO] Test UDFs output: <DBP_version> 2025-12-30 07:01:01 - [INFO] UDFs installation tested successfully. 2025-12-30 07:01:01 - [INFO] Removing previous installation directories. 2025-12-30 07:01:01 - [INFO] Removing previous installation directories on <node_name>. 2025-12-30 07:01:01 - [INFO] Removing previous installation directories on <node_name>. 2025-12-30 07:01:01 - [INFO] Removing backups... 2025-12-30 07:01:01 - [INFO] Removing Logforwarder backup directory /opt/protegrity/logforwarder_backup_20251230065914 2025-12-30 07:01:01 - [INFO] Removing RPAgent backup directory /opt/protegrity/rpagent_backup_20251230065914 2025-12-30 07:01:01 - [INFO] Removing Database Protector backup directory /opt/protegrity/databaseprotector_backup_20251230065914 2025-12-30 07:01:01 - [INFO] Removing User configuration backup directory /etc/protegrity_backup_20251230065914 2025-12-30 07:01:01 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora.bak_2025-12-30_06:59:33 2025-12-30 07:01:01 - [INFO] Closing SSH master connections... 2025-12-30 07:01:01 - [INFO] Connection to <node_name> closed. 2025-12-30 07:01:01 - [INFO] Connection to <node_name> closed. 2025-12-30 07:01:01 - [INFO] Upgrade successful. 2025-12-30 07:01:01 - [INFO] All components upgraded successfully.
Feedback
Was this page helpful?