Wednesday, December 3, 2014

Installing E-Business Suite Release 12.2.4 Oracle VM Template

I was wondering when I will have my first hand’s on E-Business Suite 12.2.4… and here it comes. You can also make this true, just follow these simple steps and you will be there. It will be a fun journey and result will be fruitful.
The entire installation is divided into following sections :-
  • Section 1 – Hardware and Software Pre-requisites
  • Section 2 –  Downloading software and preparation
  • Section 3 –  Importing Virtual Machine
  • Section 4 –  Configuring EBS 12.2.4 Virtual Machine
  • Section 5 –  Usage and Maintenance
Section 1 – Hardware and Software Pre-requisites
I have used my personal laptop to implement this guide and it works fine. My laptop runs on Windows 7, I have used virtual machines inside my Host OS to run EBS 12.2.4 visions instance.

Hardware Requirement 
Recommended configuration
Processor Intel Dual Core / Core2Duo 2.5 Ghz
RAM 8 GB of RAM
HDD 500 GB of HDD (We need extra 300 GB of HDD to convert VM template appliance to Virtual Box readable format)
Network Network adapter
Used configuration
Processor Intel Core 2.5 Ghz
RAM 12 GB
HDD 128 + 2 TB external HDD
Network Network adapter
Software Requirement
Virtualization Oracle Virtual Box / VM Ware Player
Operating System Oracle Enterprise Linux Release6 Update5
EBS Software R12.2.4 VM Template
Network Network adapter
Other Software CygWin, Unzip Utility

Section 2 – Downloading software and preparation
2a – Downloading
Next step is to download the software from edelivery.oracle.com/linux. You follow the post here to get more details on how to download EBS 12.2.4 VM template. Choose Vision Demo Database while downloading. It has 16 zip file which totals to approx 50+ GBs. Make sure all files are downloaded correctly to avoid any error at later point.
List of zip files :-
V52470-01_1of2.zip
V52470-01_2of2.zip
V52471-01_1of2.zip
V52471-01_2of2.zip
V52472-01_1of2.zip
V52472-01_2of2.zip
V52473-01_1of2.zip
V52473-01_2of2.zip
V52474-01_1of2.zip
V52474-01_2of2.zip
V52475-01_1of2.zip
V52475-01_2of2.zip
V52476-01_1of2.zip
V52476-01_2of2.zip
V52477-01_1of2.zip
V52477-01_2of2.zip
2b – Preparation :- Preparing the zip files have two steps
  • Unzip :- When I tried to unzip for the first time, I used windows ‘extract all’ utility and had issue with the unzipped files. So its better to used some linux based utility or real unzip utility like winzip / 7zip. Since I was on windows machine I preferred installing cygwin which provides linux commands. Oracle support has provided a script to unzip and concatenate the files, see Appendix A in DOC ID # 1928303.1. If you are using script you need to manually modify some of the files as mentioned in this post. Other wise you can follow the manual unzip and concatenation.
  • Concatenation :- Once the files are unzipped you need to concatenate to create a single Oracle Virtual Appliance (.OVA) file, that will be later imported into Virtual Box / VM Player.
Manual Unzip and Concatenation
Use any unzip utility to unzip the files. Since I had cygwin, I used it to unzip and concatenate. You can open cygwin and browse to directory where zip files are stored and execute the below command.
Unzipping Files
Tauseef@Tauseef-PC /cygdrive/f/ebstemplates/12.2.4
$ for i in *.zip
do
unzip $i
done

Image 039

Concatenating Files
Tauseef@Tauseef-PC /cygdrive/f/ebstemplates/12.2.4
$ cat Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.00 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.01 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.02 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.03 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.04 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.05 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.06 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.07 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.08 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.09 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.10 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.11 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.12 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.13 \
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.14 \ 
Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.15   >  Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova

Image 041

NOTE : To make sure file are downloaded correctly, it better to do md5um and validate what is supplied with the file. This will ensure that you file is correct and will not have issue while importing.
Image 044  Image 043
Automated Unzip and Concatenation (Script)

Download the script assemble.sh from Oracle Support DOC ID # 1928303.1. Unzip it and pick the ‘VISION_INSTALL_MEDIA’. I would recommend copy the files from this folder to the folder where you have unzipped the VM templates and then execute assemble.sh.
Tauseef@Tauseef-PC /cygdrive/f/EBSTemplates/12.2.4
$ sh assemble.sh
assemble.sh: line 4: clear: command not found

