Upgrading the Oracle Database Protector on Standalone system

The Oracle Database Protector build provides an automated script to manage the upgrade process. 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:

  1. Log Forwarder
  2. RPAgent
  3. 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:

  1. Verifies the existing configuration.
  2. Creates a backup of the existing configuration.
  3. Stops the required services.
  4. Drops the existing UDFs.
  5. Installs the new version.
  6. Starts the required services.
  7. 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

  1. Log in to the instance where the installation package is extracted.
  2. Navigate to the directory containing the installation scripts.
  3. To view the arguments, run the following command:
    ./Install_OracleProtector_Linux_x64_<DBP_version>.sh --help
  4. 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

  1. Log in to the instance where the installation package is extracted.
  2. Navigate to the directory containing the installation scripts.
  3. To execute the upgrade script, run the following command:
    ./Install_OracleProtector_Linux_x64_<DBP_version>.sh --upgrade
  4. Press ENTER. The prompt to select the silent mode of installation appears.
    2025-12-23 12:21:23 - [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]:
  5. To install the components using the interactive mode, type no.
  6. Press ENTER. The prompt to enter the location of the existing installation appears.
    Enter existing installation directories:

Existing LogForwarder installation directory [/opt/protegrity]:
  7. Enter the directory path where the existing version of the Log Forwarder is installed.
  8. Press ENTER. The prompt to enter RPAgent installation directory appears.
    Existing RPAgent installation directory [/opt/protegrity]:
  9. Enter the directory path where the existing version of the RPAgent is installed.
  10. Press ENTER. The prompt to enter the Database Protector installation directory appears.
    Existing DatabaseProtector installation directory [/opt/protegrity]:
  11. Enter the directory path where the existing version of the Database Protector is installed.
  12. 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]:
  13. To install the new components in a single directory, type yes.
  14. Press ENTER. The prompt to enter the installation directory for the new version appears.
    Enter new installation directory [/opt/protegrity]:
  15. Enter the location where the components must be installed.
  16. Press ENTER. The script lists the configuration and a prompt to confirm appears.
    2025-12-23 12:21:43 - [INFO] Verifying previous installation directories for all components...
2025-12-23 12:21:43 - [INFO] Existing LogForwarder directory: /opt/protegrity1/logforwarder
2025-12-23 12:21:43 - [INFO] Existing RPAgent directory: /opt/protegrity1/rpagent
2025-12-23 12:21:43 - [INFO] Existing DatabaseProtector directory: /opt/protegrity1/databaseprotector
2025-12-23 12:21:43 - [INFO] All existing component directories verified successfully.
2025-12-23 12:21:44 - [INFO] Discovering Grid Infrastructure home dynamically...
2025-12-23 12:21:44 - [INFO] No ASM instance found. This is a standalone system.
2025-12-23 12:21:44 - [INFO] No Grid home found. Treating it as a standalone Oracle.
2025-12-23 12:21:44 - [INFO] Going to configure environment for upgrade
2025-12-23 12:21:44 - [INFO] Discovered ORACLE_SID=orcl, ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
2025-12-23 12:21:44 - [INFO] Oracle environment set:
2025-12-23 12:21:44 - [INFO] ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
2025-12-23 12:21:44 - [INFO] ORACLE_SID=orcl
2025-12-23 12:21:44 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/19.0.0/dbhome_1/lib
2025-12-23 12:21:44 - [INFO] PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/app/oracle/product/19.0.0/dbhome_1/bin
2025-12-23 12:21:44 - [INFO] Environment configured successfully...

