Smart Electrical Data Dictionary (Load Plant Structure Wizard) - Intergraph Smart Engineering Manager - 12 - Help - Hexagon

Intergraph Smart Engineering Manager Help

Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Help
Smart Engineering Manager Version
12

Allows you to enter all the database and user information for Smart Electrical data dictionary. The tablespaces and other database information displayed in the drop-down lists are based on the database used in the plant structure creation. The database user name must be unique.

An asterisk (*) means a value is required for that box.

Application to associate

Displays the application being associated. This value is carried forward from the previous page.

Schema type

Displays the application schema type. This value is carried forward from the previous page.

Oracle service/alias

Specifies the Oracle Net Service name as defined by your database administrator. This value is carried forward from the plant structure definition and appears only if using Oracle.

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.

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.

  • We recommend that you do not use SYSTEM for the default tablespace because Oracle uses this tablespace for its own use.

  • 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.

Database username

Type the user name you want to use for the application data dictionary user. This value, which must be unique in the database, defaults to the plant name that you specified earlier, with the letters 'eld' appended. See Understanding Default Database User Names.

Database password

Type the password for the application data dictionary user. We recommend using the application data dictionary user name defined in the field above as this password.

Confirm password

Re-type the password for the database user.

  • 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: '