TROUG Day Ankara 2014

poster_ankara14As Turkish Oracle User Group (TROUG), we will organize our second meeting in Ankara on December 23rd. The event will be held at the Chamber of Electrical Engineers (EMO). The main theme of the meeting is Oracle 12c. There will be 4 sessions about new features of Oracle 12c (Database In-Memory, Active Data Guard, RAC and Flex ASM and Multitenancy). I usually do presentations about Enterprise Manager but this time, I have picked a more (more...)

LAF 1.7.7 new gift for Christmas

Hello there,
It's been a long time.
This is an amazing new .FMB Forms module, kind of "Tetris" like game.
It needs the last 1.7.7 version of the LAF to run. The game is a little bit buggy, but the aim, there, is only to demonstrate what you can do with new LAF 1.7.7 dynamic shape creation and animation.


Have a good time :-)

Download the brickdown.fmb module there.

Managing Oracle Database 12c with Enterprise Manager – Part III

We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog posts on this topic, we came to the Provision Pluggable Databases page as seen below. This is accessible via the Container Database Home Page in Enterprise Manager 12c, from the Oracle Database menu.
When it comes to licensing for this page, it needs to be clearly understood. The licensing requirements for the Enterprise Manager Database Lifecycle Management (more...)

Managing Oracle Database 12c with Enterprise Manager – Part II

In the last post, we saw what the discovery of an Oracle 12.1 Container Database (CDB) would look like in Oracle Enterprise Manager 12c, with the CDB and component PDBs all being discovered by the EM Agent that has been installed on the target database server.
Drilling down to a CDB, the following screenshot illustrates how the CDB Home page would appear. The Home Page shows the list of Pluggable Databases in (more...)

Managing Oracle Database 12c with Enterprise Manager – Part I

