Version: 3.2

Database Installation

This page provides setup instructions for the Oracle Database required by USP Manager to work in high-availability deployments. It explains how to:

Install Oracle Database.
Create a dedicated user and schema for USP Manager.
Grant the required permissions.
(Optional) Verify connectivity to the database using the open source usql command-line interface.
(Optional) Run a query to confirm access.

Refer to the Oracle official documentation for installation instructions.

info

Ensure that Oracle Database is installed, running, and reachable from the host where USP Manager is deployed.

Run the following commands as an Oracle DBA to create a dedicated user and schema for USP Manager:

CREATE USER uspmanageradm IDENTIFIED BY "usp-manager-oracle-password";
GRANT CONNECT, RESOURCE TO uspmanageradm;

Use the usql client to confirm that the uspmanageradm user can connect to the database:

usql godror://uspmanageradm:usp-manager-oracle-password@//host:1521/service

Expected output:

Connected with driver godror
Type "help" for help.

godror:uspmanageradm@host/service=>

Run a simple query to confirm that the schema is accessible and currently empty:

SELECT table_name FROM user_tables;

Expected output on a new schema:

(0 rows)

This confirms that: