Calling Oracle SOA Cloud REST service from SOAP UI

On creating a SOAPUI project using the WADL, for a REST Service deployed on SOACLD. The WADL import process throws an SSL handshake exception.

This exception can be resolved by adding the following properties to the SOAPUI VM.

• Navigate to the directory 

<SOAPUI_HOME>\ bin\SoapUI-5.3.0.vmoptions    

For Example: 
C:\Program Files\SmartBear\SoapUI-5.3.0\bin\SoapUI-5.3.0.vmoptions

• Edit the file and add

-Dweblogic.security.SSL.minimumProtocolVersion=TLSv1.0

-Dsoapui.https.protocols=SSLv3,TLSv1.2

• Restart SOAPUI and the issue will be resolved

SOA 12.2.1. View SOAP Header information.

Default SOA settings do not allow to view SOAP message (header & body)out-of-the-box on the EM Console or in the logs.

In order to see these SOAP conversations for a SOA composite service you can follow below steps: Please note the log file to be checked is OWSM

• Using the Enterprise Manager, attach the management policy named oracle/log_policy to the webservice reference to which the SOAP headers needs to be monitored. 

• Restart the composite

• Check the below log file to view the SOAP messages whenever the webservice call is made.$DOMAIN_HOME/domain_name/servers/mserver_name/logs/owsm/msglogging/diagnostic.log

Oracle SOA Cloud: Deploy MDS Artifacts on SOA Cloud Instance using cloud Enterprise Manager

This BLOG thread discusses the steps on deployment of MDS artifacts on SOA cloud instance.

Setup JDeveloper SOA_DesignTimeRepository

JDeveloper 12.2.1 or 12.2.1.2 by default creates the SOA_DesignTimeRepository. This is a file based repository. At MindTelligent, we link this directory to SVN or GIT master repository. It is imperative that we have a main folder /apps and all the artifacts are stored under the apps folder.

On looking at the Design Time Repository closely, the structure looks like as shown below:

To change the location of the directory, simply right click on the  SOA_DesignTimeRepository, and click on Properties.

  
















Please click on the Browse button and choose the folder you wish to select as File based Repository
Please note that you do not select the /apps folder under which all the artifacts are located.

That is it for JDeveloper Setup. You are ready to build your composites.


Deploy the MDS artifacts on SOA cloud

• Log in to your SOA Cloud Instance 
• Navigate to the "SOA Fusion Middleware Control Console"

• Navigate to SOA Infrastructure-->Administration-->MDS configuration

Choose the option to Import the MDS

Please navigate to the folder where the Zip file for the SOA_DesignTimeRepository is located. 

The zip file SHOULD include the /apps folder

EM will display the following message if all the artifacts are successfully uploaded to the  MDS:

Installation of Apache Spark on Windows 10

Apache Spark is an open-source cluster-computing framework. Originally developed at the University of California, Berkeley's AMPLab, the Spark codebase was later donated to the Apache Software Foundation, which has maintained it since. Spark provides an interface for programming entire clusters with implicit data parallelism and fault-tolerance.

Please follow following instructions on installation Apache Spark on Windows 10.

Prerequisites:

Please ensure that you have installed JDK 1.8 or above on your environment.

Steps:

Installation of Scala 2.12.2

• Please Install Scala after downloading it. 
• Scala can be downloaded from here.
• Download will give you a .msi file. Follow instructions and install Scala

Installation of Spark

• Spark Can be downloaded from here
• I am choosing version 2.1.1 prebuit for Hadoop. Please note, I shall be running this without Hadoop.

• Extract the tar file into a folder called c:\Spark
• The contents of the Extract will look like

Download Winutils

• Download Winutils from these links : 64 bits
• Create a folder c:\Spark\Winutils\bin and copy this winutils.exe there
• The folder structure will look like

Setup Environment Variables

• Following environment variables will need to be setup:
• JAVA_HOME: C:\jdk1.8.0_91
• SCALA_HOME: C:\Program Files (x86)\scala\bin
• _JAVA_OPTION: -Xms128m -Xmx256m
• HADOOP_HOME:  C:\Spark\WinUtils
• SPARK_HOME: C:\Program Files (x86)\scala\bin
• Create a folder c:\tmp\hive and give it read/write/execute privileges for all

Test Spark Environment

• Navigate to SPARK_HOME/bin and execute command scala-shell

You should re ready to use Spark

SOA 12c: How to remove folder and Files from MDS

The folder or individual files can be removed from SOA using WLST scripts. WLST scripts can also be used for deployment of MDS. Enterprise Manager can also be used to export and import the MDS.

Please click here to see how to use Enterprise Manager to import and export MDS

However, for deletion, please refer to following steps

On the FMW server, navigate to #ORACLE_COMMON/bin

cd ${ORACLE_HOME}/oracle_common/common/bin

Execute wlst.sh file:

wlst.sh

Give the command

connect('weblogic','password','t3://WeblogicHost:7001') //Please use the Weblogic Admin Server Port here.

Give The Command to remove a specific folder. This command will remove the /app/Test folder.

sca_removeSharedData(' http://soaHost:ManagedServerPort','Test')

sca_removeSharedData(' http://localhost:8001','Test')

You should see following message:

wls:/soainfra/serverConfig/> sca_removeSharedData(' http://localhost:8000','Test')

serverURL =  http://localhost:8000

folderName = Test

user = None

INFO: Creating HTTP connection to host:localhost, port:8000

Enter username and password for realm 'default' on host localhost:8000

Authentication Scheme: Basic

Username: weblogic

Password:

INFO: Received HTTP response from the server, response code=200

---->Remove shared data success.

Give The Command to remove a specific file. This command will remove the file: /apps/Test/SOAPService.wsdl'

deleteMetadata(application='soa-infra',server='soa_server1',docs='/apps/Test/SOAPService.wsdl')

Salesforce: Generate Enterprise WSDL

To generate the metadata and enterprise WSDL files for your organization:

1. Log in to your Salesforce account. You must log in as an administrator or as a user who has the “Modify All Data” permission.
2. From Setup, enter API in the Quick Find box, then select API
3. Click Generate Enterprise WSDL and save the XML WSDL file to your file system.

Oracle Virtual Box Only Showing on 32 Bit Options

While trying to configure the SOA 12c on a VM running on 64 bit O/S, when trying to install Ubuntu Linux we observed that Oracle Virtual Box only shows 32 bit options

• To fix this issue, we need to ensure that in BIOS settings the VM support is enabled
• Hyper -V needs to be disabled. To do this Enter Windows Key + q and type in turn windows features on or off

         Ensure that the Hyper-V is unchecked and restart your machine.

• You should now be able to see all 64 bit options.