Oracle by Example brandingProvision a New Oracle E-Business Suite Installation on a Single Node on Oracle Cloud Infrastructure

section 0Before You Begin

In this 30-minute tutorial, you will use an image hosted in Oracle Cloud Infrastructure (OCI) to provision an Oracle E-Business Suite 12.2.9 with Oracle Database 19c or 12.1.0.2 demonstration instance on a single virtual machine (VM) on OCI.

Background

Create an Oracle Cloud Infrastructure Compute instance (virtual machine) containing the Release 12.2.9 database and application tiers from the provided image. Use this single-node Vision demonstration instance to evaluate and test standard Oracle E-Business Suite functionality, and demonstrate the standard business flows delivered with the applications. Also use it to become familiar with the technology components of Oracle E-Business Suite Release 12.2 and train your users.

The Oracle E-Business Suite 12.2.9 Demo Install Image can be found in the OCI Console Marketplace and also in the OCI Oracle Images list in your tenancy. Instructions for the OCI Console Marketplace are provided in this document.

Note: Alternatively, you can use the Oracle E-Business Suite Cloud Manager to provision Oracle E-Business Suite in Oracle Cloud, migrate Oracle E-Business Suite environments from on-premises to Oracle Cloud, and conduct subsequent lifecycle management of these cloud environments.  See My Oracle Support Knowledge Document 2517025.1, Getting Started with Oracle E-Business Suite on Oracle Cloud Infrastructure, to understand the complete range of options.

What Do You Need?

  • An Oracle Cloud Infrastructure (OCI) tenancy, with the following associated resources:
    • A compartment
    • A user who is either a tenancy administrator, or who has privileges to manage all resources in the compartment
    • A Virtual Cloud Network (VCN) and an associated subnet which will be associated with the Oracle E-Business Suite instance

section 1Create Instance Using an Image from the OCI Console Marketplace

Follow these steps to create and connect to your Oracle E-Business Suite instance when using an image from the OCI Console Marketplace.

  1. Log in to the OCI Service Console.
    • Select Menu, then Marketplace on the left hand panel under the heading Solutions and Platforms; then Filter by TYPE Image, PUBLISHER Oracle, and CATEGORY Packaged Application.
    • Click on Oracle E-Business Suite 12.2.9 Demo Install Image.
  2. On the resulting screen, do the following:
    • If there are multiple packages, select the latest package version from the dropdown list unless you require an earlier version. Note that the latest version contains Oracle Database 19c.
    • Select the compartment or subcompartment where you wish to install Oracle E-Business Suite.
    • Review and accept the Oracle Standard Terms and Restrictions.
    • Click Launch Instance.
  3. In the Create Compute Instance screen, specify the following:
    • Under Name your instance, enter your choice of name. For example, ebs1229-demo.
    • Under Choose an operating system or image source, you will see the name of the OCI Console Marketplace image: Oracle E-Business Suite 12.2.9 Demo Install Image.
    • Under Availability Domain, make a suitable selection from the displayed options.
    • Under Instance Type, select Virtual Machine.
    • Under Instance Shape, you will see a default shape, such as the VM.Standard2.1 shape. If you want to specify another shape, click on Change Shape.
    • Under Configure networking:
      • Select your Virtual cloud network compartment, for example, my-compartment.
      • Select your Virtual cloud network, for example, my-vcn.
      • Select your Subnet compartment, for example, my-compartment.
      • Select your Subnet, for example, my-subnet.
      • Leave the Use network security groups to control traffic box unchecked.
      • Note: If the VM is associated with a public subnet and you want to assign a public IP address, then select the Assign public IP address option.
    • Under Boot volume, accept the default volume size.
    • Under Add SSH Key, specify the file containing your SSH public key generated previously.
    • Click Create.
  4. Establish SSH Connectivity.

    Review the security lists associated with the subnet to ensure that an ingress rule exists with the following attributes:

    • SOURCE TYPE: CIDR
    • SOURCE CIDR: Enter the CIDR block of your choice. Note that 0.0.0.0/0 corresponds to the public internet. We recommend restricting this to the CIDR block that corresponds to the IP range you want to give access to.
    • IP PROTOCOL: SSH (TCP/22)
    • DESTINATION PORT: 22

    When the instance is fully provisioned and running, connect to it using SSH as described in Connecting to an Instance.

  5. After the instance has been created (provisioned), it will appear in the instance list. To view full details about it, including IP addresses, click the instance name in the list.

