Servigistics InService Deployment > Using the Servigistics InService Installer > Entering Your Database Information
  
Entering Your Database Information
When you use a previously installed Oracle or SQL database, you reference existing user names and passwords. Oracle provides persistent data storage.
Configuring your database is a two-step process; in the first step you select the database to use, either a new one or an existing one, and in the second step you configure that database for your environment.
Selecting the Database to Use
Use the following to select or create a database to use, You can select Oracle or SQL Server.
For Oracle
Option
Options
Description
Database Software
Oracle
Use the drop-down list to select the type of database software to be used.
Database Configuration
For Windows:
• Create a new database and user
• Create a new user on an existing database
• Configure to an existing user on an existing database
For Linux:
• Create a new user on an existing database
• Configure to an existing user on an existing database
Select whether or not to use an existing database, or allow the installation process to create a new one.
By default the installer is configured to create a new database and new user. This option is only available for Windows.
If you select the Create a new database and user option you are then prompted to specify an installation location in the Oracle Server Installation Directory (ORACLE_HOME) parameter.
Create database schema and load base data
Selecting this option creates the database schema that defines the tables, columns and relationships between fields and tables. This option is selected by default to allow base data to be loaded.
* 
When selected, and if you are adding an additional product to an existing installation, and that product has its own schema you are asked to provide a database installation user name and password.
For SQL
Option
Options
Description
Database Software
SQL
Use the drop-down list to select the type of database software to be used.
Database Configuration
For Windows:
• Create a new database and user
• Create a new user on an existing database
• Configure to an existing user on an existing database
For Linux:
• Create a new user on an existing database
• Configure to an existing user on an existing database
Select whether or not to use an existing database, or allow the installation process to create a new one.
By default the installer is configured to create a new database and new user. This option is only available for Windows.
If you select the Create a new database and user you are prompted to enter locations for the SQL Server Installation Directory and SQL Server Client Installation Directory parameters.
* 
There is a required command that needs to be run after creating the database and before using it. See InService Requirements for the SQL Database for more information.
Create database schema and load base data
Selecting this option creates the database schema that defines the tables, columns and relationships between fields and tables. This option is selected by default to allow base data to be loaded.
* 
When selected, and if you are adding an additional product to an existing installation, and that product has its own schema you are asked to provide a database installation user name and password.
Configuring Your Oracle Database
Enter your database information.
Option
Default
Description
*Oracle DNS Registered Host Name:
<hostName>.<domain>
Defines the fully qualified machine name of the Oracle server.
*Database Listener Port Number:
1521
Defines the port number the Oracle server listens on.
*Global Database Name (SID) or Service Name:
wind
Defines the Oracle Database System Identifier name to be given to the database when it is created. The number cannot exceed 8 aphanumeric characters, and must not begin with a numeric digit. For existing databases the database ServiceName must be used.
‘SYSTEM’ Account Password:
If creating a database supply a password to be used for the database as an administrative user (SYSTEM, SYS).
For existing databases, use the valid SYSTEM account password that can be used to connect to the database with administrative privileges.
Prefix for Generated Credentials
If checked, the prefix specified is propagated to each database user name. Typically this is only used in test or non-production systems.
Database Account Credentials
Enter the database user accounts that will be created with the provided password. For existing users the credentials will be validated using the provided user name and password.
Configuring Your SQL Database
Enter your database information.
Option
Default
Description
*SQL Server DNS Registered Host Name
<hostName>.<domain>
Defines the fully qualified machine name of the SQL server.
*TCP Port Number for SQL Server Instance
1433
Defines the port number the SQL server listens on Client Installation Directory.
Installed SQL server Instance Name (Named Instance Only)
SQL server Database Name
Defines the SQL Database System Identifier name to be given to the database when it is created. The number cannot exceed 8 aphanumeric characters, and must not begin with a numeric digit. For existing databases the database ServiceName must be used.
Prefix for Generated Credentials
If checked, the prefix specified is propagated to each database user name. Typically this is only used in test or non-production systems.
Database Account Credentials
Enter the database user accounts that will be created with the provided password. For existing users the credentials will be validated using the provided user name and password.