The following document describes the procedure used to move the EGATE database preprod environment running on "mxdaaega01" and "mxdaaega02" to the new p590 LPAR's "mxdpocega01" and "mxdpocega02". This procedure was performed on April 29, 2005 and will be used again to move preprod back to the original machines. The purpose is to define the procedure required to move the EGATE production databases to the p590 LPAR's.

• Generate HDLM SAN Disk identification document on current nodes

    mxdaaega01:
      cd /usr/DynamicLinkManager/bin
      lspv | grep dlmfdrv | grep -v dlmfdrvio |
      while read -- HDISK PVID VGNAME STATE
      do
        MAJOR=""
        LOC=""
        ls -l /dev/${VGNAME} 2>/dev/null |
          IFS="${IFS}," read -- PERMS LINKS OWNER GROUP MAJOR MINOR REMAIN
        print -- "\n${HDISK}  ${PVID}  ${VGNAME}  ${STATE}  ${MAJOR:+VGmajor#:${MAJOR}}"
        /usr/DynamicLinkManager/bin/dlnkmgr view -drv |
            grep " ${HDISK} " |
        while read -r -- LINE
        do
          print -r -- "${LINE}"
          print -r -- "${LINE}" | read -r -- DNBR DLMDISK DDISK LDEV
          LOC="${LOC}$( lscfg -l ${DDISK} | awk '{ print $2, $1 }' )\\n"
        done
        print -- "${LOC}"
      done
  

    mxdaaega02:
      cd /usr/DynamicLinkManager/bin
      lspv | grep dlmfdrv | grep -v dlmfdrvio |
      while read -- HDISK PVID VGNAME STATE
      do
        MAJOR=""
        LOC=""
        ls -l /dev/${VGNAME} 2>/dev/null |
          IFS="${IFS}," read -- PERMS LINKS OWNER GROUP MAJOR MINOR REMAIN
        print -- "\n${HDISK}  ${PVID}  ${VGNAME}  ${STATE}  ${MAJOR:+VGmajor#:${MAJOR}}"
        /usr/DynamicLinkManager/bin/dlnkmgr view -drv |
            grep " ${HDISK} " |
        while read -r -- LINE
        do
          print -r -- "${LINE}"
          print -r -- "${LINE}" | read -r -- DNBR DLMDISK DDISK LDEV
          LOC="${LOC}$( lscfg -l ${DDISK} | awk '{ print $2, $1 }' )\\n"
        done
        print -- "${LOC}"
      done
  

• Request SAN disks be presented to new machines
• Shutdown Databases on current nodes
• Shutdown HACMP on current nodes

    mxdaaega01: 
      smitty clstop
  

    mxdaaega02: 
      smitty clstop
  

• Varyoff any remaining non-rootvg volume groups
• On new nodes, save current state of disks

    mxdpocega01: 
      lspv > /tmp/lspv.out
  

    mxdpocega02: 
      lspv > /tmp/lspv.out
  

• Configure SAN disks
• Run configuration manager to pull in all SAN disks

    mxdpocega01: 
      cfgmgr
  

    mxdpocega02: 
      cfgmgr
  

• Clear persistant reserves on all SAN disks

    mxdpocega01: 
      cd /usr/DynamicLinkManager/bin
      for i in $( lspv | awk '{ print $1 }' | grep "^hdisk" )
      do
        ./dlmpr -c ${i}
      done
  

    mxdpocega02: 
      cd /usr/DynamicLinkManager/bin
      for i in $( lspv | awk '{ print $1 }' | grep "^hdisk" )
      do
        ./dlmpr -c ${i}
      done
  

• Remove all SAN disks and rediscover to obtain PVID's

    mxdpocega01: 
      for i in $( lspv | awk '{ print $1 }' )
      do
        rmdev -Rdl ${i}
      done
      cfgmgr
  

    mxdpocega02: 
      for i in $( lspv | awk '{ print $1 }' )
      do
        rmdev -Rdl ${i}
      done
      cfgmgr
  

• Check SAN disks against list of PVID's then import VG's using OCIDR.

    mxdpocega01:
      cd /usr/lpp/dr/mxdpocega01
      ./OCIDR -I config
  

    mxdpocega02:
      cd /usr/lpp/dr/mxdpocega02
      ./OCIDR -I config
  

• Varyon the non-concurrent volume groups and set to automatically varyon at boot time.

    mxdpocega01:
      varyonvg oradb01vg01
      chvg -a y oradb01vg01
      varyonvg oradb01vg02
      chvg -a y oradb01vg02
  

    mxdpocega02:
      varyonvg oradb02vg01
      chvg -a y oradb02vg01
      varyonvg oradb02vg02
      chvg -a y oradb02vg02
  

• Set the database filesystems to automatically mount at boot time.

    mxdpocega01:
      chfs -A y /u01001
      chfs -A y /u01002
      chfs -A y /backup
  

    mxdpocega02:
      chfs -A y /u01001
      chfs -A y /u01002
      chfs -A y /backup
  

• Modify the /etc/hosts file to reflect the new hostnames

    mxdpocega01:
      vi /etc/hosts
  

    mxdpocega02:
      vi /etc/hosts
  

• Modify HACMP to include the new concurrent volume groups

    mxdpocega01:
      oracon01vg oracon02vg oracon03vg oracon04vg
  

• Sync and verify, then start the HACMP configuration.

  mxdpocega01:
      Start HACMP
  

  mxdpocega02:
      Start HACMP
  

• Change ownership of oracle LV's

    mxdpocega01: 
      chown oracle:dba /dev/*orarp*
  

    mxdpocega02: 
      chown oracle:dba /dev/*orarp*
  

• Change the number of processes per user to 3000

    mxdpocega01: 
      chdev -l sys0 -a maxuproc=3000
  

    mxdpocega02: 
      chdev -l sys0 -a maxuproc=3000
  

• Mount the first Oracle CD from the NIM server and run the "rootpre.sh" script to set permissions and such.

    mxfapnim01: 
      exportfs -i -o 'root=*' /export/cdimages/Oracle8.1.7_Disk1
  

    mxdpocega01: 
      mount mxfapnim01:/export/cdimages/Oracle8.1.7_Disk1 /mnt
      cd /mnt
      ./rootpre.sh
      cd /tmp
      umount /mnt
  

    mxdpocega02: 
      mount mxfapnim01:/export/cdimages/Oracle8.1.7_Disk1 /mnt
      cd /mnt
      ./rootpre.sh
      cd /tmp
      umount /mnt
  

    mxfapnim01:
      exportfs -u /export/cdimages/Oracle8.1.7_Disk1
  

• Notify database and application group the machines are ready
• Contact Doug Lemons to make DNS changes

    CNAME: point mxdaaega01 to mxdpocega01
    CNAME: point mxdaaega02 to mxdpocega02