12 Days of #Cloud: Building #Oracle #EBS Instance

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!

 

 

One Reply to “12 Days of #Cloud: Building #Oracle #EBS Instance”

Comments are closed.