4 Installing the Agile Database on Windows

To install the Agile database on Windows:

Within the installation folder, double-click the agile9330db_oracle.exe file to start the installation on Windows. The Agile Database Configuration Utility appears.
Follow the instructions in "Creating the Agile Database on Windows" to configure the database.
Complete the postinstallation steps described in "Database Postinstallation Tasks".

4.1 Installation Notes

For best results, as you install:

Follow directions in the order in which they are given. Do not attempt to install any components out of sequence.
Oracle passwords and Agile passwords are case-sensitive. All other text entries, such as schema names and folder names, are not case-sensitive. To avoid confusion, all passwords and text entries in this guide appear in lowercase and should be typed as shown.
When prompted for a host name, type the fully qualified name for the host, not the short name. For example, if a host is named dbo, type dbo.agile.com, not dbo.

4.2 Creating the Agile Database on Windows

The Agile Database Configuration Utility creates and configures the database used by Agile. To start this utility, double-click the database installer executable file.

Drop-down lists that allow disk selection show the available disk space. If the space is a negative value, you must select another drive.

Note:

If you change a default value, you must click in the field to ensure that the change is activated.

To configure the database:

In the Destination Location dialog box of the Database Configuration Utility, accept the default location, Agile9Tmp, or click Browse to specify a destination of your choice. This is the location where template files are placed during the database installation. Throughout this document, this location is named Agile9Tmp. Click Next.
In the Oracle home dialog box, choose the appropriate ORACLE_HOME. This is the location where the Oracle software was installed. If you have multiple Oracle homes, make sure the correct Oracle home is selected in the list before continuing with the Database Configuration Utility. Click Next.

In the Oracle SID dialog box, accept the default agile9 SID. If you want to change the SID, you must use an ID that is 4 to 8 characters in length to uniquely identify the Oracle SID. If you want to use an existing SID, you must remove it before you can reuse it. Click Next.

Note:

If you only want to generate database scripts (for example, to upgrade an existing Agile schema), select the Generate database scripts only option. In this case, you should use an existing SID. Follow on-screen directions to generate scripts.

In the Database Security and Agile User Information dialog box, set the Internal/Sys password, SYSTEM password, CTXSYS password, Agile Schema Name, and Agile Schema Password. Each password must be at least 6 characters long. Click Next.
In the Database Size Estimate dialog box, choose a database sizing model. New Agile customers without an existing database to migrate should accept the default (Small). Click Next.

You can reselect a database sizing model depending on disk space available.

Note:
Refer to the Agile PLM Capacity Planning Guide for database sizing information.
In the Tablespaces dialog box, accept the default, unless you have additional hard drives with sufficient space available that allow you to distribute the files across multiple hard drives. If you change the selection to a different drive location, click the letter of the drive to make sure it is selected. Click Next.
In the Redo Log Files and Control Files dialog boxes, accept the default, unless you have additional hard drives with sufficient space available that allow you to distribute the files across multiple hard drives. Click Next.
If you accept the default location for the files on one drive, a message appears notifying you about distributing the files across multiple drives (mirroring protection). If this is not an option, click Next. Otherwise, click Back and reassign files to different hard drives.
In the Archive Log File dialog box, accept the default, unless you have additional hard drives with sufficient space available that allow you to store the file on a different hard drive. Click Next.
In the Oracle Language Support dialog box, configure the NLS_LENGTH_SEMANTICS parameter to determine data type storage allocation by the database server. The default value is CHAR. Click Next.
Accept the default character set AL32UTF8. Click Next.

Note:
For additional information about language support, refer to the Oracle Globalization Support Guide.

A Command Prompt window displays briefly.
You are prompted to install the Agile database. Click Next.

The script runs in a Command Prompt window for a while.

When instance creation is complete, a confirmatory message appears. Click OK to complete the process and exit.

Note: Oracle recommends that you change all Oracle database user passwords after you have created the Agile database. It is recommended to change these passwords periodically for security purposes:

Agile supports Full Text Search (FTS). FTS is a feature enabled through Oracle Text. Because of this feature, there is a fixed account, CTXSYS, referenced by some objects in the Agile schema. For security purposes, you can change the CTXSYS account password from its default, CTXSYS, to one of your own choice after Agile database creation and configuration.