Installing the Oracle Database Protector on RAC (Multinode) system

The Oracle Database Protector build provides an automated script to manage the installation process on a standalone system. The master script internally calls the scripts to install the components. The master script installs the components in the following order:

  1. Log Forwarder
  2. RPAgent
  3. Policy Enforcement Point (Database Protector)

The installation can also be performed manually by executing the individual scripts to install the different components.

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.

In addition, the master script will rollback the installation process if any errors are encountered. The script will revert the changes.

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.

Installing 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 script, run the following command:
    ./Install_OracleProtector_Linux_x64_<DBP_version>.sh --install
  4. Press ENTER. The prompt to select the silent mode of installation appears.
    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 install the components in the same directory appears.
    Do you want to install the new LogForwarder, RPAgent, and DatabaseProtector together in a single directory? (yes/no) [no]:
  7. To install the components in different directories, type no.
  8. Press ENTER. The prompt to enter the installation directory for the Log Forwarder appears.
    Enter new LogForwarder installation directory [/opt/protegrity]:
  9. Enter the location to install the Log Forwarder.
  10. Press ENTER. The prompt to enter the installation directory for the RPAgent appears.
    Enter new RPAgent installation directory [/opt/protegrity]:
  11. Enter the location to install the RPAgent.
  12. Press ENTER. The prompt to enter the installation directory for the Database Protector appears.
    Enter new DatabaseProtector installation directory [/opt/protegrity]:
  13. Enter the location to install the Database Protector.

    Note: To use any directory, ensure the directory is available. Otherwise, the installation will fail.

  14. Press ENTER. The script configures the environment and the prompt to confirm the configuration appears.
    2025-12-30 06:39:49 - [INFO] Discovering Grid Infrastructure home dynamically...
