Use the Oracle application creation feature in ONTAP 9.2 to set up the application with 2 instances of the database, provision the set of volumes needed for its storage and place them on aggregates and nodes that can safely meet the capacity and IOPS requirements of the workload, provision QoS policies to ensure continued compliance with those requirements, and identify the hosts that will access the objects.
An Oracle RAC application can be created for use over NFS in OnCommand System Manager using the following steps:
1. Select the SVM.
2. Click the Applications tab in the menu bar.
3. Click Add Application.
4. In the “Add Oracle Instance” page, specify the following properties of the application:
The name of the database.
The Oracle cluster name, also used to construct object names.
The names of each of the 2 database instances and their SIDs. The names will be used as the next part of the names of objects mentioned above for each database.
The datafile storage service level and size. This describes the size of the database and its desired performance characteristics, in terms of one of the storage service levels offered by the system, such as Extreme, Performance and Value.
Properties of the redo log, similar to the datafile mentioned above.
Enable or disable redo log mirroring.
Select if Grid Binaries and CRS/Voting volumes should be provisioned.
5. Select SAN as the protocol used to access the application.
6. Select the host operating system that will access the application.
7. The name of the initiator group and initiator ids that will access each of the two database instances of the application.
8. Use System Manager to view the details of the Oracle RAC application.