Enable RESTful Management Services in Weblogic Server 12c

The Restful management services is one of the important features of Weblogic Server 12c. The Restful management services allows to monitor the running Weblogic Server instances which includes :

  • Applications running in Weblogic Server
  • Data Sources configured in Weblogic Server
  • Servers including Admin Server and Manager Servers
  • Clusters with multiple machines in distributed WebLogic Infrastructure

The RestFul management services allows HTTP GET methods and supports restful formats like XML, JSON and HTML

The Restful management services provides the capability to call through any Restful Client supporting languages like python, cURL , built -in web client and JavaFX application

Pre-requisite for RestFul Management Services

The below configurations are required for RestFul management services

  • Oracle Weblogic Server 12c
  • Python 2.7 +
  • JDK 7+
  • Operating System like Windows, Linux , MacOS

How to enable Restful Management Services in Weblogic Server 12c

The below steps need to be performed to enable the Restful management services in Oracle Weblogic Server 12c

  • Log into Weblogic Server Admin Console
  • Click on Lock &Edit to create new session for making server changes
  • Navigate Home-> Domains -> Configurations-> Advanced
  • Check Enable Restful Management Services

Enable RestFul Management Services

  • Restart the Weblogic Server

How to Enable Restful Management Services usign Weblogic WLST

  • Log in as Weblogic User and start Weblogic Shell Script
[wls@mach01]$ $WL_HOME/common/bin/wlst.sh
  • Connec to Weblogic Server Admin using admin credentials and t3 URL
wls:/offline>connect("wlsadmin","","t3://mach01.domain.local:<port>")
  • Execute the below given WLST commands to enable Restful Services in Weblogic Server 12c
edit()
startEdit()
cd('/RestfulManagementServices/DEV_SOADOMAIN')
cmo.setEnabled(true)
save()
activate()
exit()
  • Restart WebLogic Administration Server and managed servers

How to test Restful Management Services

  • Ensure that the Weblogic Server is restarted with the enablement of Restful Management Services checkbox

Restful Management Services to retrieve Server Health State

http://<host>0:<port>/management/tenant-monitoring/servers
  • The blow details are shown

Test RestFul Management Services

Restful Management Services to retrieve Single Server details

http://localhost:7101/management/tenant-monitoring/servers/DefaultServer

Single Server details using Weblogic Restful Services

Restful Management Services to retrieve Weblogic Data Source details

http://localhost:7101/management/tenant-monitoring/datasources

Data Source details using Weblogic Restful Services

References: 

Oracle WebLogic RESTful Management Services: From Command Line to JavaFX


Oracle EBS R12 Concurrent Request Log and Trace File SQL

The blog provides useful SQL Queries for Identifying the Concurrent Request Log File details and Concurrent Request Trace File details

SQL Query to retrieve Concurrent Request Log File

SELECT  'LOGFILE_NAME=' || logfile_name
FROM    FND_CONCURRENT_REQUESTS
WHERE   request_id = &req
SELECT  'OUTFILE_NAME=' || outfile_name
FROM    FND_CONCURRENT_REQUESTS
WHERE   request_id = &req

SQL Query to retrieve Concurrent Request Log File on a specific Concurrent Manager Node 

SELECT  'LOGFILE_NODE_NAME=' || logfile_node_name
FROM    FND_CONCURRENT_REQUESTS
WHERE   request_id = &req

SELECT  'OUTFILE_NODE_NAME=' || outfile_node_name
FROM    FND_CONCURRENT_REQUESTS
WHERE   request_id = &req

SQL Query to retrieve Concurrent Request Trace File 

COLUMN TRACEID FORMAT A8
COLUMN TRACENAME FORMAT A80
COLUMN USER_CONCURRENT_PROGRAM_NAME FORMAT A40
COLUMN EXECNAME FORMAT A15
COLUMN ENABLE_TRACE FORMAT A12
SET LINES 80
SET PAGES 22
SET HEAD OFFSELECT 'REQUEST ID: '||REQUEST_ID ,
'TRACE ID: '||ORACLE_PROCESS_ID,
'TRACE FLAG: '||REQ.ENABLE_TRACE,
'TRACE NAME:
'||DEST.VALUE||'/'||LOWER(DBNM.VALUE)||'_ORA_'||ORACLE_PROCESS_ID||'.TRC',
'PROG. NAME: '||PROG.USER_CONCURRENT_PROGRAM_NAME,
'FILE NAME: '||EXECNAME.EXECUTION_FILE_NAME|| EXECNAME.SUBROUTINE_NAME ,
'STATUS : '||DECODE(PHASE_CODE,'R','RUNNING')
||'-'||DECODE(STATUS_CODE,'R','NORMAL'),
'SID SERIAL: '||SES.SID||','|| SES.SERIAL#,
'MODULE : '||SES.MODULE
FROM APPS.FND_CONCURRENT_REQUESTS REQ, V$SESSION SES, V$PROCESS PROC,
V$PARAMETER DEST, V$PARAMETER DBNM, APPS.FND_CONCURRENT_PROGRAMS_VL PROG,
APPS.FND_EXECUTABLES EXECNAME
WHERE REQ.REQUEST_ID = &REQUEST
AND REQ.ORACLE_PROCESS_ID=PROC.SPID(+)
AND PROC.ADDR = SES.PADDR(+)
AND DEST.NAME='USER_DUMP_DEST'
AND DBNM.NAME='DB_NAME'
AND REQ.CONCURRENT_PROGRAM_ID = PROG.CONCURRENT_PROGRAM_ID
AND REQ.PROGRAM_APPLICATION_ID = PROG.APPLICATION_ID
AND PROG.APPLICATION_ID = EXECNAME.APPLICATION_ID
AND PROG.EXECUTABLE_ID=EXECNAME.EXECUTABLE_ID;

