--- Migrate Jade to OEL7 ---

DB Server

ps -ef | egrep pmon | egrep -v grep | awk '{print $8}'
ora_pmon_pinnprod

Use this template: DB-TEMPLATE-RHEL7

https://binghamton.teamdynamix.com/TDClient/45/Portal/Requests/TicketRequests/NewForm?ID=xq-UfbOvhBw_&RequestorType=ServiceOffering

Steps to migrate to JADE_New from JADE(-OLD)

-- VM team creates JADE_New
   VMTeam should supply ip/netmask/gateway, etc.

-- JADE_New is rehosted to be reached with network numbers from VM Team.\Virtual System Name: 	JADE_New
	Routable IP: 	128.226.136.81
	Netmask: 	255.255.255.0
	Gateway: 	128.226.136.1

-- The network configuration from current JADE must be saved for use on JADE_New.
	HWADDR=00:50:56:9d:00:94
	TYPE=Ethernet
	BOOTPROTO=none
	IPADDR=128.226.136.42
	PREFIX=24
	GATEWAY=128.226.136.1
	NETMASK=255.255.255.0
	DNS1=128.226.1.11
	DNS2=128.226.1.18
	DNS3=128.226.20.130
	DOMAIN='cc.binghamton.edu binghamton.edu'
	DEFROUTE=yes
	IPV4_FAILURE_FATAL=yes
	IPV6INIT=no
	ONBOOT=yes
	NAME=eth0
	UUID=1e71b040-f45c-41ac-94e4-b5ac1eea138c
	LAST_CONNECT=1421864365
	DEVICE=eth0
	USERCTL=no

-- Ponder | Think about what other data, configs we collect to re-host JADE_New to JADE.
        LORE might have  a good idea on those extra things,
        as she built what was used to create the VMDK JADE_New is cloned from.

-- on OEL6 JADE:  ps -ef | egrep oracle | wc -l 
	more detailed read of ps if considered useful.

Alert Jeff; JADE_New is preped.

-- request that a time be scheduled to have  (VM Team) remove the internal data disk (VMDK) from "JADE_Orig".
    and assign it to "JADE_New". 
    Configure "NEW_VM" to utilize the newly added "reused disk" (VMDK). HOW??
    Then  (VM Team) will then need to do a storage move so that all disks associated with 'NEW_VM" are on the same storage volume.

-- rehost JADE to JADE_Orig using the network config from JADE_New.
-- rehost JADE_New to JADE using JADE's network config.
-- disable crond on both systems.
	OEL6   - /etc/init.d/crond stop
		 chkconfig --del crond

	OEL7   - systemctl stop crond
                 systemctl disable crond
-- reboot both.
-- ps -ef | egrep oracle
	

Disk Space: deployed and used

df -hT | egrep [ul]0[1-5] |sed "s#/dev/mapper/VolGrp--01-##" |awk '{print $2" "$3" "$5" "$6}' | sort -u
119G    75G 67% /u01
148G    93G 66% /u02
 50G   871M 2%  /l03
  9.8G 937M 10% /l01
  9.8G 937M 10% /l02
 99G   1.5G 2%  /u03
 99G    17G 18% /l05
-------------------------------
pvscan
600GB disk
-------------------------------
lvscan | sed "s#  ACTIVE            '/dev/VolGrp-01##" | sed "s/'//" | sed "s/\[//" | sed "s/\]//" | awk '{print $1" "$2" "$3}'
/u01 121.00 GiB
/u02 150.00 GiB
/u03 100.00 GiB
/u05 100.00 GiB
/l01 10.00 GiB
/l02 10.00 GiB
/l03 50.00 GiB

For JR: Is this sufficient space or should these be increased?

Notes and Documents

Current DB Migration Guide



### XFER oracle partitions from old to new
https://docs.google.com/spreadsheets/d/1SuJoH2Q1xk8EU-ASwsHqk_pxt-cgQ0SRAepIEd4UDk8/edit#gid=0

### DB server Migration to OEL7
https://docs.google.com/document/d/1BXT1dqt5Bs6TPDgcqjiY8dt2AEor9MWF4FHR7AnhTHU/edit



Valid HTML 4.0 Transitional