Installing Oracle Database Protector on Standalone 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:

Log Forwarder
RPAgent
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

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.

Installing 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 script, run the following command:

./Install_OracleProtector_Linux_x64_<DBP_version>.sh --install

Press ENTER. The prompt to select the silent mode of installation appears.
```
Do you want silent installation? (yes/no) [no]:
```
To install the components using the interactive mode, type no.

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]:

To install the components in different directories, type no.
Press ENTER. The prompt to enter the installation directory for the Log Forwarder appears.
```
Enter new LogForwarder installation directory [/opt/protegrity]:
```
Enter the location to install the Log Forwarder.
Press ENTER. The prompt to enter the installation directory for the RPAgent appears.
```
Enter new RPAgent installation directory [/opt/protegrity]:
```
Enter the location to install the RPAgent.
Press ENTER. The prompt to enter the installation directory for the Database Protector appears.
```
Enter new DatabaseProtector installation directory [/opt/protegrity]:
```
Enter the location to install the Database Protector.
Note: To use any directory for the Database Protector, ensure the directory is available. Otherwise, the installation will fail.

Press ENTER. The script configures the environment and the prompt to confirm the configuration appears.

2025-12-23 12:05:39 - [INFO] Discovering Grid Infrastructure home dynamically...
2025-12-23 12:05:39 - [INFO] No ASM instance found. This is a standalone system.
2025-12-23 12:05:39 - [INFO] No Grid home found. Treating it as a standalone Oracle.
2025-12-23 12:05:39 - [INFO] Going to configure environment for installation
2025-12-23 12:05:39 - [INFO] Discovered ORACLE_SID=orcl, ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
2025-12-23 12:05:39 - [INFO] Oracle environment set:
2025-12-23 12:05:39 - [INFO] ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
2025-12-23 12:05:39 - [INFO] ORACLE_SID=orcl
2025-12-23 12:05:39 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/19.0.0/dbhome_1/lib
2025-12-23 12:05:39 - [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:05:39 - [INFO] Environment configured successfully...
2025-12-23 12:05:39 - [INFO] **************************************************************************
2025-12-23 12:05:39 - [INFO] Installation will be done with following configuration:
2025-12-23 12:05:39 - [INFO] Oracle Instance ID: orcl
2025-12-23 12:05:39 - [INFO] Mode: install
2025-12-23 12:05:39 - [INFO] Logforwarder Installation Directory: /opt/protegrity1
2025-12-23 12:05:39 - [INFO] RPAgent Installation Directory: /opt/protegrity1
2025-12-23 12:05:39 - [INFO] DatabaseProtector Installation Directory: /opt/protegrity1
2025-12-23 12:05:39 - [INFO] This is a fresh install.
2025-12-23 12:05:39 - [INFO] Standalone setup detected
2025-12-23 12:05:39 - [INFO] **************************************************************************
2025-12-23 12:05:39 - [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 master script invokes the Log Forwarder installation script. The prompt to enter the Audit Store endpoint appears.

2025-12-23 12:05:41 - [INFO] Continuing with installation...
2025-12-23 12:05:41 - [INFO] Installing/Upgrading LOGFORWARDER...
2025-12-23 12:05:41 - [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:

Enter the IP address for the Audit Store.
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]:
```
To provide an additional endpoint, type yes.

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:

Enter the IP address for the Audit Store.
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:
```
To add the endpoints, type yes.

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-23 12:05:59 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 12:05:59 - [INFO] Installing/Upgrading RPAGENT...
Please enter upstream host name or IP address,
alternative (host:port) to use another port than the default port 25400:

Enter the upstream host name or IP address.

Press ENTER. The prompt to enter the ESA token appears.

Enter ESA token (leave blank to use username/password):

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

Press ENTER. The script installs the RPAgent and triggers the script to install the Oracle objects. The script installs the objects and the prompt to create the UDFs appears.

2025-12-23 12:06:14 - [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   113k      0 --:--:-- --:--:-- --:--:--  112k

Extracting certificates...
tar: CA.pem: time stamp 2025-12-23 12:06:15 is 0.531323771 s in the future
tar: cert.pem: time stamp 2025-12-23 12:06:15 is 0.531192197 s in the future
tar: cert.key: time stamp 2025-12-23 12:06:15 is 0.531134958 s in the future
tar: secret.txt: time stamp 2025-12-23 12:06:15 is 0.531081244 s in the future
Certificates successfully downloaded and stored in /opt/protegrity1/rpagent/data

Protegrity RPAgent installed in /opt/protegrity1/rpagent.

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

2025-12-23 12:06:14 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 12:06:14 - [INFO] Going to launch <DBP_version> version Logforwarder
2025-12-23 12:06:16 - [INFO] Successfully launched <DBP_version> version Logforwarder
2025-12-23 12:06:16 - [INFO] Going to launch <DBP_version> version RPAgent
2025-12-23 12:06:16 - [INFO] Successfully launched <DBP_version> version RPAgent
2025-12-23 12:06:16 - [INFO] Configuring extproc.ora
2025-12-23 12:06:16 - [INFO] Backed up existing /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
2025-12-23 12:06:16 - [INFO] /opt/protegrity1/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:06:16 - [INFO] Updated extproc.ora at /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
2025-12-23 12:06:16 - [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]:

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).
Press ENTER. The prompt to enter the Oracle Database username appears.
```
Enter Oracle database username:
```
Enter the username.
Press ENTER. The prompt to enter the Oracle Database password appears.
```
Enter Oracle database user's password:
```
Enter the password.

Press ENTER. The script creates the UDFs and completes the installation.

2025-12-23 12:06:24 - [INFO] Going to create new types and UDFs.
2025-12-23 12:06:24 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs.
2025-12-23 12:06:24 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity1/databaseprotector/oracle/sqlscripts/createobjects.sql)
2025-12-23 12:06:25 - [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:06:25 - [INFO] Create new types and UDFs executed successfully.
2025-12-23 12:06:25 - [INFO] New types and UDFs created successfully.
2025-12-23 12:06:25 - [INFO] Testing UDFs installation...
2025-12-23 12:06:26 - [INFO] Test UDFs output: <DBP_version>
2025-12-23 12:06:26 - [INFO] UDFs installation tested successfully.
2025-12-23 12:06:26 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora.bak_2025-12-23_12:06:16
2025-12-23 12:06:26 - [INFO] Closing SSH master connections...
2025-12-23 12:06:26 - [INFO] Installation successful.
2025-12-23 12:06:26 - [INFO] All components installed successfully.

Installing 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 script, run the following command:

./Install_OracleProtector_Linux_x64_<DBP_version>.sh --install

Press ENTER. The prompt to select the silent mode of installation appears.
```
Do you want silent installation? (yes/no) [no]:
```
To install the components using the silent mode, type yes.

Press ENTER. The script lists the configuration and a prompt to confirm the configuration appears.

 2025-12-23 11:40:10 - [INFO] You have chosen silent mode. Therefore, /opt/protegrity is considered as base directory for new installation.
 2025-12-23 11:40:10 - [INFO] Discovering Grid Infrastructure home dynamically...
 2025-12-23 11:40:10 - [INFO] No ASM instance found. This is a standalone system.
 2025-12-23 11:40:10 - [INFO] No Grid home found. Treating it as a standalone Oracle.
 2025-12-23 11:40:10 - [INFO] Going to configure environment for installation
 2025-12-23 11:40:10 - [INFO] Discovered ORACLE_SID=orcl, ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
 2025-12-23 11:40:10 - [INFO] Oracle environment set:
 2025-12-23 11:40:10 - [INFO] ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
 2025-12-23 11:40:10 - [INFO] ORACLE_SID=orcl
 2025-12-23 11:40:10 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/19.0.0/dbhome_1/lib
 2025-12-23 11:40:10 - [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 11:40:10 - [INFO] Environment configured successfully...
 2025-12-23 11:40:10 - [INFO] **************************************************************************
 2025-12-23 11:40:10 - [INFO] Installation will be done with following configuration:
 2025-12-23 11:40:10 - [INFO] Oracle Instance ID: orcl
 2025-12-23 11:40:10 - [INFO] Mode: install
 2025-12-23 11:40:10 - [INFO] Logforwarder Installation Directory: /opt/protegrity
 2025-12-23 11:40:10 - [INFO] RPAgent Installation Directory: /opt/protegrity
 2025-12-23 11:40:10 - [INFO] DatabaseProtector Installation Directory: /opt/protegrity
 2025-12-23 11:40:10 - [INFO] This is a fresh install.
 2025-12-23 11:40:10 - [INFO] Standalone setup detected
 2025-12-23 11:40:10 - [INFO] **************************************************************************

 2025-12-23 11:40:10 - [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 scripts starts the Log Forwarder installation and 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:
```
Enter the audit store endpoint.

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]:

To provide another audit store endpoint, type, yes.
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:
```
To continue, type yes.

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-23 11:44:29 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 11:44:29 - [INFO] Installing/Upgrading RPAGENT...
Please enter upstream host name or IP address,
alternative (host:port) to use another port than the default port 25400:

Enter the IP address.

Press ENTER. The prompt to enter the JWT token appears.

Enter ESA token (leave blank to use username/password):

To use the username and password combination, press ENTER. The prompt to enter the username appears.
```
Enter ESA username:
```
Enter the username.
Press ENTER. The prompt to enter the password appears.
```
Enter ESA password:
```
Enter the password.

Press ENTER. The script retrieves the token from ESA, extracts the certificates, and installs the RPAgent. The script completes the installation of the objects and the prompt to create the UDF appears.

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   152k      0 --:--:-- --:--:-- --:--:--  152k

Extracting certificates...
tar: CA.pem: time stamp 2025-12-23 11:50:29 is 0.471443292 s in the future
tar: cert.pem: time stamp 2025-12-23 11:50:29 is 0.47131432 s in the future
tar: cert.key: time stamp 2025-12-23 11:50:29 is 0.471256437 s in the future
tar: secret.txt: time stamp 2025-12-23 11:50:29 is 0.471203322 s in the future
Certificates successfully downloaded and stored in /opt/protegrity/rpagent/data

Protegrity RPAgent installed in /opt/protegrity/rpagent.

2025-12-23 11:50:28 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 11:50:28 - [INFO] Installing/Upgrading DBP...
2025-12-23 11:50:28 - [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 11:50:28 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 11:50:28 - [INFO] Going to launch <DBP_version> version Logforwarder
2025-12-23 11:50:30 - [INFO] Successfully launched <DBP_version> version Logforwarder
2025-12-23 11:50:30 - [INFO] Going to launch <DBP_version> version RPAgent
2025-12-23 11:50:30 - [INFO] Successfully launched <DBP_version> version RPAgent
2025-12-23 11:50:30 - [INFO] Configuring extproc.ora
2025-12-23 11:50:30 - [INFO] Backed up existing /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
2025-12-23 11:50:30 - [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 11:50:30 - [INFO] Updated extproc.ora at /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
2025-12-23 11:50:30 - [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]:

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).
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 script installs the UDFs and completes the installation process.

2025-12-23 11:50:39 - [INFO] Going to create new types and UDFs.
2025-12-23 11:50:39 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs.
2025-12-23 11:50:39 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity/databaseprotector/oracle/sqlscripts/createobjects.sql)
2025-12-23 11:50:40 - [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 11:50:40 - [INFO] Create new types and UDFs executed successfully.
2025-12-23 11:50:40 - [INFO] New types and UDFs created successfully.
2025-12-23 11:50:40 - [INFO] Testing UDFs installation...
2025-12-23 11:50:41 - [INFO] Test UDFs output: <DBP_version>
2025-12-23 11:50:41 - [INFO] UDFs installation tested successfully.
2025-12-23 11:50:41 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora.bak_2025-12-23_11:50:30
2025-12-23 11:50:41 - [INFO] Closing SSH master connections...
2025-12-23 11:50:41 - [INFO] Installation successful.
2025-12-23 11:50:41 - [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.

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:

Log in to the instance where the installation package is extracted.
Navigate to the directory containing the installation scripts.

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>

Press ENTER. The script detects the install.ini file and the prompt to verify the configuration appears.

 2025-12-23 12:16:37 - [INFO] install.ini detected: <path_to_install.ini_file>
 2025-12-23 12:16:37 - [INFO] Discovering Grid Infrastructure home dynamically...
 2025-12-23 12:16:37 - [INFO] No ASM instance found. This is a standalone system.
 2025-12-23 12:16:37 - [INFO] No Grid home found. Treating it as a standalone Oracle.
 2025-12-23 12:16:37 - [INFO] Going to configure environment for installation
 2025-12-23 12:16:37 - [INFO] Discovered ORACLE_SID=orcl, ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
 2025-12-23 12:16:37 - [INFO] Oracle environment set:
 2025-12-23 12:16:37 - [INFO] ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
 2025-12-23 12:16:37 - [INFO] ORACLE_SID=orcl
 2025-12-23 12:16:37 - [INFO] LD_LIBRARY_PATH=/u01/app/oracle/product/19.0.0/dbhome_1/lib
 2025-12-23 12:16:37 - [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:16:37 - [INFO] Environment configured successfully...

 2025-12-23 12:16:37 - [INFO] **************************************************************************
 2025-12-23 12:16:37 - [INFO] Installation will be done with following configuration:
 2025-12-23 12:16:37 - [INFO] Oracle Instance ID: orcl
 2025-12-23 12:16:37 - [INFO] Mode: install
 2025-12-23 12:16:37 - [INFO] Using configuration from install.ini:
 2025-12-23 12:16:37 - [INFO] Logforwarder Installation Directory: /opt/protegrity1
 2025-12-23 12:16:37 - [INFO] Audit Store Endpoints: <IP_Address>:9200 <IP_Address>:9200 <IP_Address>:9200
 2025-12-23 12:16:37 - [INFO] RPAgent Installation Directory: /opt/protegrity1
 2025-12-23 12:16:37 - [INFO] Upstream (ESA) IP Address for RPAgent: <IP_Address>
 2025-12-23 12:16:37 - [INFO] Upstream (ESA) Port for RPAgent: 25400
 2025-12-23 12:16:37 - [INFO] DatabaseProtector Installation Directory: /opt/protegrity1
 2025-12-23 12:16:37 - [INFO] This is a fresh install.
 2025-12-23 12:16:37 - [INFO] Standalone setup detected
 2025-12-23 12:16:37 - [INFO] **************************************************************************

 2025-12-23 12:16:37 - [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 Log Forwarder and the prompt to enter the JWT token appears.

2025-12-23 12:16:40 - [INFO] Continuing with installation...
2025-12-23 12:16:40 - [INFO] Installing/Upgrading LOGFORWARDER...
2025-12-23 12:16:40 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh...
Unpacking...
Extracting files...

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

2025-12-23 12:16:40 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 12:16:40 - [INFO] Installing/Upgrading RPAGENT...
Enter ESA token (leave blank to use username/password):

To use the credentials, press ENTER. The prompt to enter the ESA username appears.
```
Enter ESA username:
```
Enter the username.
Press ENTER. The prompt to enter the password appears.
```
Enter ESA password:
```
Enter the password.

Press ENTER. The script installs the RPAgent and the Oracle objects. The prompt to create the UDF appears.

2025-12-23 12:16:49 - [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   175k      0 --:--:-- --:--:-- --:--:--  177k

Extracting certificates...
tar: CA.pem: time stamp 2025-12-23 12:16:51 is 0.430031962 s in the future
tar: cert.pem: time stamp 2025-12-23 12:16:51 is 0.42988325 s in the future
tar: cert.key: time stamp 2025-12-23 12:16:51 is 0.429822044 s in the future
tar: secret.txt: time stamp 2025-12-23 12:16:51 is 0.429768891 s in the future
Certificates successfully downloaded and stored in /opt/protegrity1/rpagent/data

Protegrity RPAgent installed in /opt/protegrity1/rpagent.

2025-12-23 12:16:50 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 12:16:50 - [INFO] Installing/Upgrading DBP...
2025-12-23 12:16:50 - [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-23 12:16:50 - [INFO] ./PepOracleSetup_Linux_x64_<DBP_version>.sh completed successfully.
2025-12-23 12:16:50 - [INFO] Going to launch <DBP_version> version Logforwarder
2025-12-23 12:16:52 - [INFO] Successfully launched <DBP_version> version Logforwarder
2025-12-23 12:16:52 - [INFO] Going to launch <DBP_version> version RPAgent
2025-12-23 12:16:52 - [INFO] Successfully launched <DBP_version> version RPAgent
2025-12-23 12:16:52 - [INFO] Configuring extproc.ora
2025-12-23 12:16:52 - [INFO] Backed up existing /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
2025-12-23 12:16:52 - [INFO] /opt/protegrity1/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:16:52 - [INFO] Updated extproc.ora at /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora
2025-12-23 12:16:52 - [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]:

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).
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 script creates the UDFs and completes the installation.

2025-12-23 12:19:33 - [INFO] Going to create new types and UDFs.
2025-12-23 12:19:33 - [INFO] Using username '<user_name>' for database connection and creating new types and UDFs.
2025-12-23 12:19:33 - [INFO] Running SQL script: Create new types and UDFs (/opt/protegrity1/databaseprotector/oracle/sqlscripts/createobjects.sql)
2025-12-23 12:19:34 - [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:19:34 - [INFO] Create new types and UDFs executed successfully.
2025-12-23 12:19:34 - [INFO] New types and UDFs created successfully.
2025-12-23 12:19:34 - [INFO] Testing UDFs installation...
2025-12-23 12:19:35 - [INFO] Test UDFs output: <DBP_version>
2025-12-23 12:19:35 - [INFO] UDFs installation tested successfully.
2025-12-23 12:19:35 - [INFO] Removing extproc.ora backup file /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/extproc.ora.bak_2025-12-23_12:16:52
2025-12-23 12:19:35 - [INFO] Closing SSH master connections...
2025-12-23 12:19:35 - [INFO] Installation successful.
2025-12-23 12:19:35 - [INFO] All components installed successfully.

Feedback

Was this page helpful?

Last modified : January 05, 2026