Displays the database settings you can predefine for populating the corresponding values in the New Site Server and New Plant Structure wizards. Initially, the values specified during site creation populate this tab. You can modify these values for subsequent site or plant creations.
Oracle
Select this option if you are using an Oracle database. This information is carried forward from the site properties, but you can modify it for subsequent plant creations.
Oracle alias — Type the name of the Oracle net service alias used by the site in which the plant will be created.
Refresh — Click this button to update the entries in the tablespace lists if you have changed the system user name or password entries.
System user — Type a database system user name. This name does not have to be the database administrator user name, but this user must have the DBA role.
System password — Type the system password.
Oracle system passwords cannot contain any special characters other than: @ ('at' symbol), . (period), and _ (underscore).
Oracle tablespace — Select a default Oracle tablespace name for your plant database.
We recommend that you do not use SYSTEM for the default tablespace, because Oracle
uses this tablespace for its own use.
Oracle temp tablespace — Select a default Oracle temporary tablespace name for your plant database. If this list is empty, contact your database administrator.
SQL Server
Select this option if you are using a SQL Server database. This information is carried forward from the site properties, but you can modify it for subsequent plant creations.
Server — Type the node name of the server on which the SQL Server database resides.
Refresh — Click this button to update the database information if you have changed the system user name or password entries.
System user — Type a database system user name. This name does not have to be the database administrator user name, but this user must have minimum DBA privileges to be able to perform Smart Engineering Manager procedures. For details, see:
Database user names cannot contain any of the following characters: ~ ` ! % ^ & * ( ) - + = { } [ ] \ / ; : ‘ " < > , . ? | For a SQL Server database, the period (.) is not allowed.
System password — Type the system password.
SQL Server database passwords cannot contain the character: '. Other special characters are allowed for system passwords.