Set up Oracle database in Certificate Manager using Podman

This article includes updates for Certificate Manager 8.11.0-1.

This article describes how to install and set up the Oracle database, used in Smart ID Certificate Manager.

For detailed information about how to install an Oracle database, see the Oracle documentation available at http://www.oracle.com/.

Prerequisites

See the prerequisites in Set up Oracle database in Certificate Manager.

When Oracle is used for the CMDB database, tables and users must be created before the CM server is installed.

The oracle database scripts can be found in the Certificate Manager containerization .zip in the path:
certificate-manager-8.X.Y-Z\install\Oracle

Step-by-step instruction

Edit settings on the Oracle server

1. Login as an Oracle database administrator (dba) user in the operating system and run the script, that creates the tablespace and the lcmadmin user:

   CODE

   sqlplus sysdba/<password> @create_tablespace_and_user_cm.sql >create_tsu.log

2. Check the log file.

3. Run the script for creating the CMDB tables:

   CODE

   sqlplus lcmadmin/REQreq01 @create_cmdb.sql >create_cmdb.log

4. Check the log file.

5. Run the script for adding the Boot CA: sqlplus lcmadmin/REQreq01 @add_bootca.sql > add_bootca.log

6. Check the log file.

Edit settings on the CM server

Navigate to the volume hosting the cm server config directory and update the database parameters in cm.conf:

• Database.name

• Database.user

• Database.password

Secure the connection

See Set up Oracle database in Certificate Manager.