Oracle EBS 12.2.6 on VirtualBox

迷南。 2021-09-17 14:10 320阅读 0赞

Back in May, Oracle announced the general availability of [Oracle VM Virtual Appliance for E-Business Suite 12.2.6][] for download from the [Oracle Software Delivery Cloud.][]

In this series of Blog posts I will detail how you can build an Oracle EBS 12.2.6 environment with VirtualBox for use on a laptop / PC.

**Getting Started**

Logon to the Oracle Software Delivery Cloud using you SSO credentials and search for ‘**Oracle Virtual Appliance**‘ , select the Product as below and click ‘Continue’ to download the Oracle VM Virtual Appliance for Oracle E-Business Suite.

[![clip\_image001][clip_image001]][clip_image001_clip_image001]

**Compatible with VirtualBox**

As you can see from above, the Oracle VM Virtual Appliance for Oracle E-Business Suite supports both Oracle VM and [Oracle VirtualBox][]. Once download the Virtual Appliance can be imported into VirtualBox for running on a laptop / PC.

The Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.6.0.0 for x86 64bit is packaged in 19 files requiring 69.4 GB, so may take some considerable time to download depending upon your network / internet connection.

[![clip\_image002][clip_image002]][clip_image002_clip_image002]

**The Download**

You can download the 19 Oracle VM Virtual Appliances files individually by clicking on the file name or them all use wget, if you have never used wget you can read the following post on how to use [wget for downloading.][]

[![clip\_image003][clip_image003]][clip_image003_clip_image003]

The distribution includes the entire Oracle EBS Technology and Apps stack including the example Vision database.

<table style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;border-collapse:collapse;margin-left:.333in;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;" title=""> 
 <tbody style="margin-left:.333in;"> 
 <tr style="margin-left:.333in;"> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> COMPONENT</td> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> VERSION</td> 
 </tr> 
 <tr style="margin-left:.333in;"> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> RDBMS Oracle Home</td> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> 12.1.0.2</td> 
 </tr> 
 <tr style="margin-left:.333in;"> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> Application Code Level</td> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> Oracle E-Business Suite 12.2.6 Release Update Pack (<a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=2114016.1" rel="nofollow">My Oracle Support Knowledge Document 2114016.1)</a> + AD and TXK Delta 8 (<a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=2159750.1" rel="nofollow">My Oracle Support Knowledge Document 2159750.1)</a></td> 
 </tr> 
 <tr style="margin-left:.333in;"> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> Oracle Forms and Reports</td> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> 10.1.2.3</td> 
 </tr> 
 <tr style="margin-left:.333in;"> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> WebLogic Server</td> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> 10.3.6</td> 
 </tr> 
 <tr style="margin-left:.333in;"> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> Web Tier</td> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> 11.1.1.9</td> 
 </tr> 
 <tr style="margin-left:.333in;"> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> JDK</td> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> JDK 1.7 build 1.7.0_121-b15</td> 
 </tr> 
 <tr style="margin-left:.333in;"> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> Java Plugin</td> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> J2SE 1.7</td> 
 </tr> 
 <tr style="margin-left:.333in;"> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> Critical Patch Update (CPU)</td> 
 <td style="border-bottom:#a3a3a3 1pt solid;border-left:#a3a3a3 1pt solid;vertical-align:top;border-top:#a3a3a3 1pt solid;border-right:#a3a3a3 1pt solid;"> October 2016</td> 
 </tr> 
 </tbody> 
</table>

In my next post I will detail how build an Oracle E-BS 12.2.6 environment within VirtualBox.

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’

[![clip\_image004][clip_image004]][clip_image004_clip_image004]

Click ***‘Import’***, go to lunch or grab a coffee and watch the progress bar if you prefer, the remaining time will re-calulate periodically.

[![clip\_image005][clip_image005]][clip_image005_clip_image005]

Once complete, start up your new Oracle EBS R12.2.6 VM from within Oracle VirtualBox

**Oracle E-Business Suite R12.2.6**

[![clip\_image006][clip_image006]][clip_image006_clip_image006]

The initial boot will prompt you to change the ‘root’, ‘oracle’ and ‘applmgr’ passwords, the process will continue to start and configure an Oracle 12.1.0.2 database called ‘EBSDB’.

[![clip\_image007][clip_image007]][clip_image007_clip_image007]

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’**

