Did You Register for the Siebel CRM Roadshows?

The OPN team has prepared 2 fantastic training & networking opportunities for our Siebel partners! Check out the details below and make sure you register for one of the events – you are sure to gain important updates regarding the Siebel CRM executive strategy, integrations in the Cloud, case studies and more!


  • When: Wednesday 10th August, 2016, 9am-5pm
  • Where: Oracle Stonebridge office at Austin - Stonebridge Plaza II, 9600 North Mopac, Austin, Texas
  • (more...)

Application Item Prefix Usage

I was constructing a fresh app for a presentation idea and I came to think about the prefix people use for Application Items in Oracle APEX.

I've seen a few variations used, and upon asking the question on Twitter (as a poll limited to 4 options), some came back with a few other suggestions.

The final tally based on the replies (we'll (more...)

Get Started With Oracle Cloud – New Preconference Training Sessions!

The Oracle University Pre-Conference Training event being held on Sunday, September 18 from 8:30-3:30 just got better with the addition of the following Oracle Cloud training sessions which provide in-depth overview of features and functions designed for those evaluating or just getting started with Oracle Cloud Products:

Oracle FROM_TZ Function with Examples

In this article, I’ll explain what the Oracle FROM_TZ function is and show you some examples. Purpose of the Oracle FROM_TZ Function The purpose of the FROM_TZ function is to convert a TIMESTAMP value and a specified TIME ZONE to a TIMESTAMP WITH TIME ZONE value. It seems like a simple data conversion function, but […]

Monitor SOA Suite service response times with Splunk by Maarten Smeets

clip_image001Measuring performance of services can be done in various ways. In this blog article I will describe a method of measuring Oracle SOA service response times with Splunk a popular monitoring tool. In order to monitor service response times with Splunk, Splunk needs to obtain its data from somewhere. In this example I’ll use the HTTP access log which I expand with a time-taken field. Disclaimer; my experience with Splunk is something like 2 hours. (more...)

How To Learn Real Application Clusters (RAC) Administration

glasses-272399_1280-smallIn yesterday’s post about Learning, Career Development and Mentoring I mentioned a specific question I had been asked about learning RAC. I get it quite a bit, and after reading the comments from that post I thought I would write something I could use as a reply to that type of question in future. So here it is.

It’s very much an opinion piece, but I would like (more...)

OBIEE – New Feature Guide

Oracle has recently released version for OBIEE 12c, which has a variety of exciting new features for Data Visualization, BI Publisher, Dashboards in OBIEE, and ODBC connections. It can be performed as an in-place upgrade (performed by the Upgrade Assistant) or as a fresh install. The upgrade process is explained at length here. There is also an example Linux in-place upgrade from to which (more...)

Proactive Bundle Patches – Change reflected now in MOS as well

Now the Known Isuses and Alerts and Recommended Patches Notes in MOS reflect the naming and classification change of the different types of patches as well. See in: MOS Note:1683799.1 - Patch Set - Availability and Known Issues We don't speak about Bundle Patches for Exadata and DBIM anymore... [Read More]

Training Thursdays: Learning Objectives When Adopting Oracle Linux 7

If you are familiar with Linux and you are planning to adopt Oracle Linux 7, here are your key learning objectives:

  • Install and configure Oracle Linux 7
  • Configure the Oracle Linux 7 boot process
  • Manage services in Oracle Linux 7
  • Configure networking in Oracle Linux 7
  • Install and update software packages in Oracle Linux 7
  • Configure storage in Oracle Linux 7
  • Perform security administration in Oracle Linux 7
  • Configure system logging in Oracle Linux 7
  • (more...)

Selecting Data from the Repository


As you may know, one of the many areas of responsibility I have as a product manager in the Enterprise Manager product management team is BI Publisher. BI Publisher is the tool of choice for reporting in Enterprise Manager. If it’s not a tool you’re familiar with, then you are missing out on a lot of the power of the Enterprise Manager repository to provide you the information you need to extend Enterprise Manager (more...)

SQLcl: ANSICONSOLE and Column Header Formatting

Question: Why is SQLcl truncating my column header names? It doesn’t do it if I use SET SQLFORMAT ANSICONSOLE though… Answer: Because, SQL*Plus. Longer Answer: SQLcl follows the SQL*Plus rules. And in this case, the rule is: The default width of CHAR and VARCHAR2 (VARCHAR) columns is the width of the... [Read More]

Introducing the OTN Community Update!

Watch your one-stop source for the latest in Oracle technology and community Today! We’re pleased to introduce the first iteration of the OTN Community Update. This first edition focuses on the Middleware community. The Middleware Community Udpate starts with a quick look at the releases of Oracle... [Read More]

Losing /u01

There was an incident where /u01 was lost.

This means having to reinstall and patch software again.

When installing grid and I encountered:

CRS is already configured on this node for crshome=/u01/app/oracle/product/11.2.0/grid

Ah Crap! This is me being melodramatic.

The system was using Oracle Restart, it needs to be removed.

# /u01/app/oracle/product/11.2.0/grid/crs/install/roothas.pl -deconfig -force -verbose  

In hindsight, it would have been much easier to delete from /etc/oracle.

Guess what? ASM will (more...)

Bloom Pruning im Ausführungsplan

Maria Colgan hat mal wieder einen Artikel geschrieben, der sich nicht unmittelbar mit ihrem aktuellen Tätigkeitsfeld In-Memory beschäftigt, sondern ihr altes Thema betrifft: die Strategien des Optimizers. Im Artikel zeigt sie einen Plan, der in der Name-Spalte zwei Bloom Filter Erzeugungen aufführt (JOIN FILTER CREATE, PART JOIN FILTER CREATE), aber nur die Verwendung eines der beiden Filter. Der zweite Bloom Filter erscheint in den Spalten Pstart und Pstop und wird zum Partition Pruning verwendet (also (more...)

ReCreate ASM Disks

The following ASM disks were created which does not follow convention:
ASM_REDO01_006, ASM_REDO01_007, ASM_REDO01_008, ASM_REDO01_009, and ASM_REDO01_010

It should be:
ASM_REDO01_001, ASM_REDO01_002, ASM_REDO01_003, ASM_REDO01_004, and ASM_REDO01_005

Hence, we will need to recreate them. Here’s the process for me to remember.

conn / as sysasm
drop diskgroup DATA01;
drop diskgroup REDO01;
SQL> show parameter disk

------------------------------------ ----------- ------------------------------
asm_diskgroups			     string
asm_diskstring			     string	 ORCL:*


# /etc/init.d/oracleasm querydisk -d ASM_DATA01_001
Disk "ASM_DATA01_001" is  (more...)

Oracle TZ_OFFSET Function with Examples

The Oracle TZ_OFFSET function is a useful datetime function. Learn how to use this function and see some examples in this article. Purpose of the Oracle TZ_OFFSET Function The purpose of the TZ_OFFSET function is to display a number that indicates the number of hours from UTC that a specified time is. You can specify […]

VirtualBox with SOA, BPM, OSB and BAM in 33 minutes by Peter van Nes


The Oracle Quick Start installers for Developers are great for probably many developers, but they are limited. Shutting down (or crashing of) JDeveloper will shutdown the domain and there are separate Quick Start installers for SOA and BPM suite. When installing a SOA or BPM environment for development or research purposes i prefer an environment which is more close to a production configuration. Setting up an new environment can take some time when you have (more...)

ADF BC REST Running Live in Oracle Java Cloud

It passed almost two years since my previous post about Oracle Java Cloud and ADF - End-To-End ADF Cloud Deployment Process. There is huge improvement in Oracle Cloud, great progress done in these two years by Oracle. Access and management of Oracle Cloud environment is so smooth now, it is even hard to say you are working with your own on premise servers or cloud machines. This is great, I'm impressed - well done Oracle.


Learning, Career Development and Mentoring

glasses-272399_1280-smallYesterday I received pretty much the same question from three different people, or maybe one person pretending to be three people. 🙂 The questions went something like this.

I want to get good at RAC. Will you teach me?

One of the three suggested I might want to use my Sundays teaching them. 🙂

I’m not mad at people for asking this and I don’t want to offend anyone by mentioning this, but it goes back (more...)

New OA Framework 12.2.4 Update 11 Now Available

Web-based content in Oracle E-Business Suite 12 runs on the Oracle Application Framework (OAF or "OA Framework") user interface libraries and infrastructure.   Since the release of Oracle E-Business Suite 12.2 in 2013, we have released several updates to Oracle Application Framework to fix performance, security, and stability issues. 

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Pack. (more...)