Oracle Event Processing (OEP) features in SOA Suite 12c

Oracle Event Processing (OEP) 12c is used for design, develop and deploy the complex event processing applications that needs monitoring of real-time streaming events (IoT) providing high throughput and low latency platform. 

Oracle Event Processing consists of the below given components
1. Oracle Event Processing server : where the Oracle Event Processing applications are hosted / deployed
2. Oracle Event Processing Visualizer: web based interface to configure, deploy and manage Oracle Event Processing applications
3. Command-line administrative interface : command line interface to start and stop domains , deploy , resume or uninstall an application on Oracle Event Processing Server.
4. Oracle JDeveloper IDE : enables to design, develop and deploy the Oracle Event Processing applications

An Oracle Event Processing application receives and processes data streaming from an event source. Oracle Event Processing follows the event-driven architecture called SEDA which is comprises of into a set of stages (nodes) connected by queues. Oracle Event Processing application, the channel represents queues, other components are considered as stages in the processing.

The Event Processing Network (EPN) is the combination of stages and queues for processing the data streaming and helps in performing the below execution steps

  1. Input received in EPN is through and adapter.
  2. Adapter converts input into an event
  3. An event is processed from one stage to another stage using channels / queues.
  4. Events are similar to database rows and acts as tuples to execute queries with Oracle Continuous Query Language (Oracle CQL) desinged to execute streaming data.
  5. Each stage can make connections with external components if required for processing logic. Stages also enable to capture multiple processing paths connected with multiple downstream for processing streaming data.

Oracle Event Processing Application development in JDeveloper

Project Templates: Oracle Event Processing applications can be developed using the below provided application templates.

OEP Application Templates OEP Application Template Description
Empty OEP Project  template provides the basic structure for Oracle Event Processing applications
FX Template template useful for simulating a Foreign Currency exchange application  
Hello World Template simple OEP application sending Hello World message to the server
Signal Generation Template template useful for simulating events and generating signal for the change in price or volumes data streaming 

Oracle Event Processing project Options:

Oracle Event Processing project provides the below actions to be performed in the context menu.

OEP context Menu Option OEP context Menu Option Description
Open EPN Diagram

The EPN Diagram provides many features and is used as the Optimised layout. It allows to create Event Types to carry event data using Java Bean or Tulep Event Type and is registered in the Event Type Repository.  It allows to Add Component onto an empty area in the EPN to build the EPN diagram

Configure JDBC Context Allows to create an application context with the instance of Oracle JDBC Data
Configure Spatial Context Allows to to manage large number of moving objects like polygons,circles,3D positioning and spatial clustering
Deploy > oep-profile Allows to deploy Oracle Event Processing  application deployment bundle
Deploy > New Deployment profile Allows to deployment profile for the  Oracle Event Processing application
Encryption Manager
Allows to to encrypt the application

EPN Components:

Oracle Event Processing application comprises of different components to be added in the EPN. These components allows to create Event Types, handling inbound and outbound adapter data streaming , helps in using CQL query code and perform various other operations. 

EPN component  EPN Component Description
Adapter Allows OEP application to connect to External Input or outputdata data for processing
Beans Allows to create Event Beans using Java Spring technology for handling event business logic
Cache Allows to create a Cache System Component in the EPN to create space / area for random access memory (RAM) that holds recently accessed data by an OEP application
Channel Allows to to transfer events from stage to stage in the EPN
Event Bean Allows to create application event logic in Java 
Processor Allows to create CQL query code to read data from big data Hadoop or NoSQL Database.
Table as an external relation source to store events in the database , configured as a listener 

Advanced Adapters in OEP Application:

Below given are the advanced adapters which can be used in the Oracle Event Processing application to connect to External Input or output data data for processing.

Adapter Name  Adapter Description
CVS Inbound Adapter Allows to READ data in the form of commaseparated values in the EPN
CVS Outbound Adapter Allows to SEND data in the form of commaseparated values from the EPN
HTTP Publisher Adapter Allows to SEND JavaScript Object Notation (JSON) event data from EPN to a web-based user interface
HTTP Subscriber Adapter Allows to READ JavaScript Object Notation (JSON) event data sent from HTTP Server to EPN.
JMS Inbound Adapter Allows to READ Java Message Service (JMS) topics data in the EPN
JMS Outbound Adapter Allows to SEND Java Message Service (JMS) topics data from the EPN
REST Inbound  Adapter Allows to READ events from HTTP Post requests
REST Outbound  Adapter Allows to SEND events in REST format from EPN

OEP integration with Big Data Extensions: 

The Oracle Event Processing applications handles huge volume of event data which needs to be processed and stored.  The below given are the big data extensions being used with OEP applications for storing huge event data providing  high throughout and low latency.

Database Name  Database Description
Hadoop Database  Oracle CQL processor executes large data volumes using non-relational data store Hadoop distributed file system (HDFS)
NoSQL Database Oracle CQL processor executes large data volumes using Oracle NoSQL Database which stores data in key-value pairs
HBase Database Oracle CQL processor executes large data volumes using HBase Database

Cache system in Oracle Event Processing: OEP provides the below mechanism for providing cache using OEP applications.

