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

eSight V300R009C00 Single-Node System Software Installation Guide (SUSE Linux) 09

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 Database Instances

Creating Database Instances

This topic describes how to use the DBCA (Database Configuration Assistant) to create a database instance.

Prerequisites

If a remote terminal is used for the installation, the remote terminal must provide a graphical user interface (GUI), and the SUSE Linux operating system must be configured to support remote GUI login. For details, see How to Use the VNC to Remotely Log In to SUSE Linux.

Context

An Oracle database instance is the memory structure and background process that Oracle uses to manipulate the data in the database. When enabling the Oracle database server, the Oracle database instance is used to access and manipulate the data files in the disks.

Procedure

  1. Log in to the Oracle database server as the root user.
  2. Set the environment variable.

    1. View the value of the environment variable DISPLAY.

      # echo $DISPLAY

      The following information is displayed:

      :0.0     
    2. Disable the access control.

      # xhost +

      access control disabled, clients can connect from any host
    3. Switch to the oracle user

      # su - oracle

    4. Set the value of the environment variable DISPLAY.

      > export DISPLAY=:0.0

      The value following = is the output of command echo $DISPLAY. Here :0.0 is used as an example.

    NOTE:

    If you use a graphical terminal, such as Xshell, to remotely log in to the server and perform installation, run the following command:

    > export DISPLAY=IP address of the graphical terminal:0.0

  3. Start the DBCA.

    > dbca

  4. Click Next.

  5. Select Create a Database and click Next.

  6. Select Custom Database and click Next.

  7. Type the database instance name esight in the Global Database Name and SID fields, and click Next.

  8. Clear all check boxes on the Enterprise Manager tab and Automatic Maintenance Tasks tab. Click Next.

  9. Set the passwords for database users, and click Next.

    NOTE:

    To set the passwords of all users to the same value, select Use the Same Administrative Password for All Accounts and set the user password.

    To ensure user password security, design passwords according to User Name and Password Planning that meet the complexity requirement and modify the passwords periodically.

  10. Retain the default configuration and click Next.

  11. Clear all check boxes and click Next.

  12. Retain the default configuration and click Next.

  13. Click Memory tab, select Custom, and modify memory parameters based on the physical memory size and the actual application situation.

    • If eSight and the Oracle database are installed on the same server, the recommended values for SGA Size and PGA Size are 12.5% of the memory. The maximum values for the two parameters cannot exceed 8 GB.

      If the memory is 32 GB, set SGA Size and PGA Size to 4096 MB.

    • If eSight and the Oracle database are installed on the different servers, the recommended value for Percentage is 70%.

  14. Click Sizing tab, modify device capacity parameters based on the actual application situation, for example, type 500 in the Process field.

  15. Click Character Sets tab, set character set parameters.

    1. Select Choose from the list of character sets in the Database Character Set area.
    2. Deselect Show recommended character sets only.
    3. Select AL32UTF8 - Unicode UTF-8 Universal character set from the Database Character Set drop-down list box of Choose from the list of character sets.
    4. Select UTF8 - Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant from the National Character Set drop-down list box.
    5. Select American from the Default Language drop-down list box.
    6. Select United States from the Default Territory drop-down list box.

  16. Click Connection Mode tab, and select Dedicated Server Mode. Click Next.

  17. Expand Redo Log Groups, set File Size of each group to 512 MB.

  18. Under Redo Log Groups, add three log groups and set File Size of each group to 512 MB, and click Next.

  19. Select Create Database and click Finish.

  20. Check if the required database instance configuration item is true and click OK.

  21. The system starts creating the database instance. When the database instance is created, the following window is displayed.

    NOTE:

    It takes about 15 minutes to create a database instance.

    NOTE:

    Click Password Management to change the password of the SYS and SYSTEM users.

  22. Click Exit.
Download
Updated: 2019-05-17

Document ID: EDOC1100011860

Views: 92926

Downloads: 138

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