3 Performing a Secure Shipboard Property Management System Installation

This chapter presents planning information for the Shipboard Property Management System installation.

For information about installing the Shipboard Property Management System, see the SPMS 20.1 Installation Guide, available at the Oracle Help Center.

Pre-Installation Configuration

Before installing the Shipboard Property Management System, the following tasks must be performed:

  • Apply critical security patches to the operating system.

  • Apply critical security patches to the database server application.

  • Create the required Oracle Database objects per the instructions in the SPMS 20.1 Installation Guide available at Oracle Help Center.

  • Acquire the Secure Sockets Layer (SSL) compliant security certificate from the Certification Authority.

Shipboard Property Management System Installation

You can perform a custom or a typical installation of the Shipboard Property Management System. Perform a custom installation to avoid installing options and products you do not need. If you choose to perform a typical installation, remove or disable features that you do not need after the installation.

The installation requires the user running the installation to have an Administrator privilege assigned. Users without the required access might complete the installation but it may not be successful.

When creating a database, enter a complex password that adheres to the database hardening guidelines for all users.

Before you begin, ensure these features are turned on and the required files are available.

  • For a Microsoft Windows 10 user, ensure the Microsoft .NET Framework 4.7 is turned on in Window Features before installing the Oracle Full Client and OHC_SPMS_V20.1SETUP.exe.

  • Download the OHC_SPMS_V20.1SETUP.exe from the Oracle Software Delivery Cloud.

Web Services Installation

This section describes the steps to install the OHC Web Services and other required Microsoft Windows components.

Installing WebServices

See section Webservice Installation in SPMS 20.1 Installation Guide for steps to complete the installation.

Establishing a Connection

Web Service Connection

For Simphony users:

  • Ensure the Simphony Extensibility DLL version is the same as SPMS.

  • Go to Simphony Properties Enterprise and choose the option “Fidelio Web Server Address”, and then change the SPMS web service to http://<ip address>/OHCTransactionsSevices/OHCTransactionsServices.asmx

Web Service Database Connection

If the database server name is not defaulted to “Fidelio”, edit the ‘web.config’ file in C:\inetpub\wwwroot\OHCTransactionsService and to define the SPMS database server name under <appSetting>.

<appSettings>
          <add key="Server" value="<SERVER NAME>" />
        </appSettings>

WebService File Path Configuration for Simphony

  1. Edit the ‘web.config’ file in C:\inetpub\wwwroot\OHCTransactionsService and change the file path name where the mi_exp.txt, employee.txt, rvc.txt, and AL Product Classes.txt files will be saved.

  2. Change the --Path-- according to the path you created in the c:\temp\folder. The path can be the ship name or ship code and it is user-definable.

Figure 3-1 Simphony File Path


This figure shows the file path configuration for Simphony WebServices.

WebService Configuration for OPI

Edit the ‘web.config’ file in C:\inetpub\OHCOPIWebServices and to define the SPMS database server name (SOURCE) and password (PASSWORD) under <connectionStrings>.

<connectionStrings>
    <add name="OHCEntities" connectionString="metadata=<a target="_blank" href="res://*/OHCModel.csdl|res://*/OHCModel.ssdl|res://*/OHCModel.msl;provider=Oracle.ManagedDataAccess.Client;provider">res://*/OHCModel.csdl|res://*/OHCModel.ssdl|res://*/OHCModel.msl;provider=Oracle.ManagedDataAccess.Client;provider</a> connection string=&quot;DATA SOURCE=[SOURCE];PASSWORD=[PASSWORD];PERSIST SECURITY INFO=True;USER ID=<USER ID>&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

If Wallet is applied,

<connectionStrings>
    <add name="OHCEntities" connectionString="metadata=<a target="_blank" href="res://*/OHCModel.csdl|res://*/OHCModel.ssdl|res://*/OHCModel.msl;provider=Oracle.ManagedDataAccess.Client;provider">res://*/OHCModel.csdl|res://*/OHCModel.ssdl|res://*/OHCModel.msl;provider=Oracle.ManagedDataAccess.Client;provider</a> connection string=&quot;DATA SOURCE=<IP Address>:<Port No>/<Service Name>;PASSWORD=[PASSWORD];PERSIST SECURITY INFO=True;USER ID=<User ID>&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>