Cache System Description
Coherence Cache System OEP provides Coherence Cache System component to maintain the data stored on a shared resource
Local Cache System OEP provides Local Cache System to access data files through network

CQL Patterns in Oracle Event Processing:

Oracle CQL patterns are stored within the context of an Oracle CQL processor and helps in Oracle CQL query formation. 

CQL Pattern CQL Pattern Description
Averaging Rule The component helps nin computing an average for the specified number of events (table rows)
Detect Missing Event Rule The component in identifying the expected event that does not occur
Partitioning Rule The component performs the event panel partition by an event property and display partitioned events
Select With Subsequent Filtering Query The component filter events to populate the view with events that pass the filter criteria.
Select From Multiple Streams The component joins two streams to select from correlated events
Select With From The component select events from a channel according to the specified properties
Select With Pattern Matching The component select events from a channel according to specified property values

WLS Extensions in Oracle Event Processing:

WLS Extension Name  WLS Extension Description
RMIInbound The adapter helps in receiving incoming data sent from Oracle WebLogic Server over the remote method invocation (RMI) protocol
RMIOutbound The adapter helps in sending outgoing data to Oracle WebLogic Server over the remote method invocation (RMI) protocol

EDN Adapters in Oracle Event Processing:

WLS Extension Name  WLS Extension Description
EDNInbound The adapter helps in receiving incoming data from the Oracle SOA Suite event network

EDNOutbound The adapter helps in sending outgoing data to the Oracle SOA Suite event network

 

Points to Consider:

  • EPN components helps in exchanging data with external sources like external databases, caches, HTTP messages, Java Message Service (JMS) messages, files, and big data storage.
  • Event Data is modelled as event types so that it can be accessed by the Oracle Event Processing application.
  • Oracle Continuous Query Language (Oracle CQL) helps in querying the streaming data
    Oracle Event Processing applications supports Spring Framework for writing Java Classes for adding additional logic as Spring beans to retrieve and send event data like other EPN components
  • OSGi (Open Services Gateway initiative) that that implements a complete and dynamic component model in the form of Bundles for deployment and can be installed, started, stopped, updated, and uninstalled remotely. Oracle Event Processing application components are assembled and deployed as OSGi bundles.
  • XML configuration file: Oracle Event Processing configuration files are defined in XML like assembly file which provides mapping between EPN stages and other design-time configurations
  • Hadoop / NoSQL Integration:  Oracle Event Processing can access the data from big data Hadoop or from NOSQL Database using the CQL query code. 
  • REST Adapters: Oracle Event Processing integrates with REST Inbound and Outbound Adapters to consume events from HTTP POST requests to be processed by the EPN.
  • Oracle Business Rules: Oracle Event Processing integrates with Oracle Business Rules to develop custom business logic in OEP applications.

REFERENCES:

Oracle Middleware Event Processing


Describe SOA Suite’s role in cloud integration and mobile applications ?

SOA Suite is one of the popular middleware integration mechanism for providing service based integrations in the heterogeneous environment.  With the increased demand for Cloud based and mobile integrated applications, Oracle SOA Suite 12c  provides enhanced features providing SOA Solutions for On-premises applications, cloud based applications, mobile applications and Internet of Things (IoT). It also provides support for lightweight REST and JSON integration standards.

Oracle SOA Suite 12c cloud and mobile integration features

The below given are the enhanced features provided in the SOA Suite 12c release

End-to-End-Integration Flow: SOA Suite provides the improved integration process which helps in automating the data flow integrations across third party systems, external services, cloud based applications and thus reduces speed time to market, increase productivity, and lower costs

SOA suite In-built cloud application adapters:  SOA Suite 12c provides support for adapter integration to connect virtually any application , service, data store, ,messaging system including the  in-built cloud application adapters for  on-premises as well Cloud based applications. The below given are the few SOA Suite cloud adapters available as part of SOA Suite installation

Component Name Cloud Adapter Connector 
CX Connectivity 
  • Oracle Commerce Cloud
  • Oracle CPQ Cloud
  • Oracle Eloqua Cloud
  • Oracle Engagement Cloud
  • Oracle Service Cloud (RightNow)
  • SAP Commerce Cloud (Hybris)
Database Connectivity 
  • Oracle Database Cloud Service
Enterprise Messaging Connectivity 
  • Oracle Messaging Cloud Service
ERP Connectivity
  • Oracle ERP Cloud
  • Oracle EPM Cloud
  • Oracle Utilities Cloud
  • Oracle Logistics Cloud
HCM Connectivity
  • Oracle Cloud HCM
  • Oracle Talent Acquisition Cloud Service (Taleo Enterprise Edition)

Business Activity Monitoring: Oracle SOA Suite provides business analytics with Oracle Business Activity Monitoring (BAM) for real-time operational intelligence for mission-critical business processes

Oracle Managed File Transfer (MFT)  Service: Oracle SOA Suite provides easy to use web based design tool for Oracle Managed File Transfer Cloud Service to securely exchanges files between internal and external FTP Servers . It also supports PGP encryption and decryption of files,  file transfer reporting for quick data analysis,  file purge scripts , file notification mechanism.  Oracle MFT also provides dashboard metrics to track file size, file volume, and elapsed time for inbound and outbound transfers and service endpoints. 

Oracle Event Processing:Oracle Event Processing (OEP) 12c is used for design, develop and deploy the complex event processing applications that needs monitoring of real-time streaming events (IoT) providing high throughput and low latency platform. 

