Oracle to AWS Migration – Oracle Database and Oracle EBS R12!
Recently, Laniakea team was tasked with migrating entire Oracle infrastructure onto AWS cloud. Below we have listed some of the critical decisions you will have to make before starting the migration to any cloud.
Few of the very important tasks are as below.
* Type of EC2 instance
* Way of copying Data
* OS Certification for Oracle EBS and databases
* Security
* VPC Configuration
* VPN Configuration
* RPM Install as recommended by Oracle
* EBS Volume type
* Hostname change or not
* RMAN backup/restore of databases
Once you have EC2 instances ready, depending upon their use(APPs Tier or DB Tier), you will have to prep the Linux servers. Please go through each step based on your OS version. We had to chose RHEL 6.2 due to compatibility to the on-prem servers. The database server was installed with 6.2 and Apps servers were installed with RHEL 5.7.
Add volumes
mkfs -t ext4 /dev/xvdf and xvdfg
ls -al /dev/disk/by-uuid/
modify /etc/hosts
vi /etc/sysconfig/network
hostname name
service network restart
add swap space
dd if=/dev/zero of=/var/myswap bs=1M count=2048
mkswap /var/myswap
swapon /var/myswap
create cd /var/tmp/.oracle folder
mkdir .oracle
chmod -R 777 .oracle/
Modify sysctl
# For 11g, Oracle-Validated setting for fs.file-max is 6815744
# # For 10g, uncomment ‘fs.file-max = 327679’, and comment ‘fs.file-max = 6553600’ entry and re-run sysctl -p
# # fs.file-max = 327679
fs.file-max = 6815744
# Oracle-Validated setting for kernel.msgmni is 2878
kernel.msgmni = 2878
# Oracle-Validated setting for kernel.sem is ‘250 32000 100 142’
kernel.sem = 250 32000 100 142
# Oracle-Validated setting for kernel.shmmni is 4096
kernel.shmmni = 4096
# Oracle-Validated setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144
# For 11g, Oracle-Validated setting for net.core.rmem_max is 4194304
# For 10g, uncomment ‘net.core.rmem_max = 2097152’, comment ‘net.core.rmem_max = 4194304’ entry and re-run sysctl -p
# net.core.rmem_max = 2097152
net.core.rmem_max = 4194304
# Oracle-Validated setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144
# For 11g, Oracle-Validated setting for net.core.wmem_max is 1048576
# For 10g, uncomment ‘net.core.wmem_max = 262144’, comment ‘net.core.wmem_max = 1048576’ entry for this parameter and re-run sysctl -p
# net.core.wmem_max = 262144
net.core.wmem_max = 1048576
# Oracle-Validated setting for fs.aio-max-nr is 3145728
fs.aio-max-nr = 3145728
# For 11g, Oracle-Validated setting for net.ipv4.ip_local_port_range is 9000 65500
# For 10g, uncomment ‘net.ipv4.ip_local_port_range = 1024 65000’, comment ‘net.ipv4.ip_local_port_range = 9000 65500’ entry and re-run sysctl -p
# net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.ip_local_port_range = 9000 65500
# Oracle-Validated setting for vm.lower_zone_protection on rhel4/oel4 is 100
#vm.lower_zone_protection = 100
# Oracle-Validated setting for vm.min_free_kbytes is 51200 to avoid OOM killer
vm.min_free_kbytes = 51200
Create /etc/oratab and /etc/oraInventory and change ownership to oracle/applmgr
Add yum repository
APPS Tier was installed with RHEL 5.
RHEL 5
remove rh-amazon-rhui-client rpm
yum.oracle.com_repo_OracleLinux_OL6_latest_x86_64.repo 10.0.1.214:/etc/yum.repos.d/
[yum.oracle.com_repo_OracleLinux_OL6_latest_x86_64]
name=added from: http://yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64
baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64
enabled=1
yum repolist all
yum-config-manager — enable yum.oracle.com_repo_OracleLinux_OL6_latest_x86_64
yum update — setopt=protected_multilib=false — skip-broken — nogpgcheck
cd <12.1_INSTALL_DIR>/apps/tech_st/10.1.2/lib $ cp -p -R stubs stubsORIG $ cd stubs $ cp <PATCH_INSTALL_DIR>/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so . $ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1 $ ln -s libgcc_s.so.1 libgcc_s.so
$ cd <12.1_INSTALL_DIR>/apps/tech_st/10.1.3/lib $ cp -p -R stubs stubsORIG $ cd stubs $ cp <PATCH_INSTALL_DIR>/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so . $ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1 $ ln -s libgcc_s.so.1 libgcc_s.so
For discoverer.
# mv /usr/lib/libXtst.so.6 /usr/lib/libXtst.so.6.ORG
# ln -s /usr/X11R6/lib/libXtst.so.6 /usr/lib/libXtst.so.6
ran adadmin — 1 2 3 options
/oracle/WG01_wgapp01/product/apps/tech_st/10.1.3/appsutil/clone/adlnkweboh.sh
/oracle/WG01_wgapp01/product/apps/tech_st/10.1.2/appsutil/clone/adlnktools.sh
changed JRE_LIB_DIR location to this — product/apps/tech_st/10.1.2/sysman/lib/env_sysman.mk
Create link for apache startup error
apachectl startssl: execing httpd apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object fi
ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
remove *.lock files
cd /oracle/WG01_wgapp01/product/inst/apps/WG01_wgapp01/ora/10.1.3/j2ee/oacore/persistence/
For Below error during login

Remove *.lock files from all j2ee component
cd $INST_TOP/ora/10.1.3/j2ee/oacore/persistence
change /etc/security/limits.conf
applmgr soft nproc 131072
applmgr hard nproc 131072
applmgr soft memlock 134217728
applmgr hard memlock 134217728
applmgr soft nofile 65536
applmgr hard nofile 65536
applmgr soft core unlimited
applmgr hard core unlimited
Disable FIREWALL — iptables flush
$ORACLE_HOME/bin/eulapi -CONNECT /@ \
-GRANT_PRIVILEGE \
-USER SYSADMIN \
-PRIVILEGE administration \
-PRIVILEGE all_admin_privs \
-LOG
Leave A Comment