12 Days of #Cloud: Day 3
Building an EBS instance on Cloud using a pre-configured image is pretty easy. Let’s build E-Business Suite 12.2.6 Vision Instance. I am going with simple architecture of one node hosting database and application services.
Reference Document: Provisioning a Single-Node Oracle E-Business Suite Release 12.2 Installation (with Database 12.1.0.2) to Oracle Compute Cloud Service
Start with creating a compute instance.
The Oracle Cloud Marketplace has images available. This simplifies the EBS instance build.
Let’s pick EBS 12.2.6 Demo image from Marketplace and start the provisioning.
Agree to the terms.
Choose the compute shape based on your budget.
Provide details of the instance.
Since we are importing from an image, nothing to do in the storage section.
The summary section shows what we are going to get.
The instance creation process starts.
The Orchestration tab shows the progress.
The build completed in little over an hour.
Let’s check the console log:
A sample of the log is below.
System parameter file is /u01/install/APPS/12.1.0/network/admin/EBSDB_b9217d/listener.ora
Log messages written to /u01/install/APPS/12.1.0/admin/EBSDB_b9217d/diag/tnslsnr/b9217d/ebsdb/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=b9217d.compute-btoracloud.oraclecloud.internal)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=b9217d.compute-btoracloud.oraclecloud.internal)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias EBSDB
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 10-NOV-2016 23:25:07
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_b9217d/listener.ora
Listener Log File /u01/install/APPS/12.1.0/admin/EBSDB_b9217d/diag/tnslsnr/b9217d/ebsdb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=b9217d.compute-btoracloud.oraclecloud.internal)(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_b9217d/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 Thu Nov 10 23:25:08 2016
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 452987000 bytes
Database Buffers 1677721600 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
=====================INSTALLATION SUMMARY============
The Oracle E-Business Suite DB HostName : b9217d.compute-btoracloud.oraclecloud.internal
The Base Installation Directory : /u01/install/APPS
The Oracle Home Location : /u01/install/APPS/11.2.0
The Oracle E-Business Suite Data File Dir: /u01/install/APPS/data
The Oracle E-Business Suite DBSID : EBSDB
The Oracle E-Business Suite DB TNS Port : 1521
==========================================================
Cloning the DB Tier Completed Successfully
Proeceeding with the Apps Tier Configuration
===================ATTENTION====================================
Successful Configuration of this Virtual Machine requires
connectivity to the E-Business Suite Database Tier
Please Ensure that this host can connect to the DB Tier before
proceeding with the configuration. The sqlnet.ora file on the
Database Tier need to contain the hostname you are going
to use for this Virtual Machine.
============================================================
=======================================
Configuring the Oracle E-Business Suite Application Tier ...
==================================================
Prepare the Pairs File for Application Tier Clone...
===================================================
Pinging the Host b9217d.compute-btoracloud.oraclecloud.internal...
The Host b9217d.compute-btoracloud.oraclecloud.internal is responding
proceeding with the configuration...
==========================================================
Starting Apps Tier configuration
==========================================================
Parameters Used for this Configuration...
The Pairs File :/u01/install/APPS/scripts/inst_apps_pairs.txt
The Source context file used :/u01/install/APPS/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml
The Target context file :/u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml
==========================================================
Configuring the VM as a new Application Tier Node
==========================================================
==========================================================
Configuring the Application Tier File System (fs1)
==========================================================
==========================================================
Cloning the Application Tier Context File
==========================================================
Executing the command perl adcfgclone.pl appsTier /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml dualfs
Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.56
stty: standard input: Inappropriate ioctl for device
Enter the APPS password :
stty: standard input: Inappropriate ioctl for device
stty: standard input: Inappropriate ioctl for device
Enter the Weblogic AdminServer password :
stty: standard input: Inappropriate ioctl for device
Running: Context clone...
Log file located at /u01/install/APPS/fs1/EBSapps/comn/clone/bin/CloneContext_1110232537.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Base Directory set to /u01/install/APPS
Target System Current File System Base set to /u01/install/APPS/fs1
Target System Other File System Base set to /u01/install/APPS/fs2
Target System Fusion Middleware Home set to /u01/install/APPS/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /u01/install/APPS/fs2/FMW_Home
Target System Web Oracle Home set to /u01/install/APPS/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /u01/install/APPS/fs2/FMW_Home/webtier
Target System Appl TOP set to /u01/install/APPS/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /u01/install/APPS/fs2/EBSapps/appl
Target System COMMON TOP set to /u01/install/APPS/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /u01/install/APPS/fs2/EBSapps/comn
Target System Current File System Instance Top set to /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d
Checking the port pool 0
done: Port Pool 0 is free
Report file located at /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml
Check Clone Context logfile /u01/install/APPS/fs1/EBSapps/comn/clone/bin/CloneContext_1110232537.log for details.
Creating Patch file system context file.....
Log file located at /u01/install/APPS/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1110232543.log
Target System Other File System Instance Top set to /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml
Check Clone Context logfile /u01/install/APPS/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1110232543.log for details.
FMW Pre-requisite check log file location : /u01/install/APPS/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check...
Configuring: Run file system....
LogFile located at /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/admin/log/clone/run/RCloneApplyAppstier_11102326.log
Configuring: Patch file system....
LogFile located at /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/admin/log/clone/patch/RCloneApplyAppstier_11102351.log
As we can see, the orchestration also completed the database configuration for EBS, running rapidclone on database and application homes. Towards the end, the summary shows how to connect to the EBS application.
Let me login to the Unix VM as opc user. Need to enable SSH first.
Use Putty, and the private key file to login to Linux VM.
The database and application are on /u01 file system.
“oracle” and “applmgr” users exist.
But, the application directories are owned by “oracle”. So, need to set the application environment and do the service start / stop using “oracle” account only.
Set the Unix environment to login to the database. The database name is EBSDB.
Use /u01/install/APPS/EBSapps.env to set the application environment.
Everything looking good so far.
The Oracle E-Business Suite instance on Oracle Cloud is installed with an internal DNS name and a private IP address, so is not accessible from the public Internet. To make the instance accessible from the public Internet, need to set the web entry point parameters in the applications context file to point to the <publichostname>.<publicdomain> name.
I am going to add a btebs122vision.compute.oraclecloud.com in my laptop hosts file to resolve to the public IP address and use that hostname for this configuration.
[oracle@b9217d APPS]$ /u01/install/scripts/configwebentry.sh
=====================NOTE=======================================
Web Entry Point refers to the host name which is designated to be used by all users to access the Oracle E-Business Suite Release 12.2 system. By default, the web entry point is set to the hostname of the application server where Oracle E-Business Suite is installed. This script can be used to configure a Web Entry Point for the E-Business Suite Application. The Web Entry Point can be the Public Hostname for the virtual machine ebs.company.com or any other device such as a Hardware/Software Load Balancer or a reverse proxy server that can route the requests to the virtual machine ebs.company.com
Press any key to continue...
Enter the values for the following parameters to configure the Web Entry Point
Enter the Web Entry Protocol (Eg: https/http):http
Enter the Web Entry Host Name(Eg: public):btebs122vision
Enter the Web Entry Domain Name:(Eg: domain.com):compute.oraclecloud.com
Enter the Web Entry Port:(Eg: 443/80):8000
Enter the E-Business Suite Base install directory:(Eg: /u01/install/APPS):/u01/install/APPS
The Web Entry Point Parameters in the context file will be updated with
webentryprotcol=http
webentryhostname=btebs122vision
webentrydomain=compute.oraclecloud.com
webentryport=8000
Press any key to continue...
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/install/APPS/fs1/EBSapps/appl
PATCH File System : /u01/install/APPS/fs2/EBSapps/appl
Non-Editioned File System : /u01/install/APPS/fs_ne
DB Host: b9217d.compute-btoracloud.oraclecloud.internal Service/SID: EBSDB
Sourcing the RUN File System ...
Updating variable s_webentryurlprotocol in context file /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http
Updating variable s_webentryhost in context file /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: btebs122vision
Updating variable s_webentrydomain in context file /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: compute.oraclecloud.com
Updating variable s_active_webport in context file /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: 8000
Updating variable s_login_page in context file /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http://btebs122vision.compute.oraclecloud.com:8000/OA_HTML/AppsLogin
Updating variable s_external_url in context file /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http://btebs122vision.compute.oraclecloud.com:8000/OA_HTML/AppsLogin
Updating variable s_chronosURL in context file /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http://btebs122vision.compute.oraclecloud.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
Updating variable s_endUserMonitoringURL in context file /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http://btebs122vision.compute.oraclecloud.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
Updating Context file /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml
Updating variable s_webentryurlprotocol in context file /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http
Updating variable s_webentryhost in context file /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: btebs122vision
Updating variable s_webentrydomain in context file /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: compute.oraclecloud.com
Updating variable s_active_webport in context file /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: 8000
Updating variable s_login_page in context file /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http://btebs122vision.compute.oraclecloud.com:8000/OA_HTML/AppsLogin
Updating variable s_external_url in context file /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http://btebs122vision.compute.oraclecloud.com:8000/OA_HTML/AppsLogin
Updating variable s_chronosURL in context file /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http://btebs122vision.compute.oraclecloud.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
Updating variable s_endUserMonitoringURL in context file /u01/install/APPS/fs2/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.xml with value: http://btebs122vision.compute.oraclecloud.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
Running AutoConfig to complete the configuration
Enter the APPS user password:
The log file for this session is located at: /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/admin/log/12122203/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d
Classpath : /u01/install/APPS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/install/APPS/fs1/EBSapps/comn/java/classes
Using Context file : /u01/install/APPS/fs1/inst/apps/EBSDB_b9217d/appl/admin/EBSDB_b9217d.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........COMPLETED
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 SHT_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.
[oracle@b9217d APPS]$
Stop and Start application using the scripts.
/u01/install/APPS/scripts/stopapps.sh /u01/install/APPS/scripts/startapps.sh
Almost done. We need to complete few more steps before we can login to the application.
A security application is a port mapping.
Let’s add port 8000, which is the EBS URL port.
Add the security application we just created to a security rule.
The URL port is open.
Now we are ready to log in to the EBS 12.2.6 application.
Oops, I don’t know the SYSADMIN password. In fact, I missed a step to enable SYSADMIN and reset the password. Go back to Linux session, and complete the missed step.
Voila! I am in!!
The Application Dashboard shows node status.
Enjoy the EBS 12.2.6 Vision Instance!