Oracle Event Processing consists of the below given components
1. Oracle Event Processing server : where the Oracle Event Processing applications are hosted / deployed
2. Oracle Event Processing Visualizer: web based interface to configure, deploy and manage Oracle Event Processing applications
3. Command-line administrative interface : command line interface to start and stop domains , deploy , resume or uninstall an application on Oracle Event Processing Server.
4. Oracle JDeveloper IDE : enables to design, develop and deploy the Oracle Event Processing applications

Virtual Administrative Access: Oracle SOA Suite provides the web based console and connectivity to Virtual machines using SSH and provides all integration capabilities at one place which reduces the complexity and overall maintenance cost. 

SOA Composite deployment on Cloud or on-premises Environment: Oracle SOA Suite allows to deploy the SOA composites for  on-premises or in the SOA cloud environment to optimize security, cost, and regulatory requirements.

REFERENCES:

Oracle SOA Integration features

Oracle SOA Application Adapters

 

 


Oracle SOA 12c tutorial on JCA Adapter Architecture

The blog contains the detailing about Adapter Role in composite application, features of JCA Adapters, Adapter types, File Adapter interview questions, FTP Adapter interview questions, File / FTP Adapter configurations, File / FTP Adapter Design and Run-time properties. The blog could be helpful in the preparation of oracle SOA Suite 12c essentials 1z0-434 Certification.

Describe the adapters role in a SOA composite application ? 

Oracle JCA Adapters provides the standard based integration framework for integrating SOA Services with packaged applications, legacy applications, Database systems and with other custom web services.  JCA Adapters enables to integrate application running in heterogeneous environment ( services available from different vendors, running on different technologies , deployed on different environments like Unix, Linux , solaris, etc)

SOA applications with JCA Adapter integration provides a robust, lightweight, highly-scalable applications ensuring high interoperability.

Features of JCA Adapters:

  1. JCA Adapters provides the connectivity platform to integrate applications with mainframe and legacy applications with ERP and CRM applications, packaged applications like SAP and Siebel , databases, and messaging systems ( like Messaging Queues, Oracle Adavanced Queue). 
  2. JCA Adapters are built on standard  like J2EE Connector Architecture (JCA) version 1.5, Extensible Markup Language (XML), and Web Service Definition Language (WSDL) and reduces the dependency on a single vendor. 
  3. SOA Composite applications integrated with JCA Adapters implements SOA Component Architecture (SOA)  which provides the service details and its inter-dependencies and represent the business logic as a reusable service components.
  4. JCA Adapters support open standards which enables it to implement Service-Oriented Architecture (SOA) and thus provides loose coupling, flexibility, and extensibility.
  5. JCA Adapters provides supports integration with other back-end applications and transforms native APIs to standard XML and back. The adapters can be configured during design time to support such integrations.   
  6. JCA Adapters provides two-way communication for supporting real-time event notifications with other back end applications like creating, updating and deleting the data.  This reduces the cost of integration and provides fast & reliable integration.
  7. J2CA 1.5 specification in the JCA Adapters provides  high scalability and availability of the Oracle Application Server platform.
  8.  JCA Adapters provides the user interface for configuring the adapter properties during design time and helps in easy implementation and deployment activities.
  9. JCA Adapters provides integration with the JCA Binding component of Oracle Fusion Middleware platform and thus can be integrated with other binding components and service engines seamlessly. 

Describe the JCA adapter architecture ? 

The JCA Adapter integration allows to communicate with the Legacy applications, packaged applications, Databases and Oracle applications like ERP and CRM.  The JCA Adapter  can be classified into the below given categories:

  1. Oracle Technology Adapters
  2. Legacy Adapters
  3. Oracle E-Business Suite Adapters
  4. Packaged Applications Adapters

The below given is the High Level Architecture for JCA Adapters

JCA Adapter Architecture Diagram

What are Oracle Technology Adapters ? 

The Oracle Technology Adapters allow to integrate Oracle application Server and Oracle Fusion Middleware components like BPEL Process Manager, Mediator to File / FTP systems, Database Systems including Tables and Advanced Queue (AQ), Java Message Services (JMS) and message queues (MQ Series). 

The adapters are configurations can be done using JDeveloper at the Design-time which generates JCA Binding XML Configuration files to be used by the JCA Binding Components for the seamless integration among applications.

The Oracle JCA technology adapters are deployed in the J2CA container of the Oracle WebLogic Server and alloes to integrate with JCA Binding components to convert Web service messages into J2CA interactions and vice-versa. The Oracle Fusion Middleware integrates the request-response service with a SCA composite reference and publish the adapter events to a SCA composite service.

Oracle Technology Adapters are based on J2EE Connector Architecture (JCA) 1.5 standards. These adapters are deployed as a resource adapter in the same Oracle WebLogic Server as Oracle Fusion Middleware. The connection factory details for technology adapters are updated in the weblogic-ra.xml to be read by Weblogic Server during run-time.

Oracle Technology Adapters Architecture

Oracle Technology Adapter Architecture Diagram

The below given technology adapters can be used for application integrations.

  1. Oracle JCA Technology Adapter for Files/FTP
  2. Oracle JCA Technology Adapter for Sockets

  3. Oracle JCA Technology Adapter for AQ

  4. Oracle JCA Technology Adapter for JMS

  5. Oracle JCA Technology Adapter for Database

  6. Oracle JCA Technology Adapter for MQ Series

  7. Oracle JCA Technology Adapter for UMS

  8. Oracle JCA Technology Adapter for LDAP

  9. Oracle JCA Technology Adapter for Microsoft Message Queueing

  10. Oracle JCA Technology Adapter for Coherence

  11. Oracle JCA Technology Adapter for JDE Edwards World

