Creating and Working with the Database

About the Database

The Oracle database comes in three flavors:

• General purpose – General use database for mixed transactions

• 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

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).

How to Create the Oracle 10g Database

Steps

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

2. On the Oracle Database 10g 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 10g, the service name should be or10g.

   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 use 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. Choose the storage type to use for this database.

      • By default, the storage type is FS (file system).

      • ASM (Automatic Storage Management) provides support for a highly-available (RAID) solution.

        See the Oracle documentation for more information and additional user setup that you would need to perform.

        To use the ASM storage type, you need to provide additional information in four fields.

        1. Type a list of raw disks to use for ASM.

        2. Choose the type of ASM redundancy to provide.

        3. Type the name of the disk group to use for ASM.

        4. Type the password to use for ASM management.

      • RAW provides no support for file system utilities.

   5. Choose whether to manage your enterprise from a local web site or a central web site.

      If you choose to manage from a central web site, provide the URL.

      ---

      Note –

      To use centralized management, you must install the management agent on the target before you create the database. You can choose to use local management now and change to centralized management later.

      ---

   6. 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.

   7. (Optional) To enable Flash backups, type the path to the backup directory.

6. Click Run Plan (includes preflight).

Using Oracle 9i and 10g on the Same Host

Once you have installed the software and created the databases, you need to combine Oracle net services configuration to run both versions of the software on a single host. Essentially, you should combine net service names and listener information into a single listener on the host. For more information, see the Oracle documentation.