Migrating databases using Dataguard, some pitfalls and observations
My customer needed to migrate to a new set of datacenters, and while other services were able to “lift and shift”, the Oracle RAC database servers had to be …
Tag: database 12c
Oracle SOA Suite: Want performance? Don’t log so much and clean up your database!
The Oracle SOA Suite infrastructure, especially composites, use the database intensively. Not only are the process definitions stored in the database, also a lot of audit information gets written …
Oracle SOA Suite: Two-way SSL with TLS1.2 made easy (slightly less complicated)
Transport layer security (TLS) is not an easy topic. Many blogs have been written about this already. Surprisingly though, I did not find a single blog which was more …
Oracle Service Bus: Pipeline alerts in Splunk using SNMP traps
Oracle Service Bus provides a reporting activity called Alert. The OSB pipeline alerts use a persistent store. This store is file based. Changing the persistent store to JDBC based, …
Oracle 12c STIG Password Generator in PL/SQL
January 24, 2017
AMIS, Cyber Security, Database, Databases, DBA Oracle, DevOps, Engineered Systems, ExaData, ODA, Oracle, Oracle 12, PL/SQL, SQL
1 Comment
![Oracle 12c STIG Password Generator in PL/SQL]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Oracle 12c STIG Password Generator in PL/SQL")
Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a password to …
WebLogic Server: Logging the SOAP action in the access.log
WebLogic Server allows you to customize your access.log. This can be very powerful if you want to monitor for example service response times in a tool like Splunk (see …
WebLogic Server: Automate obtaining performance metrics from the DMS
Oracle provides the Dynamic Monitoring Service (DMS) as part of WebLogic Server which is extremely useful if you want to obtain aggregated data of an environment in case of …
Java Callout from Business Rules
Goal and warning This blog will show how to invoke java code directly from within a Business Rules component. I didn’t manage to find this in the Oracle product …
Oracle Database 12c Release 2 is out – just only on the cloud
The next major release of the Oracle Database has always been a big thing. Last year at Oracle OpenWorld , a lot of sessions were dedicated to Release 2 …
Oracle SQL Pattern Recognition – introducing the Match Recognize operator
Oracle Database Release 12c (12.1) introduced a new operator that we can use in SQL queries. The MATCH_RECOGNIZE operator allows us to detect patterns in our relational data. Specifically: …
Next Step in Row generation in Oracle Database 12c SQL using JSON_TABLE
One of those things SQL developers are frequently looking at is the generation of rows: having a query return records that do not really exist. For example to generate …
Create an oracledb enabled Node.js application container
In my previous article, First setup of a connection from Node.js to an Oracle Database, I demonstrated how to make a connection to a remote database using Node.js and …
First setup of a connection from Node.js to an Oracle Database
In this article I will demonstrate how to make a connection to a remote Oracle database from Node.js running on linux 7. We will be using the node-oracledb module …
Starting out with Oracle SOA CS – my first steps on a fairly advanced PaaS service
One of the platform offerings in the Oracle Public Cloud is the SOA Cloud Service. This service offers various flavors of SOA Suite 12c (Service Bus, SOA Suite, Technology …
Consuming a REST service from your ADF 12.2.1 application
January 11, 2016
Frontend technology, Java, Languages, Oracle Application Development Framework, Software Development
5 Comments
With the release of ADF 12.2.1 in the fall of 2015, Oracle finally added support for declaratively consuming a RESTful web service that responds in JSON format. Until then, …
Dynamic table in ADF 12c
A while ago I decided to create an ADF page based on a dynamic table, and I found that, although there are quite some articles about the subject online, …
Integration Workload Statistics (IWS) on untyped JSON and JavaScript in Composites
Oracle SOA Suite 12.2.1 introduces Integration Workload Statistics. This is a powerful new feature which can be used to do performance measures. Oracle SOA Suite 12.2.1 also introduces untyped …
Reflections after Oracle OpenWorld 2015 – PaaS Foundation (WebLogic, Coherence, JCS and Application Container Cloud Service)
The foundation for most of the Oracle Public Cloud Platform services is the Java Cloud Service (JCS) that itself is powered by WebLogic Server. The same WebLogic that Oracle …
Reflections after Oracle OpenWorld 2015 – Data Management (Database)
This article gives an overview of some of the most eye catching stories from Oracle OpenWorld 2015 around Data Management. It discusses on premises products such as Oracle Database …
Reflections after Oracle OpenWorld 2015 – Integration
This article gives an overview of some of the most eye catching stories from Oracle OpenWorld 2015 around integration. It discusses on premises products such as SOA Suite, BPM …
SOA Suite 12.2.1: A first look at end-to-end JSON and JavaScript support in SOA Composites
SOA Suite 12.2.1 introduces end-to-end JSON support in composites and support for JavaScript in composites. The REST-binding (which can be used by Service Bus, BPEL, BPM) can receive and …
SOA Suite 12.2.1: Resiliency updates on the operations side of life
On the 25th of October at Open World 2015, Oracle released the 12.2.1 version of SOA Suite 12c. This release is full of resiliency updates on the operation side of …
Quick overview of SOA Suite 12.2.1 new features
Oracle has just released SOA Suite 12.2.1 which contains several exciting new features. The below entries have shamelessly copied from the developers guide in order to provide a quick …
Overview of WebLogic 12c RESTful Management Services
Inspired by a presentation given by Shukie Ganguly on the free Oracle Virtual Technology Summit in July (see here); “New APIs and Tools for Application Development in WebLogic 12c”, …
Creating and scaling Dynamic Clusters using wlst
April 10, 2015
Cloud, Oracle WebLogic Server, Platform Technology, Provisioning, Technology
No Comments
In my previous article, Creating and scaling Dynamic Clusters in Weblogic 12c, I described the creation and scaling of Dynamic Clusters. I used the Weblogic Console to create the …
Creating and scaling Dynamic Clusters in Weblogic 12c
Introduced in Weblogic 12.1.2, dynamic clusters is a great feature to scale your private cloud. Dynamic clusters provides you easy scaling of Weblogic clusters by adding and removing managed …
Cloud Control Agent 12c managing many objects
An Oracle Enterprise Management Agent 12c that has to manage hundreds of objects needs extra tweaking. If not, it will not start, or it will die soon, leaving you …
Christmas Masterclass Oracle SOA Suite 12c
On Friday, December 19, AMIS organises a special XMas-terclass on SOA Suite 12. SOA Suite 12c (June 2014) was a major release for Oracle’s flagship integration product. This release introduces …
MAF 2.0 : Loading Images in a Background Process – Part I
November 18, 2014
Frontend technology, Java, Mobile, Oracle, Oracle Application Development Framework, Software Development, Technology
No Comments
Images are heavily used in Mobile apps. For instance a list that contains employees usually shows the images of these employees. This works well when you have a WIFI …
In-depth look into Oracle API Catalog (OAC) 12c
With the release of Oracle Enterprise Repository 12c another product was released. Oracle API Catalog 12c (OAC) allows you to build a catalog of your organization APIs. OAC provides …
SOA Suite 12c: Creating user accounts in ApacheDS using the LDAP adapter (inspired by Maarten Smeets)
My colleague Maarten Smeets recently published a very good article on the first steps with the SOA Suite 12c LDAP adapter (https://technology.amis.nl/2014/08/08/oracle-soa-suite-12c-ldapadapter-tutorial). He inspired me to take my own …
Oracle Service Bus: Obtaining a list of exposed SOAP HTTP endpoints
The Oracle Service Bus is often used for service virtualization. Endpoints are exposed on the Service Bus which proxy other services. Using such an abstraction layer can provide benefits …
SOA Suite 12c: Actionable Emails with Human Task service
It is my assumption that inbound and outbound emailing has been configured – for example for a GMail account – as described in these two articles: GMail for inbound …
ADF and service dependencies
In order to keep the business-IT gap manageable, it is important for analysts, designers and architects to know what their implemented application landscape actually looks like. An important part …
When to use the Oracle Database In-Memory option?
September 22, 2014
Architecture, Data Warehousing & BI, Databases, Digtial Innovation, Oracle 12
1 Comment
The application and usage of the Oracle Database In-Memory has been described by Pom Bleeksma in this post. Oracle Database In-Memory can result in huge improvement in application query …
FMW 12.1.3 – Invoking Enterprise Scheduler Service Web Services from SoapUI
The Fusion Middleware 12.1.3 platform contains the ESS or Enterprise Scheduler Service. This service can be used as asynchronous, schedule based job orchestrator. It can execute jobs that are …
SOA Suite 12c: Configuring GMail as the inbound email provider for UMS (IMAP, SSL)
In a recent article, I discussed how to configure the SOA Suite 12c for sending emails using GMail: https://technology.amis.nl/2014/08/05/setup-gmail-as-mail-provider-for-soa-suite-12c-configure-smtp-certificate-in-trust-store/. An interesting aspect of that configuration is the loading of …
ADF DVT: Creating a Thematic Map using a Custom Base Map with hotspots
One of the interesting new features in ADF DVT 12.1.3 is the option to use a custom image as the base map for the Thematic Map component. This enables …
Oracle SOA Suite 12c: The LDAPAdapter, a quick and easy tutorial
In enterprises, LDAP servers are often used to store user credentials and groups and share them among applications. Oracle SOA Suite 12c introduces a new technology adapter; the LDAPAdapter …
Quick generation of a VirtualBox VM with Oracle Database 12.1.0.2 EE on CentOS 5.6
A short time ago, Oracle released Oracle Database 12c – release 12.1.0.2. With a bunch of goodies that I would like to try out. This release can be downloaded …