You can also read the below given blog on the Technology Adapter Configuration at Design -Time and other related properties.

SOA 12c DB Adapter Polling Configuration at design -time

SOA 12c DB Adapter configuration for reading table data

SOA 12c Enable Trigger File Option in File Adapter

SOA 12c File Adapter Read File Configuration at design time 

 

What are Legacy Adapters ?

Legacy adapters integrate Oracle Application Server with legacy and mainframe applications using legacy communication protocols. The legacy adapters comprises of 3 components ( Oracle Connect, Oracle Studio and J2CA Adapters) for integration with the legacy applications.

Oracle Connect: Oracle Connect components resides in the mainframe / legacy systems and includes native adapters which help in communicating Oracle Application Server with the Legacy Systems for data exchange.

  • Server Processes: includes multiple servers to process client requests
  • Native Adapters: Provides various native adapters to communicate with Tuxedo and IMS-TM transaction systems, database and file systems on mainframe systems such as VSAM and IMS-DB
  • Native adapters: It  converts legacy applications data to XML format.
  • Daemon: is an RPC-based listener deployed on legacy system and helps in managing multiple server configurations like user authentication, user authorization, connection allocation and server process management.
    Repository: Oracle Connect deployed on leagacy systems provides repository for strong XML based schema and configurations like user profile to enable single sign-on, connection configurations, adapter metadata such as adapter request -response and adapter event services.
    Oracle Legacy Adapter Architecture Diagram

J2CA Adapter: The applications deployed on Weblogic server communicates with the Oracle Connect on legacy systems using the J2CA Adapter for the data exchange.

Oracle Studio: It provides the design-time tool for configuring Oracle AS Adapters for mainframes like configure services, configure events, adapter connection information,etc.

What are Packaged Application Adapters ? 

These adapters allow to integrate Oracle Application Server with other available packaged applications like SAP , Siebel , PeopleSoft and JDEdwards. 

The JCA Packaged application adapters can be deployed as J2EE Connector Architecture (J2CA) 1.5 resource adapters ,  or the JCA Packaged application adapters can be deployed as Web service servlets within the Oracle WebLogic Server container.  

With support for J2CA interface, it also supports the Web Service Definition Language (WSDL) and Simple Object Access Protocol (SOAP) interface.  
weblogic-ra.xml contains the connection name defined in the repository project as part of J2CA deployment.

JCA Packaged Application Adapter Architecture Diagram

Application Explorer is a Java swing-based design-time tool for configuring packaged-application adapters. Application Explorer works with BSE (Business Service Engine) and deployed in the Oracle Application Server , uses SOAP Protocol for accepting requests. The schemas can be defined as XSD, BSE or WSDL with SOAP Binding. 

The below given adapter are available for integrations

  1. OracleAS Adapter for PeopleSoft

  2. OracleAS Adapter for SAP R/3 (availble as “out of the box” Adapters with SOA Suite 12.1.3.0)

  3. OracleAS Adapter for Siebel

  4. Oracle AS Adapter for J.D.Edwards EnterpriseOne and OneWorld (availble as “out of the box” Adapters with SOA Suite 12.1.3.0) 

What is Oracle E-Business Suite Adapter ?

The adapter allows you to integrate Non- Oracle Applications with the Oracle ERP Product to get information related to Customers, Suppliers, Account Receivables, Financials , Oracle Reporting, etc by using Oracle E-Business Suite Adapter.

What are the types of Oracle JCA Adapter Services ?

The Oracle JCA Adapter Services can be broadly divided into 3 types:

 

  1. Request-Response (Outbound Interaction) Service : This service process the synchronous request and response data exchange.  
  •  The adapter receives the request from the adapter client.
  • Translate the request into native format 
  • Invoke the back end application method 
  • The Back end application response translates the native format to XML Standards
  • The response is sent to the JCA Binding Component
  • JCA Binding Component returns the response to SOA Composite reference.

  2. Event Notification (Inbound Interaction) Service: This service process the asynchronous request

  • An adapter registers as a listener for the back-end application
  • Back-end application pushes the event to the adapter. 
  • The adapter sends the event notification to the adapter client. 

3. Metadata Service: This service allows to browse and store metadata and a runtime component for running services like connection details, schema for business objects and services. The adapter metadata definitions are generated as XSD, WSDL and binding configuration files.

 

REFERENCES:

SOA 12c Oracle Technology Adapter Guide 

 


Oracle Event Processing (OEP) 12c installation guide

Oracle Event Processing (OEP) 12c is used for developing, administering, and managing applications that needs monitoring of real-time streaming events (IoT) providing high throughput and low latency platform. The blog provides the Oracle Event Processing (OEP) installation and configuration steps. 

Pre-requisites for Oracle Event Processing (OEP) 12c

  1. The Oracle Event Processing (OEP) 12c  installer can be downloaded from the Oracle Edelivery download page. 
  2. The Oracle Event Processing (OEP) 12c  is to be installed on the existing middleware home with SOA Suite installed.  Refer the blog SOA Suite 12c quickstart installation guide
  3. Oracle Event Processing (OEP) 12c  installer provides Oracle JRockit as the Default JVM  at the below location <Middleware_Home>/jrockit_<Java-Version>_<RjRockit-Version>
  4. If Oracle Event Processing (OEP) 12c is to be installed on Solaris SPARC then Sun JVM is the default JVM and is included in the Solaris SPARC installer for OEP 12c
  5. The Oracle Event Processing (OEP) 12c  Typical Domain Configuration option is recommended for installing OEP for the production environment. 
  6. Select Custom domain configuration to get the OEP installed with the default ocep_domain