Script started on Fri, Nov 28, 2014 10:00:53 AM
=========================ATTENTION================================
Running this script requires the Oracle E-Business Suite Release 12.2.4 Vision Install X86 media pack to be downloaded
from Oracle Software Delivery Cloud and staged in a single directory.

Press any key to continue processing the media pack
or press CTRL-C to exit out of the script.
====================================================================


Checking for required utilities in path
found - /usr/bin/unzip
found - /usr/bin/md5sum
found - /usr/bin/cat
found - /usr/bin/tar

sitemd5sum.txt exists
Deleting sitemd5sum.txt
Generating the md5sum of V52470-01_1of2.zip
Generating the md5sum of V52470-01_2of2.zip
Generating the md5sum of V52471-01_1of2.zip
Generating the md5sum of V52471-01_2of2.zip
Generating the md5sum of V52472-01_1of2.zip
Generating the md5sum of V52472-01_2of2.zip
Generating the md5sum of V52473-01_1of2.zip
Generating the md5sum of V52473-01_2of2.zip
Generating the md5sum of V52474-01_1of2.zip
Generating the md5sum of V52474-01_2of2.zip
Generating the md5sum of V52475-01_1of2.zip
Generating the md5sum of V52475-01_2of2.zip
Generating the md5sum of V52476-01_1of2.zip
Generating the md5sum of V52476-01_2of2.zip
Generating the md5sum of V52477-01_1of2.zip
Generating the md5sum of V52477-01_2of2.zip
md5sum matched
Proceeding to unzip files
Archive:  V52470-01_1of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.00
Archive:  V52470-01_2of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.01
Archive:  V52471-01_1of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.02
Archive:  V52471-01_2of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.03
Archive:  V52472-01_1of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.04
Archive:  V52472-01_2of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.05
Archive:  V52473-01_1of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.06
Archive:  V52473-01_2of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.07
Archive:  V52474-01_1of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.08
Archive:  V52474-01_2of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.09
Archive:  V52475-01_1of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.10
Archive:  V52475-01_2of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.11
Archive:  V52476-01_1of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.12
Archive:  V52476-01_2of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.13
Archive:  V52477-01_1of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.14
Archive:  V52477-01_2of2.zip
  inflating: Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.15

Verifying the Vision Demo Database Tier Individual Files
Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.00
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.00 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.01
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.01 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.02
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.02 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.03
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.03 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.04
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.04 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.05
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.05 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.06
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.06 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.07
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.07 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.08
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.08 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.09
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.09 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.10
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.10 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.11
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.11 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.12
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.12 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.13
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.13 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.14
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.14 is present

Checking for file : Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.15
File Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova.15 is present

Concatenating the Individual Template Files
Concatenating the Files Completed
Generating the md5sum of Oracle-E-Business-Suite-12.2.4_VISION_INSTALL.ova
md5sum matched
Script started on Fri, Nov 28, 2014 16:00:53 PM
Tauseef@Tauseef-PC /cygdrive/f/EBSTemplates/12.2.4
Image 046 Image 35
NOTE : This script unzips and concatenates the files. Its also validates the checksum. I have noticed that the md5sum generated by the script differs from the what is supplied with the script. Make sure modify the ‘md5sumwhenshipped.txt’ and ‘finalmd5sumwhenshipped.txt’ as below. You just need to add ‘*’ before the zip files names. I am providing original and modified file.

