1. Extract the Oracle database scripts located at program_files/install/Oracle, from the server installation zip file, cm_server_<version>.zip.

2. Decide whether the table spaces should be stored in the ordinary file system on the Oracle server or in the ASM (Automatic Storage Management).

3. If they are to be stored in ASM, create_tablespace_and_user_cm.sql has to be adjusted. Make changes according to the following example:

   Create tablespace CMDB datafile 'cmdb.dbf' size 100m reuse autoextend on next 100m;

   should be changed to:
   

   Create tablespace CMDB datafile '+DATA' size 100m reuse autoextend on next 100m;

   DATA is just an example name of an ASM disk group. Read more about ASM groups on http://www.oracle.com/.

Login as an Oracle database administrator (dba) user in the operating system and run the script, that creates the tablespace and the lcmadmin 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.

1. Change the Database.name parameter to provide the whole connection information as defined in the Oracle database file tnsnames.ora.
   For example:

   Example: Change Database.name

   Database.name = jdbc:oracle:thin:@(DESCRIPTION=
   (ADDRESS= (PROTOCOL=tcps)
   (HOST=localhost) (PORT=1521) ) (CONNECT_DATA= (SERVER =
   DEDICATED)(SERVICE_NAME=XE)))

2. To pass any additional required parameter to the Oracle JDBC driver, add new Database.security parameters.
   For example:

   Example: Additional parameters

   Database.security.# = <parameter_name> = <parameter_value>

3. In order for the Oracle JDBC to trust the Oracle database's certificate, the certificate's issuer has to be trusted. To achieve this, add the issuer's certificate in a keystore with trusted certificates.
   For example:

   Example: Add issuer's certificate in keystore with trusted certificates

   Database.security.1 = javax.net.ssl.trustStore = <path_to_keystore_file>
   Database.security.2 = javax.net.ssl.trustStoreType = JKS
   Database.security.3 = javax.net.ssl.trustStorePassword = <keystore_password>

4. If TLS client authentication is also activated on the server, the Oracle JDBC driver needs to be provided with the key and certificate to be used for authenticating to the Oracle database. This certificate has to be signed by an issuer trusted by the Oracle database.
   For example:

   Example: Sign certificate by an issuer trusted by the Oracle database

   ;If PKCS12 file is used as storage for key and certificate
   Database.security.4 = javax.net.ssl.keyStore = <path_to_p12_file>
   Database.security.5 = javax.net.ssl.keyStoreType = PKCS12
   Database.security.6 = javax.net.ssl.keyStorePassword = <p12_password>
   ;If JKS keystore file is used
   ;Database.security.4 = javax.net.ssl.keyStore = <path_to_JKS_file>
   ;Database.security.5 = javax.net.ssl.keyStoreType = JKS
   ;Database.security.6 = javax.net.ssl.keyStorePassword = <keystore_password>