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 thelcmadminuser: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.logCheck the log file.
Navigate to the volume hosting the cm server config directory and update the database parameters in cm.conf Database.name Database.user Database.passwordEdit settings on the CM server