The following table lists the database platform pre-installation tasks that must be performed on the Simphony application and database server (or servers).
Table 2-1 Pre-Installation Tasks for Simphony Release 18.2
| Pre-Installation Task | Instructions |
|---|---|
|
Obtain the Simphony and Reporting and Analytics (R&A) software installation media and the latest patch set software (as needed) |
For instructions on attaining software, see Obtaining Installation and Patch Set Software |
|
Obtain and install a database platform on the database server (or servers) |
Simphony release 18.2 supports the following database platforms:
For Oracle Database users, create the Tablespace for the database. See After Installing Oracle Database 12c for more information about creating Tablespaces. For instructions on installing and setting up the Oracle Database, see Installing Oracle Database 12c. For instructions on installing Microsoft SQL Server, refer to the Microsoft TechNet Library. You can also install Simphony on a Microsoft SQL Server 2008 or 2012 R2 Failover Cluster. For instructions on installing a Microsoft SQL Server 2008 or 2012 R2 Failover Cluster, refer to the Microsoft TechNet Library. |
|
*For Oracle Database users only; Grant PUBLIC access for the DBMS_LOB and DBMS_SCHEDULER on the database server |
The Simphony installer requires access to execute certain Oracle database packages for which public privileges are not granted. This makes it necessary to request that temporary public access be granted for the installation to run successfully, after which the public grant can be revoked and a specific schema grant be created. Before performing a new installation, using Oracle SQL Developer, execute the following requests:
Before performing an upgrade, using Oracle SQL Developer, execute the following request:
Refer to the Oracle Database Security Guide for more information. |
|
*For Oracle Database users only; install the Oracle Database Client that matches the version of Oracle Database your database server is running |
Regardless of the Oracle Database version you are using, install or update your Oracle Database Client to match the version of Oracle Database that is installed on your database server. Oracle Database Client Installation contains more information about installing the Oracle Database Client. |
|
*For Microsoft SQL Server users only; Manually create the folders to store the Microsoft SQL Server database files |
For Simphony properties using Microsoft SQL Server, upon performing upgrades from Simphony release 2.9.2 or later, and wanting to physically separate the Transaction (MCRSPOS) and Security (MCRSCACHE) databases, manually create a database destination folder on the new database server before the upgrade. The database installation path entered in the Remote Database Location field needs to already exist on the destination database server. For example, create a |
|
Install and configure Microsoft Internet Information Services (IIS) |
Microsoft IIS needs to be installed and configured on each Simphony and Reporting and Analytics application server. Microsoft IIS is required to be installed in order to initiate the process to obtain and install secure certificates as outlined in the next step. See Installing Microsoft Internet Information Services (IIS) and Windows Communication Foundation (WCF) Features for information about configuring IIS for a Simphony system. |
|
Obtain Certificate Authority issued certificates for use with Simphony and R&A |
From within Microsoft IIS, initiate a Certificate Signing Request (CSR) to obtain and install a TLS 1.2 compliant Certificate Authority (CA) issued secure certificate on each Simphony application and R&A server. CA issued certificates are required to be installed. Self-signed certificates are not supported. For information about requesting and installing secure certificates, see Creating a Certificate Signing Request and Completing a Secure Server Certificate Installation. |
|
Configure Log File Rollover options for Internet Information Services (IIS) |
For instructions on configuring log file rollover options, refer to the Microsoft TechNet Library and search the site using: Configure Log File Rollover Options as the search phrase. |
|
Install Microsoft .NET 4.6.2 Framework |
Run the Microsoft .NET 4.6.2 Framework setup from the Simphony installation media by accessing and navigating to the: |
|
Turn on Data Execution Prevention (DEP) |
For instructions about turning on DEP on the server, refer to the Microsoft TechNet Library. |
|
Disable Anti Denial-Of-Service (DOS) Attacks |
If you are installing Simphony with Microsoft SQL Server as the database platform, add the SynAttackProtect registry key to the computer that is running Microsoft SQL Server. For instructions on disabling DOS attacks, refer to the Microsoft TechNet Library. |
|
Temporarily disable anti-virus software from the application and database servers just before the installation |
Simphony can silently fail to install due to anti-virus software. Temporarily disable or add exclusions for anti-virus software on Simphony and database servers just before installing Simphony. You can re-enable the anti-virus software after Simphony applications and databases are installed. |