OEP 12c Installation Process with Screenshots

Open the Command Prompt and Run it as Administrator

Open the folder where quick start installer are being downloaded and extracted

Execute the below command in the Command Prompt

%JAVA_HOME%\bin\java.exe -jar fmw_<12c-version>_oep.jar

The Installer opens the Oracle Event Processing (OEP) 12c installation window

Skip the Auto Update Screen

Enter the directory location for the Oracle Event Processing (OEP) 12c Installation , Click Next

Oracle Event Processing Installation screenshot

Select Event Processing with Examples to install the event server with sample applications

The next screen provides the Installation pre-requisite check performed

The next screen provides the Oracle Event Processing (OEP) 12c Installation summary details

Click Next and OEP installation progress can be tracked.

Oracle Event Processing Installation progress

Click Finish 

Oracle Event Processing (OEP) 12c Domain Configuration Steps

Once the Oracle Event Processing installation  is completed, we need to configure the domain ocep_domain for the OEP Server.

  1. Navigate to the Configuration Wizard location 
<OEP_Installation_Home>/oep/common/bin/config.cmd  (Windows) 
<OEP_Installation_Home>/oep/common/bin/config.cmd (Linux)

2. The OEP Configuration Wizard screen appears. 

Oracle Event Processing configuration wizard

Click Next 

Select the Create New Domain Option  . Click Next . 

Configure Administrator Password:

Enter the Username and Password for the New OEP domain.  Click Next. 

Configure Server:

Enter the Server Name : oep_server

Enter the port: <listen-port-number>.   Click Next

Configure Domain Identity Keystore:

Enter the keystore file :  <DOMAIN-NAME> /ss/evsidentity.jks

Enter the keystore password:  

Configuration Options:

Do you want to perform any optional configurations for JDBC Datasources :  Select No

Create OEP Domain:

Domain Name: oep_domain

Domain Location:  <OEP_Middleware_Home>/user_projects/domains

Click Next . The domain creation progress can be seen. 

Configuration wizard confirms the successful completion of oep_domain. 

Click  Done. 

Start OEP Server 

Navigate to the OEP Domain location  (<OEP_Middleware_Home>/user_projects/domains /oep_domain) 

Run the startwlevs.sh script on Linux /  Run the startwlevs.cmd script on Windows


Add BPEL process service components to SOA composite

The blog provides the step to add a simple Hello World BPEL Process service components to SOA composite applications in the design environment.  

Let’s create a HelloWorld BPEL application to demonstrate the same. 

Add a New BPEL Service Component

File > New > Application

Select Applications -> SOA Application

Enter the Application Name and Click Next

Configure SOA Settings -> Composite With BPEL Process

Hello world Composite Type

Hello world Synchronous BPEL Process

Click Finish

Template Types in BPEL Process Service Component

The Template Types allows to define what sort of BPEL Process Service Component is going to be exposed for the invocation.  It could be define as given below

  1. Web Service
  2. REST Service
  3. No Service

Template for BPEL Process Service Component

In the Create BPEL Process , user is provided with the option to select the template based on the BPEL Process Service Component.  The template creates the default files for <Process_Name>.bpel and <Process_Name>.wsdl where Process_Name is the Name given for the BPEL Process.  

BPEL Process Template files

Template Name Template Description
Asynchronous BPEL Process

Asynchronous BPEL Process does not wait for the reply to return .  Allows to create an Asynchronous BPEL Process with default Receive Activity. Add a Invoke Activity call back the client asynchronously 

Synchronous BPEL Process

An Synchronous BPEL Process waits for the reply to return to complete the service flow. 

Allows to create an synchronous BPEL Process  with default  Receive Activity. Add an reply activity to retrieve the results back.

One Way BPEL Process Allows to create the BPEL Process Service Component with one way call interface.
Define Service Later  Allows to create the BPEL Process Service Component with No activities.
Based on WSDL 

Allows to create the BPEL Process Service Component with an existing WSDL (Web Service).  

Need to define the WSDL URL, Port Type and Callback Port.

Subscribed to Events

Allows to create the BPEL Process Service Component  for subscribing to an Business Event.  

This requires event selection which needs to be subscribed, consistency level and if this event need to be published or not. 

Now Lets create a Assign Activity to map the Client Input with the Response Output String to perform the basic transformation. Assing Activity Mapping

Deploy the BPEL Service to Integrated SOA Server 

Deploy Hello world to Application Server

hello world deployment to soa serverhello world deployment to soa server

Hello World Deployment Summary

Test Hello World BPEL Web Service 

  1. Log into the SOA Server 
  2. Click on Deployed Composites -> BPELHelloWorldV1.0
  3. Click on Test Button 
  4. Enter the Input String as “Hello World”
  5. Click on Test Web Service 
  6. Web Service returns the “Hello World” as result string.

Test Hello world web service

 


Oracle Fusion Middleware 12c Infrastructure installation guide

The Oracle SOA generic installer for Oracle Fusion Middleware SOA Suite 12c includes Oracle WebLogic Server and Oracle Coherence support whereas the Oracle Fusion Middleware Infrastructure provides the Fusion Middleware Control and Java Required Files (JRF) for managing Multitenant domains with multiple partitions.  The blog provides the step by step installation for Oracle Fusion Middleware 12c Infrastructure. 

