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
In the Common Tasks section of the N1 Grid SPS browser interface, select Oracle Database 9i.
On the Oracle Database 9i Common Tasks page, click Create.
On the Plans Details page, click Run.
On the Plan Details Run page, select the target host on which you want to create the database.
On the Plan Details Run page, provide plan variables information.
Change the name of the Oracle Service, if needed.
For Oracle 9i, the service name should be or9i.
To make this service the default service, click the checkbox.
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
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.
Click Run Plan (includes preflight).
In the Common Tasks section of the N1 Grid SPS browser interface, select Oracle Database 10g.
On the Oracle Database 10g Common Tasks page, click Create.
On the Plans Details page, click Run.
On the Plan Details Run page, select the target host on which you want to create the database.
On the Plan Details Run page, provide plan variables information.
Change the name of the Oracle Service, if needed.
For Oracle 10g, the service name should be or10g.
To make this service the default service, click the checkbox.
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
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.
RAW provides no support for file system utilities.
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.
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.
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.
(Optional) To enable Flash backups, type the path to the backup directory.
Click Run Plan (includes preflight).
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.