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)