Oracle template files - SmartPlant Foundation - IM Update 46 - Administration & Configuration

SmartPlant Foundation Server Manager Help

Language
English
Product
SmartPlant Foundation
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

The following script files are used for Oracle operations. The tables below list the variables for each script file.

Template_CreateTableSpaces.sql

This file is used for Oracle databases to create the Data permanent and temp databases.

If the tablespace selected by the user in the New Site Server Wizard already exists, the creation of the tablespace will not be included in the file generated from the template file.

Variable

Description

#DATA_TS#

Name of the Data permanent tablespace.

#DATA_TEMP_TS#

Name of the Data temp tablespace.

#DEFAULT_PATH#

Default path where the DBF file will be created. This value is retrieved from the Oracle database.

Template_CreateUsers.sql

This file is used for Oracle databases to create the Data users.

Variable

Description

#DATA_USER#

Name of the Data user entered.

#DATA_PWD#

Password entered for the Data user.

#DATA_TS#

Name of the Data permanent tablespace.

#DATA_TEMP_TS#

Name of the Data temp tablespace.

Template_NewSiteOracle.bat

This file is used to login into the Oracle database and execute the CreateTableSpace and CreateUsers script files. It also launches the Oracle imp.exe command to import the Data dump file.

Variable

Description

#SYS_USER#

System user name for the Oracle database. This is typically system.

#SYS_PWD#

System password for the Oracle database.

#DATASOURCE#

Oracle data source\alias of the Oracle database.

#FROM_USER_DATA#

Variable from the database user who created the Data dump file.

This variable is determined through the code. We recommend that you do not hard code this variable.

#DATA#

Name of the Data user entered.

#DATA_DUMP#

Path to the Data dump file.

#DATA_LOG#

Path to the Data log file generated importing the Data dump file. This value is generated by is the same as the dump file, with an extension of .log.

These scripts use the BUFFER parameter with the imp.exe command to set a buffer size of 3MB for transferring rows into the database. If you experience timeouts due to network performance during execution of this command, you can lower the value to shrink the buffer size so that a smaller array of rows is inserted more frequently.

Template_ImportOracle.bat

This batch file is used for importing an Oracle dump file into a database that already has the tablespaces and the users already created. Some of the information populated in this script is retrieved from the global.asa file for that site.

Variable

Description

#USER_ID#

Name of the user ID for the connection string retrieved from the global.asa file for that site.

#USER_PWD#

Password for the connection string retrieved from the global.asa file for that site.

#DATASOURCE#

Data source for the connection string retrieved from the global.asa file for that site.

#FROM_USER#

Variable from the database user who created the Oracle dump file.

This variable is determined through the code. We recommend that you do not hard code this variable.

#TO_USER#

Name of the user ID for the connection string retrieved from the global.asa file for that site.

#DUMP_FILE#

Path to the dump file.

#DUMP_LOG#

Path to the log file generated by importing the dump file. This value is generated is the same as the dump file, with an extension of .log.