Pre-requisites for Oracle Fusion Middleware Infrastructure

  1. The  Oracle Fusion Middleware Infrastructure Installer can be downloaded from Oracle Site Oracle Fusion Middleware Infrastructure Download Link 
  2. Ensure that the Oracle Fusion Middleware SOA Suite 12c is already installed on your local machine.
  3. Minimum RAM available should be 4 GB
  4. Physical Memory allocation available should be 2 GB 

Oracle Fusion Middleware Infrastructure Installation Steps

Go to the Directory where the Oracle Fusion Middleware Infrastructure Installer is downloaded and then Extracted.

Execute the setup and it opens the Infrastructure installation welcome screen. 

SOA12c Infrastructure setup

Skip for Auto Updates

Provide the directory for Oracle Fusion Middleware Infrastructure Installation . It should be installed in the same directory where your SOA Suite is installed with Weblogic Server.

Fusion Middleware Infrastructure location

Provide the Installation Type

Fusion Middleware Infrastructure installation type

Perform the Prerequisite check for the installation

Fusion Middleware Infrastructure-installation prereqisite

Next Screen shows the Fusion Middleware Infrastructure Installation Summary Details

Fusion Middleware Infrastructure installation summary

The Installation Progress Screen

Fusion Middleware Infrastructure installation progress

The below screen shows the completion of Fusion Middleware Infrastructure Installation Process

Fusion Middleware Infrastructure installation completed


SOA 12c RCU installation error RCU-6080 Global prerequisite check failed

The blog provides the resolution for the common error like  RCU-6002 Prerequisite validation failed and  RCU-6080 Global prerequisite check failed for the specified database while installing the SOA Schemas using Repository Creation Utility in the Oracle Database.  

ERROR – RCU-6002 Prerequisite validation failed

The below could be the possible reason for the prerequisite validation failed

  1. Identify SOA 12c suported Databases: Identify the Supported Databases for SOA Suite 12c before proceeding with the Database installation. The SOA 12c Certification Matrix can be found on the Oracle Link  Oracle SOA 12c Certification Matrix under the section  Oracle Fusion Middleware 12c Certifications -> System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.2.1.4.0).xls
  2. No Execute Privileges: MDS database user created by Repository Creation Utility (RCU) does not have  EXECUTE privilege on DBMS_OUTPUT, DBMS_STATS, and DBMS_LOB. Log into the Oracle Database as SYSDBA and GRANT  EXECUTE Privileges to the MDS User. 

ERROR – RCU-6080 Global prerequisite check failed for the specified database

Cause for the Error – ” The selected Oracle database is a multitenant container database (CDB). Connecting to a multitenant container database (CDB) is not supported. Connect to a valid pluggble database (PDB)”  

Before we execute the Repository Creation Utility, the following validations need to be performed

  1.  Do not Select Container Database: While installing the Oracle Database ensure that the Container Database Checkbox is not selected. 

Oracle Database Identification

2. Pluggable Database must be installed: The Oracle Database installs the Pluggable Database (PDB) which is to be used while installing RCU.  The below screen shows the XEPDB1 PDB created by the Oracle Database Installer.  Save this information as it is to be provided when providing Database details for loading SOA Schema

Oralce XE Pluggable Database

3. Oracle Database Validations:  Before we proceed with the RCU Setup, the below given SQLs can be useful to validate the installed Oracle Database. 

Validate if the Database is created as CDB or not

SELECT CDB FROM V$DATABASE; 

CDB
----
YES

Retrieve the installed Pluggable Database . In our case , the PDB XEPDB1 exists. 

SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;

CON_ID NAME OPEN_MODE
2 PDB$SEED READ ONLY
3 XEPDB1 READ WRITE

Retrieve the Service Name for the Pluggable Database  XEPDB1

select name from v$services;

name
---
SYS$BACKGROUND
SYS$USERS
xepdb1

 

Provide the Oracle Database Connection details in RCU Database Connection Screen with Service Name as XEPDB1

Oracle Database connection details


Oracle SOA Suite 12c 12.2.1.4.0 quickstart installation guide

Oracle SOA 12c 12.2.1.4.0 is the Oracle Fusion Middleware Product from Oracle technologies. Oracle provides the Oracle SOA Suite 12c quickstart installer for the learning and evaluation purpose.  The blog provides the SOA 12c step by step installation process on Windows 10 for the beginners.   The complete list of SOA 12c Hardware and Software requirements can be referred on the Oracle Link  Oracle SOA 12c Certification Matrix under the section  Oracle Fusion Middleware 12c Certifications -> System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.2.1.4.0).xls

Software requirements for SOA 12c installation: 

  1. Download JDK 1.8 from the Oracle Java download link  Oracle JDK1.8 download Windows X64 and install on your local machine.
  2. Set up the JAVA_HOME in the Environment Variables.
  3. Install Oracle 12c Database from the Oracle site link  Oracle 12c Database Download
  4. Ensure that Oracle SOA 12c quickstart is currently supported for Windows 64 bit and thus need to be installed on Windows 7 / Windows 10 64-bit machines only.
  5. Download the SOA12c 12.2.14.0 from the Oracle Software Delivery Cloud Oracle SOA 12c Download Link
Download Oracle SOA 12c  from Delivery Cloud
Download Oracle SOA 12c from Delivery Cloud

