In our era of growing cyber threats, data security is of paramount importance. Companies are continuously exploring advanced methodologies to safeguard their sensitive information. One of these methodologies is the use of machine learning (ML) for enhancing data security. Oracle Autonomous Database comes with in-built Oracle Machine Learning, making it a compelling choice for securing your data. Oracle Autonomous Database and Machine Learning Oracle Autonomous Database, built on Oracle’s Exadata technology, is a cloud-based service that leverages machine learning and automation to mitigate hum ..read more

In the era of Big Data, a significant percentage of the data comes in unstructured text format, coming from various sources like emails, social media, reviews, and more. Extracting valuable insights from this textual data is where text mining comes in, and Oracle Autonomous Database with Oracle Machine Learning (OML) offers a useful platform for such tasks. In this article, we will explore how to implement text mining capabilities in Oracle Autonomous Database using OML. Understanding Text Mining Text mining involves extracting valuable information from unstructured text data. This process inv ..read more

As enterprises increasingly move towards digitization and cloud computing, migration of on-premise applications to the cloud has become a necessity rather than a choice. Oracle Cloud, offers a platform to facilitate this transition. Key Steps in Migration Assessment and Planning: Begin with an assessment of your current on-premise applications. Identify their dependencies, storage needs, and understand their architecture and data flows. This assessment should include the operational processes and the requirements for security, performance, and availability. Based on this, develop a migration ..read more

A usual requirement when building a JSF or Oracle ADF form is to set binding values not added by the user automatically on a button click. For example, setting a technical ID in an Entity Object right before executing a commit on the table. To do so, you can use a core JSF functionality with the f:setPropertyActionListener tag: Register an ActionListener instance on the UIComponent associated with the closest parent UIComponent custom action. This actionListener will cause the value given by the “value” attribute to be set into the ValueExpression given by the “target” attribute. The implemen ..read more

Oracle WebLogic Server is a Java EE application server currently developed by Oracle Corporation. You can start, stop and restart both the administration and the managed servers in two ways: Using the WebLogic Server Administration Console Using WebLogic Scripting Tool (WLST) 1) Stop and start an Oracle WebLogic Server using the WebLogic Server Administration Console This is only possible if your Admin Server has been started using a node manager. See nmConnect (https://docs.oracle.com/middleware/1213/wls/WLSTC/reference.htm#WLSTC476) Using WLST Commands to Start the Administration Server N ..read more

If you run Oracle SOA BPEL on-premise and at scale, you know how easier it can be to monitor your SOA BPEL processes through SQL queries. Those SQL queries get more profitable the more SOA BPEL instances you get, as the Enterprise Manager console usually doesn’t work for big payloads. In this previous article, you can find useful SQL Queries for monitoring Oracle SOA BPEL to : Identify BPEL Errors from the last 10 minutes  Identify Business faults from the previous 10 minutes Identify instance not purged after the retention period (here 70 days) Get the number of process and their states ..read more

Enterprise who usually run an Oracle SOA Suite BPEL environment to process workflows manage production and multiple test environments where they may need to mass abort instances. Especially to reset the Oracle SOA BPEL environment before running a non-regression or performance test. Below is the script I usually set up for my clients to close running instances before running new tests or to fully reset the environment. View the code on Gist ..read more

Implementing a working Purge script to get rid of old Oracle SOA BPEL instances is one of the most important tasks to maintain a working Oracle SOA Suite environment in production. Forgetting to do so will have the whole environment slow down as Oracle SOA Bpel database get bigger. Depending on your business requirement, I usually advise purging instances data older than 2 months. Instances data are useful to troubleshoot issues with BPEL processes and shouldn’t be kept once those are successfully completed. You may also need to update failed instances status to force them in a purgeable state ..read more

Oracle SOA BPEL infrastructures are notoriously hard to scale. Once your production Oracle SOA BPEL Database grows, you’ll often find that your whole Oracle SOA BPEL infrastructure performance may hinder. To fix it, you then need to focus on : Implementing the right database purge strategy Monitor large instances to improve your composite performances (see https://cedricleruth.com/useful-monitoring-sql-queries-for-oracle-soa-bpel/) Implement the proper Oracle Database partitioning How to partition for performance your Oracle SOA BPEL Database? Below is an example of partitioning scripts writ ..read more

If you run Oracle SOA BPEL on-premise and at scale, you know how easier it can be to monitor your SOA BPEL processes through SQL queries. Those SQL queries get more profitable the more SOA BPEL instances you get, as the Enterprise Manager console usually doesn’t work for big payloads. You’ll find below a couple of SQL queries to : Identify BPEL Errors from the last 10 minutes  Identify Business faults from the previous 10 minutes Identify instance not purged after the retention period (here 70 days) Get the number of process and their states for each composite name and revision (useful t ..read more