Saturday, May 26, 2018

How to Verify/Apply the Patches Applied to an Oracle Home

To List the patches applied to your Oracle Home.

Go to Oracle Home and Run opatch under OPatch Folder
(Provide the full path for Oracle Home while running the command)

/soa/oracle/OPatch/opatch lsinventory



How to Apply Patch

Extract the Patch folder you downloaded from Oracle Support Site.
Go into the Extracted folder and run below command. Before Running, make sure you shutdown all the servers including admin server.
$ORACLE_HOME/OPatch/opatch apply
Example: /soa/oracle/OPatch/opatch apply




Saturday, May 19, 2018

How to create Proxy Server in OSB Business Service | SOA 12C

For few of the web services with downstream systems, we need to invoke them via a proxy servers.
In the below screenshot, i have shown the how to create a proxy server and associate it with Business service in OSB.

Expand System project(which is a default project with empty folders in OSB).
Select Proxy Server.


Right Click on Proxy Servers folder, then Create -> Create Proxy Server.

 Give a Proxy Server name and details, as shown below.



Once the Proxy Server is created successfully, Open your Business Service and select the Transport Detail page. In the Advanced Options, select the Proxy server you have created in the previous step.


And you are done!!

Thursday, May 17, 2018

The invocation resulted in an error: Server chose TLSv1, but that protocol version is not enabled or not supported by the client.

Error while invoking HTTPS URL from OSB Business service.

Error Message: The invocation resulted in an error: Server chose TLSv1, but that protocol version is not enabled or not supported by the client.

Steps to Resolve: 
  • Open weblogic console., Click on Servers

  •  Click on OSB Server

  • Navigate to Configuration->Server Start



  • Add the below property in Arguments

Dweblogic.security.SSL.minimumProtocolVersion=TLSv1


Now Restart the OSB Server for the changes to reflect.

Reference: https://docs.oracle.com/middleware/1213/wls/SECMG/ssl_version.htm#SECMG636

Wednesday, May 16, 2018

ESS (Enterprise Scheduler Service) for Inbound JCA Adapters in SOA 12C

Enterprise Scheduler Service (ESS) is a scheduler that is part of SOA Suite 12c. ESS supports a number of scheduling activities around the SOA Suite.
With the help of em console, we can manage job requests, define metadata and schedule jobs, and APIs to define metadata and create schedules in ESS.
In this section, we are going to create a schedule and assign it to a Inbound JCA (jms,file,db polling,etc..) adapter.

Scenario: Deactivate the DB adapter at 10 PM everyday and activate it back at 8 AM next morning. In this case, records created  by system between 10 PM to 8 AM will not be processed immediately.

Expand Scheduling Services, Right click on ESSAPP. Job Requests-> Define Schedules.


Click on Create to create a new schedule.

Now we have to create 2 Schedules, One for activation and other for Deactivation. (Sequence doesn't matter)
Please note that package have to be mentioned as "soa".
First Deactivation,
 Now Activation,



If you want to look at the schedules, you can just click on name of one the schedules.


Now you can go to your composite, And click on adapter.

 Click on calendar icon on the right corner.

Select the schedules created in above steps and click on Apply Schedules.


And you are done!!!!

Note: I have experienced a issue with clustered ESS servers, the schedules created were not displaying in the adapter. So i brought down one of the ESS server and tried the same and it worked. Not sure whether its product bug, so keep this as a workaround if adapters are not showing the schedules created.