Launching Oracle EBS 12.2.9 Vision Instance on Oracle Cloud in 30 minutes

19
3115

If any customer or DBA wants to run Oracle EBS 12.2 Vision Instance, they download EBS 12.2.9 VM Appliance from Oracle E-Delivery. It takes a lot of time to Download Media, Extract, Configure VM and run EBS Instance. Ideally it takes around 1-1.5 Days to run the instance.

But with Oracle Cloud you can run it in 30 minutes!!! 🙂

I am surprised as well. Oracle has done an amazing job in not only making the EBS 12.2 image available online, but making it very easy to run it so quickly.

This post will help you run the EBS 12.2.9 instance in 30 mins even if you have ZERO knowledge on Oracle Cloud.

So what do you need first:

  • Register for free cloud account (Takes 10-15 mins)
  • Download MobaXterm or Putty Software
  • Generate SSH keys

Generating SSH Keys:

First generate the SSH keys needed to connect to the VM you are about to create. I used MobaXterm as it is free and easy to use. You can also use Putty. Simply run “ssh keygen” command as below and keep the SSH Key ready to be used while creating the VM.

Create VM Instance:

First click on Create VM Instance and Provide a name for the VM Instance.

Click on “Change Image Source” and select “Oracle EBS 12.2.9”.

Click on “Show Shape, Network” and Choose “VM.Standard E2.2”. This shape will provide 2 OCPU and 16 GB Memory which is very much needed for EBS 12.2.

If this is a newly created account and you have not created a VCN before, a new VNC is created automatically. Select the option “Assign a public IP Address” so that a Public IP is allocated to the EBS VM Instance and we can access the VM through internet. Then Paste the SSH keys we have generated previously.

Click on “Create” at the bottom. Once you click on it, initially it will show the VM instance status as “Provisioning” and then you can see it as “Running” within 2-3 minutes.

Now copy the Public IP (131.61.XXX.XXX) from the VM instance page and connect through MobaXterm – Session. Locate the id_rsa (Private Key) file which we generated before. Save the session name as “EBS-Vision-1229” or any name of your choice. Once you connect, sudo to root and run below commands to configure the Host Names to run EBS.

[opc@ebs-vision-1229 ~]$ hostname
ebs-vision-1229
[opc@ebs-vision-1229 ~]$ sudo su -
[root@ebs-vision-1229 ~]# cd /u01/install/scripts/
[root@ebs-vision-1229 scripts]# ls
cleanup.sh configdhcp.sh configstatic.sh configwebentry.sh configyum.sh disableRoot.sh updatehosts.sh zeroout.sh
[root@ebs-vision-1229 scripts]# sh updatehosts.sh
Updating hosts file with the current IPFully Qualified Hostname for this server is : apps.example.com
IP Address Configured for this server is : 10.0.0.2
Updating /etc/hosts file Information
removing the /etc/hosts.org file
Hosts file update completed[root@ebs-vision-1229 scripts]#
[root@ebs-vision-1229 scripts]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.0.0.2 apps.example.com apps
[root@ebs-vision-1229 scripts]# hostname apps.example.com
[root@ebs-vision-1229 scripts]# hostname
apps.example.com

Before you start the services, we need to create a Security Rule in the VCN to ensure we can access the port 8000 for EBS.

Navigate to Networking — Virtual Cloud Networks — Click on VCN — Security Lists — Add Ingress Rules — Provide CIDR, Port 8000

After this, you should be able to see the new Ingress Rule to access the 8000 port from Internet. If you are new to OCI then you can think of Ingress Rule as a Firewall Rule to access a specific port.

Start the Services now using Oracle Provided scripts, startdb.sh and startapps.sh. I have also run enableSYSADMIN.sh script to enable and reset SYSADMIN user.

Now add the Host Entry in your Windows Laptop/Desktop with the EBS VM Instance IP. Access the Oracle EBS URL 🙂

If you want to connect to the database using SQL Developer, then refer to this:

All the best! Keep learning.

19 COMMENTS

  1. Hi Vishnu,

    Great article.
    I have followed all the steps which you have mentioned but I’m unable to login to EBIZ page.Do i need to modify anything after adding port 8000 in security list ? i have used the same hostname.

  2. Thank you Vishnu, Great post.
    I have issue while starting the apps services. Forms server failed to start with below error.
    Can you please help me on this

    • Sure. Are you able to start the Database? Did you run the update hosts command? Thats the important step. Also, run “hostname apps.example.com” before you try to start them. If still not working, send an email to vishnu.vinnakota@gmail.com and I can help you through zoom or some other way.

  3. Hi Vishnu,

    Thank You for the valuable post ! You have made it very simple and clear. I was able to create a cloud instance and launch EBS 12.2.9 application. Now, I would like to connect to the database to exercise some tools such as Oracle Workflow Builder. Kindly please could you post an article or provide pointers about how to connect to “ebsdb” sitting on apps.example.com?

    • Hello,

      I will soon post about it too. As we discussed, you need to create the SSH tunnel to 1521 using the same private key and then use SQL Developer to connect to localhost using 1521.

      Thank you for the compliment. Sorry, I have not been able to find much time to reply.

  4. Hi Vishnu,

    I am so Thankful to You for sparing your valuable time and sharing the knowledge. Greatly appreciate Your efforts. I will try this out. I was in dire need of availing the database access to exercise some tools.

  5. Hello Vishu,
    great article. Just wanted to know if EBS 12.2.9 will come under Always free Eligibility tier.

    Thanks
    Sunil

    • Hello. I doubt it because of the free tier resources Oracle Mentioned. Since maximum of 100GB Block Volume is the limit, you probably won’t be able to run it forever. You can give a try though.

      Compute (up to two instances)
      Autonomous Database (up to two database instances)
      Load Balancing (one load balancer)
      Block Volume (up to 100 GB total storage)
      Object Storage (up to 20 GiB)
      Vault (up to 20 keys and up to 150 secrets)

      Thanks,
      Vishnu

LEAVE A REPLY

Please enter your comment!
Please enter your name here