In case we want to mount a folder located in other partition, below steps can be followed.

Check the mount now.

[himanshu@ebs122 ~]$ df -aTh

Filesystem     Type         Size  Used Avail Use% Mounted on

/dev/sda1      ext4         9.8G  3.6G  5.8G  39% /

proc           proc            0     0     0    - /proc

sysfs          sysfs           0     0     0    - /sys

devpts         devpts          0     0     0    - /dev/pts

tmpfs          tmpfs        7.3G     0  7.3G   0% /dev/shm

none           binfmt_misc     0     0     0    - /proc/sys/fs/binfmt_misc

sunrpc         rpc_pipefs      0     0     0    - /var/lib/nfs/rpc_pipefs

/dev/sdb       ext4         394G   77G  318G  20% /u01

/u01/stage     none         394G   77G  318G  20% /stage

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.

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

Add appplmgr to dba group as well.

Also change password for oracle and applmgr user.

Install java using below command

yum install java

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

edit /etc/fstab and add below

/u01/swapfile swap swap defaults 0 0

check available swap size.

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

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.

In this post we are going to see how to attach a DISK on Google Cloud VM.

Steps:

3) Format the Disk

4) Mounting the DISK. Create a directory and mount the disk on that.

In this post we are going to see how can we setup GUI in google cloud VM using vncserver. I would be using the same for installing EBS R12.2 in future posts.

Steps:

1. Setup a VM on Google Cloud. I am using RHEL 6.

[himanshu@ebs122 ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.10 (Santiago)

2. Install the required RPMS

yum install tigervnc-server

yum install twm

yum install xterm

yum install xsetroot
yum install xclock

3. Start the VNC server using below command

[himanshu@ebs122 ~]$ vncserver

You will require a password to access your desktops.

Password:
Verify:
xauth:  file /home/himanshu/.Xauthority does not exist

New 'ebs122:1 (himanshu)' desktop is ebs122:1

Creating default startup script /home/himanshu/.vnc/xstartup
Starting applications specified in /home/himanshu/.vnc/xstartup
Log file is /home/himanshu/.vnc/ebs122:1.log

4. Now install any vnc viewer and try to access.

Scripts:

SELECT

    fcp.concurrent_program_id,

    fcp.concurrent_program_name,

    fcpt.user_concurrent_program_name,

    fcpt.description,

    fe.executable_name,

    fet.user_executable_name,

    fe.execution_file_name

FROM

    apps.fnd_concurrent_programs fcp,

    apps.fnd_concurrent_programs_tl fcpt,

    apps.fnd_executables fe,

    apps.fnd_executables_tl fet

WHERE

        fe.executable_id = fet.executable_id

    AND

        fcp.concurrent_program_id = fcpt.concurrent_program_id

    AND

        fcpt.language = fet.language

    AND

        fcp.executable_id = fe.executable_id

    AND

        fcp.executable_application_id = fe.application_id

    AND

        fcpt.language = 'US'

  AND

    upper(fcpt.user_concurrent_program_name) LIKE  upper('%%')

      -- and upper(fcp.concurrent_program_name) LIKE  upper('%%');

Script to find redo log file members.

select GROUP#,TYPE,MEMBER from v$logfile;

Script to find redo log file size

select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024 as "Size in MB",MEMBERS,STATUS from v$log;

Script to find both log file and its size

SELECT

    a.group#,

    a.thread#,

    a.sequence#,

    a.archived,

    a.status,

    b.member AS redolog_file_name,

    ( a.bytes / 1024 / 1024 ) AS "Size in MB"

FROM

    v$log a

    JOIN v$logfile b ON a.group# = b.group#

ORDER BY a.group#

When trying to install oracle rpm on RHEL 6 Operating system on Google Cloud VM getting below error.

Error:

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle


GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Cause :

GPG key mising.

Solution:

Download GPG key.

Command:

get http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle