2 Overview of SPMS Components

To set up a full SPMS 20.3 environment, the following components are required:

  1. SPMS Database Server.

  2. SPMS .NET Secure Server.

  3. SPMS .NET Web Server.

  4. SPMS Desktop Application Clients.

  5. SPMS REST API Server.

  6. SPMS Web Application Server.

It is important that you know and understand that each of the components listed above is not restricted to one component per machine. Depending on your operation requirements and resource availability, you can select one of the following options:

  1. Install all the components in the same machine.

  2. Install each component separately in a different machine.

  3. Install the components using a combination of both option 1 and option 2.

SPMS Database Server

The SPMS Database Server is the machine that hosts the database of the SPMS applications. It is the core or heart of the SPMS environment. It must be installed with database management software and configured to handle database requests from multiple database clients.

Below are the minimum system requirements for each server type. We strongly recommend that you refer to the Cruise Compatibility Matrix at Oracle Help Center for the latest Operating System and Database version.

Minimum System Specification

  • Operating System:

    • Microsoft Windows Server 2016

  • Memory:

    • 8 GB of RAM, and

    • 160 GB of disk space.

  • Oracle Database Version:

    • Oracle Database Server 12c

  • Oracle Database Client Version:

    • Oracle Database 32-bit Full Client for 12c including the ODAC

  • Web Browser:

    • Internet Explorer 8.0

  • Microsoft .NET Framework runtime:

    • Framework version 2 enabled,

    • Framework version 3.5 enabled, and

    • Framework version 4.8 enabled.

SPMS Secure Server

The SPMS Secure Server hosts the web service that manages the user credentials. It is similar to password manager software. In SPMS 7.30, there is no Secure Server. Instead, a separate database schema handles the same responsibility. From SPMS 8.0, 20.1, 20.2, 20.3, or newer versions, the database schema is replaced by a web service hosted on a web host (SPMS Secure Server) that handles HTTPS requests from multiple clients.

Note:

SPMS Secure Server installation files are bundled with the SPMS Transactions Service. Therefore, installing the SPMS Transactions Service also deploys a copy of the SPMS Secure Service.

Minimum System Specification

  • Operating System:

    • Microsoft Windows Server 2016

  • Memory:

    • 8 GB of RAM, and

    • 160 GB of disk space.

  • Oracle Database Client Version:

    • Oracle Database 32-bit Full Client for 12c including the ODAC

  • Web Browser:

    • Internet Explorer 8.0

  • Microsoft Internet Information Services (IIS):

    • IIS v6 with Management Compatibility Services

  • Microsoft .NET Framework runtime:

    • Framework version 2 enabled,

    • Framework version 3.5 enabled, and

    • Framework version 4.8 enabled.

SPMS Web Server

The SPMS Web Server is a web host to the SPMS web services for SPMS applications and integrations. It provides SOAP-based web services to access the SPMS functions. SPMS web services are hosted on Microsoft IIS. Oracle recommends that the web services be secured with TLS (HTTPS). The SPMS Web Server can host any of the three SPMS web services, or a combination of the SPMS web services, or all of them altogether. The SPMS web services distributed are:

  1. OHC SPMS Transactions Service,

  2. OHC SPMS Web Services, and

  3. OHC SPMS OPI Web APIs.

Note:

You can install all the SPMS web services on the same machine or install them separately, depending on the resource availability and operational requirements.

Minimum System Specification

  • Operating System:

    • Microsoft Windows Server 2016

  • Memory:

    • 8 GB of RAM, and

    • 160 GB of disk space.

  • Oracle Database Client Version:

    • Oracle Database 32-bit Full Client for 12c including the ODAC

  • Web Browser:

    • Internet Explorer 8.0

  • Microsoft Internet Information Services (IIS):

    • IIS v6 with Management Compatibility Services

  • Microsoft .NET Framework runtime:

    • Framework version 2 enabled,

    • Framework version 3.5 enabled, and

    • Framework version 4.8 enabled.

SPMS API and Apps Server

The SPMS API & Apps Server is a web host to the Cruise Property Management System web apps and REST APIs.

