Enables you to set parameters for the target Smart Instrumentation database and start the database setup process. Setting the database parameters is the second step in the Smart Instrumentation database setup process on Oracle that you run using the DB Setup Utility.
The New Database Definitions dialog box changes depending on the tablespaces creation
option you select.
Administration schema
The options in this section are used to define the Admin schema name and password. For more information about the Admin schema and other Smart Instrumentation database schemas, see Smart Instrumentation Configuration and Maintenance Guide, Smart Instrumentation Database Technical Review > Logon Data and Database Connection Security > Smart Instrumentation Database Schemas.
Administration schema login name — Accept the default Admin schema logon name IN_DBAMN or enter another name if you need. The logon name must be unique in the Oracle server. The logon name can only start with a letter and contain no spaces. You can use an underscore ( _ ) to replace a space.
Administration schema login password — Accept the default Admin schema logon password IN_DBAMN or enter another password if you need. The logon password can only start with a letter and contain no spaces. You can use an underscore ( _ ) to replace a space.
Estimated number of domains - Displays the number of domains.
Tablespaces
Automatic - The tablespaces for the administration and domain or domains are created automatically.
Customized - The user is able to configure the tablespace name, data file name and path, and the tablespace size of the Admin schema data, Admin schema indexes, and Temporary tablespaces. The tablespaces for the domain or domains are created automatically.
Predefined - The user predefines a list of tablespaces as wished. The user, then, selects the Admin schema data, Admin schema indexes, and Temporary tablespaces names. Next comes the configuration of the tablespace name, data file name and path, and the tablespace size. The user has then to configure the tablespaces for the Domain or Domains.
Create - Starts the database creation process, at the end of which you can create the Oracle ORASETUP.LOG script file if needed.
Administration schema data
This box appears when the user selects the Customized or the Predefined options.
Tablespace name — When working in Customized mode accept the default Admin data tablespace name or enter another name if you need . When working in Predefined mode, use the combo box to select a tablespace.
Datafile name and path — When working in Customized mode, accept the default path and name of the Admin datafile. You can specify another path and name if you need. The default file extension is .ddti. You can change the file extension as you require.
When working in Predefined mode this option not available.
Tablespace size (MB) — When working in Customized mode, accept the default Admin data tablespace size (15MB) if you want to create four Smart Instrumentation domains only. If you want to create more than four domains, you need to specify a larger tablespace size.
When working in Predefined mode this option not available.
Administration schema indexes
This box appears when the user selects the Customized or the Predefined options.
Tablespace name — When working in Customized mode, accept the default value or type the required Admin index tablespace name. When working in Predefined mode, use the combo box to select a tablespace.
Datafile name and path — When working in Customized mode, accept the default path and name of the Admin index datafile or type the required path and name. The default file extension is .ddti. You can change the file extension as you require.
When working in Predefined mode this option not available.
Tablespace size (MB) — When working in Customized mode, accept the default Admin index data tablespace size (5MB) if you want to create four Smart Instrumentation domains only. If you want to create more than four domains, you need to specify a larger tablespace size.
When working in Predefined mode this option not available.
Temporary Tablespaces
This box appears when the user selects the Customized or the Predefined options.
Tablespace name — When working in Customized mode, accept the default value or type the required Admin index tablespace name. When working in Predefined mode, use the combo box to select a tablespace.
Datafile name and path — When working in Customized mode, accept the default path and name of the Admin index datafile or type the required path and name. The default file extension is .ddti. You can change the file extension as you require.
When working in Predefined mode this option not available.
Tablespace size (MB) — When working in Customized mode, accept the default Admin index data tablespace size (75MB) if you want to create four Smart Instrumentation domains only. If you want to create more than four domains, you need to specify a larger tablespace size.
When working in Predefined mode this option not available.