RAC Attack - Oracle Cluster Database at Home/Cluster Verification Utility (ASM)

From Wikibooks, open books for an open world
Jump to: navigation, search


  1. Login to collabn1 as the oracle user and open a terminal.
    RA-oel-console-collabn1.png
  2. Run CVU to validate that you're ready to install CRS. Use the new “fixup” feature of 11gR2 CVU to create a script that can fix missing parameters.

    [oracle@collabn1 ~]$ /mnt/cdrom*/grid/runcluvfy.sh stage -pre crsinst -n collabn1,collabn2 -fixup -r 11gR2
     
    Performing pre-checks for cluster services setup
     
    Checking node reachability...
    Node reachability check passed from node "collabn1"
     
    Checking user equivalence...
    User equivalence check passed for user "oracle"
     
    Checking node connectivity...
     
    Checking hosts config file...
     
    Verification of the hosts config file successful
     
    Node connectivity passed for subnet "192.168.78.0" with node(s) collabn2,collabn1
    TCP connectivity check passed for subnet "192.168.78.0"
     
    Node connectivity passed for subnet "172.16.100.0" with node(s) collabn2,collabn1
    TCP connectivity check passed for subnet "172.16.100.0"
     
    Interfaces found on subnet "192.168.78.0" that are likely candidates for VIP are:
    collabn2 eth0:192.168.78.52
    collabn1 eth0:192.168.78.51
     
    Interfaces found on subnet "172.16.100.0" that are likely candidates for a private interconnect are:
    collabn2 eth1:172.16.100.52
    collabn1 eth1:172.16.100.51
     
    Node connectivity check passed
     
    Total memory check failed
    Check failed on nodes:
            collabn2,collabn1
    Available memory check passed
    Swap space check failed
    Free disk space check passed for "collabn2:/tmp"
    Free disk space check passed for "collabn1:/tmp"
    User existence check passed for "oracle"
    Group existence check passed for "oinstall"
    Group existence check passed for "dba"
    Membership check for user "oracle" in group "oinstall" [as Primary] passed
    Membership check for user "oracle" in group "dba" passed
    Run level check passed
    Hard limits check passed for "maximum open file descriptors"
    Soft limits check passed for "maximum open file descriptors"
    Hard limits check passed for "maximum user processes"
    Soft limits check passed for "maximum user processes"
    System architecture check passed
    Kernel version check passed
    Kernel parameter check passed for "semmsl"
    Kernel parameter check passed for "semmns"
    Kernel parameter check passed for "semopm"
    Kernel parameter check passed for "semmni"
    Kernel parameter check passed for "shmmax"
    Kernel parameter check passed for "shmmni"
    Kernel parameter check passed for "shmall"
    Kernel parameter check failed for "file-max"
    Check failed on nodes:
            collabn2,collabn1
    Kernel parameter check passed for "ip_local_port_range"
    Kernel parameter check passed for "rmem_default"
    Kernel parameter check passed for "rmem_max"
    Kernel parameter check passed for "wmem_default"
    Kernel parameter check failed for "wmem_max"
    Check failed on nodes:
            collabn2,collabn1
    Kernel parameter check failed for "aio-max-nr"
    Check failed on nodes:
            collabn2,collabn1
    Package existence check passed for "make-3.81"
    Package existence check passed for "binutils-2.17.50.0.6"
    Package existence check passed for "gcc-4.1.2"
    Package existence check passed for "gcc-c++-4.1.2"
    Package existence check passed for "libgomp-4.1.2"
    Package existence check passed for "libaio-0.3.106"
    Package existence check passed for "glibc-2.5-24"
    Package existence check passed for "compat-libstdc++-33-3.2.3"
    Package existence check passed for "elfutils-libelf-0.125"
    Package existence check passed for "elfutils-libelf-devel-0.125"
    Package existence check passed for "glibc-common-2.5"
    Package existence check passed for "glibc-devel-2.5"
    Package existence check passed for "glibc-headers-2.5"
    Package existence check passed for "libaio-devel-0.3.106"
    Package existence check passed for "libgcc-4.1.2"
    Package existence check passed for "libstdc++-4.1.2"
    Package existence check passed for "libstdc++-devel-4.1.2"
    Package existence check passed for "sysstat-7.0.2"
    Package existence check passed for "unixODBC-2.2.11"
    Package existence check passed for "unixODBC-devel-2.2.11"
    Package existence check passed for "ksh-20060214"
    Check for multiple users with UID value 0 passed
    Current group ID check passed
    Core file name pattern consistency check passed.
     
    User "oracle" is not part of "root" group. Check passed
    Default user file creation mask check passed
     
    Starting Clock synchronization checks using Network Time Protocol(NTP)...
     
    NTP Configuration file check started...
    NTP Configuration file check passed
     
    Checking daemon liveness...
    Liveness check failed for "ntpd"
    Check failed on nodes:
            collabn2,collabn1
    PRVF-5415 : Check to see if NTP daemon is running failed
    Clock synchronization check using Network Time Protocol(NTP) failed
     
    Fixup information has been generated for following node(s):
    collabn2,collabn1
    Please run the following script on each node as "root" user to execute the fixups:
    '/tmp/CVU_11.2.0.1.0_oracle/runfixup.sh'
     
    Pre-check for cluster services setup was unsuccessful on all the nodes.
    
  3. Switch to the root user and run the fixup script on both nodes.

    collabn1:/home/oracle[RAC1]$ su -
    Password:
    -bash: oraenv: No such file or directory
     
    [root@collabn1 ~]# /tmp/CVU_11.2.0.1.0_oracle/runfixup.sh
     
    Response file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.response
    Enable file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.enable
    Log file location: /tmp/CVU_11.2.0.1.0_oracle/orarun.log
    Setting Kernel Parameters...
    fs.file-max = 6815744
    net.ipv4.ip_local_port_range = 9000 65500
    net.core.wmem_max=262144
    net.core.wmem_max = 1048576
    fs.aio-max-nr = 1048576
     
    [root@collabn1 ~]# ssh collabn2 /tmp/CVU_11.2.0.1.0_oracle/runfixup.sh
    root@collabn2's password:
    /root/.bashrc: line 16: oraenv: No such file or directory
     
    Response file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.response
    Enable file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.enable
    Log file location: /tmp/CVU_11.2.0.1.0_oracle/orarun.log
    Setting Kernel Parameters...
    fs.file-max = 6815744
    net.ipv4.ip_local_port_range = 9000 65500
    net.core.wmem_max=262144
    net.core.wmem_max = 1048576
    fs.aio-max-nr = 1048576
    
  4. As the oracle user, run CVU again to make sure the fixit script worked. The NTP, memory and swap checks might fail – but this is acceptable for our VMware test cluster.

    [root@collabn1 ~]# exit
    logout
     
    collabn1:/home/oracle[RAC1]$ /mnt/cdrom*/grid/runcluvfy.sh stage -pre crsinst -n collabn1,collabn2 -r 11gR2
     
    ...
    Total memory check failed
    ...
    Swap space check failed
    ...
    Kernel parameter check passed for "file-max"
    ...
    Kernel parameter check passed for "wmem_max"
    Kernel parameter check passed for "aio-max-nr"
    ...
    Liveness check failed for "ntpd"
    ...