Set up Oracle database in Certificate Manager using Podman

This article is new for Certificate Manager 8.10.4.

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.10.4-1\cmdb-install-tool-8.10.4.zip\install\Oracle

Step-by-step instruction

Edit settings on the Oracle server

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
```
Check the log file.

Run the script for creating the CMDB tables:

CODE

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

Check the log file.
Run the script for adding the Boot CA: sqlplus lcmadmin/REQreq01 @add_bootca.sql > add_bootca.log
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.