Oracle Cloud Applications: Standard Infrastructure Installation Guide
Oracle Cloud Applications: Standard Infrastructure Installation Guide
Oracle Cloud Applications: Standard Infrastructure Installation Guide
Version 5
Feb 2020
DISCLAIMER:
This guide may contain screen shots and output reports to facilitate the user comprehension about the
topic. The content represents a fictitious sample. Any similarity to actual persons, living or dead, or
company names, active or inactive, is purely coincidental and not intended in any manner.
TABLE OF CONTENTS
TABLE OF CONTENTS ..............................................................................................................................................2
PLANNING THE LATIN AMERICA CLOUD LOCAL SOLUTION INFRASTRUCTURE INSTALLATION ................................5
STANDARD INFRASTRUCTURE TOPOLOGY FOR LATIN AMERICA CLOUD LOCAL SOLUTION ................................................... 5
SYSTEM REQUIREMENTS .......................................................................................................................................... 6
ROADMAP TO CONFIGURE A STANDARD INFRASTRUCTURE TOPOLOGY FOR LACLS ..................................................................... 8
VALIDATE LATIN AMERICA CLOUD LOCAL SOLUTION STANDARD INFRASTRUCTURE INSTALLATION ................... 39
2
Revision History
This document will continue to evolve as existing sections change and new information is added.
3
ABOUT THIS DOCUMENT
This document approach Provisioning and Setup steps to configure the infrastructure required to
support and run Latin America Cloud Local Solution (LACLS).
The purpose of this document is to define a roadmap to guide you through to set up and configure steps
for the Oracle Cloud Services required to support LACLS solutions. This document does not replace the
specific Oracle Documentation about Oracle Cloud Products covered in this guide.
INTENDED AUDIENCE
This document is intended for technical users, primarily database administrators, database application
developers and cloud infrastructure analysts who are new to LACLS. It assumes you have a working
knowledge of the following:
If you are not used to Oracle Cloud Infrastructure concepts and usage, we suggest you attend one or
more of the Oracle Cloud training classes available through Oracle University.
PLANNING THE LATIN AMERICA CLOUD LOCAL SOLUTION INFRASTRUCTURE
INSTALLATION
The Standard infrastructure for the Latin America Cloud Local Solution includes:
Oracle Integration Cloud (OIC) instance. Where the Integration Connectors and User Interface
are hosted.
Oracle Financials Cloud instance. Where LACLS connects to reach transactional data.
ERP Services
HCM Supply
3rd party cloud
Oracle Integration Cloud Marketing Chain
Sales
5
SYSTEM REQUIREMENTS
This document does not cover the provision of services or the installation of additional components of
DBCS and OIC required for LACLS solutions.
Before proceeding with the configuration steps described in the next sections of this guide, make sure
that all the SYSTEM REQUIREMENTS listed have been fulfilled.
Provide a DBCS instance with the stated minimum recommended. Please refer to the Bare
Metal and Virtual Machine DB Systems Documentation for details about the provisioning of
this service.
Notes:
Once the DBCS instance is provisioned, install and configure the mandatory APEX and ORDS
Standalone database components. Please refer to Installing Application Express and
Configuring Oracle REST Data Services for more details about this.
IMPORTANT:
6
to public networks/Internet. If this is the case, consider obtaining a TLS/SSL server
certificate signed by a Certificate Authority (CA), to use with ORDS. Please refer MOS
note 2350013.1 for more details.
Provide an OIC instance with the stated minimum recommended. Please refer to the
Integration Cloud for details about the provisioning of this service.
Notes:
A minimum of 10k messages per hour is recommended for a full installation of LACLS solutions in
a production environment. If you choose to do a partial installation of these solutions, you can
start in 5k messages per hour and escalate the OIC instance later if necessary.
For development and test environments, 5k of messages per hour is enough for most cases.
Once the OIC instance is provisioned, install and configure the mandatory On-Premises
Connectivity Agent. Please refer to Manage the Agent Group and the On-Premises
Connectivity Agent for more details about this.
7
ROADMAP TO CONFIGURE A STANDARD INFRASTRUCTURE TOPOLOGY FOR LACLS
There are a series of steps to configure a standard Infrastructure topology to support LACLS. This
document has all steps you need to configure this.
Configuring LACLS Database Schema with APEX and Enable LACLS DB schema to work with APEX and ORDS in DBCS
ORDS
Configuring Oracle Integration Cloud (OIC) Configures OIC trusted certificates; Create and test a Database
Connection using ADAPTER with Connectivity Agent and Create and
test a Database Connection using REST.
Testing OIC REST Data Service connection Use Oracle Integration to create and execute a new Integration
using REST to the new deployed database instance and validate the
installation.
Testing OIC ADAPTER connection Use Oracle Integration to create and execute a new Integration
using ADAPTER to the new deployed database instance and validate
the installation.
8
CONFIGURING LATIN AMERICA CLOUD LOCAL SOLUTION STANDARD
INFRASTRUCTURE
The following steps guide you through to deploying LACLS database repository by creating a exclusive
Tablespace and User with the required privileges.
Important:
LACLS repository must be created in the same pluggable database (PDB), used in the installation of
APEX and ORDS. If you have chosen to install APEX and ORDS in the cdb$root, then before
proceeding to the next step you must create a new PDB to receive the LACLS schema.
9
Complete the form with required fields.
10
Click save, then click Test
Customers installing LACLS must configure the LACLS schema to receive future database objects
from LACLS solutions. The lacls_create_dbcs_schema.sql required to provision the new schema
is available in the LACLS Install Pack. This pack stores all the scripts to create database objects one
by one. The files are available in LACLS Install Pack. Please refer to MOS Note 2588752.1, Section
3, Table 3.1.1, to download the latest available pack.
a. In SQL Developer, connect with SYS as SYSDBA and run the lacls_create_dbcs_schema.sql to
create LACLS database schema.
Note:
This script will create a new "LACLS" tablespace and the "lacls" user with required privileges.
11
Execute lacls_create_dbcs_schema.sql script
Note:
This script will require you to enter a password for the new LACLS user to be created. Please
enter the password for the LACLS user when prompted.
12
3. Configure a database connection to LACLS User in SQL Developer
a. Execute SQL Developer.exe and create a new database connection to LACLS user in PDB
13
Complete the form with required fields.
14
Click save, then click Test
15
CONFIGURING LACLS DATABASE SCHEMA WITH APEX AND ORDS
This is the final step to validate if previous configurations are working fine. Please follow the next steps
to validate your installation:
16
Complete the fields and click on Next
17
Complete the fields and click on Next
18
Click in Done to finish
19
Logout INTERNAL workspace
a. Login Oracle Application Express with LACLS Workspace and enable ORDS to schema.
20
Change user password (required in first login)
21
Go to SQL Workshop
22
To finish, click in Register Schema with ORDS to enable LACLS schema
23
Check ORDS Status for LACLS Schema
24
Select the “administration Icon” > Manage User and Groups
25
26
CONFIGURING ORACLE INTEGRATION CLOUD (OIC)
In this session we will configure the OIC instance with the trusted certificates and create and test a
Database Connection using ADAPTER with Connectivity Agent and also create and test a Database
Connection using REST. These components will be used by the integrations to access the LACLS database
schema. Please refer to the Create Connection documentation and Install the Connectivity Agent
documentation for more details about these steps.
1. Create and validate an Integration Database Connection using ADAPTER with Connectivity
Agent.
27
Now, click in Configure Connectivity and provide the connection properties.
Note:
This information can be found in the DBCS Instance details panel, through the Oracle Cloud
services console
Click in OK to save the Connection properties and click in Configure Security to provide
the LACLS database user credentials.
28
Click in OK to save the Security properties and go to Configure Agents to provide the
Agent Group. Choose the <DB AGENT GROUP> and click in Use to confirm.
29
Complete the fields as in the figure and click in Create.
On the right side, click on Configure Connectivity, complete the fields and click on OK
30
On the right side, click in Configure Security Button
31
3. Import ORDS certificate as trusted in Oracle Integration.
32
Click next > Select DER option > click Next > Choose the file location and save under
name ORDS.der
33
Go to Oracle Integration Cloud (OIC)
34
4. Import ERP certificate as trusted in Oracle Integration.
35
Click Next > Select DER option > click Next > Choose the file location and save under
name ERP_CLOUD.der
36
Go to Oracle Integration Cloud
37
Click on right button Upload
38
VALIDATE LATIN AMERICA CLOUD LOCAL SOLUTION STANDARD
INFRASTRUCTURE INSTALLATION
This is the final step to validate if previous configurations for REST are working fine
A Test Integration must be created to check the integrity of REST endpoints by performing a simple SQL
query to the Sample table. If the integration succeeds on its execution it means all configurations and
components are working fine.
The file is available in LACLS Install Pack. Please refer to MOS Note 2588752.1, Section 3, Table
3.1.1, to download the latest available pack. As reference use the Section 2, Image 2.1.1 to identify
the directories where the .par file can be found.
39
5. Activate the integration by clicking the Switch button
The following screen appears. Activate the traces as per your desire and click in the Activate
button
7. Navigate to Monitoring Tracking and follow how integration is executed. If it succeeds means
your configuration is fine, otherwise, check the Integration Logs to diagnose the problems
40
41
TESTING OIC ADAPTER CONNECTION
This is the final step to validate if previous configurations for OIC Agent and connections are working fine.
A Test Integration must be created to check the integrity of agents by performing a simple SQL query to
the DUAL table. If the integration succeeds on its execution it means all configurations and components
are working fine.
The file is available in LACLS Install Pack. Please refer to MOS Note 2588752.1, Section 3, Table
3.1.1, to download the latest available pack. As reference use the Section 2, Image 2.1.1 to identify
the directories where the .par file can be found.
42
The following screen appears. Activate the traces as per your desire and click in the Activate
button
14. Navigate to Monitoring Tracking and follow how integration is executed. If it succeeds means
your configuration is fine, otherwise, check the Integration Logs to diagnose the problems
43
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject
to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose.
We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not
be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of
SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered
trademark of The Open Group.
44