2025-12-23 12:21:44 - [INFO] **************************************************************************
2025-12-23 12:21:44 - [INFO] Upgrade will be done with following configuration:
2025-12-23 12:21:44 - [INFO] Oracle Instance ID: orcl
2025-12-23 12:21:44 - [INFO] Mode: upgrade
2025-12-23 12:21:44 - [INFO] Existing Logforwarder Installation Directory: /opt/protegrity1
2025-12-23 12:21:44 - [INFO] Existing RPAgent Installation Directory: /opt/protegrity1
2025-12-23 12:21:44 - [INFO] Existing DatabaseProtector Installation Directory: /opt/protegrity1
2025-12-23 12:21:44 - [INFO] New Logforwarder Installation Directory: /opt/protegrity
2025-12-23 12:21:44 - [INFO] New RPAgent Installation Directory: /opt/protegrity
2025-12-23 12:21:44 - [INFO] New DatabaseProtector Installation Directory: /opt/protegrity
2025-12-23 12:21:44 - [INFO] Audit Store Endpoints: <IP_Address>:9200 <IP_Address>:9200 <IP_Address>:9200
2025-12-23 12:21:44 - [INFO] Upstream (ESA) Hostname or IP Address for RPAgent: <IP_Address>
2025-12-23 12:21:44 - [INFO] Upstream (ESA) Port for RPAgent: 25400 (Default)
2025-12-23 12:21:44 - [INFO] This is an upgrade.
2025-12-23 12:21:44 - [INFO] Previous installations will be backed up before upgrade.
2025-12-23 12:21:44 - [INFO] Existing Logforwarder and RPAgent configurations will be retained
2025-12-23 12:21:44 - [INFO] Standalone setup detected
2025-12-23 12:21:44 - [INFO] **************************************************************************
2025-12-23 12:21:44 - [WARN] **************************************************************************
2025-12-23 12:21:44 - [WARN] IMPORTANT: Any queries currently running may be impacted during upgrade.
2025-12-23 12:21:44 - [WARN] It is recommended to perform the upgrade during a maintenance window.
2025-12-23 12:21:44 - [WARN] **************************************************************************

2025-12-23 12:21:44 - [INFO] Please verify the above configuration before proceeding.
Do you want to continue? (yes/no) [no]:
  17. To proceed with the upgrade, type yes.
  18. Press ENTER. The script creates a backup of the existing configuration, installs the Log Forwarder, RPAgent, and the Oracle objects. The prompt to create the UDF appears.
    2025-12-23 12:21:48 - [INFO] Continuing with upgrade...
2025-12-23 12:21:48 - [INFO] Backing up /opt/protegrity1/logforwarder to /opt/protegrity1/logforwarder_backup_20251223122148...
2025-12-23 12:21:48 - [INFO] Backup of /opt/protegrity1/logforwarder completed Successfully...
2025-12-23 12:21:48 - [INFO] Backing up /opt/protegrity1/rpagent to /opt/protegrity1/rpagent_backup_20251223122148...
2025-12-23 12:21:48 - [INFO] Backup of /opt/protegrity1/rpagent completed Successfully...
2025-12-23 12:21:48 - [INFO] Backing up /opt/protegrity1/databaseprotector to /opt/protegrity1/databaseprotector_backup_20251223122148...
2025-12-23 12:21:49 - [INFO] Backup of /opt/protegrity1/databaseprotector completed Successfully...
2025-12-23 12:21:49 - [INFO] Backing up /etc/protegrity to /etc/protegrity_backup_20251223122148...
2025-12-23 12:21:49 - [INFO] Backup of /etc/protegrity completed Successfully...
2025-12-23 12:21:49 - [INFO] Existing Logforwarder is currently running.
2025-12-23 12:21:49 - [INFO] Existing RPAgent is currently running.
2025-12-23 12:21:49 - [INFO] Installing/Upgrading LOGFORWARDER...
2025-12-23 12:21:49 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh...
Unpacking...
Extracting files...

Protegrity Log Forwarder installed in /opt/protegrity/logforwarder.

