Enterprise Manager 13c – Database Usage Tracking Report Bug with FTP destination

Within Oracle Enterprise Manager 13c you have a nice Feature under the BI Publisher Reports to generate Database Usage Tracking Reports and to deliver them to a FTP Server, called BurstToFTP.


Unfortunatelly if you follow the very good official step-by-step documentation on how to setup and to configure the Database Usage Tracking Report you will not be able to get your Database Usage Tracking Reports under your FTP Server :-(

Enterprise Manager 13c – Resolve Pending Status of Systems Infrastructure Server Components

From time to time you can observe, that some Systems Infrastructure Server Components are turning into a "Pending Status". Mostly the reason for this status change is not clear, a restart of the underlying Oracle Agents also doesn't resolve this pending state.


 The simplest solution to get rid of the pending state is to remove the Systems Infrastructure Server Component and to re-add it.

For this just connect with the oracle user to your server (more...)

Oracle XE 18.4.0.0.0 (18c) for Windows

The Oracle Database Express Edition (XE) 18.4.0.0.0 (18c) is since yesterday available for Windows x64 on Oracle Technology Networks:


For the download of the latest Oracle XE 18c for Windows x64 checkout following link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html




Happy Download ...

Enterprise Manager 13.3 – Customize Login Page

Since Oracle Enterprise Manager 13.3 you have the option to customize the Login Page with your own logo image (size of the image is fixed with width of 200px and height of 70px) and a free text field.

In order to customize your login page you have to perform following steps.

At first you will need to activate the http port for your WebLogic Admin Server of your Enterprise Manager 13.3 environment.

Connect (more...)

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 (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 Matrix for Fusion Middleware 12.2.1.3. (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 (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-oracle-linux-with-oracle-preinstallation-rpm.html#GUID-22846194-58EF-4552-AAC3-6F6D0A1DF794


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 ;-)

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 the (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 Systems (64-bit)
  • HP-UX Itanium (64-bit)
Unfortunately the Documentation for Oracle Enterprise Manager 13c Release (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 (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 (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 (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 in addition some MBeans (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. (more...)

Oracle 18c – ALTER USER RENAME

2 years ago, I have published an article series about the undocumented feature "ALTER USER RENAME":

As I was getting access to an Oracle 18c Database, I was trying directly, if the ALTER USER RENAME still works (more...)

Oracle Traffic Director 12.2.1.3.0 in Docker

As I am currently working a lot with Docker and I already managed to place Oracle Forms & Reports into Docker, my next goal was to use the Oracle Traffic Director as well in Docker.

Based on my blog post "How to install and configure Oracle Traffic Director 12c - fully unattended" http://dirknachbar.blogspot.ch/2017/09/how-to-install-and-configure-oracle.html, I have converted and aligned my scripts to be used in a Docker Image.

The Oracle Traffic Director (more...)

Oracle Forms & Reports on Docker – The Concept and Technique behind

In the last days I was working on my Oracle Forms & Reports in Docker solution and I already published it via my blog and in my personal GitHub Repository.

Oracle Forms & Reports 12.2.1.3.0 with FADS in Docker

The next release of my Oracle Forms & Reports 12.2.1.3.0 Docker solution is now containing an option on running the Oracle Forms Application Deployment Services (FADS) within the Docker container.

The source code can be found under my personal GitHub Repository: https://github.com/DirkNachbar/Docker

Feel free to get a copy and enjoy playing around with Oracle Forms Application Deployment Services (FADS) under a Docker container.