For a primary site, the wizard performs the basic steps required for creating a new site, including creating the server service, cache service, and configuration service, creating IIS virtual directories, and importing database dump files.
When creating a new site for an Oracle database, please note the following:
-
If you prefer to manually import one of the delivered database dump files using the Oracle Data Pump Import utility (impdp) before creating the site using Server Manager, you should use one of the .dpdmp files delivered in C:\Program Files (x86)\SPF\Database. These files must be unzipped.
-
You can use SPFADW.dpdmp when integration is required with other Hexagon products.
The IMPDP syntax is as follows:
IMPDP system/password@sid [AS SYSDBA] CONTENT=ALL DIRECTORY=directory_object REMAP_SCHEMA=source_schema:target_schema REMAP_TABLESPACE=source_tablespace:target_tablespace DUMPFILE=file_name.dpdmp LOGFILE=file_name.logFor example:
IMPDP sys/password@MyDB CONTENT=ALL DIRECTORY=DUMPS REMAP_SCHEMA=SPFADW:SPFADW REMAP_TABLESPACE=SPFADWSPACE:SPFADWSPACE DUMPFILE=SPFADW.dpdmp LOGFILE=SPFADW-Import.log
The dump file must be copied to the location on the database server defined by the
DIRECTORY parameter. Please refer to your Oracle documentation for more information
about using the IMPDP command.
-
If you import a database dump file manually, you should do so before running the site creation wizard. When you run the wizard, specify the manually imported database as the existing database for the site.
-
Oracle passwords are limited to a maximum of 30 characters.
When creating a new site for a SQL Server database, please note the following:
-
When the application server is separate from the database server and you are using a backup file to load the data schema to the database, you must share the folder in which the file is located before you run the New Site Wizard. When specifying the path to the backup file in the wizard, you must use UNC format. For example, \\SPFServer\SQLDataShare\SPF.BAK.
-
If you are using one of the delivered backup files, after you copy the file to the shared folder, you must unzip the file before you run the wizard. By default, this zip file is delivered in C:\Program Files (x86)\SPF\Database\SQL Server.
-
The delivered backup file is compatible with the version of SQL Server listed in the database server software recommendations. If any particular service pack is required, it will be listed in the software recommendations, but even if the backup file was created on a SQL Server installation with a service pack, it can be restored to a database without the service pack or with a different service pack. See SmartPlant Foundation Database Server platform recommendations for detailed software recommendations.
-
The wizard enforces a nine-character limit on site names. If you allow the wizard to automatically create user accounts for the site, the site name is used as the basis for naming the set of virtual directories, application pools, and user accounts required to support the site (for example, for a site named SiteName, its file service virtual directory, application pool, and user account are each named SiteNameFileService). Because Windows local user names cannot exceed 20 characters, the nine-character limit is enforced to ensure this Windows limit is not exceeded.
-
See Configure a new site for information about ensuring optimum performance.
-
Server Manager uses template script files for importing dump files and for creating new sites using new databases. See Database creation script files for information about modifying the template script files.
-
When a new site is created, the trace log file paths for the server, cache service, configuration service, file service, and remote services are automatically created. For more information, see Setting Up SmartPlant Foundation Logging.