Original File
14646bebd648794927dd5362eafde980  V52470-01_1of2.zip
18fb139a098d98ff7c549cd96d3ba9f4  V52470-01_2of2.zip
b279daa07cad13a7c4136e1bae7008ee  V52471-01_1of2.zip
d64465dd9ee363070c7b356d6f5dd22c  V52471-01_2of2.zip
896d61da07636a2b9baf1c2da50bc919  V52472-01_1of2.zip
37442fbee1680978ee06460143df567a  V52472-01_2of2.zip
cc937a5c125f75a2bef6f09aa5ccc275  V52473-01_1of2.zip
27e5e11dd26ab7eac44e0dea7aa56928  V52473-01_2of2.zip
caf7cb4e0fd4ae08c0ec7253e46c70a1  V52474-01_1of2.zip
390b703e61c2146aef6d6823207c3461  V52474-01_2of2.zip
18c0efccf9a8334e80b40bad68530549  V52475-01_1of2.zip
512faa227e654630116c64e9e853070b  V52475-01_2of2.zip
172a59f1217e1eb08f44845145736786  V52476-01_1of2.zip
0aec25771eac7c00acbd847c079f9bb6  V52476-01_2of2.zip
9798d3ef9ee4b8ddaf0b1d1ecbb946e3  V52477-01_1of2.zip
d099bc32ded6b76789f423af000cb193  V52477-01_2of2.zip
Modified File
14646bebd648794927dd5362eafde980 *V52470-01_1of2.zip
18fb139a098d98ff7c549cd96d3ba9f4 *V52470-01_2of2.zip
b279daa07cad13a7c4136e1bae7008ee *V52471-01_1of2.zip
d64465dd9ee363070c7b356d6f5dd22c *V52471-01_2of2.zip
896d61da07636a2b9baf1c2da50bc919 *V52472-01_1of2.zip
37442fbee1680978ee06460143df567a *V52472-01_2of2.zip
cc937a5c125f75a2bef6f09aa5ccc275 *V52473-01_1of2.zip
27e5e11dd26ab7eac44e0dea7aa56928 *V52473-01_2of2.zip
caf7cb4e0fd4ae08c0ec7253e46c70a1 *V52474-01_1of2.zip
390b703e61c2146aef6d6823207c3461 *V52474-01_2of2.zip
18c0efccf9a8334e80b40bad68530549 *V52475-01_1of2.zip
512faa227e654630116c64e9e853070b *V52475-01_2of2.zip
172a59f1217e1eb08f44845145736786 *V52476-01_1of2.zip
0aec25771eac7c00acbd847c079f9bb6 *V52476-01_2of2.zip
9798d3ef9ee4b8ddaf0b1d1ecbb946e3 *V52477-01_1of2.zip
d099bc32ded6b76789f423af000cb193 *V52477-01_2of2.zip
If the md5sum don’t matched you will get below error from script
Files finalmd5sumwhenshipped.txt and finalsitemd5sum.txt differ
====================FAILURE======================================
md5sum did not match
md5sum of the final template file (finalmd5sumwhenshipped.txt) is provided for your reference
Check MOS Note 1928303.1 (Oracle VM Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.4) for instructions to deploy the template.
==============================================================
Image 047
Section 3– Importing Virtual Machine

Please make sure you have installed latest version of Virtual Box. I had issue as initially I was trying with little old version (4.2.18) of Virtual Box. In this test I have used v4.3.20. Follow the note download and install Virtual Box to get more details.

Before we import the Virtual Appliance (.OVA), validate the File –> Preferences of Virtual Box, under General settings validate if the Default Machine Folder is on the correct drive and its has ample space to create the Virtual Machine because this import is going to create a .vmdk file of 256 GB.Image 746

To start the import goto File –>Import Appliance

- Open Appliance

- Choose the .OVA file and open –> Next

- Validate Appliance Setting and Import. Agree to Terms and condition. It will start importing the virtual machine.

Once done you will see a virtual machine definition and its respective files.

Section 4 – Configuring EBS 12.2.4 Virtual Machine

Now you have the Virtual Machine configuration ready, let’s start configuring EBS 12.2.4. But before we do that I would suggest to update the network configuration and have network adapter as ‘Host Only Network’, I feel its better to configure the VM as static IP and for the Host Only Network is good. This is just a personal opinion.. if you want you can go with existing configuration ie. Bridged Network.

Virtual Machine default configuration has RAM set as around 6 GB… based on your system configuration change the value accordingly and start the virtual machine. Linux R6U5 will start and show the details of the machine. Since the default network configuration is DHCP you need to make a note of the IP which is assigned to ethernet adapter if you want to login with some tool like putty.

Once the system is booted login with the IP assigned using putty or use the native linux screen to configure.

Login in with root user, system will ask to change the pwd for root, oracle and applmgr user.
By default network is configured with DHCP, which may change the IP address of the guest machine every time you restart. So its better to change it to static. Oracle has provided a script to change the network to static under /u01/install/scripts/configstatic.sh.

Execute the script configstatic.sh and it will ask the IP details and again configures the application as we did in earlier step.
login as: root
root@192.168.56.199's password:
Last login: Sun Nov 30 11:15:33 2014 from 192.168.56.1
Changing password for user root.
New password:
BAD PASSWORD: it is based on your username
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.
Changing password for user oracle.
New password:
BAD PASSWORD: it is based on your username
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.
Changing password for user applmgr.
New password:
BAD PASSWORD: it is based on your username
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.

