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


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


eSight V300R010C00 Maintenance Guide 08

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).
Checking the Database Logs

Checking the Database Logs

Maintenance personnel must periodically check the running status of the database.

Reference Standard

No exception affecting the database operation is found in the log files.


  1. Check the SQL Server database logs.


    In a HA system, you need to perform the operations only on the active server. The standby server automatically synchronizes data from the active server.

    The log files of the SQL Server database are stored in SQL Server installation directory\MSSQL\LOG.

  2. Check the Oracle database logs.

    By default, the alert logs of the Oracle 11g database are stored in $ORACLE_BASE/diag/rdbms/db_name/sid/trace/alert*.log. Here, db_name is the database name and sid is the instance name of the database.

    To view the path where the alert log files are stored, perform the following operations:

    1. Log in to the database server as the oracle user and run the following command to connect to the database:

      > sqlplus '/ as sysdba'

    2. Run the following command to view the path where the alert log files are stored:

      SQL> show parameter dump;

      Information similar to the following is displayed. By default, the alert log files are stored in the path specified by background_dump_dest.

      NAME                                 TYPE        VALUE 
      ------------------------------------ ----------- ------------------------------ 
      background_core_dump                 string      partial 
      core_dump_dest                       string      /opt/oracle/diag/rdbms/inomc/inomc/cdump 
      max_dump_file_size                   string  unlimited 
      shadow_core_dump                     string      partial 
      user_dump_dest                       string      /opt/oracle/diag/rdbms/inomc/inomc/trace     

Exception Handling

Rectify the exceptions based on the error information recorded in log files. If the exceptions persist, contact Huawei technical support engineers.

Updated: 2019-08-03

Document ID: EDOC1100044373

Views: 26622

Downloads: 84

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