No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FusionCube DB 3.1 Database Best Practice 03 (Oracle RAC 11g R2)

Rate and give feedback :
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Creating an Oracle RAC Database

Creating an Oracle RAC Database

Use DBCA to create an Oracle RAC database.

Procedure

  1. Open Xstart, log in as user oracle, and run the dbca command.
  2. The DBCA GUI is displayed.
  3. Select Oracle Real Application Clusters (RAC) database, and click Next.

    Figure 4-46 DBCA

  4. Select Create a Database, and click Next.

    Figure 4-47 DBCA

  5. Select a database template. Although you are advised to select General Purpose or Transaction Processing, you can also select Custom Database (which allows you to customize parameters, such as the block size). This step uses Custom Database as an example. Then click Next.

    Figure 4-48 DBCA

  6. Set Configuration Type to Admin-Managed, set Global Database Name (for example, to dbn), set SID Prefix (for example, to dbn0), select all nodes, and click Next. The value of Global Database Name must be the same as the value of ORACLE_UNQNAME set in Configuring Environment Variables. If the values of Oracle_SID are dbn01 and dbn02 in Configuring Environment Variables, set SID Prefix to dbn0 so that the configured values of ORACLE_SID can be used to access and use the database to be installed.

    Figure 4-49 DBCA

  7. Select Configure Enterprise Manager and Configure Database Control for local management, retain the default settings, and click Next.

    Figure 4-50 DBCA

  8. Select Use the Same Administrative Password for All Accounts, set the password, and click Next.

    Figure 4-51 DBCA

  9. Set Storage Type to Automatic Storage Management (ASM), select Use Oracle-Managed Files, set Database Area to the DATA disk group that is created in the preceding section, and click Next.

    Figure 4-52 DBCA

  10. Enter the password set in step 8, and click OK.

    Figure 4-53 DBCA

  11. Select Specify Fast Recovery Area, set Fast Recovery Area to the FRA disk group that is created in the preceding section, and set Fast Recovery Ares Size according to the size of the created FRA partition. The size cannot exceed the total available capacity of the partition. (In the test environment, you do not need to select Enable Archiving. However, in the production environment, you need to select Enable Archiving because data needs to be backed up.) Then click Next.

    Figure 4-54 DBCA

  12. Retain the default settings. and click Next.

    Figure 4-55 DBCA

  13. On the Memory tab, select Custom, and set SGA Size and PGA Size according to the values calculated.

    Figure 4-56 DBCA

  14. Switch to the Sizing tab and set parameters. If the service model is OLTP, the default value of Block Size is 8 KB. If the service model is OLAP, the default value of Block Size is 32 KB. The default value of Processes is 2000 for a FusionCube database system. You can change the value as required.

    Figure 4-57 DBCA

  15. Switch to the Character Sets tab, select a proper database character set based on service requirements, and click Next. If the character set is incorrectly set, garbled characters may occur. In addition, it is difficult to adjust the character set after such problems occur. Confirm with the customer about the character set configuration before the installation.

    Figure 4-58 DBCA

  16. Click Next.

    Figure 4-59 DBCA

  17. Confirm the default database storage information, and click Next.

    Figure 4-60 DBCA

  18. To prevent the "checkpoint not complete" error from occurring and database performance from being affected by frequent log switches, adjust the redo log size to ensure that log switches occur every 15 to 30 minutes.

    Click Finish to start database creation.

    Figure 4-61 DBCA

    Click OK.

    Figure 4-62 DBCA

  19. Wait patiently. Database creation may take a long period of time.

    Figure 4-63 DBCA

  20. Click Exit.

    Figure 4-64 DBCA

  21. The Oracle RAC database creation is complete.
Translation
Download
Updated: 2018-12-26

Document ID: EDOC1100035759

Views: 24960

Downloads: 35

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next