Configure jobStatusRepository in Oracle Reports 12c

Within this blog post I will show you how to configure the Oracle Reports 12c jobStatusRepository against an Oracle Database.

Within Oracle Reports 12c a major change is, that within the jobStatusRepository configuration, we have now to use an entry in the Credential Store Facility (CSF).

At first create in your target database for the Reports Server Queue a user:

create user rwadmin identified by "Oracle12c" default tablespace users quota unlimited on users;
grant create (more...)

Microsoft SQL Server under Linux – Preview

Today something off topic, as I am normally blogging about Oracle Fusion Middleware stuff.

Microsoft SQL Server under Linux - Preview ... many of you (specially the Oracle Guys) might think now "WHAT ????", but its really true.
Some months ago Microsoft announced that they will release a SQL Server Version for Linux and I was lucky to get into the Preview Program.

The installation of the SQL Server under Linux (currently supported under Ubuntu 16 (more...)

Integrating Critical Patch Updates (CPU) into your WebLogic Server on Docker

Bruno Borges is doing a great job providing Docker Images for various Oracle WebLogic scenarios within the GitHub Repository https://github.com/oracle/docker-images/tree/master/OracleWebLogic

The provided samples are a real good starting point to create your Oracle WebLogic Servers and Domains including sample application.

But I personally miss one point within the Installation process of the Oracle WebLogic Server, applying Critical Patch Updates.

The integration is really simple.
As an example I will take Bruno's build file https://github. (more...)

Oracle Forms Stand-alone Application Launcher (FSAL)

Since Oracle Forms 12c its possible to start your Oracle Forms without invoking a browser, this is called Oracle Forms Stand-alone Application Launcher (FSAL).

As pre requirement you will need either a JRE or JDK on your desktop, which should execute the Oracle Forms.

For this new Feature Oracle has integrated a short description Website within your installed and configured Oracle Forms & Reports Server 12c. The description website can be reached under following URL (more...)

Oracle Reports 12c – The missing configuration steps

Oracle Forms & Reports 12c is released since a quite long time and I had now some chance to have a more detailed look on the Oracle Reports 12c component.

After you have successfully installed and configured the Oracle Forms & Reports 12c, you might find out that your Oracle Reports 12c is not working ... because its not yet configured, even you completed the Configuration Assistent successfully :-)

The following steps are describing the necessary (more...)

A quick look on WLSDM for WebLogic Server

WLSDM (WL Smart Dashboard & Monitoring) was already mentioned by some people within the Oracle WebLogic Community.

The WLSDM tool is a Console extension with which you can monitor your Oracle WebLogic Server environment. But its not only a pure monitoring tool, its more than this, it provides on top even Notifications and Alarms for metrics.

Current release for WLSDM is 2.3.1 which also comes with Oracle SOA Support :-)

The installation is (more...)

WebLogic Server 12.2.1.1.0 available

Since 21st June 2016 the latest release of Oracle WebLogic Server 12.2.1.1.0 is available for download under Oracle Technology Network.



Under the "What's New in Oracle WebLogic Server 12.2.1.1.0" document you can find all new features for the latest release of Oracle WebLogic Server 12.2.1.1.0.
In general the Release 12.2.1.1.0 is the first patch set for Oracle (more...)

Audit Activities of WebLogic Server in Enterprise Manager 13c

In Oracle Enterprise Manager 13c were introduced a nice new feature for auditing activities of Oracle WebLogic Server events.

Before you can audit your activities like Domain login, Domain logout and Domain updates, you have to enable them via a simple emcli command.

Logon to your server which is hosting your Oracle Management Server (OMS) and perform following steps:

[oracle@em13c]# emcli login -username=sysman
Enter Password:
Login successful
[oracle@em13c]# emcli update_audit_settings \
-operations_to_enable="WEBLOGIC_DOMAIN_UPDATE_INVOKE;WEBLOGIC_DOMAIN_LOGIN;WEBLOGIC_DOMAIN_LOGOUT"
Successfully updated the (more...)

ALTER USER RENAME – Part 3

This is part 3 of the ALTER USER RENAME series

Inspired by a Twitter Comment from Franck Pachot and as I love to test really funny and strange things with Oracle Products.



I was trying to rename the SYS user and the SYSTEM user.

SQL> alter session set "_enable_rename_user"=true;
(more...)

ALTER USER RENAME – Part 2

It seems that my first blog post today "ALTER USER RENAME - A half official option" got some great attentions :-)

How did I come to the ALTER USER RENAME command? Just a lucky punch due to my customer. My customer were trying to rename an user in an Oracle Database with several objects (tables, view, functions, types and so) by simply updating the sys.user$ table :-)
The result were better than (more...)

