Defines the database for the plant schema for your new plant structure. An asterisk (*) at the end of an item name indicates a value is required for that item.
Database type
Displays the database type used by the site in which the plant will be created.
Oracle service/alias
Displays the Oracle Net Service alias specified previously in which the plant will be created. 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
Select a database from the list to use for the plant schemas. This option appears only if SQL Server is selected as the database type.
Oracle tablespace
Select the default Oracle tablespace name for your plant database. These tablespaces were defined when the database administrator created the default database instance using Oracle Database Assistant. This option appears only if Oracle is selected as the database type.
Oracle temp tablespace
Select the default Oracle temporary tablespace name for your plant database. 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 selecting Back and then selecting 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 plant user. This value, which must be unique in the database, defaults to the plant name. Database usernames cannot start with a numeric digit and cannot contain any of the following characters: ~ ` ! % ^ & * ( ) - + = { } [ ] \ / ; : ‘ " < > , . ? |. See Understanding Default Database User Names.
Database password
Type the password for the database user. We recommend using the plant database user name as this password.
Confirm password
Re-type the password for the database user. Oracle database passwords cannot contain the characters: " ' @ and SQL Server database passwords cannot contain the character: '