A friend from a lovely country in South America wrote to me :
“Hi My Friend!! My colleague has installed an Oracle Database 12c Container database (CDB) and he has created 2 Pluggable databases (PDBs) on it. He is keen to manage the CDB and PDBs in Enterprise Manager.
“But, when he adds the database to Enterprise Manager 12c, he sees it like a non-CDB and there is no way to work with PDB’s (in (more...)

NWOUG Women in Technology Scholarship

This year the Northwest Oracle User Group created a scholarship for an outstanding female student in the Portland State University Computer Engineering  Department.  The criteria was straight-forward.  In addition to being an outstanding student we asked all the applicants to answer this question:

“How does employee participation in professional communities add value for their employers?”

The arguments for promoting WIT are well-documented elsewhere, and it had a bearing on our decision.   But we also (more...)

Oracle database operating system memory allocation management for PGA

This post is about memory management on the operating system level of an Oracle database. The first question that might pop in your head is: isn’t this a solved problem? The answer is: yes, if you use Oracle’s AMM (Automatic Memory Management) feature, which let’s you set a limit for the Oracle datababase’s two main memory area’s: SGA and PGA. But in my opinion any serious, real life, usage of an Oracle database on Linux (more...)

View application log files in PCF using the CF CLI

I recently setup verbose GC logging on a  deployed application to Pivotal Cloud Foundry (PCF) and specified a file to write the GC logging info to. Below shows how you can view application files using the CF CLI.

1. Start by invoking the following to show your deployed applications

[Tue Dec 16 09:32:10 papicella@:~/cf/APJ-vcloud ] $ cf apps
Getting apps in org ANZ / space development as pas...

name           (more...)

Linux cluster sysadmin — OS metric monitoring with colmux

In this mini-series of blog posts I’m taking a look at a few very useful tools that can make your life as the sysadmin of a cluster of Linux machines. This may be a Hadoop cluster, or just a plain simple set of ‘normal’ machines on which you want to run the same commands and monitoring.

First we looked at using SSH keys for intra-machine authorisation, which is a pre-requisite executing the same command (more...)

ora:getAttachmentProperty: Failed to decode properties string

Last week I created a process that polls the usermessagingservice-email adapter to read emails and store the email with attachments as Oracle ACM case documents.

For simple e-mails this works fine, but with some emails I get the error:
0An error occurs while processing the XPath expression; the expression is ora:getAttachmentProperty('Content-Type', 'ReceiveMessage_ReceiveNotification_InputVariable','body', '/ns2:message/ns2:attachment[$AttachmentId]').XPath expression failed to execute.

An error occurs while processing the XPath expression; the expression is ora:getAttachmentProperty('Content-Type', 'ReceiveMessage_ReceiveNotification_InputVariable','body', '/ns2:message/ns2:attachment[$AttachmentId]').

The XPath (more...)

“4k bug” is not a bug

A couple of weeks back I received an update on my “4k bug” SR (slow multirow DML performance for small block sizes). As it turns out, the observed behavior is not a bug. It’s actually more interesting than that. It is an undocumented feature that controls the insert mode depending on the estimated row size (the sum of all column sizes). If the estimated column size exceeds the size of the block, then Oracle switches (more...)

The UKOUG Apps14 Conference

Cedar had a strong presence at the recent Apps14 conference in the ACC, Liverpool. It is supposed to be the largest applications conference in Europe with over 800 attendees, and we were particularly interested in the PeopleSoft and Apps Innovation streams.

This year we’d decided not to have a stand (as the conference is mixed with the other applications and the database/tech community, it means the exhibition stands are much more expensive than at the PeopleSoft-only (more...)

What makes MapR superior to other Hadoop distributions?

These days Hortonworks with their IPO and Cloudera sitting on $1bn of cash grab all the headlines. However,the real visionary in the field is someone else. Someone blasting the previous world record in TeraSort . A Hadoop distribution on both Amazon Web Services and the Google Compute Engine. A company that Google is invested in. While their competitors have been in skirmishes with each other, MapR has been quietly working away and innovating.

MapR-FS: Features and (more...)

Develop against the versions in the Yum repositories!

I saw a tweet by Simon Haslam at the weekend that read,

“I’m v surprised to read that @Atlassian Stash needs newer git than in the latest RHEL/OL6 repos!”

I had a similar experience at the weekend too, but this time with Oracle REST Data Services (ORDS) 3.0 EA. According to the documentation, it requires the following version of Tomcat.

“Apache Tomcat Release 7.0.56 or later”

So let’s have a look (more...)


Purpose is to demonstrate how to create HA for Bi-Directional Replication Goldengate installed on ACFS with RAC cluster using XAG.

XAG simplifies the process since there are no requirements to create action scripts.

Please review REFERENCE section for versions used in test case and versions requirements.

Goldengate is installed on ACFS for simplicity; otherwise, at a minimum the following directories br, dirchk, dirdat, dirtmp will need to be on shared storage with symbolic links if (more...)

Running Java Mission Control and Flight Recorder against WildFly and EAP

Java Mission Control (JMC) enables you to monitor and manage Java applications without introducing the performance overhead normally associated with these types of tools. It uses data which is already getting collected for normal dynamic optimization of the JVM resulting in a very lightweight approach to observe and analyze problems in the application code. The JMC consists of three different types of tools. A JMX browser which let's you browse all available JVM instances on (more...)

Some thoughts on Continuous Delivery

Continuous Delivery is something a lot of companies strife for. It is changing the way we develop software to allows quick (continuous) delivery of business value. Why is it difficult to achieve and what are the challenges which need to be faced? Inspired by a Continuous Delivery conference in the Netherlands and personal experiences, some personal thoughts on the subject. The bottom line is that it requires a cultural change in a company and it is a (more...)

Day 3+ of UKOUG Tech 14

Sorry it’s taken a couple of days to finish off this series of blog posts on UKOUG Tech 14. I had expected to get some time on the trip back to write this, but as you’ll see if you keep reading, that really didn’t happen. So let’s go back to Day 3 of the conference.

I started the day by attending Patrick Hurley’s “Adventures in Database Administration” session. This was quite different to the normal (more...)

ORA-4068 and CONSTANT keyword…good and bad

Anyone that has ever coded PLSQL will be familiar with the error ORA-4068, where you had some state persisted in a session due to a package variable, and then when you change the package, the state is cleared along with an ORA-4068.  Here’s a quick example:


Session 1 

SQL> create or replace
  2  package PKG is
  3    procedure P;
  4  end;
  5  /

Package created.

SQL> create or replace
  2  package body  (more...)

How To Set EAR Upload Size for Oracle Enterprise Manager

By default, there is a limit for EAR upload size (~40 MB) in Enterprise Manager. If your ADF application is fairly big, you may face this limitation and will not be able to deploy through Enterprise Manager. Deployment for large EAR would work through WebLogic console, WLST script or directly from JDEV, however sometimes you may need to deploy through Enterprise Manager. I will describe in this post, how you could increase the limit - (more...)