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 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 plant user. This value, which must be unique in the database, defaults to the plant name. For more information about default database user names, see Understanding Default Database User Names.
Database usernames cannot start with a numeric digit and cannot contain any of the
following characters: ~ ` ! % ^ & * ( ) - + = { } [ ] \ / ; : ‘ " < > , . ? |
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: '