Couldn't obtain a DHCP Address during boot.Attempting to configure the machine with a static IP Address.

Use the hostname ebs.example.com when prompted to avoid re-configuration of the db/application tier file system


Press any key to continue...

Configuring network interface.
  Network device: eth0
  Hardware address: 08:00:27:F5:D5:41

Enter static IP address: 192.168.56.199
Enter netmask: [255.255.255.0] 255.255.255.0
Enter gateway: 192.168.56.1
Enter DNS server: 192.168.56.1

Shutting down interface eth0:                              [  OK  ]
Shutting down loopback interface:                          [  OK  ]
/usr/bin/logger: invalid option -- 'b'
usage: logger [-is] [-f file] [-p pri] [-t tag] [-u socket] [ message ... ]

Configuring network settings.
  IP configuration: Static IP address

Bringing up loopback interface:                            [  OK  ]
Bringing up interface eth0:  Determining if ip address 192.168.56.199 is already in use for device eth0...
                                                           [  OK  ]

Enter hostname (e.g, host.example.com): ebs.example.com
/usr/bin/logger: invalid option -- 'b'
usage: logger [-is] [-f file] [-p pri] [-t tag] [-u socket] [ message ... ]

Network configuration changed successfully.
  IP configuration: Static IP address
  IP address:       192.168.56.199
  Netmask:          255.255.255.0
  Gateway:          192.168.56.1
  DNS server:       192.168.56.1
  Hostname:         ebs.example.com


=====================VM CONFIGURATION SUMMARY========================
HOSTNAME FOR THE VM : ebs.example.com
DB/APPS FILE SYSTEM OWNER : oracle
TOP-LEVEL INSTALLATION DIRECTORY: /u01/install/VISION
SCRIPTS TO START/STOP/RECONFIGURE THE INSTANCE: /u01/install/VISION/scripts
SCRIPTS TO RECONFIGURE THE VM: /u01/install/scripts
ORACLE E-BUSINESS SUITE HOME PAGE: http://ebs.example.com:8000
====================================================================

 Starting the Oracle E-Business Suite Vision Demo Database

Logfile: /u01/install/VISION/11.2.0/appsutil/log/EBSDB_ebs/addlnctl.txt

You are running addlnctl.sh version 120.4


Starting listener process EBSDB ...


Listener EBSDB has already been started.


addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/VISION/11.2.0/appsutil/log/EBSDB_ebs/addlnctl.txt for more information ...


You are running addbctl.sh version 120.1


Starting the database EBSDB ...


SQL*Plus: Release 11.2.0.4.0 Production on Sun Nov 30 11:25:09 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected.
ORA-01081: cannot start already-running ORACLE - shut it down first
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

addbctl.sh: exiting with status 9


  E-Business Suite Environment Information
  ----------------------------------------
  RUN File System           : /u01/install/VISION/fs1/EBSapps/appl
  PATCH File System         : /u01/install/VISION/fs2/EBSapps/appl
  Non-Editioned File System : /u01/install/VISION/fs_ne


  DB Host: ebs.example.com  Service/SID: EBSDB


  Sourcing the RUN File System ...

stty: standard input: Inappropriate ioctl for device
Enter the APPS user password:
stty: standard input: Inappropriate ioctl for device

The log file for this session is located at: /u01/install/VISION/fs1/inst/apps/EBSDB_ebs/admin/log/11301125/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /u01/install/VISION/fs1/inst/apps/EBSDB_ebs
        Classpath                   : /u01/install/VISION/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/install/VISION/fs1/EBSapps/comn/java/classes

        Using Context file          : /u01/install/VISION/fs1/inst/apps/EBSDB_ebs/appl/admin/EBSDB_ebs.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........
         Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring CZ_TOP........COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring GMF_TOP.......COMPLETED
        Configuring PON_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
Logfile: /u01/install/VISION/11.2.0/appsutil/log/EBSDB_ebs/addlnctl.txt

You are running addlnctl.sh version 120.4


Shutting down listener process EBSDB ...


LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 30-NOV-2014 11:28:49

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebs.example.com)(PORT=1521)))
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/VISION/11.2.0/appsutil/log/EBSDB_ebs/addlnctl.txt for more information ...


