If you followed my previous post Oracle E-Business Suite R12.2.6 on Virtual Box you will have already downloaded the 19 required zip files, and be ready to go.
Ok, change directory to the location of the downloaded files, unzip and concatenate them into a single OVA file using the following:
$ unzip ‘V*.zip’
$ cat Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.* > Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova
Getting started – Virtual Box
Start Virtual Box and navigate to File -> Import Appliance
Click on ‘Expert Mode’ and edit the ‘Virtual Disk Image’ path to a location with adequate space (~500GB), in this example I am using my Samsung Portable SSD T1 1TB dive mounted at ‘/Volumes/Samsung_T1’
Click ‘Import’, go to lunch or grab a coffee and watch the progress bar if you prefer, the remaining time will re-calulate periodically.
Once complete, start up your new Oracle EBS R12.2.6 VM from within Oracle VirtualBox
Oracle E-Business Suite R12.2.6
The initial boot will prompt you to change the ‘root’, ‘oracle’ and ‘applmgr’ passwords, the process will continue to start and configure an Oracle 18.104.22.168 database called ‘EBSDB’.
Use ‘ifconfig -a’ to determine your VM’s IP address from you VirtualBox console before using SSH from your host to connect using your preferred client.
Add the IP address to your local ‘/etc/host’ file so your browser can resolve your Oracle EBS VISION sandbox environment. e.g.
192.168.0.23 apps.example.com apps
Change directory to ‘/u01/install/APPS/scripts’ to access the database and application stop / start scripts and run ‘startdb.sh’ and ‘startapps.sh’
[oracle@apps scripts]$ ./startdb.sh
You are running addlnctl.sh version 120.4
Starting listener process EBSDB …
LSNRCTL for Linux: Version 22.214.171.124.0 – Production on 15-AUG-2017 07:42:19
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /u01/install/APPS/12.1.0/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 126.96.36.199.0 – Production
System parameter file is /u01/install/APPS/12.1.0/network/admin/EBSDB_apps/listener.ora
Log messages written to /u01/install/APPS/12.1.0/admin/EBSDB_apps/diag/tnslsnr/apps/ebsdb/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.example.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps.example.com)(PORT=1521)))
STATUS of the LISTENER
Version TNSLSNR for Linux: Version 188.8.131.52.0 – Production
Start Date 15-AUG-2017 07:42:19
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File /u01/install/APPS/12.1.0/network/admin/EBSDB_apps/listener.ora
Listener Log File /u01/install/APPS/12.1.0/admin/EBSDB_apps/diag/tnslsnr/apps/ebsdb/alert/log.xml
Listening Endpoints Summary…
Service “EBSDB” has 1 instance(s).
Instance “EBSDB”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/install/APPS/12.1.0/appsutil/log/EBSDB_apps/addlnctl.txt for more information …
You are running addbctl.sh version 120.1
Starting the database EBSDB …
SQL*Plus: Release 184.108.40.206.0 Production on Tue Aug 15 07:42:19 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1308625016 bytes
Database Buffers 822083584 bytes
Redo Buffers 13848576 bytes
Disconnected from Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
addbctl.sh: exiting with status 0
[oracle@apps scripts]$ ./startapps.sh
Starting the Oracle E-Business Suite Application Tier Services
You are running adstrtal.sh version 120.24.12020000.11
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_apps/logs/appl/admin/log/adstrtal.log for more information …
Before you can logon you will need to enable SYSADMIN and the Demo accounts, Oracle have provided scripts to do this e.g.
[oracle@apps scripts]$ ./enableSYSADMIN.sh
This script will let you set a new password for the SYSADMIN EBS Applications User, the default password most likely was “sysadmin”, so pick a different one now.
Enter new password for SYSADMIN:
Re-enter password for SYSADMIN:
Changing password for SYSADMIN
Log filename : L7583909.log
Report filename : O7583909.out
[oracle@apps scripts]$ ./enableDEMOusers.sh
Enter a new password for the EBS Applications Users, the default password
most likely was “welcome”, so pick a different one now…
Enter new password for DEMO users:
Re-enter password for DEMO users:
Setting password for DEMO users…
Log filename : L7583911.log
Oracle EBS R12 Dashboard
You should now be able to logon as ‘SYSADMIN’ or explore your Oracle EBS R12.2.6 VISION sandbox environment using the Demo users (see below) and the password defined above at: http://apps.example.com:8000/
“AFENG”, “AMARLIN”, “AMILLER”, “APOTTER”, “BPALMER”, “BWEBB”
“CBROWN”, “CONMGR”, “CONTMGR”, “CSADM”, “DBAKER”, “EBUSINESS”
“FBRAMER”, “HRMS”, “ILANG”, “ISUPPORTADMIN”, “JFROST”
“KJONES”, “LJONES”, “MFG”, “MGRMKT”, “MNT”, “OPERATIONS”
“PHENRY”, “PIMMGR”, “PLMMGR”, “PROCESS_OPS”, “PROJMFG”
“PSTOCK”, “RBATES”, “SCRIPTUSER”, “SERVICES”, “SFM”
“SPAIN”, “SVYADMIN”, “TRADEMGR”
[twitter-follow screen_name=’RonEkins’ show_count=’yes’]
I installed the 12.2.6 VM and the services start perfectly. The homepage and webforms open well. But I’m having major problems opening java forms. Tried so many suggestions with firefox, IE and Chrome – no luck. I’m using windows 10, IE11, Firefox 52ESR
Did you have trouble opening java forms. Any suggestions ?
Check you have got pop-up blockers disabled, add the URL to the browser exception list and also try adding the URL to the Java console security exception list.
Thanks for your reply. After I posted my request for help yesterday, I went through the “Recommended browsers for R12” metalink document , step by step, and was able to get my IE11 to open java forms.
i have the same previous problem connecting to forms i have tried many ways but still the same, also how can i connect to the EBS VM DB? keep giving me invalid username/password.
Dear Tom Holden,
if possible, how you did get IE11 open java forms?
I’ve downloaded the 19 files and unzipped them, how do I concatenate them into single ova file? please help, thanks.
Yes, you need to concat them into a single file using the assemble scripts or cat e.g.
cat Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.00 \
Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.18 > Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova
Hi Ron, thank you for the quick reply. I downloaded all the 19 files, and concatenated all of them in a single .ova file in windows OS. I think the above commands are for Linux OS. I imported the Appliance and its installed but when I try to open it, I get an error message that “Could not start the machine because following physical network interfaces were not found: etho0 (Adapter1) ” I see from your screenshots that you didn’t get this error. Anything I missed during this implementation? also you are using Linux OS to write all your command line scripts, I’m searching for similar commands for windows command line for eg. the concatenation was different syntax in windows command line( copy /b) . Sorry I’m new to this so have all these basic questions.
Oracle provide a Unix & Mac script to assemble the OVA file, or you could use ‘cat’, alternatively on Windows you could use ‘type’ but this will be fairly slow.
Thanks you very much for this post. I am trying this, but having an issue:
I got an error when doing the concatenation of the files:
cat: Oracle-E-Business-Suite-12.2.7_VISION_INSTALL.ova.07: Input/output error
this repeated for file from 07 till 17.
Thanks a lot
I got it, the files were deleted in my first try. There was a power off and the system lost the files created with the first unzip command.