3 Setting Up SPMS Database Server

After setting up the SPMS Secure Server, you can prepare the SPMS Database Server for the SPMS Secure Server to connect to the SPMS Database. Currently, there are two options to prepare the SPMS Database Server.

  1. Upgrade from an existing SPMS 8.0 / 20.X/ 23.X Database to SPMS 23.2 Database, or

  2. Set up from a seed SPMS 23.2 Database. See Definition of SPMS Seed Database in Appendix section.

Since the SPMS Database Server can be prepared from an existing SPMS 8.0 / 20.X / 23.X Database or a seed SPMS 23.2 Database, you need to understand that:

  • By upgrading from an existing SPMS 8.0 / 20.X / 23.X Database, there could be existing data in the Database. Therefore, you need to validate the Database to ensure that all data is valid and error free. This method of SPMS Database setup is similar to a live ship upgrade from SPMS 8.0 / 20.X / 23.X to SPMS 23.2.

  • When upgrading from a seed SPMS 23.2 Database, it should NOT contain any data in the SPMS Database. As there is no data, there will not be any SPMS Encryption Key in the SPMS Database yet. Subsequently, the Database will need to undergo a migration process to ensure that the SPMS 23.2 Database is now ready for SPMS installation. This method of SPMS Database setup is like a new ship installation with SPMS 23.2

The diagram below summarizes the process of setting up the SPMS Database Server based on the options available to you when preparing the SPMS 23.2 Database.

Figure 3-1 Database Preparation Workflow


This figure shows the Database Preparation Workflow

Prerequisites

  1. Oracle 19c Database Management System is installed on the target machine. It is presumed that:

    • You know where to obtain the Oracle Database Server installer.

    • You know how to install Oracle Database Server.

    • You know how to perform Oracle Database DMP import and export.

  2. SPMS 23.2 Installer is downloaded and available on the target machine. See topic Where to Download in SPMS Installation File.

  3. SPMS 23.2 Package is downloaded and available in the target machine. See topic SPMS Package File.

  4. Before the SPMS Database preparation, you must ensure that the DB TNS name on the client machine is the same as the DB TNS name configured on the SPMS Web Server.

  5. Before you begin the SPMS Database upgrade and if you are on the below version, ensure that they are updated accordingly:

    • From SPMS v7.30x, you must update the database to v8.0.12 first before continuing.

    • From v8.0 to v8.0.11, update the database with OHC Database Installer version 8.0.12 before continuing.

    • Know the current database encryption key before you proceed to upgrade. Contact Customer Support on how to obtain an encryption key if you do not have this information.

Important:

  • Before you proceed, it is important to know where you intend to set up the SPMS Database Server. See topic Recommendation for the Installed SPMS Environment section for some examples of SPMS Environment configurations. The SPMS Database Server is the heart of every SPMS environment. Therefore, the first thing you need to do before installing the full SPMS environment is to identify the location of the SPMS Database Server.

  • The SPMS Database Server must be reachable by all SPMS Application Clients, SPMS Secure Server, and SPMS Web Server.