*  startdb.sh
 *  stopdb.sh
 *  startapps.sh
 *  stopapps.sh

[![clip\_image008][clip_image008]][clip_image008_clip_image008]

**\[oracle@apps scripts\]$ ./startdb.sh**

Logfile: /u01/install/APPS/12.1.0/appsutil/log/EBSDB\_apps/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process EBSDB …

LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 15-AUG-2017 07:42:19

Starting /u01/install/APPS/12.1.0/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 12.1.0.2.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

————————

Alias EBSDB

Version TNSLSNR for Linux: Version 12.1.0.2.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

SNMP OFF

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…

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.example.com)(PORT=1521)))

Services 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 12.1.0.2.0 Production on Tue Aug 15 07:42:19 2017

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

Database mounted.

Database opened.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.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\]$

**\[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@apps scripts\]$

**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/][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”

[![clip\_image009][clip_image009]][clip_image009_clip_image009]

Sales Dashboard – LJONES

来自 <[https://ronekins.wordpress.com/2017/08/15/oracle-ebs-r12-2-6-on-virtual-box-pt2/][https_ronekins.wordpress.com_2017_08_15_oracle-ebs-r12-2-6-on-virtual-box-pt2]>

[Oracle VM Virtual Appliance for E-Business Suite 12.2.6]: https://blogs.oracle.com/stevenchan/oracle-vm-virtual-appliance-for-e-business-suite-1226-now-available
[Oracle Software Delivery Cloud.]: https://edelivery.oracle.com/osdc/faces/SearchSoftware
[clip_image001]: https://images2018.cnblogs.com/blog/430057/201806/430057-20180603101421228-106020074.png
[clip_image001_clip_image001]: /images/20210726/7fde37a633034da5ac0b7c786b55b2f6.png
[Oracle VirtualBox]: https://www.virtualbox.org/wiki/Downloads
[clip_image002]: https://images2018.cnblogs.com/blog/430057/201806/430057-20180603101427467-1195385025.png
[clip_image002_clip_image002]: /images/20210726/0b823333d6264dfeb6f72e44e3ac6a4f.png
[wget for downloading.]: https://ronekins.wordpress.com/2016/12/14/downloading-oracle-e-business-suite-r12-2-6-using-wget/
[clip_image003]: https://images2018.cnblogs.com/blog/430057/201806/430057-20180603101441326-775503305.png
[clip_image003_clip_image003]: /images/20210726/dcc3fdae7d494f3c95ae85009e978971.png
[Oracle E-Business Suite R12.2.6 on Virtual Box]: https://ronekins.wordpress.com/2017/07/24/oracle-ebs-12-2-6-on-virtualbox/
[clip_image004]: https://images2018.cnblogs.com/blog/430057/201806/430057-20180603101453188-1545409311.png
[clip_image004_clip_image004]: /images/20210726/f5b489ba73c142aba4624d0b29bbd87e.png
[clip_image005]: https://images2018.cnblogs.com/blog/430057/201806/430057-20180603101456928-1339815559.png
[clip_image005_clip_image005]: /images/20210726/ef3a5541da774038a9c686c1e3cef220.png
[clip_image006]: https://images2018.cnblogs.com/blog/430057/201806/430057-20180603101459711-1027744802.png
[clip_image006_clip_image006]: /images/20210726/2b3f06ff71cd444a9fec7cffc91301cf.png
[clip_image007]: https://images2018.cnblogs.com/blog/430057/201806/430057-20180603101504133-316791609.png
[clip_image007_clip_image007]: /images/20210726/2e375e25fb0b49e792d1c7f0e91b6375.png
[clip_image008]: https://images2018.cnblogs.com/blog/430057/201806/430057-20180603101525300-391736381.png
[clip_image008_clip_image008]: /images/20210726/c8ca3824b3a94ef88c931b54bf39216a.png
[http_apps.example.com_8000]: http://apps.example.com:8000/
[clip_image009]: https://images2018.cnblogs.com/blog/430057/201806/430057-20180603101539495-461081280.png
[clip_image009_clip_image009]: /images/20210726/847c548ddb7b48f8ad3a38b78eb6e30d.png
[https_ronekins.wordpress.com_2017_08_15_oracle-ebs-r12-2-6-on-virtual-box-pt2]: https://ronekins.wordpress.com/2017/08/15/oracle-ebs-r12-2-6-on-virtual-box-pt2/