Data Dictionary (New Site Server Wizard) - Intergraph Smart Engineering Manager - Installation & Upgrade - Intergraph

Intergraph SmartPlant Engineering Manager Installation and Upgrade

Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
Smart Electrical Version
2015 R1 (7.1)
Smart Instrumentation Version
(none)
Smart P&ID Version
7.1 (2014 R1)
Smart Engineering Manager Version
7.2 (2014 R2)

Allows you to specify the user name and password for the site data dictionary. The data dictionary contains database tables, database table attributes, item types, select list definitions, and select list entries.

The site schema and site data dictionary schema reside in the same (Oracle) service or (SQL) server. However, the site schema and the site data dictionary can be in different tablespaces.

Database type — Displays the database type used for this site. This value is carried forward from the previous page.

Oracle service/alias — Displays the Oracle net service alias as defined by your database administrator. This value is carried forward from the previous page. This option appears only if Oracle is selected as the database type.

Database server — 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 defined by your database administrator. This option appears only if SQL Server is selected as the database type.

Oracle tablespace — Select the default Oracle tablespace name for your site database. These tablespaces were defined when the database administrator created the default database instance. This option appears only if Oracle is selected as the database type on the previous page.

Oracle temp tablespace — Select the default Oracle temporary tablespace name for your site database. The temporary tablespace was defined when the database administrator created the temporary database instance using Oracle Database Assistant. 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 clicking Back and then clicking 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 site data dictionary user. This value, which must be unique in the database, defaults to the site name that you specified earlier, with the letter "d" appended. For more information about default database user names, see Understanding Default Database User Names.

Database password — Type the password for the site data dictionary user. We recommend using this database user name as this password.

Confirm password — Re-type the password.

  • 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 site names can be up to 64 characters long, the software truncates the characters to the maximum allowed by Oracle in creating the default database user names.

  • The software removes all spaces or special characters in a site name before using that name to create a default database user name.

  • Oracle database passwords cannot contain the characters: " ' @

  • SQL Server database passwords cannot contain the character: '

See Also

New Site Server Wizard
Paths (New Site Server Wizard)
Change the Database Passwords for the Site (see )