section 2Conduct Post-Install Steps

  1. Update Network Configuration.

    First, update the network configuration files to use the logical name "apps.example.com" as the internal host name for the Oracle E-Business Suite application, as follows:

    • Connect as the opc user using ssh to the Oracle Cloud Infrastructure instance that hosts your Oracle E-Business Suite environment:.
        $ ssh -i <SSH private key> opc@<external-IP-address>
    • Switch to the root user.
        $ sudo su - 
    • Execute the updatehosts.sh script.
        # /u01/install/scripts/updatehosts.sh
  2. Update Operating System.

    Perform an operating system update using the following command:

    # yum update 
    Is this ok [y/d/N]: y
    
  3. Update Host Name.

    Set the host name of the virtual machine to apps:

    # hostname apps.example.com

    Note: You will have an opportunity to change the host name later.

  4. Change Passwords.

    To ensure your environment is adequately protected, you must change your Oracle E-Business Suite account passwords.

    • While still logged on to the Oracle Cloud Infrastructure instance that hosts your Oracle E-Business Suite environment, switch from the opc user to the oracle user using the following command:
        $ sudo su - oracle
    • Start the database:
        $ /u01/install/APPS/scripts/startdb.sh 
    • Set the environment:
        $ . /u01/install/APPS/EBSapps.env run
    • To log in through the web interface, you must initially set a password of your choice for the SYSADMIN user. After the SYSADMIN user is active with the new password, you can create new users or activate existing locked users. To enable the SYSADMIN user, run the following commands:
        $ mkdir -p ~/logs
      
      $ cd  ~/logs
      $ sh /u01/install/APPS/scripts/enableSYSADMIN.sh

      When prompted, enter a new password for the SYSADMIN user.

      The SYSADMIN user can now connect to Oracle E-Business Suite through the web interface and create new users or activate existing locked users.

    • For this Vision demo environment, you can run another script to unlock a set of 36 application users that are typically used when demonstrating Oracle E-Business using the Vision database. Run this script with the same environment as when running the enableSYSADMIN.sh script. To enable the demo users, run the following commands:
        $ cd  ~/logs
      $ /u01/install/APPS/scripts/enableDEMOusers.sh

      When prompted, enter a new password.

      Do not run this script on a fresh or production environment.

  5. Enable HTTP Access.

    From the OCI console, add a security rule to the security list.

    • Navigate to Networking, then Virtual Cloud Networks.
    • Select the VCN associated with your instance, such as my-vcn.
    • Identify the subnet associated with your instance, and click on the link for the security list.
    • Click Edit All Rules.
    • Add an Ingress Rule with the following attributes:
      • SOURCE TYPE: CIDR
      • SOURCE CIDR: Enter the CIDR block of your choice. Note that 0.0.0.0/0 corresponds to the public internet. We recommend restricting this to the CIDR block that corresponds to the IP range you want to give access to.
      • IP PROTOCOL: TCP
      • DESTINATION PORT: 8000
  6. Configure Web Entry Point (Optional).

    Use the configwebentry.sh script provided in the /u01/install/scripts directory to change the default webentry point, which is apps.example.com. For instance, you could follow the steps in this example to set the webentry point to myapps.example.com and access the application using http://myapps.example.com:8000/OA_HTML/AppsLogin:

    $ /u01/install/scripts/configwebentry.sh 
    Enter the Web Entry Protocol (Eg: https/http): http
    Enter the Web Entry Host Name(Eg: public): myapps 
    Enter the Web Entry Domain Name:(Eg: example.com): example.com
    Enter the Web Entry Port:(Eg: 443/80): 8000 
    Enter the ORACLE_SID:(Eg: EBSDB): ebsdb 
    
    
    Running AutoConfig to complete the configuration
    
    Enter the APPS user password:  apps_password (for example, apps)
  7. Update Local Hosts File.
    • Update the Local Hosts File on Windows:
      • Find the hosts file you want to modify.
      • Open the file explorer to open the following directory: C:\\Windows\System32\drivers\etc
      • As you CANNOT edit in this folder, perform the following:
        • Copy this ‘hosts’ file to your desktop.
        • Edit the hosts file with a text editor.
        • Add 1 line IP address and host name: <external-IP-address> <hostname>
          Your host name may be apps.example.com, or the host name you configured in step 6 (such as myapps.example.com).
      • Once added, save the file as ‘hosts’ file without any extension.
      • Then, you can copy back to the original folder.
      • Confirm to replace as administrator.
    • Update the Local Hosts File on Mac:
      • On your Mac, open the Terminal application.
      • Change to the folder where you will find the hosts file.
          $ cd /etc
      • Use the following vi command to edit the file:
          $ sudo vi hosts 
      • Add your host name and save the file.
          <external-IP-address> <hostname>
  8. Log on to Applications.
    • As the Oracle user, start the application tier services.
         # sudo su - oracle 
       $ /u01/install/APPS/scripts/startapps.sh 
    • You can now access the applications using http://<hostname>:8000/OA_HTML/AppsLogin.

      For instance, if your host name is myapps.example.com, your login will be: http://myapps.example.com:8000/OA_HTML/AppsLogin

  9. Acknowledge the secure configuration recommendations.

    Access to the environment will be restricted until the system administrator configures or acknowledges the secure configuration recommendations.

    To access the Secure Configuration Console, a user must have a responsibility that includes the Applications System (OAM_APP_SYSTEM) function privilege, such as the seeded System Administration or System Administrator responsibilities, and must be registered as a local user with Oracle E-Business Suite. The administrator must log in to Oracle E-Business Suite using the local login page (http(s)://[host]:[port]/OA_HTML/AppsLocalLogin.jsp) to navigate to the console and unlock the system. If a user with local system administrator privileges is not available, you can access the Secure Configuration Console through a command line utility. For more information, see "Secure Configuration Console" in the Oracle E-Business Suite Security Guide.

    Description of scc.jpg follows
    Description of the illustration scc.jpg

    Note: Once the system is "Unlocked" for normal usage, the Secure Configuration Console is still available for administrators under the 'Functional Administrator' responsibility.


more informationWant to Learn More?