ALTER TABLE ADD column with DEFAULT value and Virtual Private Database

I recently came over a real strange behaviour with ALTER TABLE ADD column with DEFAULT value on one of my customers. They are using a Software Product based on WebLogic and Oracle Database, from time to time we receive some new version of this Software Product which includes Database related changes, e.g. add new tables, add columns to an existing table and so on. Within the latest Software Update, we could observe that the overall update process for the Database related part was increasing to around 12 hours !!!! Before it was quite shorter. Mainly...

Read More

Oracle 18c Certification for Fusion Middleware 12c Release 2

Since a few days the Certification Matrix for Oracle Fusion Middleware 12c Release 2 (12.2.1.x) was updated within Oracle Technology Network, now Oracle 18c (18.1 on Exadata and 18.3 on On-Premise) is certified and supported as Target Database for RCU (Repository Creation Utility and as Application Datasource. Certification Matrix for Fusion Middleware 12.2.1.2.0: https://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-122120-certmatrix-3254735.xlsx Certification...

Read More

Installation of Oracle 18c (18.3) RPM manually

Since last night the RPM version of Oracle 18c (18.3) is available, see my blog post http://dirknachbar.blogspot.com/2018/10/oracle-18c-rpm-for-linux-available.html I was directly testing the manually way in installing the Oracle 18c (18.3) RPM version, not Unbreakable Linux Network (ULN). As pre requirement you will need an up and running Linux Server, in my case an Oracle Enterprise Linux 7.4, and the Oracle 18c RPM and as well the Oracle 18c Preinstallation RPM. The Oracle 18c RPM you will find under https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html The...

Read More

Oracle 18c RPM for Linux available

Since last night, the RPM for Oracle Database 18c (18.3) for Linux x86-64 is available for download in Oracle Technology Network The RPM can be downloaded under following link: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html The corresponding documentation can be found under: https://docs.oracle.com/en/database/oracle/oracle-database/18/ladbi/automatically-configuring-o...

Read More

Java 11 General Availability

Right on time as scheduled Java 11 has become General Availability. This is the first Java Release under the new license with the so called Long Term Support (LTS). The latest Java SE 11 (LTS) can be found under https://www.oracle.com/technetwork/java/javase/downloads/index-jsp-138363.html But before using this release in productive environments, just make sure that you really meet the new license or consult your Oracle Sales ;...

Read More

Documentation for Oracle Enterprise Manager 13c Release 3 (13.3.0.0) available

Since a few days the latest Release of Oracle Enterprise Manager 13c Release 3 (13.3.0.0) is available for download (see my blogpost "Oracle Enterprise Manager 13c Release 3 (13.3.0.0) available" ) but the corresponding documentation was not yet available. But now Oracle also uploaded the documentation for Oracle Enterprise Manager 13c Release 3 (13.3.0.0), which can be found under https://docs.oracle.com/cd/cloud-control-13.3/index.html Under...

Read More

Oracle Enterprise Manager 13c Release 3 (13.3.0.0) available

The lastest Release of Oracle Enterprise Manager 13c Release 3 (13.3.0.0) is available for download under Oracle Technology Network: https://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html The Oracle Enterprise Manager 13c Release 3 (13.3.0.0) is available for following Operating Systems: Linux x86-64 (64-bit) Windows x86-64 (64-bit) Solaris Operating System (SPARC) Solaris Operating System (x86-64) IBM AIX on POWER...

Read More

Oracle Forms 12.2.1.3.0 and FRM- 93552 on Windows

I recently had a project for installing and configure Oracle Forms & Reports 12.2.1.3.0 on a Windows 2016 Server. While the installation and configuration of Oracle Forms & Reports 12.2.1.3.0 went really smooth, I was hitting directly after using the Oracle provided Test Forms under http://:/forms/frmservlet the FRM-93552 error. The official Oracle Documentation states that you have to install the Microsoft Visual C++ Redistributable 2012...

Read More

Oracle Reports 12c and DESTYPE=blobdestination

Last week a colleague of mine contacted me to support him for a problem to configure and use Oracle Reports 12c (12.2.1.2.0 and 12.2.1.3.0) with DESTYPE=blobdestination, which means instead of displaying a rendered Report like PDF or XLS or HTML in the Browser to store the generated Report in a LOB into an underlying table in an Oracle Database. At first you will need to download the BLOBDestination11g.jar (even when its compiled for Oracle Reports 11g, you can use it with Oracle Reports 12c) from My Oracle Support Note 11514155.1 https://support.oracle.com/epmos/faces/DocContentDisplay?id=1151455.1 Transfer...

Read More

Tracking applied Patches in WebLogic Server outfile

With a small trick you can track your applied patches in your Oracle Software Home on your Oracle WebLogic Server in the outfile. Simply add -Dweblogic.log.DisplayPatchInfo=true to your already existing setUserOverrides.sh or create a new setUserOverrides.sh in your $DOMAIN_HOME/bin directory. # Display applied patches in WebLogic Server outfile JAVA_OPTIONS="$JAVA_OPTIONS -Dweblogic.log.DisplayPatchInfo=true " After that just restart your WebLogic Server and you will find in the outfile of your WebLogic Server following entries: #...

Read More

Oracle SOA Suite 12c - Purge

Many people struggle with the configuration and execution of the SOA Purge functionality under Oracle SOA Suite 12c. Oracle provided with SOA Suite 12c a nice web interface for enabling, and scheduling the AutoPurge functionality within the Enterprise Manager Fusion Middleware Control 12c. But in case you just enable, schedule and define your retention time for the AutoPurge within this web interface nothing will be happen :-( You have to modify...

Read More

Oracle 18c - SQLPlus cute Features

As I got my fingers on the latest Oracle 18c Release, I had the chance to test some cute new features within SQLPlus, which are really helpful. SET LINESIZE WINDOW: The new option WINDOW for SET LINESIZE automatically adjust your linesize to your current window size. As you can see in the below screenshot, the first select was executed without the linesize option, so you will have the usual line break in your result set. Afterwards I execute "SET...

Read More

Oracle 18c - ALTER USER RENAME

2 years ago, I have published an article series about the undocumented feature "ALTER USER RENAME": Part 1: ALTER USER RENAME - A half official option: http://dirknachbar.blogspot.ch/2016/03/alter-user-rename-half-official-option.html Part 2: ALTER USER RENAME - Part 2: http://dirknachbar.blogspot.ch/2016/03/alter-user-rename-part-2.html Part 3: ALTER USER RENAME - Part 3: http://dirknachbar.blogspot.ch/2016/03/alter-user-rename-part-3.html As I was getting access to an Oracle 18c Database, I was trying directly, if the ALTER USER...

Read More