Easy Step-by-Step Install of Oracle EBS 12.2.3 with Non-DBA skills
- This #Oracle_EBS instance will be running on a virtual machine hosted by #Oracle Virtual Box It will be a Single Node install which means only one VM is required.
- You will not need to install Oracle VM Server and Oracle VM Manager.
- You will need some IT basic skills but you don’t need to be a DBA or super technical
- I used Metalink’s Doc ID 1620448.1 as a reference.
Basic Systems Requirements
- A 64-bit Desktop or Laptop running Oracle Virtual Box (I tested it with a beefed-up desktop running Windows Server 2012)
- At least 6 GB RAM (That’s what the appliance requires, I updated to 8 GB before importing in in Virtual Box)
- Hard Drive (built-in or external) 500 GB minimum (My VM was 261 GB when I was done but the Virtual Box appliances comes with 500 GB by default, which you can update before importing it)
- One static IP address will be ideal if you want to connect to Oracle EBS outside your local PC. You will also need additional network information such as Network Mask, Default Gateway, DNS Server, host name and Domain.
Step 1 — Download the install files
I will be showing how to install a Single Node Vision instance on a Virtual Machine. This means both database and application servers will be under the same IP address and a typical Vision instance will be created. This instance will run within Virtual Box.
a) Log in to Oracle Software Delivery Cloud (a.k.a eDelivery) and search for the Oracle VM Virtual Appliances for Oracle E-Business Suite (12.2.3) Media Pack for x86 64 bit
b) Select and download all the files for Oracle E-Business Suite Release 12.2.3 Single Node Vision Install X86 (64 bit)
Step 2 — Unzip Files and concatenate into a single .ova file
You will end up with the .ova file that you need to import to Virtual Box
Step 3 — Double click .ova file to import into Virtual Box.
Step 4 — Change Network preferences and settings for the imported appliance
Step 5 — Start up your VM
During the process you will be asked to change the password for the following users: root, oracle and applmgr
Step 6— After completing the initial install of the VM choose to install VISION
Step 7— Configure Static IP
In case you missed or skipped this step during the install you can go back to these setting by running the following script from /u01/install/scripts:
ovm_configure_network
Step 8— Configure Database Tier
- Run script visiondbconfig.sh from /u01/install/VISION/scripts
- Add your SID or Database Name (i.e.: VIS1223)
Step 9— Configure Applications Tier
- Run visionappsconfig.sh from /u01/install/VISION/scripts
- Indicate Host Name (just host without the domain), Domain Name, Database SID, and Port Number
Step 10— Check the Installation Summary
Hopefully when the process of setting up the Applications tier is completed the installation summary information will be displayed on your screen.
Write down your Oracle EBS Login Page but don’t launch it right now:
http://<your-server>.<your-domain>:8000/OA_HTML/AppsLogin
Step 11— Edit host file in your desktop
Go to C:\Windows\System32\drivers\etc\hosts and add an entry with the IP address and host name of the server from where your are running your new instance.
Step 12 — Change your Java Security Level
Go to the Java Control Panel and update your Java Security Level to Medium
Step 13 (Final Step!) — Open your Browser and navigate to the Oracle EBS 12.2.3 Login Page
http://<your-server>.<your-domain>:8000/OA_HTML/AppsLogin
Useful scripts:
SCRIPTS BASE_DIR: /u01/install/VISION/scripts/
START SCRIPT FOR DB: /u01/install/VISION/scripts/startvisiondb.sh
STOP SCRIPT FOR DB: /u01/install/VISION/scripts/stopvisiondb.sh
START SCRIPT FOR APPS: /u01/install/VISION/scripts/startvisionapps.sh
STOP SCRIPT FOR APPS: /u01/install/VISION/scripts/stopvisionapps.sh
DB RE-CONFIG SCRIPT: /u01/install/VISION/scripts/visiondbconfig.sh
APPS RE-CONFIG SCRIPT: /u01/install/VISION/scripts/visionappsconfig.sh
DB CLEANUP SCRIPT: /u01/install/VISION/scripts/visiondbcleanup.sh
APPS CLEANUP SCRIPT: /u01/install/VISION/scripts/visionappscleanup.sh
CONFIGURE A NEW WEB ENTRY POINT: /u01/install/scripts/configwebentry.sh