orachk 건전성 검사 실행(CLI)

다음 절차에 따라 데이터베이스 VM에서 건전성 검사를 실행할 수 있습니다. ORAchk는 앱 VM에서 실행되지 않습니다.

ORAchk를 실행하려면 다운로드하여 데이터베이스 VM에 설치해야 합니다.

ORAchk에 대한 자세한 내용은 ORAchk 개요를 참조하십시오.

1. 데이터베이스 VM에 로그인한 후 root 역할로 전환합니다.

   DB VM에 로그인을 참조하십시오.

2. orachk가 설치된 디렉토리로 변경합니다.
3. orachk를 실행합니다.

   root@mc1dbzg1-mc1zg1zone1:~# ./orachk     
            CRS stack is running and CRS_HOME is not set. Do you want to set     
   CRS_HOME to /u01/app/12.1.0.2/grid?[y/n][y]y     
   Checking for prompts on mc1dbzg1-mc1zg1zone1 for oracle user...     
   Checking ssh user equivalency settings on all nodes in cluster     
   Node mc1dbzg1-mc1zg1zone2 is not configured for ssh user equivalency and the script uses ssh to execute checks on remote nodes.     
   Without this facility the script cannot run audit checks on the remote nodes.     
   If necessary due to security policies the script can be run individually on each node.     
   Do you want to configure SSH for user root on mc1dbzg1-mc1zg1zone2     [y/n][y]y
   Enter root password on mc1dbzg1-mc1zg1zone2 :-     
   Verifying root password.     
    . .     
   Checking for prompts for oracle user on all nodes...     
       
   Searching for running databases . . . . .     
            . .          
   List of running databases registered in OCR          1.rac12c1          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          
   
   . . . . .  Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS . . . . . . . . . . . .   
   -------------------------------------------------------------------------------------------------------   
       
   Oracle Stack Status     
   -------------------------------------------------------------------------------------------------------
   Host Name  CRS Installed  RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name     
   -------------------------------------------------------------------------------------------------------
   mc1dbzg1-mc1zg1zone1 Yes         Yes           Yes              Yes            Yes        rac12c11     
   -------------------------------------------------------------------------------------------------------
   . . . . . . root passwords are incorrect or login to as root is     disabled in ssh
   configuration for following nodes.     
   You can still continue but root privileged checks will not be executed on following nodes.     
            1. mc1dbzg1-mc1zg1zone2     
            Do you want to continue[y/n][y]:- y
            *** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***     
   Collections and audit checks log file is     
       /root/orachk_mc1dbzg1-mc1zg1zone1_rac12c1_061716_150741/log/orachk.log     
       
       
   Checking for prompts in /root/.profile     on mc1dbzg1-mc1zg1zone1 for
       root user...     
       =============================================================
             Node name - mc1dbzg1-mc1zg1zone1     
       =============================================================          . . . . .     
   Collecting - ASM Disk Groups          
   Collecting - ASM Disk I/O stats
   Collecting - ASM Diskgroup Attributes          
   Collecting - ASM disk partnership imbalance          
   Collecting - ASM diskgroup attributes     
   Collecting - ASM diskgroup usable free space          
   
   <output omitted> 
   
            Detailed report (html) -
       /root/orachk_mc1dbzg1-mc1zg1zone1_rac12c1_061716_150741/orachk_mc1dbzg1-mc1zg1zone1_rac12c1_061716_150741.html
       UPLOAD(if required) -     /root/orachk_mc1dbzg1-mc1zg1zone1_rac12c1_061716_150741.zip