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