Skip to main content

Oracle APPS R12.2 Installation on Google Cloud VM

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.

Labels:

Comments

Post a Comment

Popular posts from this blog

WebLogic migration to OCI using WDT tool

WebLogic migration to OCI using WDT tool Oracle WebLogic Deploy Tool (WDT) is an open-source project designed to simplify and streamline the management of Oracle WebLogic Server domains. With WDT, you can export configuration and application files from one WebLogic Server domain and import them into another, making it a highly effective tool for tasks like migrating on-premises WebLogic configurations to Oracle Cloud. This blog outlines a detailed step-by-step process for using WDT to migrate WebLogic resources and configurations. Supported WLS versions Why Use WDT for Migration? When moving Oracle WebLogic resources from an on-premises environment to Oracle Cloud (or another WebLogic Server), WDT provides an efficient and reliable approach to: Discover and export domain configurations and application binaries. Create reusable models and archives for deployment in a target domain. Key Pre-Requisites Source System: An Oracle WebLogic Server with pre-configured resources such as: Applica...
Post a Comment
Read more

How to Validate TDE Wallet Password in Oracle Database

How to Validate TDE Wallet Password in Oracle Database Validating the Transparent Data Encryption (TDE) wallet password is crucial, especially when ensuring that the password is correct without using the OPEN or CLOSE commands in the database. This blog post explains a straightforward method to validate the TDE password using the mkstore utility. Steps to Validate TDE Wallet Password Follow these steps to validate the TDE wallet password: Step 1: Copy the Keystore/Wallet File Navigate to your existing TDE wallet directory. Copy only the ewallet.p12 file to a new directory. If a cwallet.sso file exists, do not copy it . The absence of cwallet.sso ensures that the wallet does not use auto-login, forcing the utility to prompt for the password. Step 2: Validate Using mkstore Use the mkstore utility to check the contents of the wallet file. The mkstore utility will prompt you for the TDE wallet password, allowing you to validate its correctness. Command Syntax To display the conten...
Post a Comment
Read more

Rename a PDB in Oracle Database Multitenant Architecture in TDE and Non TDE Environment

Rename a PDB in Oracle Database Multitenant Architecture I am sharing a step-by-step guide to help you rename a PDB. This approach uses SQL commands. Without TDE or encryption Wallet Initial Check Check the Current Database Name and Open Mode: SQL > SELECT NAME, OPEN_MODE FROM V$DATABASE; NAME OPEN_MODE --------- -------------------- BEECDB READ WRITE List Current PDBs: SQL > SHOW PDBS; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 FUAT READ WRITE NO We need to RENAME FUAT to BEE  Steps to Rename the PDB Step 1: Export ORACLE_SID Set the Oracle SID to the Container Database (CDB): export ORACLE_SID=BEECDB Step 2: Verify Target PDB Name Availability If the target PDB name is different from the current PDB name, ensure no service exists with the target PDB name. Run SQL to Check Exi...
Post a Comment
Read more