Oracle Database 12.2 Feature Support with WebLogic Server

It's finally available - you can download the Oracle 12.2 database!  Integration of WebLogic Server (WLS) with Oracle 12.2 has been in progress for two years.

This article provides information on how Oracle 12.2 database features are supported in WebLogic Server releases.

Using Older Drivers with the 12.2 Database Server

The simplest integration of WebLogic Server with a 12.2 database is to use the Oracle driver jar files included in your WebLogic Server installation. There are no known problems or upgrade issues when using 11.2.0.3, 11.2.0.4, 12.1.0.1, or 12.1.0.2 drivers with a 12.2 database.  See the Oracle JDBC FAQ for more information on driver support and features of Oracle 12.2 database.

Using the Oracle 12.2 Drivers with the 12.2 Database Server

To use many of the new 12.2 database features, it is necessary to use the 12.2 database driver jar files.

Note that Oracle 12.2 database driver jar files are compiled for JDK 8. The earliest release of WLS that supports JDK 8 is WLS 12.1.3. The Oracle 12.2 database driver jar files cannot work with earlier versions of WLS.  In earlier versions of WLS you can use the drivers that come with the WLS installation to connect to the 12.2 DB, as explained above.  This article does not apply to Fusion MiddleWare (FMW) deployments of WLS. It’s likely that the next released version of FMW 12.2.1.3 will ship and support the Oracle 12.2 database driver jar files out of the box.

Required Oracle 12.2 Driver Files

The 12.2 Oracle database jar files are not shipped with WLS 12.1.3, 12.2.1, 12.2.1.1, and 12.2.1.2.

This section lists the files required to use an Oracle 12.2 driver with these releases of WebLogic Server. These files are installed under the 12.2 database $ORACLE_HOME directory.

Note: These jar files must be added to the CLASSPATH used for running WebLogic Server at the head of the CLASSPATH. They must come before all of the 12.1.0.2 client jar files.

Select one of the following ojdbc files (note that these have "8" in the name instead of "7" from the earlier release) :

  • jdbc/lib/ojdbc8.jar

  • jdbc/lib/ojdbc8_g.jar

  • jdbc/lib/ojdbc8dms.jar

  • jdbc/lib/ojdbc8dms_g.jar

    The following table lists additional required driver files:

File

Description

jdbc/lib/simplefan.jar

Fast Application Notification (new)

ucp/lib/ucp.jar

Universal Connection Pool

opmn/lib/ons.jar

Oracle Network Server client

jlib/orai18n.jar

Internationalization support

jlib/orai18n-mapping.jar

Internationalization support

jlib/orai18n-collation.jar

Internationalization support

jlib/oraclepki.jar

Oracle Wallet support

jlib/osdt_cert.jar

Oracle Wallet support

jlib/osdt_core.jar

Oracle Wallet support

rdbms/jlib/aqapi.jar

AQ JMS support

lib/xmlparserv2_sans_jaxp_services.jar

SQLXML support

rdbms/jlib/xdb.jar

SQLXML support

Download Oracle 12.2 Database Files

If you want to run one of these releases with the 12.2 jar files, Oracle recommends that you do a custom install of the Oracle Database client kit for a minimal installation. Select the Database entry from http://www.oracle.com/technetwork/index.html. Under Oracle Database 12.2 Release 1, select the "See All" link for your OS platform. For a minimal install, under the Oracle Database 12.2 Release 1 Client heading, select the proper zip file and download it. Unzip the file and run the installer. Select Custom, then select the Oracle JDBC/Thin interfaces, Oracle Net listener, and Oracle Advanced Security check boxes. You can also use an Administrator package client installation or a full database installation to get the jar files. The jar files are identical on all platforms.

Update the WebLogic Server CLASSPATH or PRE_CLASSPATH

To use an Oracle 12.2 database and Oracle 12.2 JDBC driver, you must update the CLASSPATH in your WebLogic Server environment. Prepend the required files specified in Required Oracle 12.2 Driver Files listed above to the CLASSPATH (before the 12.1.0.2 Driver jar files).  If you are using startWebLogic.sh, you also need to set the PRE_CLASSPATH.

