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 V300R010C00SPC200, 300, and 500 Local HA System Software Installation Guide (SUSE Linux + Oracle + Veritas) 10

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).
(Optional) Modifying Running Parameters of the Oracle Database

(Optional) Modifying Running Parameters of the Oracle Database

You can execute the Oracle configuration script to optimize the database running memory and enable the scheduled task for clearing the database audit logs.

Prerequisites

You have obtained the eSight installation package from the Oracle server.

Context

The Oracle logs are not deleted for a long time. As a result, the disk space usage is high or the disk space is used up, leading to unavailability of eSight. You can manually execute the script in the eSight installation package to perform optimization as follows:

  • Set the Oracle running memory to one fourth of the total memory of the server.
  • Keep database audit logs for one week.

Deleted logs cannot be restored. Excise caution when executing the script.

Procedure

In the Veritas HA system, perform the following operations only on the active server.

  1. Log in to the server as the ossuser user.
  2. Switch to the root user.

    > su - root

  3. Start the Oracle.

    1. Run the following command to start the Oracle.

      # hares -online Oracle -sys $(hostname)

    2. Check the status of the Oracle.

      # hares -state Oracle -sys $(hostname)

      If the following information is displayed, the Oracle start successfully.

      ONLINE

  4. Copy the script from the eSight installation directory to the Oracle home directory. Here, the installation directory /opt/eSight is used as an example.

    # cp -rpf /opt/eSight/AppBase/uninstall/scripts/cleanScripts/oracle/set_log_clean.sh ~oracle

  5. Set the owner and group of the script.

    # cd ~oracle

    # chown oracle:dba set_log_clean.sh

  6. Switch to the oracle user and execute the script.

    # su - oracle

    > sh ./set_log_clean.sh

  7. Restart the Oracle.

    1. Switch to the root user.

      > su - root

    2. Stop the Oracle.
      1. Run the following command to stop the Oracle.

        # hares -offline Oracle -sys $(hostname)

      2. Check the status of the Oracle.

        # hares -state Oracle -sys $(hostname)

        If the following information is displayed, the Oracle stop successfully.

        OFFLINE
    3. Start the Oracle.
      1. Run the following command to start the Oracle.

        # hares -online Oracle -sys $(hostname)

      2. Check the status of the Oracle.

        # hares -state Oracle -sys $(hostname)

        If the following information is displayed, the Oracle start successfully.

        ONLINE

  8. Check whether the database memory is set successfully.

    1. Switch to the oracle user.

      # su - oracle

    2. Run the following command to obtain the total memory of the server, in MB:
      free -m | grep Mem | sed 's/ /\n/g' |sed '/^[[:space:]]*$/d' |sed -n '2p' 
      15951
    3. Log in to the database and query the maximum running memory of the database. In the query result, VALUE should be one fourth of the total memory of the server. (This is not an accurate value. The Oracle automatically adjusts the memory value slightly.)
      sqlplus / as sysdba 
      SQL>show parameter memory_max_target; 
      NAME                                 TYPE                   VALUE 
      ------------------------------------ ---------------------- ------------------------------ 
      memory_max_target                    big integer          3988M

  9. Check whether the log clearing task has been adjusted. In the query result, LAST_ARCHIVE_TS specifies a time one week before the script execution time, indicating that scripts of one week ago are all deleted.

    SQL>SELECT * FROM DBA_AUDIT_MGMT_LAST_ARCH_TS WHERE AUDIT_TRAIL LIKE '%OS%'; 
    AUDIT_TRAIL                              RAC_INSTANCE LAST_ARCHIVE_TS 
    ---------------------------------------- ------------ ------------------------------------------------------- 
    OS AUDIT TRAIL                                      1 02-OCT-17 11.55.03.000000 PM +08:00     
    SQL> exit

Translation
Download
Updated: 2019-10-30

Document ID: EDOC1100044372

Views: 30036

Downloads: 26

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