Create an Oracle database - SmartPlant Foundation - IM Update 42 - Installation & Upgrade

1. If you are using an existing Oracle database, skip to step 5. Otherwise, type, or browse to, the Location of the scripts to create tables to specify the scripts used to create the tables.

   This script is the default script installed with Server Manager.

   

   • An example of the default script to create tables for an Oracle site can be found at: [product installation location]\ SPFServerManager\DatabaseScripts\Template_SPLMDbaseTablesOracle.sql

   • If you specify a different path than the default path in Location of the scripts to create tables, after you set up the license site, Server Manager will remember that path next time you open the wizard. If the path you specified does not exist next time you open the wizard, the path is reset to the default.

   • If you are using an existing Oracle database, this option and the boxes for the Oracle tablespace and temp tablespace are disabled.

2. If you want to save the script path for future operations, select the Save as default option.

3. Select the Oracle tablespace from the list of valid tablespaces, or type the name of the tablespace.

   

   • By default, the name of the new tablespace created appears in the list as the name of the site with a suffix of _Data.

   • The name of the temp tablespace created appears in the list as the name of the site with a suffix of _DataTemp.

4. Select an Oracle temp tablespace, or type the name of the temp tablespace.

   The name of the temp tablespace to be created appears in the list as the name of the site with a suffix of _DataTemp.

5. In the Database username box, type the name of the Oracle user who owns the objects in the Data database schema.

6. Type and then confirm the Database password for the Oracle database user.

   Oracle passwords are limited to a maximum of 30 characters.

7. Click Next to display the Ready to Create License Server page. Review the new server parameters, and click Back to make any changes.

8. Click Next. The Server Creation Status appears as the site is created, and then the After License Server Creation page appears.

9. Read the information about the additional steps required to fully configure the new server, and then click Finish to create the server. The new server appears in the tree view.

   For more information about fully configuring the server, see Configure the license server for performance.

At the end of the process the wizard adds a new entry to each selected site's SPFAppServer.config file, which allows the user to direct each site to a license server. For example:

<add key="LicenseServerURL" value=http://localhost/SPFLicenseServer />