Smart P&ID Schema (New Workshare Collaboration Wizard) - Intergraph Smart P&ID - Configuration - Intergraph

Intergraph Smart P&ID Workshare Configuration and Reference (2019)

Language
English
Product
Intergraph Smart P&ID
Search by Category
Administration & Configuration
Smart Electrical Version
2019 (9.0)
Smart P&ID Version
9 (2019)
Smart Engineering Manager Version
10 (2019)

Allows you to enter database information for the Smart P&ID application schema at the satellite site. The tablespaces and other database information displayed in the drop-down lists are based on the information specified on the satellite plant structure creation page. An asterisk (*) means a value is required for that box.

 This page displays only when configuring a satellite for standalone Workshare.

Application to associate — Displays the application being associated to the satellite plant.

Schema type — Displays the application schema type being created.

Oracle service/alias — Specifies the Oracle net service name for the satellite plant database. This value is carried forward from the satellite plant structure definition page and appears only if using Oracle.

Database server — Displays the node name of the server on which the satellite SQL Server database resides. This option appears only if using SQL Server.

Database name — Displays the name of the SQL Server database used by the satellite plant to which the application is being associated. This option appears only if using SQL Server.

Oracle tablespace — Select the default tablespace name for your application schema. These tablespaces are defined when the database administrator created the default database instance using Oracle Database Assistant.

Oracle temp tablespace — Select the default temporary tablespace name for your application schema. 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.

  • We recommend that you do not use SYSTEM for the default tablespace because Oracle uses this tablespace for its own use. This option appears only if using Oracle.

  • 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 satellite Smart P&ID database user. This name must be unique in the database. For more information about default database user names, see Understanding Default Database User Names.

Database password — Type the password for the satellite Smart P&ID database user. We recommend using the satellite Smart P&ID user name defined above 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 plant 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.

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

  • SQL Server database passwords cannot contain the character: '