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 Local HA System Software Installation Guide (SUSE Linux + MySQL + OMMHA) 11

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).
How Do I Do If eSight Fails to Be Upgraded Due to Insufficient Tablespace Caused by Too Many Oracle Audit Logs

How Do I Do If eSight Fails to Be Upgraded Due to Insufficient Tablespace Caused by Too Many Oracle Audit Logs

Question

If the tablespace is insufficient due to a large number of audit logs are generated during eSight upgrade, an error will be reported during database backup, leading to upgrade failure. The error information is as follows:

ORA-39171: Job is experiencing a resumable wait.
ORA001691: unable to extend lob segment

Answer

This problem occurs when the Oracle audit log function is enabled (audit_trail is set to DB or OS). Too many audit logs cause insufficient tablespace. To solve this problem, disable the Oracle audit log function (set audit_trail to FALSE) and enable the audit log function (set audit_trail to the original value) again after the upgrade is complete.

To change the value of audit_trail from OS to FALSE, perform the following steps:

  1. Cancel the upgrade and delete the backup directory.

    The default backup directory is /opt/eSightback.

  2. Disable the audit function for the Oracle database.

    1. Log in to the Oracle server as the root user.
      1. Run the su - oracle command to switch to the oracle user.
      2. Run the sqlplus / as sysdba command to access the Oracle GUI.
    2. Ensure that the Oracle service is started normally. If the Oracle service is not started, perform the following steps to start it:
      • In a two-node cluster, log in to the VCS client and bring the Oracle resource online. For details, see the chapter Bringing a Resource Online of Maintenance Guide.
      • In a single-node system, run the startup command to start the Oracle service.
    3. Check the original value of audit_trail and record the value.
      SQL> show parameter audit_trail
       
      NAME                                 TYPE
      ------------------------------------ ---------------------------------
      VALUE
      ------------------------------
      audit_trail                          string
      OS
      SQL>
    4. Change the value of audit_trail to FALSE.

      After being modified, the value of audit_trail does not change immediately. You need to restart the Oracle service for the modification to take effect.

      SQL> alter system set audit_trail=FALSE scope=spfile;
       
      System altered.
       
      SQL> show parameter audit_trail
       
      NAME                                 TYPE
      ------------------------------------ ---------------------------------
      VALUE
      ------------------------------
      audit_trail                          string
      OS
      SQL>
    5. Restart the Oracle service.
      • In a two-node cluster, log in to the VCS client, bring the Oracle resource offline, and then bring the Oracle resource online. For details, see the chapter Managing Resource and Resource Groups of Local High Availability System Software Installation Guide (SUSE Linux + Oracle + Veritas).
      • In a single-node system, run the shutdown immediate command to stop the Oracle service, and then run the startup command to start the Oracle service.
    6. Verify that the value of audit_trail is changed to FALSE.
      SQL> show parameter audit_trail
       
      NAME                                 TYPE
      ------------------------------------ ---------------------------------
      VALUE
      ------------------------------
      audit_trail                          string
      FALSE
      SQL>

  3. Perform the eSight upgrade again and ensure that the eSight upgrade is successful.
  4. Enable the audit log function for the Oracle database again.

    1. Log in to the Oracle server as the root user.
      1. Run the su - oracle command to switch to the oracle user.
      2. Run the sqlplus / as sysdba command to access the Oracle GUI.
    2. Ensure that the Oracle service is started normally. If the Oracle service is not started, perform the following steps to start it:
      • In a two-node cluster, log in to the VCS client and bring the Oracle resource online. For details, see the chapter Bringing a Resource Online of Maintenance Guide.
      • In a single-node system, run the startup command to start the Oracle service.
    3. Run the following command to restore the value of audit_trail to the original one:
      SQL> alter system set audit_trail=OS scope=spfile;
       
      System altered.
    4. Restart the Oracle service.
      • In a two-node cluster, log in to the VCS client, bring the Oracle resource offline, and then bring the Oracle resource online. For details, see the chapter Managing Resource and Resource Groups of Local High Availability System Software Installation Guide (SUSE Linux + Oracle + Veritas).
      • In a single-node system, run the shutdown immediate command to stop the Oracle service, and then run the startup command to start the Oracle service.
    5. Verify that the value of audit_trail is changed to OS.
      SQL> show parameter audit_trail
       
      NAME                                 TYPE
      ------------------------------------ ---------------------------------
      VALUE
      ------------------------------
      audit_trail                          string
      OS
      SQL>

Download
Updated: 2019-11-22

Document ID: EDOC1100011856

Views: 92678

Downloads: 53

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