2025-12-23 12:21:49 - [INFO] Retaining existing Logforwarder configuration...
2025-12-23 12:21:49 - [INFO] Logforwarder configuration retained successfully.
2025-12-23 12:21:49 - [INFO] Updating configuration files in /opt/protegrity/logforwarder/data to use new installation directory.
2025-12-23 12:21:49 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 12:21:49 - [INFO] Installing/Upgrading RPAGENT...
2025-12-23 12:21:49 - [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-23 12:21:49 - [INFO] Retaining existing RPAgent configuration...
2025-12-23 12:21:49 - [INFO] RPAgent configuration retained successfully.
2025-12-23 12:21:49 - [INFO] Updating configuration files in /opt/protegrity/rpagent/data to use new installation directory.
2025-12-23 12:21:49 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 12:21:49 - [INFO] Installing/Upgrading DBP...
2025-12-23 12:21:49 - [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-23 12:21:49 - [INFO] Retaining existing Database Protector configuration...
2025-12-23 12:21:49 - [INFO] Database Protector configuration retained successfully.
2025-12-23 12:21:49 - [INFO] Updating configuration files in /opt/protegrity/databaseprotector/oracle/data to use new installation directory.
2025-12-23 12:21:49 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 12:21:49 - [INFO] Going to stop existing Logforwarder instance
2025-12-23 12:21:54 - [INFO] Existing Logforwarder successfully stopped
2025-12-23 12:21:54 - [INFO] Going to launch <DBP_version> version Logforwarder
2025-12-23 12:21:56 - [INFO] Successfully launched <DBP_version> version Logforwarder
2025-12-23 12:21:56 - [INFO] Going to stop existing RPAgent instance
Stopping rpagent
2025-12-23 12:21:57 - [INFO] Existing RPAgent successfully stopped
2025-12-23 12:21:57 - [INFO] Going to launch <DBP_version> version RPAgent
2025-12-23 12:21:57 - [INFO] Successfully launched <DBP_version> version RPAgent
2025-12-23 12:21:57 - [INFO] Configuring extproc.ora
2025-12-23 12:21:57 - [INFO] Backed up existing /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
2025-12-23 12:21:57 - [INFO] /opt/protegrity/databaseprotector/oracle/lib/peporacle.plm already present in /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
2025-12-23 12:21:57 - [INFO] Updated extproc.ora at /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
2025-12-23 12:21:57 - [INFO] No separate runtime home detected or runtime home same as ORACLE_HOME; skipping sync.
Do you want to continue and create UDFs?
To create the UDFs, provide the database credentials  (yes/no) [no]:
  19. To create the UDFs, type yes.
  20. Press ENTER. The prompt to enter the database username appears.
    Enter Oracle database username:
  21. Enter the database username.
  22. Press ENTER. The prompt to enter the database password appears.
    Enter Oracle database user's password:
  23. Enter the database password.
  24. Press ENTER. The prompt to confirm the database user appears.
    Was a different Oracle database user used for the previous installation's types and UDFs? (yes/no) [no]:
  25. To continue with the existing database username, type no.
  26. Press ENTER. The script drops the UDFs from the existing version and installs the UDFs from the new version. The script also performs a cleanup and completes the upgrade.
    2025-12-23 12:24:20 - [INFO] Dropping existing types and UDFs
2025-12-23 12:24:20 - [INFO] Using username '' for database connection and dropping existing types and UDFs.
2025-12-23 12:24:20 - [INFO] Running SQL script: Drop existing types and UDFs (/opt/protegrity1/databaseprotector_backup_20251223122148/oracle/sqlscripts/dropobjects.sql)
2025-12-23 12:24:21 - [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-23 12:24:21 - [INFO] Drop existing types and UDFs executed successfully.
2025-12-23 12:24:21 - [INFO] Existing types and UDFs dropped successfully.
2025-12-23 12:24:21 - [INFO] Going to create new types and UDFs.
2025-12-23 12:24:21 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs.
2025-12-23 12:24:21 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity/databaseprotector/oracle/sqlscripts/createobjects.sql)
2025-12-23 12:24:23 - [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-23 12:24:23 - [INFO] Create new types and UDFs executed successfully.
2025-12-23 12:24:23 - [INFO] New types and UDFs created successfully.
2025-12-23 12:24:23 - [INFO] Testing UDFs installation...
2025-12-23 12:24:24 - [INFO] Test UDFs output: <DBP_version>
2025-12-23 12:24:24 - [INFO] UDFs installation tested successfully.
2025-12-23 12:24:24 - [INFO] Removing previous installation directories.
2025-12-23 12:24:24 - [INFO] Removing previous Logforwarder directory /opt/protegrity1/logforwarder
2025-12-23 12:24:24 - [INFO] Removing previous RPAgent directory /opt/protegrity1/rpagent
2025-12-23 12:24:24 - [INFO] Removing previous DatabaseProtector directory /opt/protegrity1/databaseprotector
2025-12-23 12:24:24 - [INFO] Removing backups...
2025-12-23 12:24:24 - [INFO] Removing Logforwarder backup directory /opt/protegrity1/logforwarder_backup_20251223122148
2025-12-23 12:24:24 - [INFO] Removing RPAgent backup directory /opt/protegrity1/rpagent_backup_20251223122148
2025-12-23 12:24:24 - [INFO] Removing Database Protector backup directory /opt/protegrity1/databaseprotector_backup_20251223122148
2025-12-23 12:24:24 - [INFO] Removing User configuration backup directory /etc/protegrity_backup_20251223122148
2025-12-23 12:24:24 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora.bak_2025-12-23_12:21:57
2025-12-23 12:24:24 - [INFO] Closing SSH master connections...
2025-12-23 12:24:24 - [INFO] Upgrade successful.
2025-12-23 12:24:24 - [INFO] All components upgraded successfully.

Upgrading the Protector using the Silent Mode

  1. Log in to the instance where the installation package is extracted.
  2. Navigate to the directory containing the installation scripts.
  3. To execute the upgrade script, run the following command:
    ./Install_OracleProtector_Linux_x64_<DBP_version>.sh --upgrade
  4. Press ENTER. The prompt to select the silent mode of installation appears.
    2025-12-23 12:21:23 - [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]:
  5. To install the components using the silent mode, type yes.
  6. Press ENTER. The script retrieves the current configuration and a prompt to confirm the configuration appears.
     2025-12-23 12:51:34 - [INFO] You have chosen silent mode. Therefore, /opt/protegrity is considered as base directory for new installation.
 2025-12-23 12:51:34 - [INFO] This is an upgrade and you have chosen silent mode. Therefore, /opt/protegrity is considered as base directory for existing installation.
 2025-12-23 12:51:34 - [INFO] Verifying previous installation directories for all components...
 2025-12-23 12:51:34 - [INFO] Existing LogForwarder directory: /opt/protegrity/logforwarder
 2025-12-23 12:51:34 - [INFO] Existing RPAgent directory: /opt/protegrity/rpagent
 2025-12-23 12:51:34 - [INFO] Existing DatabaseProtector directory: /opt/protegrity/databaseprotector
 2025-12-23 12:51:34 - [INFO] All existing component directories verified successfully.
 2025-12-23 12:51:34 - [INFO] Discovering Grid Infrastructure home dynamically...
 2025-12-23 12:51:34 - [INFO] No ASM instance found. This is a standalone system.
 2025-12-23 12:51:34 - [INFO] No Grid home found. Treating it as a standalone Oracle.
 2025-12-23 12:51:34 - [INFO] Going to configure environment for upgrade
 2025-12-23 12:51:34 - [INFO] Discovered ORACLE_SID=orcl, ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
 2025-12-23 12:51:34 - [INFO] Oracle environment set:
 2025-12-23 12:51:34 - [INFO] ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
 2025-12-23 12:51:34 - [INFO] ORACLE_SID=orcl
 2025-12-23 12:51:34 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/19.0.0/dbhome_1/lib
 2025-12-23 12:51:34 - [INFO] PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/app/oracle/product/19.0.0/dbhome_1/bin
 2025-12-23 12:51:34 - [INFO] Environment configured successfully...
 2025-12-23 12:51:34 - [INFO] **************************************************************************
 2025-12-23 12:51:34 - [INFO] Upgrade will be done with following configuration:
 2025-12-23 12:51:34 - [INFO] Oracle Instance ID: orcl
 2025-12-23 12:51:34 - [INFO] Mode: upgrade
 2025-12-23 12:51:34 - [INFO] Existing Logforwarder Installation Directory: /opt/protegrity
 2025-12-23 12:51:34 - [INFO] Existing RPAgent Installation Directory: /opt/protegrity
 2025-12-23 12:51:34 - [INFO] Existing DatabaseProtector Installation Directory: /opt/protegrity
 2025-12-23 12:51:34 - [INFO] New Logforwarder Installation Directory: /opt/protegrity
 2025-12-23 12:51:34 - [INFO] New RPAgent Installation Directory: /opt/protegrity
 2025-12-23 12:51:34 - [INFO] New DatabaseProtector Installation Directory: /opt/protegrity
 2025-12-23 12:51:34 - [INFO] Audit Store Endpoints: <IP_Address>:9200 <IP_Address>:9200 <IP_Address>:9200
 2025-12-23 12:51:34 - [INFO] Upstream (ESA) Hostname or IP Address for RPAgent: <IP_Address>
 2025-12-23 12:51:34 - [INFO] Upstream (ESA) Port for RPAgent: 25400 (Default)
 2025-12-23 12:51:34 - [INFO] This is an upgrade.
 2025-12-23 12:51:34 - [INFO] Previous installations will be backed up before upgrade.
 2025-12-23 12:51:34 - [INFO] Existing Logforwarder and RPAgent configurations will be retained
 2025-12-23 12:51:34 - [INFO] Standalone setup detected
 2025-12-23 12:51:34 - [INFO] **************************************************************************
 2025-12-23 12:51:34 - [WARN] **************************************************************************
 2025-12-23 12:51:34 - [WARN] IMPORTANT: Any queries currently running may be impacted during upgrade.
 2025-12-23 12:51:34 - [WARN] It is recommended to perform the upgrade during a maintenance window.
 2025-12-23 12:51:34 - [WARN] **************************************************************************
 2025-12-23 12:51:34 - [INFO] Please verify the above configuration before proceeding.
 Do you want to continue? (yes/no) [no]:
  7. To proceed with the configuration, type yes.
  8. Press ENTER. The script upgrades the Log Forwarder, RPAgent, and the Oracle objects. The prompt to create the UDF appears.
     2025-12-23 12:51:42 - [INFO] Continuing with upgrade...
 2025-12-23 12:51:42 - [INFO] Backing up /opt/protegrity/logforwarder to /opt/protegrity/logforwarder_backup_20251223125142...
 2025-12-23 12:51:42 - [INFO] Backup of /opt/protegrity/logforwarder completed Successfully...
 2025-12-23 12:51:42 - [INFO] Backing up /opt/protegrity/rpagent to /opt/protegrity/rpagent_backup_20251223125142...
 2025-12-23 12:51:42 - [INFO] Backup of /opt/protegrity/rpagent completed Successfully...
 2025-12-23 12:51:42 - [INFO] Backing up /opt/protegrity/databaseprotector to /opt/protegrity/databaseprotector_backup_20251223125142...
 2025-12-23 12:51:42 - [INFO] Backup of /opt/protegrity/databaseprotector completed Successfully...
 2025-12-23 12:51:42 - [INFO] Backing up /etc/protegrity to /etc/protegrity_backup_20251223125142...
 2025-12-23 12:51:42 - [INFO] Backup of /etc/protegrity completed Successfully...
 2025-12-23 12:51:42 - [INFO] Existing Logforwarder is currently running.
 2025-12-23 12:51:42 - [INFO] Existing RPAgent is currently running.
 2025-12-23 12:51:42 - [INFO] Installing/Upgrading LOGFORWARDER...
 2025-12-23 12:51:42 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh...
 Unpacking...
 Extracting files...

 Protegrity Log Forwarder installed in /opt/protegrity/logforwarder.

 2025-12-23 12:51:42 - [INFO] Retaining existing Logforwarder configuration...
 2025-12-23 12:51:42 - [INFO] Logforwarder configuration retained successfully.
 2025-12-23 12:51:42 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
 2025-12-23 12:51:42 - [INFO] Installing/Upgrading RPAGENT...
 2025-12-23 12:51:42 - [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-23 12:51:42 - [INFO] Retaining existing RPAgent configuration...
 2025-12-23 12:51:42 - [INFO] RPAgent configuration retained successfully.
 2025-12-23 12:51:42 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
 2025-12-23 12:51:42 - [INFO] Installing/Upgrading DBP...
 2025-12-23 12:51:42 - [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-23 12:51:42 - [INFO] Retaining existing Database Protector configuration...
 2025-12-23 12:51:42 - [INFO] Database Protector configuration retained successfully.
 2025-12-23 12:51:42 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully.
 2025-12-23 12:51:42 - [INFO] Going to stop existing Logforwarder instance
 2025-12-23 12:51:47 - [INFO] Existing Logforwarder successfully stopped
 2025-12-23 12:51:47 - [INFO] Going to launch <DBP_version> version Logforwarder
 2025-12-23 12:51:49 - [INFO] Successfully launched <DBP_version> version Logforwarder
 2025-12-23 12:51:49 - [INFO] Going to stop existing RPAgent instance
 Stopping rpagent
 2025-12-23 12:51:50 - [INFO] Existing RPAgent successfully stopped
 2025-12-23 12:51:50 - [INFO] Going to launch <DBP_version> version RPAgent
 2025-12-23 12:51:50 - [INFO] Successfully launched <DBP_version> version RPAgent
 2025-12-23 12:51:50 - [INFO] Configuring extproc.ora
 2025-12-23 12:51:50 - [INFO] Backed up existing /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
 2025-12-23 12:51:50 - [INFO] /opt/protegrity/databaseprotector/oracle/lib/peporacle.plm already present in /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
 2025-12-23 12:51:50 - [INFO] Updated extproc.ora at /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
 2025-12-23 12:51:50 - [INFO] No separate runtime home detected or runtime home same as ORACLE_HOME; skipping sync.
 Do you want to continue and create UDFs?
 To create the UDFs, provide the database credentials  (yes/no) [no]:
  9. To create the UDFs, type yes.
  10. Press ENTER. The prompt to enter the database username appears.
    Enter Oracle database username:
  11. Enter the database username.
  12. Press ENTER. The prompt to enter the database password appears.
    Enter Oracle database user's password:
  13. Enter the database user’s password.
  14. Press ENTER. The prompt to confirm the database user appears.
    Was a different Oracle database user used for the previous installation's types and UDFs? (yes/no) [no]:
  15. To provide the Oracle user for the previous installation, type yes.
  16. Press ENTER. The prompt to enter the database username appears.
    Enter previous Oracle database username (for dropping existing types and UDFs):
  17. Enter the database username.
  18. Press ENTER. The prompt to enter the database password appears.
    Enter previous Oracle database user's password:
  19. Enter the database user’s password.
  20. Press ENTER. The script drops the older versions of the UDFs, creates a backup, installs the newer version of the UDFs, and performs a cleanup operation to complete the upgrade.
    2025-12-23 12:52:18 - [INFO] Dropping existing types and UDFs
2025-12-23 12:52:18 - [INFO] Using username '<user_name>' for database connection and dropping existing types and UDFs.
2025-12-23 12:52:18 - [INFO] Running SQL script: Drop existing types and UDFs (/opt/protegrity/databaseprotector_backup_20251223125142/oracle/sqlscripts/dropobjects.sql)
2025-12-23 12:52:19 - [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-23 12:52:19 - [INFO] Drop existing types and UDFs executed successfully.
2025-12-23 12:52:19 - [INFO] Existing types and UDFs dropped successfully.
2025-12-23 12:52:19 - [INFO] Going to create new types and UDFs.
2025-12-23 12:52:19 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs.
2025-12-23 12:52:19 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity/databaseprotector/oracle/sqlscripts/createobjects.sql)
2025-12-23 12:52:20 - [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-23 12:52:20 - [INFO] Create new types and UDFs executed successfully.
2025-12-23 12:52:20 - [INFO] New types and UDFs created successfully.
2025-12-23 12:52:20 - [INFO] Testing UDFs installation...
2025-12-23 12:52:21 - [INFO] Test UDFs output: <DBP_version>
2025-12-23 12:52:21 - [INFO] UDFs installation tested successfully.
2025-12-23 12:52:21 - [INFO] Removing previous installation directories.
2025-12-23 12:52:21 - [INFO] Removing backups...
2025-12-23 12:52:21 - [INFO] Removing Logforwarder backup directory /opt/protegrity/logforwarder_backup_20251223125142
2025-12-23 12:52:21 - [INFO] Removing RPAgent backup directory /opt/protegrity/rpagent_backup_20251223125142
2025-12-23 12:52:21 - [INFO] Removing Database Protector backup directory /opt/protegrity/databaseprotector_backup_20251223125142
2025-12-23 12:52:21 - [INFO] Removing User configuration backup directory /etc/protegrity_backup_20251223125142
2025-12-23 12:52:21 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora.bak_2025-12-23_12:51:50
2025-12-23 12:52:21 - [INFO] Closing SSH master connections...
2025-12-23 12:52:21 - [INFO] Upgrade successful.
2025-12-23 12:52:21 - [INFO] All components upgraded successfully.

Last modified : January 05, 2026