Download V983385-01_1of2.zip and V983385-01_2of2.zip  for Oracle Fusion Middleware 12c (12.2.1.4.0) SOA Quick Start for (Microsoft Windows x64 (64-bit) using the Oracle Download Manager. 

Oracle SOA 12c Download Manager
Oracle SOA 12c Download Manager

Hardware requirements for SOA 12c installation: 

Hardware Requirement  Memory Allocation
SOA Server 3 GB (Minimum)
OSB Server 3 GB (Minimum)
Weblogic Server 3 GB (Minimum)
Operating System and Other Software 3 GB 
Swap Memory 2 GB
Temp Memory 3 GB to 5 GB
RAM  4 GB (Minimum) , recommended 8 GB

SOA 12c Installation Process with Screenshots:

Open the Command Prompt and Run it as Administrator

Open the folder where quick start installer are being downloaded and extracted

Execute the below command in the Command Prompt 

%JAVA_HOME%\bin\java.exe -jar fmw_12.2.1.4.0_soa_quickstart.jar

The Installer opens the SOA 12c quickstart installation window

SOA 12c quickstart installation welcome screen

Skip the Auto Update Screen 

Enter the directory location for the SOA 12c Installation 

SOA12c installation location

The next screen provides the Installation pre-requisite check performed 

SOA12c installation prerequisite check

The below screen provides the SOA 12c Installation summary details 

SOA12c installation summary

Installation Progress Screen

SOA12c installation progress

Installation Completion Screen

SOA12c installation complete

JDeveloper 12c SDK Extension Update

Open the Installed JDeveloper and click Help-> Check for Updates. The latest available updates are shown.

Jdeveloper Update Screen

Click Next and Select the SDK Extensions for the JDeveloper

Jdeveloper SDK extensions

Click Next and then Finish to get the updates installed for JDeveloper. You might need Restart for the JDeveloper get the changes reflected.

How to Install Oracle XE 18c Database 

Perform the steps provided in the below given blog for Oracle XE 18c Database Installation Oracle XE 18c Installation Steps

Repository Creation Utility (RCU)

The repository creation utility (RCU) is provided to CREATE the SOA Schema which is consumed by the SOA Services. The SOA Composite details will be residing in this schema. The SOA 12c installer provides the RCU Windows batch program to install the SOA Schema. The below given is the step by step installation process for RCU. 

Pre-requisites for the RCU

  1. Supported Database should be installed in your local machine
  2. 4 GB Memory allocation required for Oracle Database
  3. SOA12c Software Installation is completed in your local machine

Navigate to the SOA Directory at the below given path and execute the Config batch in the command prompt as Administrator.

<SOA12c_Directory_Location>\oracle_common\common\bin\config.bat

The Repository Creation Utility (RCU) Welcome Screen is opened

SOA12c RCU Setup Screen

Select the RCU Creation Type 

SOA12c RCU Repository Creation Screen

Enter the Oracle Database Connection details 

Oracle Database connection details

Select the SOA Component that need to be installed using RCU

RCU component selection

RCU Tablespace Mapping Verification Screen. 

RCU Tablespace Mapping

RCU Schema and Tablespace Summary Screen

RCU Schema & Tablespace Summary

RCU Successful Completion Screen

RCU Successful Completion Screen


How to Configure or update Advanced BPEL Properties in MBean Browser

Hello All,

The Prevous blog http://oracleappshelp.com/2019/05/22/how-to-configure-bpel-process-service-engine-properties-in-soa-12c/ provided the details on the properties related to the BPEL Service Engine .

There are advanced level properties also which are covered in this blog.

Log into the em console of the SOA Server and click on SOA Folder in the Administrator Area
Right click on SOA-INFRA and select SOA Administration -> BPEL Properties
Click More BPEL Configuration Properties

Below are the list of properties which can be defined in SOA Server as per the project need.

Advanced BPEL Properties in MBean Browser

Advanced BPEL Properties in MBean Browser

Advanced BPEL Properties in MBean Browser

Advanced BPEL Properties in MBean Browser

Advanced BPEL Properties in MBean Browser

Advanced BPEL Properties in MBean Browser


Configure BPEL Process Service Engine Properties in soa 12c

The blog depicts the steps to navigate and configure or change the default BPEL Service Engine Properties.

Log into the em console of the SOA Server and click on SOA Folder in the Administrator Area
Right click on SOA-INFRA and select SOA Administration -> BPEL Properties

Navigation- BPEL Service Engine Properties

Below are the properties which can be changed as per the project need

S. No Property Name Property Description
1 Audit Level The Audit Level can be defined as given below
• Inherit – This is the default logging same as SOA Infrastructure Audit Level Logging
• Off – No business flow instance tracking and payload tracking data is maintained
• Minimal- Only business flow instance tracking data is maintained. No Payload data details.
• Production – Business flow instance tracking data is maintained.
All other activity payload details are maintained but Payload details for assign activities are not maintained.
• Development – All events are logged. business flow instance tracking and payload tracking data is maintained
2 Audit Level Threshold The larger payloads will have large audit trail and thus stored in dehydration store table in chunks.
Specify the Numeric Value (size in bytes) of an instance Audit Trail before it is chunked.
3 Large Document Threshold To handle the large document, specify the maximum threshold value for the BPEL Variable before its contents are considered to be stored separately than rest of the instance scope data
4 Payload Validation Enable this option to validate Inbound and Outbound messages. Fault is raised for the Non-Schema complaint payload data
5 Disable BPEL Monitors and Sensors Enablement of this checkbox will disable BPEL monitors and sensors in the deployed SOA Composite applications.

BPEL Service Engine Properties