Minimum System Specification

  • Operating System:

    • Microsoft Windows Server 2019

  • Memory:

    • 16 GB of RAM, and

    • 250 GB of disk space.

  • Oracle Database Client Version:

    • Oracle Database 32-bit Full Client for 12c including the ODAC

SPMS Application Clients

The SPMS Application Clients are service consumers that connect to the SPMS Database Server or SPMS Web Server to perform their intended operation.

Minimum System Specification

  • Operating System:

    • Microsoft Windows 10 Standard Edition

  • Memory:

    • 8 GB of RAM, and

    • 160 GB of disk space.

  • Oracle Database Client Version:

    • Oracle Database 32-bit Full Client for 12c including the ODAC

  • Web Browser:

    • Internet Explorer 8.0

  • Microsoft .NET Framework runtime:

    • Framework version 2 enabled,

    • Framework version 3.5 enabled, and

    • Framework version 4.8 enabled.

Recommendation for the Installed SPMS Environment

In this section, we suggest some of the possible installed SPMS environments. You are in no way limited by the examples of the installed SPMS environment shown below.

Minimal Configuration

In the configuration shown below, the SPMS Database Server and SPMS Web Server are installed on the same machine. The minimum system specification for this type of configuration will be the combination of both the SPMS Database Server and SPMS Web Server.

Figure 2-1 Minimum SPMS Configuration


This figure shows the minimum SPMS configuration

Minimum System Specification for Combined Web Server and Database Server

  • Operating System:

    • Microsoft Windows Server 2016

  • Memory:

    • 16 GB of RAM, and

    • 320 GB of disk space.

  • Oracle Database Version:

    • Oracle Database Server 12c

  • Oracle Database Client Version:

    • Oracle Database 32-bit Full Client for 12c including the ODAC

  • Web Browser:

    • Internet Explorer 8.0

  • Microsoft Internet Information Services (IIS):

    • IIS v6 with Management Compatibility Services

  • Microsoft .NET Framework runtime:

    • Framework version 2 enabled,

    • Framework version 3.5 enabled, and

    • Framework version 4.8 enabled.

Typical Configuration

In the configuration shown below, the SPMS Database Server and SPMS Web Server are installed separately on different machines. The benefit of this configuration is that there is a clear delineation where all of the database traffic will be directed to the machine hosting the SPMS Database, and all the web requests will then go to the SPMS Web Server. The minimum system specification for this configuration remains the same as recommended in SPMS Database Server, SPMS Secure Server, SPMS Web Server, and SPMS Application Clients.

Figure 2-2 Typical SPMS Configuration


This figure shows the Typical SPMS Configuration

Alternative Configuration

In the configuration shown below, the SPMS Database Server and SPMS Web Server are installed separately on different machines. Here, the SPMS Secure Server is installed on the same machine as the SPMS Database. By setting up the SPMS Secure Server and the SPMS Database on the same machine, we mirror the Database Server configuration in the older SPMS 7.0 / 7.30. In the older SPMS version, the SPMS Database Server handles all database requests and also manages the secure server responsibilities through the two SPMS Database schemas.

Figure 2-3 Alternative SPMS Configuration


This figure shows the Alternative SPMS Configuration

Minimum System Specification for Combined Secure Server and Database Server

  • Operating System:

    • Microsoft Windows Server 2016

  • Memory:

    • 8 GB of RAM, and

    • 160 GB of disk space.

  • Oracle Database Version:

    • Oracle Database Server 12c

  • Oracle Database Client Version:

    • Oracle Database 32-bit Full Client for 12c including the ODAC

  • Web Browser:

    • Internet Explorer 8.0

  • Microsoft Internet Information Services (IIS):

    • IIS v6 with Management Compatibility Services

  • Microsoft .NET Framework runtime:

    • Framework version 2 enabled,

    • Framework version 3.5 enabled, and

    • Framework version 4.8 enabled.

Installing SPMS Components

As shown in the Recommendation for the Installed SPMS Environment section, the SPMS installation consists of setting up all the components listed below.

  1. SPMS Database Server,

  2. SPMS Secure Server,

  3. SPMS Web Server, and

  4. SPMS Application Clients.

Figure 2-4 SPMS 8.0 Summarized Installation Process Flow


This figure shows the SPMS 8.0 Summarized Installation Process Flow