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

FusionCube DB 3.1 Database Best Practice 03 (Oracle RAC 11g R2)

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).
Using the Tool

Using the Tool

After the database environment is deployed, upload the downloaded orachk.zip software package to one RAC server and perform a configuration audit as user root.

To use the tool, run the following command as user oracle:

 [dbn01 orachk]# ./oracheck 

CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /u01/app/11.2.0.4/grid?[y/n][y]y <==Check whether the value of CRS_HOME is correct.
Checking ssh user equivalency settings on all nodes in cluster 
Node dbn02 is configured for ssh user equivalency for oracle user
Searching for running databases . . . . . 
. . 
List of running databases registered in OCR 
1. RACDB 
2. None of above 
Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number 
like 1,2 etc [1-2][1].1 <===========Select the database to be checked. 
. . 
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS 
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

------------------------------------------------------------------------------------------------------- 
                                                Oracle Stack Status 
------------------------------------------------------------------------------------------------------- 
 Host Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name 
 ------------------------------------------------------------------------------------------------------- 
 dbn01        Yes             Yes             Yes             Yes        Yes      Yes      RACDB1   
 dbn02        Yes             Yes             Yes             Yes        Yes      Yes      RACDB2   
 ------------------------------------------------------------------------------------------------------- 
 Copying plug-ins 
 . . . . . . . . . . . . . . . . . . 
 . . . . . . 
  
 113 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is  
 not available, audit checks which  require root privileged data collection can be skipped. 

1. Enter 1 if you will enter root password for each  host when prompted 
 2. Enter 2 if you have sudo configured for oracle user to execute root_raccheck.sh script 
 3. Enter 3 to skip the root privileged collections 
 4. Enter 4 to exit and work with the SA to configure sudo  or to arrange for root access and run the tool later. 
  
 Please indicate your selection from one of the above options for root access[1-4][1]:-1 <=========Indicates the password input mode of user root. 1 indicates that the password will be entered manually.
  
Note:
Option 1: In the execution phase, enter the password of user root as prompted.
Option 2: Indicates that sudo is configured for user oracle.
Option 3: Skip the checks that require the permission of user root. This option is not recommended.
Option 4: Exit ORAchk to configure the root permission.
  
 Is root password same on all nodes?[y/n][y]y <===Check whether the same password of user root is used on all nodes.
Enter root password :  <==Enter the password of user root.
 Verifying root password. 
 . . . 

*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) *** <========Start the check.
  
 Collections and audit checks log file is 
 /home/oracle/raccheck/raccheck_dbn01_RACDB_111013_185118/log/raccheck.log 
  
 Checking for prompts in /home/oracle/.bash_profile on dbn01 for oracle user... 
  
 Checking for prompts in /home/oracle/.bash_profile on dbn02 for oracle user... 
  
 Starting to run raccheck in background on dbn02 <==========Check the remote node.
============================================================= 
                     Node name - dbn01 
 ============================================================= 
  
 Collecting - ASM DIsk I/O stats 
 Collecting - ASM Disk Groups 
 Collecting - ASM Diskgroup Attributes 
 Collecting - ASM disk partnership imbalance 
 Collecting - ASM diskgroup attributes 
 Collecting - ASM initialization parameters 

After the operations are complete, the following information (or similar information) is displayed:

Detailed report (html) - /home/oracle/orachk/orachk_dbn01_RACDB_111013_185118/orachk_dbn01_RACDB_111013_185118.html 
UPLOAD(if required) - /home/oracle/orachk/orachk_dbn01_RACDB_111013_185118.zip 
Translation
Download
Updated: 2018-12-26

Document ID: EDOC1100035759

Views: 23822

Downloads: 32

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