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

KunLun Mission Critical Server Oracle Database Oracle 12c R1 (RAC) Best Practice 02

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

Procedure

  1. Log in to the dbn01 node as user oracle, and run the dbca command to open the Database Configuration Assistant window.
  2. Select Create a Database, and click Next.

  3. Click Advanced configuration, and click Next.

  4. Set Database Type to Oracle Real Application Clusters (RAC) database, Configuration Type to Admin-Managed, and Template to Custom Database, and click Next.

  5. Enter the database name dbn0. If the values of ORACLE_SID set during environment variable configuration are dbn01 and dbn02, set SID Prefix to dbn0 so that the configured values of ORACLE_SID can be used to access the database to be installed.
  6. Determine whether to create a CDB and PDB.

    • To create a CDB, select Create As Container Database.
    • To create a PDB, select Create a Container Database with one or more PDBs, and set the PDB quantity and name, as shown in Figure 3-4.
    • If no PDB is required, select Create an Empty Container Database, as shown in Figure 3-5.
    • If no CDB is required, deselect Create As Container Database, as shown in Figure 3-6.
    NOTE:

    According to the official Oracle document (Doc ID 2024572.1), you are advised to set Global database name and Cluster Name (in step 8 of Installation Procedure) to different values in Oracle RAC 12c R1 or later. Set the parameters based on the customer's LLD.

    Figure 3-4 Create CDB and PDB
    Figure 3-5 Create an Empty Container Database

    Figure 3-6 Create as Container Database

  7. Click Next.
  8. Select all nodes and click Next.

  9. Select Run Cluster Verification Utility (CVU) Checks Periodically and Configure Enterprise Manager (EM) Database Express, retain the default port 5500, and click Next.

  10. Set the same password for all users, and click Next.

  11. Select a created disk group to store data and logs. Select Specify Fast Recovery Area, click Browse, select the created FRA disk group, and set Fast Recovery Area Size to the remaining space of the FRA disk group. Select Enable Archiving, and click Next.

  12. Retain the default settings and click Next.

  13. Select Custom Settings to customize the parameters. The HugePages feature is enabled before the configuration. Therefore, you need to set a small SGA size and PGA size to continue the installation, and modify the SGA size and PGA size after the installation is complete.

    NOTE:

    When you configure the SGA size and PGA size based on the values calculated in Oracle RAC Node Memory Plan, the system displays a message indicating that the memory is insufficient. In this case, you need to set a small SGA size and PGA size to continue the installation, and change the SGA size and PGA size by referring to Configuring the Database.

  14. Click the Sizing tab and set the parameters.

    NOTE:

    In this example, the maximum number of OS user processes that can be simultaneously connected to the database is set to 2000. You can change this value based on the customer's requirements.

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

  15. Click the Character Sets tab, select a proper database character set based on the service requirements, and click Next.

    NOTE:

    If the character set is incorrect, garbled characters may occur. Changing the character set is difficult after the database is created. Confirm with the customer about the character set before the installation.

  16. To avoid the "checkpoint not complete" error and performance deterioration caused by frequent log switching, adjust the redo log size to ensure that log switchover occurs every 15 to 30 minutes.

  17. Select Create Database, and click Next.
  18. View the check results.

    NOTE:

    If alarms are displayed, handle them as follows:

    • The "Single Client Access Name (SCAN)" alarm is generated when only one SCAN IP address is configured. You can ignore this alarm.
    • If the system reports other alarms, contact the database administrator before performing the installation.

  19. Select Ignore All and click Next. View the installation summary information and click Finish.

  20. The installation starts.

  21. After the Oracle RAC database is created, click Close.

Download
Updated: 2019-02-01

Document ID: EDOC1100053123

Views: 13903

Downloads: 14

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