Recent Posts by Stephen Felts

Earlier, I wrote an article about how to migrate from a Multi Data source (MDS) for RAC connectivity to Active GridLink (AGL). This is needed to move from the older datasource technology to the newer technology, both supporting Oracle RAC. The information is now in the public documentation set at Migrating from Multi Data Source to Active GridLink . There are also many customers that are growing up from a standalone database to an Oracle RAC cluster. In this case, it’s a...

This article describes how to integrate WebLogic Server 14.1.1.0.0 running on Java SE 11 in the latest supported version of Eclipse IDE for Java EE Developers with Oracle Enterprise Pack for Eclipse (OEPE) 12.2.1.0. You need to start by getting all of the pieces - Java SE Development Kit, WebLogic Server, Eclipse IDE, and Oracle Enterprise Pack for Eclipse. Go to https://www.oracle.com/java/technologies/javase-jdk11-downloads.html to download Java SE Development kit (neither...

Much performance testing has been done in the area of JMS running on a JDBC store on an Oracle RAC Cluster. The goal of this article is to point to some existing documentation, point out a new, related feature introduced in WLS 12.1.3, and summarize the various approaches. First, let me point out suggestions in optimization of the Oracle database table that is used for the JMS backing store. The current JMS documentation proposes using a reverse index when enabling "I/O...

WebLogic Server UCP Data Source Type WebLogic Server (WLS) 12.2.1 introduced a new datasource type that uses the Oracle Universal Connection Pool (UCP) as an alternative connection pool.  The UCP datasource allows for configuration, deployment, and monitoring of the UCP connection pool as part of the WLS domain.  It is certified with the Oracle Thin driver (simple, XA, and replay drivers).  The product documentation is at https://docs.oracle.com/en/middleware/fusion-middleware/we...

Active GridLink (AGL) is the data source type that provides connectivity between WebLogic Server and an Oracle Database service, which may include one or more Oracle RAC clusters or Active Data Guard sites.  As the supported topologies grow to include additional features like Global Database Services (GDS) and new features are added to the Oracle networking and database support, the complexity of the URL to access this has also gotten more complex. There are lots of examples...

This article discusses designing and deploying an Active GridLink (AGL) data source to handle database down times with an Oracle Database RAC environment.  AGL Configuration for Database Outages It is assumed that an Active GridLink data source is configured as described Using Active GridLink Data Sources with the following. - FAN enabled.  FAN provides rapid notification about state changes for database services, instances, the databases themselves, and the nodes that form the...

One of the hot new features in Oracle database, first introduced in 12c, is Application Continuity (AC).  The feature basically will detect that a connection has gone bad and substitute a new one under the covers (I'll talk about it more in another article).  To be able to do that, the application is given a connection wrapper instead of the real connection.  Wrappers or dynamic proxies can only be generated for classes based on interfaces.  The Oracle types, like REF and...

This blog article will walk through creating an Autonomous Transaction Processing (ATP) Database in the Oracle Cloud.  It can then be accessed using a WebLogic Server datasource, as described in https://blogs.oracle.com/weblogicserver/atp-database-use-with-weblogic-server-v2 .  For an introduction to Oracle ATP databases, see https://docs.oracle.com/en/cloud/paas/atp-cloud/index.html. Creating an ATP Database You need to start by getting an account in the Oracle Cloud.  You can...

This blog describes the use of Oracle's Autonomous Transaction Processing (ATP) service with a WebLogic Server (WLS) datasource.  There is documentation available from various sources that sort of covers this but this document will try to pull it all together in one place for WLS and try to cover solutions for difficulties seen by our customers. This document is focused on what is more specifically called ATP-S (as opposed to ATP-D, the RAC-based version - most of the...