2 Overview of SPMS Components

To set up a full SPMS 20.1 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, and

  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. You can choose to install the components all under the same machine, in each individual machine, or whichever combination you deem appropriate, depending on your operation requirements and resource availability.

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 also configured to handle database requests from multiple database clients.

Minimum System Specification

  • Operating System:

    • Microsoft Windows Server 2012 R2

  • 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.7.2 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, this is handled by one of the two database schemas. However, in SPMS 8.0, 20.1 or newer version, the database schema has been replaced by a web service hosted on a web host that handles HTTPS requests from multiple clients.

Note:

SPMS Secure Server installation files are bundled together under the SPMS Transactions Service when installing the SPMS Web Server. Therefore, installing the SPMS Transactions Service will also deploy a copy of the SPMS Secure Service.

Minimum System Specification

  • Operating System:

    • Microsoft Windows Server 2012 R2

  • 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.7.2 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 is secured with TLS (HTTPS). The SPMS Web Server can host any of the three SPMS web services, or combination of the SPMS web services, or all of them altogether. The SPMS web services distributed are:

  1. SPMS Transactions Service,

  2. SPMS Web Services, and

  3. SPMS OPI Web Services.

Note:

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

Minimum System Specification

  • Operating System:

    • Microsoft Windows Server 2012 R2

  • 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.7.2 enabled.

SPMS Application Clients

The SPMS Application Clients are service consumers that will 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.7.2 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 in below figure, 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 2012 R2

  • 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.5.1 enabled.

Typical Configuration

In the configuration illustrated in below figure, 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 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 in below figure, 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 2012 R2

  • 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.5.1 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