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
[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
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.