--- 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