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 thelcmadmin
user:CODEsqlplus sysdba/<password> @create_tablespace_and_user_cm.sql >create_tsu.log
Check the log file.
Run the script for creating the CMDB tables:
CODEsqlplus 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