How to Create the Oracle 9i Database

Steps

1. In the Common Tasks section of the N1 Grid SPS browser interface, select Oracle Database 9i.

2. On the Oracle Database 9i Common Tasks page, click Create.

3. On the Plans Details page, click Run.

4. On the Plan Details Run page, select the target host on which you want to create the database.

5. On the Plan Details Run page, provide plan variables information.

   1. Change the name of the Oracle Service, if needed.

      For Oracle 9i, the service name should be or9i.

   2. To make this service the default service, click the checkbox.

   3. Type the name of the database template to apply to this database.

      By default, the database template is General_Purpose. This template implies that the database will be used for a mixture of transaction types. The other possible templates are:

      • Data_Warehouse – Database optimized for responding to long-running and “ad hoc” queries

      • Transaction_Processing – Transaction-oriented database intended for handling many short transactions and canned queries

   4. If needed, change the character set to use for the database.

      By default, the character set is Western European (ISO 8859). For more information about character sets in Oracle, see the Oracle documentation.

6. Click Run Plan (includes preflight).