The following code sample outlines a simple shell script that updates the CLASSPATH of your WebLogic environment. Make sure ORACLE_HOME is set appropriately (e.g., something like
/somedir/app/myid/product/12.2.0/client_1).

#!/bin/sh
# source this file in to add the new 12.2 jar files at the beginning of the CLASSPATH
case "`uname`" in
*CYGWIN*)
SEP=";"
;;
Windows_NT)
SEP=";"
;;
*)
SEP=":"
;;
esac

dir=${ORACLE_HOME:?}
# We need one of the following
#jdbc/lib/ojdbc8.jar
#jdbc/lib/ojdbc8_g.jar
#jdbc/lib/ojdbc8dms.jar
#jdbc/lib/ojdbc8dms_g.jar
if [ "$1" = "" ]
then
ojdbc=ojdbc8.jar
else
ojdbc="$1"
fi

case "$ojdbc" in
ojdbc8.jar|ojdbc8_g.jar|ojdbc8dms.jar|ojdbc8dms_g.jar)
ojdbc=jdbc/lib/$ojdbc
;;
*)
echo "Invalid argument - must be ojdbc8.jar|ojdbc8_g.jar|ojdbc8dms.jar|ojdbc8dms_g.jar"
exit 1
;;
esac

CLASSPATH="${dir}/${ojdbc}${SEP}$CLASSPATH"
CLASSPATH="${dir}/jdbc/lib/lib/simplefan.jar${SEP}$CLASSPATH"
CLASSPATH="${dir}/ucp/lib/ucp.jar${SEP}$CLASSPATH"
CLASSPATH="${dir}/opmn/lib/ons.jar${SEP}$CLASSPATH"
CLASSPATH="${dir}/jlib/orai18n.jar${SEP}$CLASSPATH"
CLASSPATH="${dir}/jlib/orai18n-mapping.jar${SEP}$CLASSPATH"
CLASSPATH="${dir}/jlib/oraclepki.jar ${SEP}$CLASSPATH"
CLASSPATH="${dir}/jlib/osdt_cert.jar ${SEP}$CLASSPATH"
CLASSPATH="${dir}/jlib/osdt_core.jar${SEP}$CLASSPATH"
CLASSPATH="${dir}/rdbms/jlib/aqapi.jar${SEP}$CLASSPATH"
CLASSPATH="${dir}/lib/xmlparserv2_sans_jaxp_services.jar${SEP}$CLASSPATH"
CLASSPATH="${dir}/jlib/orai18n-collation.jar${SEP}$CLASSPATH"
CLASSPATH="${dir}/rdbms/jlib/xdb.jar${SEP}$CLASSPATH"

For example, save this script in your environment with the name setdb122_jars.sh. Then run script with the ojdbc8.jar:

. ./setdb122_jars.sh ojdbc8.jar

export PRE_CLASSPATH="$CLASSPATH" 

WebLogic Server Integration with Oracle Database 12.2

Several Oracle Database 12.2 features have been in WLS for many releases, just waiting for the release of the new database version to start working. The following table lists these features. All of these features require the 12.2 driver jar files and 12.2 database server.

Feature

WLS Release Introduced

Oracle Database Release

JDBC 4.2 support

12.1.3

12.2

Service Switching

12.2.1

12.2

XA Replay Driver

12.2.1

12.2

Gradual Draining

12.2.1.2.0

12.1 with 12.2 enhancements

UCP MT Shared Pool support

12.2.1.1.0

12.2

AGL Support for URL with @alias or @ldap

12.2.1.2.0

12.2

Sharding API’s

Not directly available in WLS datasource but can be used via the WLS UCP native datasource type added in 12.2.1

12.2

You should expect other articles to describe these features in more detail and additional integration in future WLS releases.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

The official blog for Oracle WebLogic Server fans and followers!

Stay Connected

Search


Archives
« April 2017
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
      
Today