ALTER USER RENAME – A half official option

Many times DBA's have to rename / copy complete users/schemas from the current name to a new name within one database. Since several years DBA's are asking for a simple method inside Oracle to execute something like "ALTER USER RENAME".

Common approaches to rename users/schemas are:
  • IMPDP with REMAP_SCHEMA
  • update of sys.user$
For the option "update of sys.user$", which is in my opinion a really bad choice, see Tom Kyte's comment 



CPUJan2016 – WebLogic Server 12.1.2.0.8 OPatch apply error

Since 19th January 2016 the Critical Patch Update for January 2016 is out.
In case you are trying to apply the CPUJan2016 against an Oracle WebLogic Server 12.1.2 you may run into following error:

Verifying the update...
[ Error during Update inventory for apply Phase]. Detail:
There are 1 copy files under ORACLE_HOME that are not patched.
Files check failed: Some files under ORACLE_HOME are not patched.
Please see logfile for details.
[ (more...)

Enterprise Manager 13c Presentations on Oracle Technology Network

As everybody already know that the latest version of Oracle Enterprise Manager 13c (13.1.0.0) has been released yesterday (see also my post from 18th December 2015), Oracle has uploaded several interesting presentations around the new Oracle Enterprise Manager 13c.

The presentations are covering various topics around the Oracle Enterprise Manager 13c (some presentations are also still covering Enterprise Manager 12c):

  • General
  • Cloud Management
  • Middleware Management
  • Database Management
  • Installation & Upgrade | (more...)

Oracle Enterprise Manager 13c available

Seems its early Christmas :-) the new release of the Oracle Enterprise Manager 13c (13.1.0.0) is available for download in the Oracle Technology Network http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html



The new Oracle Enterprise Manager 13c is available for:


  • Linux x86-64
  • Windows x86-64
  • Solaris (SPARC)
  • Solaris (x86-64)
  • IBM AIX on POWER Systems
  • HP-UX Itanium


Happy download :-)

Oracle Enterprise Manager 13c – First Video on Oracle Learning Library YouTube Channel

I just discovered that since today (18th December 2015) is a first Oracle Learning Library video for the Oracle Enterprise Manager 13c (!!!!!) available.




Enjoy watching it :-)

WebLogic 12.2.1 – Redeployment of versioned applications via RESTful Management Services

With the latest release of Oracle WebLogic Server 12.2.1 came quite a lot of enhancements for the RESTful Management Services. The enhancements are really impressive, you are able to monitor (GET) or to modify (POST) your WebLogic environment in detail with a simple URL call either via Browser or via Command Line Tools like cURL. The response time for such REST calls are really impressive compared to the classical way with WLST scripts (more...)

WebLogic 12.2.1 – New Feature for Data Source System Properties

Within the new release of Oracle WebLogic Server 12.2.1 is a really cool new feature for Data Source System Properties.

In case you have mutliple data sources defined within your Oracle WebLogic Server pointing to the same Oracle Database and mostly using the same Oracle Database user, you have currently limited chances to identify in your v$session, which session belongs to which WebLogic Server Data Source.

For example, you have 2 Data Sources (more...)

Oracle Forms 12c (12.2.1) first impressions

As I already posted over the weekend, several new Oracle Fusion Middleware Components were released by Oracle.

One of this new Components is Oracle Forms & Reports 12c (12.2.1).

I have been playing around a little bit with the latest release:


  • Oracle Forms & Reports 12c is now requiring a configured Meta Repository
  • Don't try to use as the underlying Oracle WebLogic Server 12c (12.2.1) the "standalone" WebLogic Server, you NEED (more...)

Several New Oracle Fusion Middleware Components 12.2.1 available

Oracle has been busy releasing several new Release for various Oracle Fusion Middleware Components on Friday 23rd October 2015

Oracle WebLogic Server is now available as Release 12.2.1
Download can be found here: http://www.oracle.com/technetwork/middleware/weblogic/downloads/index.html

  • There are in general 3 options available for the latest Oracle WebLogic Server 12.2.1
  • Quick Installer for Developers for Windows, Linux and MAC OS X
  • Generic Installer
  • Fusion Middleware Infrastructure Installer
Oracle Forms & (more...)

APEX 5.0 available for download

Since yesterday (15th April 2015) the latest Oracle Application Express (APEX) release 5.0 is available for download.

APEX 5.0 can be found under http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html



The new APEX 5.0 is supported for all Editions of Oracle Database 11.1.0.7 or higher, even Oracle Express Edition 11g (XE) can be used for the new APEX 5.0