You are running addbctl.sh version 120.1


Shutting down database EBSDB ...


SQL*Plus: Release 11.2.0.4.0 Production on Sun Nov 30 11:28:49 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

addbctl.sh: exiting with status 0



Enter VISION for configuring the VISION Demo Instance
Enter NONE to login to the VM
VISION
Configuring the VISION Instance
Copying /u01/install/VISION/scripts/visiondb.rc to /etc/init.d/visiondb
Copying /u01/install/VISION/scripts/visionapps.rc to /etc/init.d/visionapps
Adding service VISION DB to be managed on boot
Adding service VISION APPS to be managed on boot

[root@ebs tmp]#

Now the system is ready and both database and application startup scripts has been added to system startup. So next time when you start the system it will start database and application automatically.

Section 5 – Usage and Maintenance

To use the oracle application you need to make an entry into ‘hosts’ (C:\Windows\System32\drivers\etc\hosts) file of your HOST OS. Once done start using the application by using the URL ‘http://ebs.example.com:8000

Image 729
Before you shutdown your system you need to make sure you have successfully stopped all the application and database services. For all those things you already have scripts created in system folder ‘/u01/install/VISION/scripts’. First stop the application tier services and then database. To stop the services make sure run the script with ‘oracle’ user.
View EBS12.2.4Shutdown
View Full Album
Enjoy EBS12.2.4 !!!!!!




