Oracle APPS R12.2 Installation on Google Cloud VM

In this post I am going to share steps to install Oracle Apps R12.2 in Google Cloud.


Server Preparation:

Google cloud VM creation with 500 GB storage and make sure host name length is small. I have used RHEL 6 image for Operation system.

VNC server installation- Refer link to check the steps


Once above tasks are done, we have to start with installation and pre-requisites.

1) I will install RPM's using oracle public repository.

cd /etc/yum.repos.d

Move all present repo files to backup directory.

mkdir bkp
mv * bkp/

Download oracle public repository repo file.

wget http://public-yum.oracle.com/public-yum-ol6.repo

Using a text editor, change the field ‘enabled=0’ to ‘enabled=1’ for the repositories corresponding to the machine’s operating system while also enabling the ‘addons’ channel. Here’s an example of a repo file’s entries:
[ol6_latest]

name=Oracle Linux $releasever Latest ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

[ol6_addons]

name=Oracle Linux $releasever Add ons ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

[ol6_UEK_latest]

name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

2) Install the RPMS now using below command.

yum install oracle-ebs-server-R12-preinstall.x86_64

Once the pre-reqs are installed. We can verify the users.


[himanshu@ebs122 stage]$ id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)

[himanshu@ebs122 stage]$ id applmgr

uid=54322(applmgr) gid=54321(oinstall) groups=54321(oinstall)

Add appplmgr to dba group as well.


[himanshu@ebs122 stage]$ sudo usermod -aG dba applmgr

[himanshu@ebs122 stage]$ id applmgr

uid=54322(applmgr) gid=54321(oinstall) groups=54321(oinstall),54322(dba)



Also change password for oracle and applmgr user.

Install java using below command

yum install java


Link to Motif library in Oracle Application Server 10.1.2

unlink /usr/lib/libXtst.so.6

ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

Make sure hostname entry is present in below file

[applmgr@ebs122 scripts]$ cat /etc/sysconfig/network
NETWORKING=yes

HOSTNAME=ebs122.lab

Run Below Command

ifconfig lo:1 external_ip netmask 255.0.0.0 up


3) Make the below changes in limits.conf.


/etc/security/limits.conf:
---------------
 * hard nofile 65536
 * soft nofile 4096
 * hard nproc 16384
 * soft nproc 2047
 * hard stack 16384
 * soft stack 10240

4) Add a swap file of 20 GB Size

sudo fallocate -l 20G /u01/swapfile
sudo chmod 600 /u01/swapfile
sudo mkswap /u01/swapfile
sudo swapon /u01/swapfile

In Linux 7 use below in place of fallallocate

dd if=/dev/zero of=/swapfile bs=1024 count=20971520

edit /etc/fstab and add below

/u01/swapfile swap swap defaults 0 0

check available swap size.

[himanshu@ebs122 stage]$ free -g
             total       used       free     shared    buffers     cached
Mem:            14         12          2          0          0         11
-/+ buffers/cache:          0         14
Swap:           19          0         19
[himanshu@ebs122 stage]$ grep SwapTotal /proc/meminfo
SwapTotal:      20971516 kB

5) Create /etc/oraInst.loc file and put below content in it.

inventory_loc=/u01/oracle/oraInventory 
inst_group=dba 

Note: Make sure no space character are there in file content.

6) Setup ingress firewall rule for Google Cloud VM to enable connectivity to database port. I have decided to use port pool as 10 and 20, so my database port would be 1531(1521+10)





7) Map the hostname with Cloud external IP to be able to access.

[himanshu@ebs122 stage]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
34.93.86.157 ebs122.lab ebs122

8)Download the and keep the software on server and proceed with installation of EBS as normal.

Please follow link for  stage and installation screens.





9) Once Installation is Completed, Please verify by opening the login screen.




Also not you have to enable firewall for access http/weblogic ports as done in step 6.


For any doubts, please feel to ask.