Oracle
This section describes how to configure storage resources for Oracle.
Prerequisites
The system has sufficient storage space.
Procedure
- Log in to DeviceManager.
- Choose
Provisioning >
Application >
Oracle.
- Click Create.
The Create Oracle Storage Resource Wizard is displayed.
- Set basic information about the Oracle instance to be created.
Table 6-16 describes related parameters.
Table 6-16 Parameters of an Oracle instanceParameter
Description
Value
Name
Name of an Oracle instance.
The name:
- Must be unique.
- Can contain only letters, digits, underscores (_), periods (.), and hyphens (-).
- Must contain 1 to 22 characters.
[Example]
OracleApp_001
Description
Description of an Oracle instance. Description can be left blank or contain up to 255 characters.
[Example]
-
- Click Next and set the Oracle application parameters.
Table 6-17 describes related parameters.
Table 6-17 Oracle application parametersParameter
Description
Value
Service Type
Type of an Oracle application. The possible values are described as follows:
- OLTP: Online transaction processing (OLTP) is a main application of traditional relational databases. It is used for processing basic and ordinary transactions, such as bank transaction.
- OLAP: Online analytical processing (OLAP) is a technology that uses multidimensional structures to provide rapid accesses to data for analysis. This application mainly applies to data warehouse systems, such as dynamic reporting systems.
[Example]
OLTP
Service Scale
Storage space required by Oracle services.
[Example]
40 GB
- (Optional) Set advanced properties for an Oracle application.
- Click Advanced.
The Advanced dialog box is displayed.
- Set advanced properties for an Oracle application.
Table 6-18 describes related parameters.
Table 6-18 Parameters in advanced properties of an Oracle applicationParameter
Description
Value
Enable log archiving
After this option is selected, the system will allocate storage resources to Oracle applications to archive data and logs.
[Example]
Enable log archiving
Log Amount per Day (GB)
Maximum volume of storage space used to store logs per day. This parameter is available after Enable log archiving is selected.
[Example]
3
Log Retention Period (days)
Retention period of system logs. After this period expires, logs are not stored. This parameter is available after Enable log archiving is selected.
[Example]
8
Enable SmartThin
After this option is selected, the system creates thin LUNs. A thin LUN is allocated an initial capacity (30% of the total capacity) when created and is dynamically allocated required storage resources when its available capacity is insufficient.
[Example]
Enable SmartThin
Reserve snapshot space
After this option is selected, the system automatically selects a storage pool whose capacity is 130% of the required capacity. When you use the storage pool to create storage resources for applications, reserve sufficient space to create snapshots for applications.
[Example]
Reserve snapshot space
Flashback
After this option is selected, Oracle supports flashback deletion, which means a cancel button is added for a table and its related objects. After this function is enabled, the system will enable the log archiving function accordingly.
[Example]
Enable deselected
Use RAC
After this option is selected, Oracle provides cluster software and storage management software, reducing application costs. When applications scale up, users can expand the system on demand to ensure system performance. If this option is not selected, the system will not allocate LUNs to store cluster logs.
[Example]
Use RAC
- Click OK.
You are returned to the Set Oracle Database Parameters page.
- Click Advanced.
- Click Next and set storage resource parameters for Oracle.
The system will allocate optimal storage resources based on preset Oracle parameters.
Table 6-19 describes storage resource parameters.
Table 6-19 Oracle storage resource parametersParameter
Description
Value
LUN Capacity
LUN storage space allocated to store data, logs, or archives.
[Example]
60 GB
LUN Quantity
Number of LUNs allocated to store data, logs, or archives.
[Example]
1
Storage Pool Policy
The system sets storage pool allocation policies based on preset Oracle parameters. The value can be High performance, Performance/Cost balance, Low cost, or Manual selection. The four values are described as follows:
- High performance: The system automatically selects a RAID 6 storage pool containing SAS disks only. If such a storage pool does not exist in the system, create one.
- Performance/Cost balance: The system automatically selects a RAID 6 storage pool containing SAS and NL-SAS disks only. If such a storage pool does not exist in the system, create one.
- Low cost: The system automatically selects a RAID 6 storage pool containing NL-SAS disks only. If such a storage pool does not exist in the system, create one.
- Manual selection: Users define storage pools that meet the Oracle service requirements.
[Example]
Manual selection
Selected Storage Pool
Name of the storage pool automatically allocated by the system to an Oracle instance.
[Example]
StoragePool001
- (Optional) If the desired storage pool type does not exist or is unavailable, click
and modify Storage Pool Policy in the dialog box that is displayed, or click Create Storage Pool to create one.
Table 6-19 describes related parameters.
- (Optional) Select a host to which you want to map the instance.
- If a mapped host is selected, the system automatically creates a LUN group, a host group, and a mapping view, and adds the LUN group and host group to the mapping view.
- If no mapped host is selected, the system automatically creates a LUN group only. You need to manually create a host group and a mapping view for a mapped host and add the host to the mapping view. After being added to the mapping view, the host can access storage resources.
The LUN group must contain all LUNs in the application instance.
- Click Next.
The Select Mapping Hosts page is displayed.
- In the Available Hosts list, select the host that is used to access storage resources.
- Click
to add the host to Selected Hosts.
- Confirm your settings.
- Click Next.
The summary page is displayed.
- Verify that the information about the Oracle instance to be created is correct and click Finish.
The Execution Result dialog box is displayed, indicating that the operation succeeded.
- Click Close.
- Click Next.