29 comments :

  1. Hi
    Have you executed visiondbconfig.sh and visionappsconfig.sh after you have started the VM? I am getting errors in visionappsconfig.sh. I am using 12.2.4 single node vision VM template

    ReplyDelete
  2. Hi Jayanta,

    I have not ran any of those scripts... When the machine start for the first time, after setting up the password it automatically runs those two scripts.

    Regards
    Tauseef

    ReplyDelete
  3. Hi Tauseef,
    Thanks for your reply. Since the visionappsconfig.sh failed twice, I had to issue a cleanup.sh
    I restarted the VM and re-entered the root, oracle and applmgr passwords. Now it is asking me to configure a static IP
    What should be the DNS for the static IP

    ReplyDelete
  4. Hello,

    It depends on what series of IP address you are using... in my case I used HOST Only Adapter, so DNS is 192.168.56.1.

    Regards
    Tauseef

    ReplyDelete
    Replies
    1. Now I can login to the application but not able to navigate to any screen that is forms based. Only java pages are working. Any ideas?

      Delete
  5. Hello,

    Its java issue. What version of Java do you have and what is your HOST OS. Based on that we need to take action..

    For now I can suggest two things.. remove all the Jave from system.... Run this site in compatibility mode in IE and install Java from Oracle when it prompts... hope that works.

    Regards
    Tauseef

    ReplyDelete
  6. Hi
    I have downloaded vm template files for EBS 12.2.4 and have two issues as of now. 1 not able to get forms research sayd open-motif RPM to install, as well only able to login in line mode not windows on linux, how to enable windows as well how to solve forms issues

    ReplyDelete
    Replies
    1. Hi Venkat,

      Sorry I am not able to follow your question.

      - Have you installed the application and having issues in launching forms or having issue while installing?

      - Are you installing using VM template via provided appliance? If VM template then you don't need any thing... you just need to import the appliance.

      - What is that line mode.. Do you mean you are not able to login into Unix box in virtual machine. If yes then when you try to login with root user for the first time, it will ask for change the password.

      Regards,
      Tauseef

      Delete
  7. Hi Tauseef
    Just deployed R1224 VM template but could not lunch the forms. I am having the error below

    In order to access this application, you must install the J2SE Plugin version 1.7.0_67. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete.

    Please I need your help

    Thanks

    egochigo@gmail.com

    ReplyDelete
    Replies
    1. Hello,

      You java/browser configs are not correct. It also depends on what version of Host OS you are using and which browser you are trying.. along with Java version.

      You can follow Oracle Support note - 389422.1 that talks about recommended setting for browser.

      Hope that that helps.

      Regards
      Tauseef

      Delete
  8. Hi Tauseef,

    A very well written post! I have a question, how can I access my vision instance from anywhere in the world?

    Thanks!

    ReplyDelete
    Replies
    1. Hello,

      For that you have to have a domain and map this to the domain... I don't have the detailed steps handy...

      Delete
  9. very well written but not easy to follow at all.

    It would help if you gave a line and highlighted what u were doing in a pic or two.
    Instead of giving lines and pics elsewhere to follow

    ReplyDelete
    Replies
    1. Hello,

      Thanks for the suggestion.. First I had written installing 12.1.3 and its has very detailed steps with highlights... I felt there I put too detailed so I cut thru some in this.... will keep that in mind for future posts.

      Tauseef

      Delete
  10. HOW TO STOP THE APPS TIER
    How can I stop the apps tier from starting up automatically?

    ReplyDelete
    Replies
    1. Hello,

      To stop the apps tier you can run the stop script available under /u01/install/scripts.

      To automatically stop starting apps server at start you can remove the script from start up... If you see the setup steps its copies :

      Copying /u01/install/VISION/scripts/visiondb.rc to /etc/init.d/visiondb
      Copying /u01/install/VISION/scripts/visionapps.rc to /etc/init.d/visionapps

      I believe if you remove the script from there it will not start automatically.

      Regards
      Tauseef

      Delete
  11. Hi,

    Thanks for your clear tutorial and i follwed it successfully installed oracle ebs,in my desktop.

    Now I want to access url of ebs from outisde network by using global ip or public ip.

    Can you please tell me the process of it.

    ReplyDelete
  12. Hello - Thanks for the detailed instructions.
    Was able to complete the install and login to the application. For some reason if I don't do a clean VM shutdown I am not able to login to the system. This has been an issue for quite a while. Reinstalled the whole thing about 5 times and it's the same issue after every bad shutdown.

    Any tips on how to fix this? Is the issue ip related.
    I am using host-only adapter.

    Ran the confogstatic.sh script and also cleanup.sh but no luck.

    Thanks

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
    2. Hello there.. I haven't had issues till now with bad shutdown.. I did shutdown without shutting down services but it works.. any way are you using dynamic IP? that could be a problem.. Apart from that you need to see what services is not getting started.. Also try pinging each server from host.

      Regards
      Tauseef

      Delete
  13. Thanks Tauseef.

    I had dynamic IP earlier but changed to to static by running the configstatic.sh script.
    Was able to ping fine.
    How do I check what services are not getting started?
    Thanks for your help.
    Hari

    ReplyDelete
  14. Hi Tauseef,

    Great blog thanks!

    A few other people have touched on accessing the EBS over the internet. Do you have any steps to follow in order to achieve this please?

    Thanks Matt

    ReplyDelete
  15. Hi Tauseef,

    I have read that in order to access EBS over the internet, a DMZ configuration needs to be followed.

    Is this even possible with just a Router and (Server/Computer) running EBS inside a VM?

    Many thanks Matt.

    ReplyDelete
  16. Hi Tauseef,

    Good Morning

    Great Post. You saved me a lot.

    I would like to know How to access Database (12.2.4) using Oracle SQL PLUS and Toad for Oracle.

    Could you please provide the guide lines, from Where to download and How to configure.

    Thank you

    ReplyDelete
  17. Hi Tauseef,

    Good Morning,

    I have successfully installed the 12.2.4 using the steps provided.

    But i am having one issue the concurrent managers are shutting down after the intial start.

    Thanks
    Vamsi.

    ReplyDelete
  18. Hi Tauseef,

    I installed 12.2.4 successfully but while launching from browser i am getting the following error

    Failure of server APACHE bridge:
    No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent.


    Any suggestions or pointers on how to proceed would be helpful.

    BR
    Dhiva

    ReplyDelete
    Replies
    1. You need to restart the application server oacore

      Delete
  19. Hi Tauseef,
    great article!

    I have created the environment and it is working ok.

    I want to access the weblogic console in order to do some monitoring of the environment.

    However I dont have the weblogic user/password details.

    I have tried using the ones that were setup as part of the install but they dont work.

    Do you know what they are?


    David

    ReplyDelete
  20. Hi Tauseef,

    I have imported R12.1.3 using Virtual Box Host Only adapter network settings. It worked for a month and not working after due to the ip address got changed. I tried for some time and then removed and re-imported the appliance. This time used the same Host only adapter and configured the ip using configstatic.sh file.

    Application is still not working. I can ping the guest from the host. The only difference is ping guest display loop back ip for static and the guest ip for the dynamic.

    Please let me know to troubleshoot the issue.

    Thanks

    ReplyDelete

SeachBox