2025-12-30 06:39:50 - [INFO] Discovered GRID_HOME: /u01/app/21.3.0./grid
2025-12-30 06:39:50 - [INFO] Grid home found: /u01/app/21.3.0./grid
2025-12-30 06:39:50 - [INFO] RAC setup detected
2025-12-30 06:39:50 - [INFO] Current node: <node_name> (<node_name>.localdomain.com)
2025-12-30 06:39:50 - [INFO] Other nodes: <node_name> <node_name>
2025-12-30 06:39:50 - [INFO] Checking for required tools...
2025-12-30 06:39:50 - [INFO] All required tools are available
2025-12-30 06:39:50 - [INFO] Going to configure environment for installation
2025-12-30 06:39:50 - [INFO] Discovered ORACLE_SID=<oracle_system_identifier>, ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1
2025-12-30 06:39:50 - [INFO] Oracle environment set:
2025-12-30 06:39:50 - [INFO] ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1
2025-12-30 06:39:50 - [INFO] ORACLE_SID=<oracle_system_identifier>
2025-12-30 06:39:50 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/21.3.0/db_1/lib
2025-12-30 06:39:50 - [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:39:50 - [INFO] Environment configured successfully...

2025-12-30 06:39:50 - [INFO] **************************************************************************
2025-12-30 06:39:50 - [INFO] Installation will be done with following configuration:
2025-12-30 06:39:50 - [INFO] Oracle Instance ID: <oracle_instance_ID>
2025-12-30 06:39:50 - [INFO] Mode: install
2025-12-30 06:39:50 - [INFO] Logforwarder Installation Directory: /opt/protegrity1
2025-12-30 06:39:50 - [INFO] RPAgent Installation Directory: /opt/protegrity1
2025-12-30 06:39:50 - [INFO] DatabaseProtector Installation Directory: /opt/protegrity1
2025-12-30 06:39:50 - [INFO] This is a fresh install.
2025-12-30 06:39:50 - [INFO] RAC setup detected with nodes: <node_name>
<node_name>
<node_name>
2025-12-30 06:39:50 - [INFO] **************************************************************************

2025-12-30 06:39:50 - [INFO] Please verify the above configuration before proceeding.
Do you want to continue? (yes/no) [no]:
  15. To proceed with the configuration, type yes.
  16. Press ENTER. The master script invokes the Log Forwarder installation script. The prompt to enter the Audit Store endpoint appears.
    2025-12-30 06:40:10 - [INFO] Continuing with installation...
2025-12-30 06:40:10 - [INFO] Installing/Upgrading LOGFORWARDER...
2025-12-30 06:40:10 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh...
Enter the audit store endpoint (host),
alternative (host:port) to use another port than the default port 9200:
  17. Enter the IP address for the Audit Store.
  18. Press ENTER. The script lists the endpoint to be added. The prompt to add additional end point appears.
    Audit store endpoints: <IP_Address>:9200
Do you want to add another audit store endpoint? [y/n]:
  19. To provide an additional endpoint, type yes.
  20. Press ENTER. The prompt to enter the Audit Store endpoint appears.
    Enter the audit store endpoint (host),
alternative (host:port) to use another port than the default port 9200:
  21. Enter the IP address for the Audit Store.
  22. Press ENTER. The script lists the endpoints that will be added. The prompt to continue the installation appears.
    <IP_Address>:9200
<IP_Address>:9200
Type 'y' to accept or 'n' to abort installation:
  23. To add the endpoints, type yes.
  24. Press ENTER. The script unpacks the files and installs the Log Forwarder. The prompt to enter the upstream host name or IP address appears.
    Unpacking...
Extracting files...
Protegrity Log Forwarder installed in /opt/protegrity1/logforwarder.
2025-12-30 06:40:10 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-30 06:40:10 - [INFO] Installing/Upgrading RPAGENT...
Please enter upstream host name or IP address,
alternative (host:port) to use another port than the default port 25400:
  25. Enter the upstream host name or IP address.
  26. Press ENTER. The prompt to enter the ESA token appears.
    Enter ESA token (leave blank to use username/password):

    Note: To use the username and password, press ENTER.

  27. Enter the JWT token.
  28. Press ENTER. The script installs the RPAgent and triggers the script to install the Oracle objects. The script verifies the nodes and the prompt to confirm the username for the node appears.
    2025-12-30 06:40:24 - [INFO] Executing ./RPAgentSetup_Linux_x64_<DBP_version>.sh...
Unpacking...
Extracting files...
Downloading certificates from <IP_Address>:25400...
% Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                Dload  Upload   Total   Spent    Left  Speed
100 11264  100 11264    0     0  55457      0 --:--:-- --:--:-- --:--:-- 55487

Extracting certificates...
tar: CA.pem: time stamp 2025-12-30 06:40:25 is 0.061687997 s in the future
tar: cert.pem: time stamp 2025-12-30 06:40:25 is 0.061525058 s in the future
tar: cert.key: time stamp 2025-12-30 06:40:25 is 0.061482332 s in the future
tar: secret.txt: time stamp 2025-12-30 06:40:25 is 0.061448035 s in the future
Certificates successfully downloaded and stored in /opt/protegrity1/rpagent/data

Protegrity RPAgent installed in /opt/protegrity1/rpagent.

2025-12-30 06:40:24 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-30 06:40:24 - [INFO] Installing/Upgrading DBP...
2025-12-30 06:40:24 - [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/protegrity1/databaseprotector/oracle.

2025-12-30 06:40:24 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-30 06:40:24 - [INFO] Going to launch <DBP_version> version Logforwarder
2025-12-30 06:40:27 - [INFO] Successfully launched <DBP_version> version Logforwarder
2025-12-30 06:40:27 - [INFO] Going to launch <DBP_version> version RPAgent
2025-12-30 06:40:27 - [INFO] Successfully launched <DBP_version> version RPAgent
2025-12-30 06:40:27 - [INFO] Configuring extproc.ora
2025-12-30 06:40:27 - [INFO] Backed up existing /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora
2025-12-30 06:40:27 - [INFO] Updated EXTPROC_DLLS in /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora to only include /opt/protegrity1/databaseprotector/oracle/lib/peporacle.plm
2025-12-30 06:40:27 - [INFO] Updated extproc.ora at /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora
2025-12-30 06:40:27 - [INFO] Detected separate runtime home: /u01/app/oracle/homes/OraDB21Home1
2025-12-30 06:40:27 - [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:40:27 - [INFO] Synchronized extproc.ora in runtime home /u01/app/oracle/homes/OraDB21Home1/hs/admin
2025-12-30 06:40:27 - [INFO] Configuring RAC nodes...
2025-12-30 06:40:27 - [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]:
  29. To use separate usernames, type no.
  30. Press ENTER. The script prompts for the username to access a node.
    Enter remote username for node <node_name> (must be in sudoers):
  31. Enter the username to access the node.
  32. Press ENTER. The script validates the username and the prompt to enter the password appears.
    2025-12-30 06:40:35 - [INFO] Opening SSH connection to <node_name> for precheck...
2025-12-30 06:40:35 - [INFO] Opening SSH master connection to <node_name>...
Warning: Permanently added '<node_name>,<node_IP>' (ECDSA) to the list of known hosts.
<user_name>@<node_name>'s password:
  33. Enter the password.
  34. Press ENTER. The script validates the password. The prompt to enter the username for the next node appears.
    2025-12-30 06:40:41 - [INFO] SSH master connection to <node_name> ready
2025-12-30 06:40:41 - [INFO] Checking sudo access for <node_name>...
2025-12-30 06:40:41 - [INFO] Precheck OK for <node_name>
Enter remote username for node <node_name> (must be in sudoers):
  35. Enter the username to access the node.
  36. Press ENTER. The script validates the username and the prompt to enter the password appears.
    2025-12-30 06:40:45 - [INFO] Opening SSH connection to <node_name> for precheck...
2025-12-30 06:40:45 - [INFO] Opening SSH master connection to <node_name>...
Warning: Permanently added '<node_name>,<node_IP>' (ECDSA) to the list of known hosts.
<user_name>@<node_name>'s password:
  37. Enter the password.
  38. Press ENTER. The script validates the password, completes the pre-check, and completes the RAC node configuration. The prompt to create the UDF appears.
    2025-12-30 06:40:50 - [INFO] SSH master connection to <node_name> ready
2025-12-30 06:40:50 - [INFO] Checking sudo access for <node_name>...
2025-12-30 06:40:50 - [INFO] Precheck OK for <node_name>
2025-12-30 06:40:50 - [INFO] Precheck complete. Starting RAC node configuration...
2025-12-30 06:40:50 - [INFO] Syncing /opt/protegrity1/logforwarder to <node_name>...
2025-12-30 06:40:54 - [INFO] Starting new Logforwarder on <node_name>
2025-12-30 06:40:56 - [INFO] Syncing /opt/protegrity1/rpagent to <node_name>...
2025-12-30 06:40:57 - [INFO] Starting new RPAgent on <node_name>
2025-12-30 06:40:57 - [INFO] Syncing /opt/protegrity1/databaseprotector to <node_name>...
2025-12-30 06:40:58 - [INFO] Syncing /etc/protegrity to <node_name>...
2025-12-30 06:40:58 - [INFO] Updating extproc.ora on <node_name>
2025-12-30 06:40:58 - [INFO] Updating runtime extproc.ora symlink on <node_name>
2025-12-30 06:40:59 - [INFO] Node <node_name> configured successfully.
2025-12-30 06:40:59 - [INFO] Syncing /opt/protegrity1/logforwarder to <node_name>...
2025-12-30 06:41:02 - [INFO] Starting new Logforwarder on <node_name>
2025-12-30 06:41:04 - [INFO] Syncing /opt/protegrity1/rpagent to <node_name>...
2025-12-30 06:41:06 - [INFO] Starting new RPAgent on <node_name>
2025-12-30 06:41:06 - [INFO] Syncing /opt/protegrity1/databaseprotector to <node_name>...
2025-12-30 06:41:06 - [INFO] Syncing /etc/protegrity to <node_name>...
2025-12-30 06:41:07 - [INFO] Updating extproc.ora on <node_name>
2025-12-30 06:41:07 - [INFO] Updating runtime extproc.ora symlink on <node_name>
2025-12-30 06:41:07 - [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]:
  39. To create the UDFs, type yes.

    Note: If you select No to create the UDFs, the script skips creating the UDFs. The installation will complete successfully. However, the database will not contain the required UDFs. To manually create the UDFs, refer to the section Creating the User Defined Functions (UDFs).

  40. Press ENTER. The prompt to enter the database username appears.
    Enter Oracle database username:
  41. Enter the username.
  42. Press ENTER. The prompt to enter the database password appears.
    Enter Oracle database user's password:
  43. Enter the password.
  44. Press ENTER. The script creates the UDFs and completes the installation.
    2025-12-30 06:41:26 - [INFO] Going to create new types and UDFs.
2025-12-30 06:41:26 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs.
2025-12-30 06:41:26 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity1/databaseprotector/oracle/sqlscripts/createobjects.sql)
2025-12-30 06:41:27 - [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:41:27 - [INFO] Create new types and UDFs executed successfully.
2025-12-30 06:41:27 - [INFO] New types and UDFs created successfully.
2025-12-30 06:41:27 - [INFO] Testing UDFs installation...
2025-12-30 06:41:27 - [INFO] Test UDFs output: <DBP_version>
2025-12-30 06:41:27 - [INFO] UDFs installation tested successfully.
2025-12-30 06:41:27 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora.bak_2025-12-30_06:40:27
2025-12-30 06:41:27 - [INFO] Closing SSH master connections...
2025-12-30 06:41:27 - [INFO] Connection to <node_name> closed.
2025-12-30 06:41:27 - [INFO] Connection to <node_name> closed.
2025-12-30 06:41:27 - [INFO] Installation successful.
2025-12-30 06:41:27 - [INFO] All components installed successfully.

Installing 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 script, run the following command:
    ./Install_OracleProtector_Linux_x64_<DBP_version>.sh --install
  4. Press ENTER. The prompt to select the silent mode of installation appears.
    Do you want silent installation? (yes/no) [no]:
  5. To install the components using the silent mode, type yes.
  6. Press ENTER. The script lists the configuration and a prompt to confirm the configuration appears.
    2025-12-30 06:31:27 - [INFO] You have chosen silent mode. Therefore, /opt/protegrity is considered as base directory for new installation.
 2025-12-30 06:31:27 - [INFO] Discovering Grid Infrastructure home dynamically...
 2025-12-30 06:31:27 - [INFO] Discovered GRID_HOME: /u01/app/21.3.0./grid
 2025-12-30 06:31:27 - [INFO] Grid home found: /u01/app/21.3.0./grid
 2025-12-30 06:31:27 - [INFO] RAC setup detected
 2025-12-30 06:31:27 - [INFO] Current node: <node_name> (<node_name>.localdomain.com)
 2025-12-30 06:31:27 - [INFO] Other nodes: <node_name> <node_name>
 2025-12-30 06:31:27 - [INFO] Checking for required tools...
 2025-12-30 06:31:27 - [INFO] All required tools are available
 2025-12-30 06:31:27 - [INFO] Going to configure environment for installation
 2025-12-30 06:31:28 - [INFO] Discovered ORACLE_SID=<oracle_system_identifier>, ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1
 2025-12-30 06:31:28 - [INFO] Oracle environment set:
 2025-12-30 06:31:28 - [INFO] ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1
 2025-12-30 06:31:28 - [INFO] ORACLE_SID=<oracle_system_identifier>
 2025-12-30 06:31:28 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/21.3.0/db_1/lib
 2025-12-30 06:31:28 - [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:31:28 - [INFO] Environment configured successfully...

 2025-12-30 06:31:28 - [INFO] **************************************************************************
 2025-12-30 06:31:28 - [INFO] Installation will be done with following configuration:
 2025-12-30 06:31:28 - [INFO] Oracle Instance ID: <oracle_instance_ID>
 2025-12-30 06:31:28 - [INFO] Mode: install
 2025-12-30 06:31:28 - [INFO] Logforwarder Installation Directory: /opt/protegrity
 2025-12-30 06:31:28 - [INFO] RPAgent Installation Directory: /opt/protegrity
 2025-12-30 06:31:28 - [INFO] DatabaseProtector Installation Directory: /opt/protegrity
 2025-12-30 06:31:28 - [INFO] This is a fresh install.
 2025-12-30 06:31:28 - [INFO] RAC setup detected with nodes: <node_name>
 <node_name>
 <node_name>
 2025-12-30 06:31:28 - [INFO] **************************************************************************

 2025-12-30 06:31:28 - [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 scripts starts the Log Forwarder installation and the prompt to enter the Audit Store endpoint appears.
    2025-12-30 06:31:30 - [INFO] Continuing with installation...
2025-12-30 06:31:30 - [INFO] Installing/Upgrading LOGFORWARDER...
2025-12-30 06:31:30 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh...
Enter the audit store endpoint (host), alternative (host:port) to use another port than the default port 9200:
  9. Enter the audit store endpoint.
  10. Press ENTER. The prompt to enter additional endpoint appears.
    Audit store endpoints: <IP_Address>:9200
Do you want to add another audit store endpoint? [y/n]:
  11. To provide another audit store endpoint, type, yes.
  12. Press ENTER. The script lists the audit store endpoints. The prompt to enter another endpoint appears.
    <IP_Address>:9200
<IP_Address>:9200
Type 'y' to accept or 'n' to abort installation:
  13. To continue, type yes.
  14. Press ENTER. The script installs the Log Forwarder. The script starts the RPAgent installation. The prompt to enter the upstream IP address appears.
    Unpacking...
Extracting files...

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

2025-12-30 06:31:45 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-30 06:31:45 - [INFO] Installing/Upgrading RPAGENT...
Please enter upstream host name or IP address,
alternative (host:port) to use another port than the default port 25400:
  15. Enter the IP address.
  16. Press ENTER. The prompt to enter the JWT token appears.
    Enter ESA token (leave blank to use username/password):
  17. To use the credentials, press ENTER. The prompt to enter the username appears.
    Enter ESA username:
  18. Enter the username.
  19. Press ENTER. The prompt to enter the password appears.
    Enter ESA user's password:
  20. Enter the password.
  21. Press ENTER. The script installs the RPAgent and the Database Protector. The script starts the RAC node configuration. The prompt to enter the username for the node appears.
    2025-12-30 06:31:54 - [INFO] Executing ./RPAgentSetup_Linux_x64_<DBP_version>.sh...
Unpacking...
Extracting files...
Obtaining token from <IP_Address>:25400...
Downloading certificates from <IP_Address>:25400...
% Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                Dload  Upload   Total   Spent    Left  Speed
100 11264  100 11264    0     0  55596      0 --:--:-- --:--:-- --:--:-- 55762

Extracting certificates...
Certificates successfully downloaded and stored in /opt/protegrity/rpagent/data

Protegrity RPAgent installed in /opt/protegrity/rpagent.

2025-12-30 06:31:55 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-30 06:31:55 - [INFO] Installing/Upgrading DBP...
2025-12-30 06:31:55 - [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:31:55 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-30 06:31:55 - [INFO] Going to launch <DBP_version> version Logforwarder
2025-12-30 06:31:57 - [INFO] Successfully launched <DBP_version> version Logforwarder
2025-12-30 06:31:57 - [INFO] Going to launch <DBP_version> version RPAgent
2025-12-30 06:31:58 - [INFO] Successfully launched <DBP_version> version RPAgent
2025-12-30 06:31:58 - [INFO] Configuring extproc.ora
2025-12-30 06:31:58 - [INFO] Backed up existing /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora
2025-12-30 06:31:58 - [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:31:58 - [INFO] Updated extproc.ora at /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora
2025-12-30 06:31:58 - [INFO] Detected separate runtime home: /u01/app/oracle/homes/OraDB21Home1
2025-12-30 06:31:58 - [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:31:58 - [INFO] Synchronized extproc.ora in runtime home /u01/app/oracle/homes/OraDB21Home1/hs/admin
2025-12-30 06:31:58 - [INFO] Configuring RAC nodes...
2025-12-30 06:31:58 - [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]:
  22. To use the same credentials for all the nodes, type yes.
  23. Press ENTER. The prompt to enter the username appears.
    Enter remote username for all nodes (must be in sudoers):
  24. Enter the username to access all the nodes.
  25. Press ENTER. The script validates the username. The prompt to enter the password appears.
    2025-12-30 06:32:05 - [INFO] Opening SSH connection to <node_name> for precheck...
2025-12-30 06:32:05 - [INFO] Opening SSH master connection to <node_name>...
Warning: Permanently added '<node_name>,<node_IP>' (ECDSA) to the list of known hosts.
<user_name>@<node_name>'s password:
  26. Enter the password.
  27. Press ENTER. The script establishes a connection to the other nodes. The prompt to enter the password appears.
    2025-12-30 06:32:10 - [INFO] SSH master connection to <node_name> ready
2025-12-30 06:32:10 - [INFO] Checking sudo access for <node_name>...
2025-12-30 06:32:11 - [INFO] Precheck OK for <node_name>
2025-12-30 06:32:11 - [INFO] Opening SSH connection to <node_name> for precheck...
2025-12-30 06:32:11 - [INFO] Opening SSH master connection to <node_name>...
Warning: Permanently added '<node_name>,<node_IP>' (ECDSA) to the list of known hosts.
<user_name>@<node_name>'s password:
  28. Enter the password.
  29. Press ENTER. The script starts the RAC node configuration. The prompt to create the UDF appears.
    2025-12-30 06:32:15 - [INFO] SSH master connection to <node_name> ready
2025-12-30 06:32:15 - [INFO] Checking sudo access for <node_name>...
2025-12-30 06:32:16 - [INFO] Precheck OK for <node_name>
2025-12-30 06:32:16 - [INFO] Precheck complete. Starting RAC node configuration...
2025-12-30 06:32:16 - [INFO] Syncing /opt/protegrity/logforwarder to <node_name>...
2025-12-30 06:32:19 - [INFO] Starting new Logforwarder on <node_name>
2025-12-30 06:32:21 - [INFO] Syncing /opt/protegrity/rpagent to <node_name>...
2025-12-30 06:32:23 - [INFO] Starting new RPAgent on <node_name>
2025-12-30 06:32:23 - [INFO] Syncing /opt/protegrity/databaseprotector to <node_name>...
2025-12-30 06:32:24 - [INFO] Syncing /etc/protegrity to <node_name>...
2025-12-30 06:32:24 - [INFO] Updating extproc.ora on <node_name>
2025-12-30 06:32:24 - [INFO] Updating runtime extproc.ora symlink on <node_name>
2025-12-30 06:32:24 - [INFO] Node <node_name> configured successfully.
2025-12-30 06:32:24 - [INFO] Syncing /opt/protegrity/logforwarder to <node_name>...
2025-12-30 06:32:28 - [INFO] Starting new Logforwarder on <node_name>
2025-12-30 06:32:30 - [INFO] Syncing /opt/protegrity/rpagent to <node_name>...
2025-12-30 06:32:31 - [INFO] Starting new RPAgent on <node_name>
2025-12-30 06:32:31 - [INFO] Syncing /opt/protegrity/databaseprotector to <node_name>...
2025-12-30 06:32:32 - [INFO] Syncing /etc/protegrity to <node_name>...
2025-12-30 06:32:32 - [INFO] Updating extproc.ora on <node_name>
2025-12-30 06:32:33 - [INFO] Updating runtime extproc.ora symlink on <node_name>
2025-12-30 06:32:33 - [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]:
  30. To create the UDF, type yes.

    Note: If you select No to create the UDFs, the script skips creating the UDFs. The installation will complete successfully. However, the database will not contain the required UDFs. To manually create the UDFs, refer to the section Creating the User Defined Functions (UDFs).

  31. Press ENTER. The prompt to enter the databse username appears.
    Enter Oracle database username:
  32. Enter the username.
  33. Press ENTER. The prompt to enter the password appears.
    Enter Oracle database user's password:
  34. Enter the password.
  35. Press ENTER. The script creates the UDFs and completes the installation.
    2025-12-30 06:32:41 - [INFO] Going to create new types and UDFs.
2025-12-30 06:32:41 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs.
2025-12-30 06:32:41 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity/databaseprotector/oracle/sqlscripts/createobjects.sql)
2025-12-30 06:32:42 - [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:32:42 - [INFO] Create new types and UDFs executed successfully.
2025-12-30 06:32:42 - [INFO] New types and UDFs created successfully.
2025-12-30 06:32:42 - [INFO] Testing UDFs installation...
2025-12-30 06:32:42 - [INFO] Test UDFs output: <DBP_version>
2025-12-30 06:32:42 - [INFO] UDFs installation tested successfully.
2025-12-30 06:32:42 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora.bak_2025-12-30_06:31:58
2025-12-30 06:32:42 - [INFO] Closing SSH master connections...
2025-12-30 06:32:42 - [INFO] Connection to <node_name> closed.
2025-12-30 06:32:42 - [INFO] Connection to <node_name> closed.
2025-12-30 06:32:42 - [INFO] Installation successful.
2025-12-30 06:32:42 - [INFO] All components installed successfully.

Installing the Protector using the install.ini file

This argument requires the install.ini file to be present and updated with the required parameters. The install.ini files contains the installation directories for the components and the endpoints for the Log Forwarder and RPAgent.

Note: Ensure that the install.ini file is available on the primary node.

A sample output of the install.ini file is listed below.

[Logforwarder]
INSTALLATION_DIR = </opt/protegrity1>
AUDIT_STORE_ENDPOINTS = <IP_address>:9200 <IP_address>:9200 <IP_address>:9200

[RPAgent]
INSTALLATION_DIR = </opt/protegrity1>
UPSTREAM_HOST_IP_ADDR_PORT = <IP_address>:25400

[DatabaseProtector]
INSTALLATION_DIR = </opt/protegrity1>

Note: To use any directory for the Database Protector, ensure the directory is available. Otherwise, the installation will fail. Note: The default port for the Audit Store endpoint is 9200. The default port for the RPAgent is 25400. To use any other port, replace the value.

To install the protector using the install.ini argument:

  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 script with the argument, run the following command:
    ./Install_OracleProtector_Linux_x64_<DBP_version>.sh --install --install-ini <path_to_install.ini_file>
  4. Press ENTER. The script detects the install.ini file and the prompt to verify the configuration appears.
     2025-12-30 06:52:50 - [INFO] install.ini detected: <path_to_install.ini_file>
 2025-12-30 06:52:51 - [INFO] Discovering Grid Infrastructure home dynamically...
 2025-12-30 06:52:51 - [INFO] Discovered GRID_HOME: /u01/app/21.3.0./grid
 2025-12-30 06:52:51 - [INFO] Grid home found: /u01/app/21.3.0./grid
 2025-12-30 06:52:51 - [INFO] RAC setup detected
 2025-12-30 06:52:51 - [INFO] Current node: <node_name> (<node_name>.localdomain.com)
 2025-12-30 06:52:51 - [INFO] Other nodes: <node_name> <node_name>
 2025-12-30 06:52:51 - [INFO] Checking for required tools...
 2025-12-30 06:52:51 - [INFO] All required tools are available
 2025-12-30 06:52:51 - [INFO] Going to configure environment for installation
 2025-12-30 06:52:51 - [INFO] Discovered ORACLE_SID=<oracle_system_identifier>, ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1
 2025-12-30 06:52:51 - [INFO] Oracle environment set:
 2025-12-30 06:52:51 - [INFO] ORACLE_HOME=/u01/app/oracle/product/21.3.0/db_1
 2025-12-30 06:52:51 - [INFO] ORACLE_SID=<oracle_system_identifier>
 2025-12-30 06:52:51 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/21.3.0/db_1/lib
 2025-12-30 06:52:51 - [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:52:51 - [INFO] Environment configured successfully...
 2025-12-30 06:52:51 - [INFO] **************************************************************************
 2025-12-30 06:52:51 - [INFO] Installation will be done with following configuration:
 2025-12-30 06:52:51 - [INFO] Oracle Instance ID: <oracle_instance_ID>
 2025-12-30 06:52:51 - [INFO] Mode: install
 2025-12-30 06:52:51 - [INFO] Using configuration from install.ini:
 2025-12-30 06:52:51 - [INFO] Logforwarder Installation Directory: /opt/protegrity1
 2025-12-30 06:52:51 - [INFO] Audit Store Endpoints: <IP_Address>:9200 <IP_Address>:9200 <IP_Address>:9200
 2025-12-30 06:52:51 - [INFO] RPAgent Installation Directory: /opt/protegrity1
 2025-12-30 06:52:51 - [INFO] Upstream (ESA) IP Address for RPAgent: <IP_Address>
 2025-12-30 06:52:51 - [INFO] Upstream (ESA) Port for RPAgent: 25400
 2025-12-30 06:52:51 - [INFO] DatabaseProtector Installation Directory: /opt/protegrity1
 2025-12-30 06:52:51 - [INFO] This is a fresh install.
 2025-12-30 06:52:51 - [INFO] RAC setup detected with nodes: <node_name>
 <node_name>
 <node_name>
 2025-12-30 06:52:51 - [INFO] **************************************************************************

 2025-12-30 06:52:51 - [INFO] Please verify the above configuration before proceeding.
 Do you want to continue? (yes/no) [no]:
  5. To proceed with the configuration, type yes.
  6. Press ENTER. The script installs the Log Forwarder. The script starts in the RPAgent installation. The prompt to enter the JWT token appears.
    2025-12-30 06:52:54 - [INFO] Continuing with installation...
2025-12-30 06:52:54 - [INFO] Installing/Upgrading LOGFORWARDER...
2025-12-30 06:52:54 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh...
Unpacking...
Extracting files...
Protegrity Log Forwarder installed in /opt/protegrity1/logforwarder.

2025-12-30 06:52:54 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-30 06:52:54 - [INFO] Installing/Upgrading RPAGENT...
Enter ESA token (leave blank to use username/password):
  7. Enter the JWT token.

    Note: To use the username and password, press ENTER.

  8. Press ENTER. The script downloads the certificates and completes the installation for the RPAgent and the Database Protector. The prompt to enter the username to access the node appears.
     2025-12-30 06:53:06 - [INFO] Executing ./RPAgentSetup_Linux_x64_<DBP_version>.sh...
 Unpacking...
 Extracting files...
 Downloading certificates from <IP_Address>:25400...
 % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
 100 11264  100 11264    0     0  55949      0 --:--:-- --:--:-- --:--:-- 56039

 Extracting certificates...
 Certificates successfully downloaded and stored in /opt/protegrity1/rpagent/data

 Protegrity RPAgent installed in /opt/protegrity1/rpagent.

 2025-12-30 06:53:06 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
 2025-12-30 06:53:06 - [INFO] Installing/Upgrading DBP...
 2025-12-30 06:53:06 - [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/protegrity1/databaseprotector/oracle.

 2025-12-30 06:53:06 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully.
 2025-12-30 06:53:06 - [INFO] Going to launch <DBP_version> version Logforwarder
 2025-12-30 06:53:08 - [INFO] Successfully launched <DBP_version> version Logforwarder
 2025-12-30 06:53:08 - [INFO] Going to launch <DBP_version> version RPAgent
 2025-12-30 06:53:08 - [INFO] Successfully launched <DBP_version> version RPAgent
 2025-12-30 06:53:08 - [INFO] Configuring extproc.ora
 2025-12-30 06:53:08 - [INFO] Backed up existing /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora
 2025-12-30 06:53:08 - [INFO] Updated EXTPROC_DLLS in /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora to only include /opt/protegrity1/databaseprotector/oracle/lib/peporacle.plm
 2025-12-30 06:53:08 - [INFO] Updated extproc.ora at /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora
 2025-12-30 06:53:08 - [INFO] Detected separate runtime home: /u01/app/oracle/homes/OraDB21Home1
 2025-12-30 06:53:08 - [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:53:08 - [INFO] Synchronized extproc.ora in runtime home /u01/app/oracle/homes/OraDB21Home1/hs/admin
 2025-12-30 06:53:08 - [INFO] Configuring RAC nodes...
 2025-12-30 06:53:08 - [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]:
  9. To proceed with the different usernames for the nodes, type no.
  10. Press ENTER. The prompt to enter the username appears.
    Enter remote username for node <node_name> (must be in sudoers):
  11. Enter the username to connect to the node.
  12. Press ENTER. The script validates the username. The prompt to enter the password appears.
    2025-12-30 06:53:15 - [INFO] Opening SSH connection to <node_name> for precheck...
2025-12-30 06:53:15 - [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:
  13. Enter the password to access the node.
  14. Press ENTER. The script validates the credentials. The prompt to enter the username for the next node appears.
    2025-12-30 06:53:19 - [INFO] SSH master connection to <node_name> ready
2025-12-30 06:53:19 - [INFO] Checking sudo access for <node_name>...
2025-12-30 06:53:19 - [INFO] Precheck OK for <node_name>
Enter remote username for node <node_name> (must be in sudoers):
  15. Enter the username to connect to the node.
  16. Press ENTER. The script validates the username. The prompt to enter the password appears.
    2025-12-30 06:53:23 - [INFO] Opening SSH connection to <node_name> for precheck...
2025-12-30 06:53:23 - [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:
  17. Enter the password to access the node.
  18. Press ENTER. The script validates the credentials, configures the nodes, and the prompt to create the UDF appears.
    2025-12-30 06:53:27 - [INFO] SSH master connection to <node_name> ready
2025-12-30 06:53:27 - [INFO] Checking sudo access for <node_name>...
2025-12-30 06:53:27 - [INFO] Precheck OK for <node_name>
2025-12-30 06:53:27 - [INFO] Precheck complete. Starting RAC node configuration...
2025-12-30 06:53:27 - [INFO] Syncing /opt/protegrity1/logforwarder to <node_name>...
2025-12-30 06:53:30 - [INFO] Starting new Logforwarder on <node_name>
2025-12-30 06:53:33 - [INFO] Syncing /opt/protegrity1/rpagent to <node_name>...
2025-12-30 06:53:34 - [INFO] Starting new RPAgent on <node_name>
2025-12-30 06:53:34 - [INFO] Syncing /opt/protegrity1/databaseprotector to <node_name>...
2025-12-30 06:53:35 - [INFO] Syncing /etc/protegrity to <node_name>...
2025-12-30 06:53:35 - [INFO] Updating extproc.ora on <node_name>
2025-12-30 06:53:35 - [INFO] Updating runtime extproc.ora symlink on <node_name>
2025-12-30 06:53:36 - [INFO] Node <node_name> configured successfully.
2025-12-30 06:53:36 - [INFO] Syncing /opt/protegrity1/logforwarder to <node_name>...
2025-12-30 06:53:39 - [INFO] Starting new Logforwarder on <node_name>
2025-12-30 06:53:41 - [INFO] Syncing /opt/protegrity1/rpagent to <node_name>...
2025-12-30 06:53:42 - [INFO] Starting new RPAgent on <node_name>
2025-12-30 06:53:43 - [INFO] Syncing /opt/protegrity1/databaseprotector to <node_name>...
2025-12-30 06:53:43 - [INFO] Syncing /etc/protegrity to <node_name>...
2025-12-30 06:53:44 - [INFO] Updating extproc.ora on <node_name>
2025-12-30 06:53:44 - [INFO] Updating runtime extproc.ora symlink on <node_name>
2025-12-30 06:53:44 - [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]:
  19. To create the UDFs, type yes.

    Note: If you select No to create the UDFs, the script skips creating the UDFs. The installation will complete successfully. However, the database will not contain the required UDFs. To manually create the UDFs, refer to the section Creating the User Defined Functions (UDFs).

  20. Press ENTER. The prompt to enter the database username appears.
    Enter Oracle database username:
  21. Enter the username to connect to the database.
  22. Press ENTER. The prompt to enter the password appears.
    Enter Oracle database user's password:
  23. Enter the password to connect to the database.
  24. Press ENTER. The script creates the UDFs and completes the installation.
    2025-12-30 06:53:52 - [INFO] Going to create new types and UDFs.
2025-12-30 06:53:52 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs.
2025-12-30 06:53:52 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity1/databaseprotector/oracle/sqlscripts/createobjects.sql)
2025-12-30 06:53:53 - [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:53:53 - [INFO] Create new types and UDFs executed successfully.
2025-12-30 06:53:53 - [INFO] New types and UDFs created successfully.
2025-12-30 06:53:53 - [INFO] Testing UDFs installation...
2025-12-30 06:53:53 - [INFO] Test UDFs output: <DBP_version>
2025-12-30 06:53:53 - [INFO] UDFs installation tested successfully.
2025-12-30 06:53:53 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/21.3.0/db_1/hs/admin/extproc.ora.bak_2025-12-30_06:53:08
2025-12-30 06:53:53 - [INFO] Closing SSH master connections...
2025-12-30 06:53:53 - [INFO] Connection to <node_name> closed.
2025-12-30 06:53:53 - [INFO] Connection to <node_name> closed.
2025-12-30 06:53:53 - [INFO] Installation successful.
2025-12-30 06:53:53 - [INFO] All components installed successfully.

Last modified : January 05, 2026