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
Select 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
Select 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. See Create Oracle Admin Users with Limited Privileges and Create SQL Server Admin Users with Limited Privileges.
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.