Allows you to specify the database information for the satellite plant data dictionary. An asterisk (*) at the end of an item name indicates a value is required for that item.
This page displays only when configuring a satellite for standalone Workshare.
Database type
Displays the database type used at the satellite site.
Oracle service/alias
Displays the Oracle net service alias specified earlier. This option appears only if the satellite site is using Oracle.
Database server
Displays the node name of the server on which the satellite SQL Server database resides. This option appears only if SQL Server is used by the satellite site.
Database name
Displays the name of the SQL Server database where the satellite 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 satellite plant data dictionary. These tablespaces were defined when the database administrator created the default database instance using Oracle Database Assistant. This option appears only if the satellite site is using Oracle.
Oracle temp tablespace
Select the default Oracle temporary tablespace name for your satellite plant data dictionary. If this list is empty, contact your database administrator. This option appears only if the satellite site is using Oracle.
-
We recommend that you do not use SYSTEM for the default tablespace because Oracle uses this tablespace for its own uses.
-
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
ype the user name you want to use for the plant data dictionary user. This value, which must be unique in the database, defaults to satellite plant name with the letter 'd' appended. See Understanding Default Database User Names.
Database password
Type the password for the plant data dictionary user. We recommend using the satellite plant database user name, entered 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 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: '