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 Oracle | Cloud Applications and Cloud Platform.
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
Login as an Oracle database administrator (
dba
) user in the operating system and run the script, that creates the tablespace and thelcmadmin
user:sqlplus sysdba/<password> @create_tablespace_and_user_cm.sql >create_tsu.log
Check the log file.
Run the script for creating the CMDB tables:
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
Copyright 2024 Technology Nexus Secured Business Solutions AB. All rights reserved.
Contact Nexus | https://www.nexusgroup.com | Disclaimer | Terms & Conditions