4 Replies Latest reply: Aug 7, 2012 2:56 PM by MR139 RSS

    RACCheck Script

    MR139
      I have installed 2-node Oracle 11gR2 (11.2.0.3) cluster on RHEL 5.

      I used GRID user to install Grid Infrastructure and ORACLE user to install RDBMS. Now I want to run RACCheck (RAC Configuration Audit Tool [ID 1268927.1]) script, and according to the document we have to run as Oracle S/W owner which is ORACLE in my case. But ORACLE doesn't have permission to run the command to check the Cluster Confoguration (eg., $CRS_HOME/bin/crsctl query crs softwareversion). So its all failing. And I cannot run as GRID user.

      Does anybody has similar issue?

      See the result of RACCheck
      oracle@hublpr1:/admintmp/ORACLE/RAC-Check$ ./raccheck
      
      CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /app/grid/product/11.2.0.3?[y/n][y]
      
      Checking ssh user equivalency settings on all nodes in cluster
      
      Node hublpr2 is configured for ssh user equivalency for oracle user
      
      
      Searching for running databases . . . . .
      
      . . .
      List of running databases registered in OCR
      1. agrprod
      2. eipprod
      3. mdmprod
      4. All of above
      5. None of above
      
      Select databases from list for checking best practices. For multiple databases, select 4 for All or comma separated number like 1,2 etc [1-5][4].
      
      Searching out ORACLE_HOME for selected databases.
      
      . . . . . .
      
      
      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
      -------------------------------------------------------------------------------------------------------
      hublpr1     Yes             Yes             Yes             Yes        Yes      Yes      agrprod1 eipprod1 mdmprod1
      hublpr2     Yes             Yes             Yes             Yes        Yes      Yes      agrprod2 eipprod2 mdmprod2
      -------------------------------------------------------------------------------------------------------
      
      86 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[1-4][1]:-
      
      *** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***
      
      
      Log file for collections and audit checks are at
      /admintmp/ORACLE/RAC-Check/raccheck_080612_102035/raccheck.log
      
      =============================================================
                          Node name - hublpr1
      =============================================================
      Collecting - ASM DIsk I/O stats
      Collecting - ASM Disk Groups
      Collecting - ASM disk partnership imbalance
      Collecting - ASM diskgroup attributes
      Collecting - ASM initialization parameters
      Collecting - Active sessions load balance for agrprod database
      Collecting - Active sessions load balance for eipprod database
      Collecting - Active sessions load balance for mdmprod database
      Collecting - Archived Destination Status for agrprod database
      Collecting - Archived Destination Status for eipprod database
      Collecting - Archived Destination Status for mdmprod database
      Collecting - Cluster Interconnect Config for agrprod database
      Collecting - Cluster Interconnect Config for eipprod database
      Collecting - Cluster Interconnect Config for mdmprod database
      Collecting - DB Diagnostic Destination for agrprod database
      Collecting - DB Diagnostic Destination for eipprod database
      Collecting - DB Diagnostic Destination for mdmprod database
      Collecting - Database Archive Destinations for agrprod database
      Collecting - Database Archive Destinations for eipprod database
      Collecting - Database Archive Destinations for mdmprod database
      Collecting - Database Files for agrprod database
      Collecting - Database Files for eipprod database
      Collecting - Database Files for mdmprod database
      Collecting - Database Instance Settings for agrprod database
      Collecting - Database Instance Settings for eipprod database
      Collecting - Database Instance Settings for mdmprod database
      Collecting - Database Parameters for agrprod database
      Collecting - Database Parameters for eipprod database
      Collecting - Database Parameters for mdmprod database
      Collecting - Database Properties for agrprod database
      Collecting - Database Properties for eipprod database
      Collecting - Database Properties for mdmprod database
      Collecting - Database Registry for agrprod database
      Collecting - Database Registry for eipprod database
      Collecting - Database Registry for mdmprod database
      Collecting - Database Sequences for agrprod database
      Collecting - Database Sequences for eipprod database
      Collecting - Database Sequences for mdmprod database
      Collecting - Database Undocumented Parameters for agrprod database
      Collecting - Database Undocumented Parameters for eipprod database
      Collecting - Database Undocumented Parameters for mdmprod database
      Collecting - Database Workload Services for agrprod database
      Collecting - Database Workload Services for eipprod database
      Collecting - Database Workload Services for mdmprod database
      Collecting - Dataguard Status for agrprod database
      Collecting - Dataguard Status for eipprod database
      Collecting - Dataguard Status for mdmprod database
      Collecting - Files not opened by ASM
      Collecting - Log Sequence Numbers for agrprod database
      Collecting - Log Sequence Numbers for eipprod database
      Collecting - Log Sequence Numbers for mdmprod database
      Collecting - Percentage of asm disk  Imbalance
      Collecting - Process for shipping Redo to standby for agrprod database
      Collecting - Process for shipping Redo to standby for eipprod database
      Collecting - Process for shipping Redo to standby for mdmprod database
      Collecting - Redo Log information for agrprod database
      Collecting - Redo Log information for eipprod database
      Collecting - Redo Log information for mdmprod database
      Collecting - Standby redo log creation status before switchover for agrprod database
      Collecting - Standby redo log creation status before switchover for eipprod database
      Collecting - Standby redo log creation status before switchover for mdmprod database
      Collecting - CPU Information
      ./raccheck: line 4024: 30854 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024: 31289 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - CRS active version
      ./raccheck: line 4024: 31809 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024: 32594 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - CRS oifcfg
      ./raccheck: line 4024:   730 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024:  1498 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - CRS software version
      ./raccheck: line 4024:  2126 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024:  2864 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - CSS Reboot time
      ./raccheck: line 4024:  3501 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024:  4362 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - CSS diagwait
      ./raccheck: line 4024:  4777 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024:  5646 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - CSS disktimout
      ./raccheck: line 4024:  6086 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024:  6997 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - Cluster interconnect (clusterware)
      ./raccheck: line 4024:  7431 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024:  8152 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - Clusterware OCR healthcheck
      ./raccheck: line 4024:  9041 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024:  9808 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - Clusterware Resource Status
      ./raccheck: line 4024: 10681 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024: 11226 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - Huge pages configuration
      ./raccheck: line 4024: 12453 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024: 13012 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - Kernel parameters
      ./raccheck: line 4024: 13609 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024: 14463 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - Linux module config.
      ./raccheck: line 4024: 15211 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024: 15955 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - Maximum number of semaphore sets on system
      ./raccheck: line 4024: 16545 Killed                  $localcmd >> $OUTFIL 2>> $ERRFIL
      ./raccheck: line 4024: 17267 Killed                  $localcmd_report >> $OUTFIL_REPORT 2>> $ERRFIL
      Collecting - Maximum number of semaphores on system
      ...................................................
      ...................................................
      ...................................................
        • 1. Re: RACCheck Script
          Sebastian Solbach -Dba Community-Oracle
          Hi,

          as stated in

          https://support.us.oracle.com/oip/faces/secure/km/DownloadAttachment.jspx?attachid=1268927.1:RACCHECKUSERSGUIDE

          in your case were Oracle user does not have the rights to call grid components, you may also run it as GI user.
          However you will have to provide DB credentials for the DB checks.

          I only wonder why you get errors. Even if you separate the users the binaries belong to oinstall group and have executable rights. So it should be possible for the database installation user to run crsctl. Though I do not have an env to try this right now...

          Can you post your id (id grid / id oracle) and an ll on $GI_HOME/crsctl and $ORACLE_HOME/oracle?

          Regards
          Sebastian
          • 2. Re: RACCheck Script
            MR139
            I am able to run the commands individually from oracle user, but when I run "raccheck" script its not working.

            oracle & grid user id:_
            oracle@hublpr1:/admintmp/ORACLE/RAC-Check$ id oracle
            uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmdba),506(oper)
            oracle@hublpr1:/admintmp/ORACLE/RAC-Check$
            oracle@hublpr1:/admintmp/ORACLE/RAC-Check$ id grid
            uid=502(grid) gid=501(oinstall) groups=501(oinstall),503(asmadmin),504(asmdba),505(asmoper)
            oracle@hublpr1:/admintmp/ORACLE/RAC-Check$
            I am able to run crsctl command or any other GI command from oracle user. But "raccheck" script is not working.
            oracle@hublpr1:/admintmp/ORACLE/RAC-Check$ echo $CRS_HOME
            /app/grid/product/11.2.0.3
            
            oracle@hublpr1:/admintmp/ORACLE/RAC-Check$ $CRS_HOME/bin/crsctl query crs activeversion
            Oracle Clusterware active version on the cluster is [11.2.0.3.0]
            
            oracle@hublpr1:/admintmp/ORACLE/RAC-Check$ $CRS_HOME/bin/crsctl query crs softwareversion
            Oracle Clusterware version on node [hublpr1] is [11.2.0.3.0]
            
            oracle@hublpr1:/admintmp/ORACLE/RAC-Check$ $CRS_HOME/bin/crsctl check crs
            CRS-4638: Oracle High Availability Services is online
            CRS-4537: Cluster Ready Services is online
            CRS-4529: Cluster Synchronization Services is online
            CRS-4533: Event Manager is online
            
            oracle@hublpr1:/admintmp/ORACLE/RAC-Check$ cat /proc/cpuinfo
            processor       : 0
            vendor_id       : GenuineIntel
            cpu family      : 6
            model           : 44
            ...................................................
            ...................................................
            ...................................................
            • 3. Re: RACCheck Script
              Sebastian Solbach -Dba Community-Oracle
              Hi,

              could be an environment issue. (Especially because you use $CRS_HOME above). I know that some Oracle scripts don't like CRS_HOME to be set.
              Can you try to unset all Oracle related environment variables, then set only ORACLE_HOME, PATH and ORACLE_BASE?

              Regards
              Sebastian
              • 4. Re: RACCheck Script
                MR139
                Yes, it is because of environment variable. In our .bash_profile script we are running ".oraenv" and it was waiting for the input, that was the issue and I didn't realize that. I commented that line and its running fine.

                Thank you all for helping me.