Create the database instance - SmartPlant Foundation - IM Update 47 - Installation & Upgrade

Installation and Setup for SmartPlant Foundation Application Server

Language
English
Product
SmartPlant Foundation
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
10

Before installing the SmartPlant Foundation software on the application server, create a database instance on the database server that will be used to contain the SmartPlant Foundation application data.

Refer to your database software documentation for information on creating instances and databases.

Oracle

A single Oracle database instance must be created, which will contain one or more tablespaces for SmartPlant Foundation data. No tablespaces need to be created at this time. They can be created after the application software is installed.

SQL Server

Once the database server instance is running, no additional databases need to be created. The databases can be created after the application software is installed.

We recommend that the name of the Oracle or SQL Server instance match the name of the SmartPlant Foundation database.

  • To maintain data integrity and international compatibility, Oracle encodings should be set to the following:

    1. Database Character Set option - Use Unicode (AL32UTF8)

      See your Oracle documentation for information about changing the encodings on your existing projects to match the AL32UTF8 setting.

    2. National Character Set option - AL16UTF16 (the default)

      The Default Language (American) and Default Date Format (America) options will, of course, reflect locale-specific information.

  • The Oracle client installation does not involve any checking or modifying the Oracle client character set. After the installation, you must not change any of the default values of the NLS_LANG parameter on the client.

  • For more information about support and known issues for internationalization and localization, see Internationalization.