Defines the Smart Electrical schema database information for your Smart Electrical plant structure.
-
This screen is only displayed if an application was associated to the plant structure selected previously in the Applications to associate page of the wizard.
-
An asterisk (*) at the end of an item name indicates a value is required for that item.
Oracle service/alias
Displays the Oracle Net Service alias specified previously in which the plant will be created. This option appears only if Oracle is selected as the database type.
Database node
Displays the Node Name of the server on which the SQL Server database resides. This option appears only if SQL Server is selected as the database type.
Database name
Displays the name of the SQL Server database in which the plant will be created. This option appears only if SQL Server is selected as the database type.
Oracle tablespace
Select the default Oracle tablespace name for your plant database. These tablespaces were defined when the database administrator created the default database instance using Oracle Database Assistant. This option appears only if Oracle is selected as the database type.
-
We recommend that you do not use SYSTEM for the default tablespace because Oracle uses this tablespace for its own uses.
-
If you create new Oracle tablespaces or SQL Server databases after starting this wizard, you must refresh the tablespace list by selecting Back and then selecting Next to return to this page before the new information will display in the appropriate lists.
Oracle temp tablespace
Select the default Oracle temporary tablespace name for your plant database. If this list is empty, contact your database administrator. This option appears only if Oracle is selected as the database type on the previous page.
Database username
Type the user name you want to use for the Smart Electrical schema user. This value, which must be unique in the database, defaults to the plant name that you specified earlier, with the letters "el" appended. See Understanding Default Database User Names.
Database password
Displays the default database password, as set by the database software. You can change the password for the Smart Electrical database user by typing a new password in the Database password field. We recommend using the default Smart Electrical user name defined above as this password.
Confirm password
Re-type the password for the database user.
Smart Electrical reference data path
Taken from the Plant structure path as set previously in the Target Paths screen of the wizard. To select a different path, type the required path or click the ellipsis button to browse to the reference data path for the application options. This field is limited to 255 characters. Specify a reference data path outside the plant structure path to avoid duplicate sets of reference data and longer process times when saving or backing up your plant and also to avoid deleting the reference data if you delete the plant. For example, if the Plant structure path is \\siteserver\sitename\plantname, do not set the Smart Electrical reference data path to \\siteserver\sitename\plantname\refdata.
-
When loading a plant structure, the software checks the reference data folder structure and, if necessary, creates additional folder levels to ensure that all files with the same names are located in unique folder paths.
-
The software sets the related password defaults for the above user name automatically to <default user name> for Oracle and to <default user name> + '1' for SQL Server. In the case of SQL Server running on Windows Server, if you are using SQL Server authentication, you can specify that SQL Server is to use the password validation rules that are used by Windows Server.
-
Database usernames cannot start with a numeric digit and cannot contain any of the following characters: ~ ` ! % ^ & * ( ) - + = { } [ ] \ / ; : ‘ " < > , . ? |
-
Oracle database user names are limited to 30 characters. Because these are derived from plant names that can be up to 64 characters long, the software truncates any excess characters to the maximum allowed in creating the default database user names.
-
Oracle database passwords cannot contain the characters: " ' @. SQL Server database passwords cannot contain the character: '