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

OBIEE automatic redirect to a Dashboard via mod_rewrite

Normally end users would like to have a simple URL access for Oracle Business Intelligence Enterprise Edition (OBIEE) 11g like http://webhost:7777 and than to be automatically redirected to their Dashboard, instead of typing endless complex URL's.

Assuming you have following standard implementation of an OBIEE environment which contains an Oracle HTTP Server (OHS) configured with mod_wl_ohs to be proxied to point to your WebLogic Server hosting OBIEE and an OBIEE Server, you can simply use (more...)

Oracle 12.1.0.2.0 for Linux and Solaris available

The long awaited Oracle Database Server 12.1.0.2.0 is available under Oracle Software Delivery Website https://edelivery.oracle.com

Currently the 12.1.0.2.0 is available for:

  • Linux 64bit
  • Solaris SPARC
  • Solaris Intel 64bit

Happy download :-)

Oracle 12c Database (12.1.0.1.0) available for download

The long awaited Oracle 12c Database (12.1.0.1.0) is available for download under http://edelivery.oracle.com



Currently only the Linux Release is available.

Happy downloading to all :-)

Oracle WebLogic Server 11g: Interactive Quick Reference

Oracle has published a really nice and useful Oracle WebLogic Server 11g Interactive Quick Reference under the following link http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/wls/Poster/poster.html



The Quick Reference shows you an architecural overview of the Oracle WebLogic Server processes, tools, configuration files, log files and so on including a short description of (more...)