Oracle Transportation Management Cloud Webcast Series

If your organization moves goods, you know that the challenge of meeting delivery schedules while controlling costs and complying with international regulations is an ongoing struggle. The volatility of today’s market conditions makes this harder than ever. Wouldn’t you like to have the best systems available as quickly as possible and at a low cost? Now you can!

Join us for these upcoming webcasts to learn how Oracle’s market leading Transportation Management applications can be (more...)

Real-time Big Data with Oracle GoldenGate 12c

Oracle recently announced the enhanced version of Oracle GoldenGate 12c with expanded support for heterogeneous databases and big data solutions, improved manageability, and support for hybrid cloud environments.

Oracle GoldenGate 12c provides best-of-breed, real-time data integration and heterogeneous database replication. Among many new features, is better support for Big Data with Oracle GoldenGate Adapter for Java enabling integration with Oracle NoSQL, Apache Hadoop, Apache HDFS, Apache (more...)

Restoring an Enterprise Controller on a new system

| Nov 20, 2014

An Ops Center user was recently planning a deployment, and they were wondering about disaster recovery. Apart from Ops Center's High Availability option, they asked, what recovery options are available if an EC system completely dies?

One other option that you can use is Ops Center's backup and restore capability. If you've made a backup of your Enterprise Controller, it's possible to restore that Enterprise Controller on a new system. There are a few tricks (more...)

IBM AIX to Oracle Solaris Migration Resources

Getting customers to move from legacy IBM Power Servers to Oracle's SPARC Systems requires educating IT managers, architects, and system administrators on the differences and benefits of Oracle Solaris.

There are several excellent resources available to help you through the sales cycle:
  • Point customers to the Oracle Learning Library.  This free resource includes a migration fundamentals course, hands-on labs for AIX administrators, and technology comparison guides.  Once the customer has a basic level of Solaris (more...)

Tools for MVC in Java EE 8

| Nov 20, 2014

Last week at Devoxx, Manfred Riem (MVC 1.0 Co-Specification Lead) did a session on MVC 1.0 (JSR 371) to a packed room. During the session, Geertjan Wielenga (Principal Product Manager in the Oracle Developer Tools) did a cameo appearance to discuss the tooling in the context of MVC. Amongst other things, Geertjan is looking at some of the potential features an IDE could bring to simplify the development of MVC based (more...)

Christmas Masterclass Oracle SOA Suite 12c

On Friday, December 19, AMIS organises a special XMas-terclass on SOA Suite 12.

SOA Suite 12c (June 2014) was a major release for Oracle’s flagship integration product. This release introduces new functionality, higher developer productivity, more robust run-time scalability and performance. 12c brings together development and administration of Service Bus and SOA composite applications, it ships new technology adapters as well as a SDK to develop custom adapters and provides across the stack support for REST-style (more...)

NetApp Plug-in for Oracle RMAN

Nice feature for Oracle dba's to handle the backups using NetApp technology. Check this demo.. http://community.netapp.com/t5/FAS-Data-ONTAP-and-Related-Plug-ins-Articles-and-Resources/Video-NetApp-Plug-in-2-0-for-Oracle-RMAN-MML-Demo/ta-p/87711

Conference Organisation from the Inside – UKOUG Tech14

An interesting experience I have had this year is being more involved in helping organise the annual UKOUG Oracle Technical Conference – Tech14 this year. I fully intended to blog about things as we progressed, but it never happened. But I thought it would be interesting to do a couple of blogs about it, for anyone interested,

If you have never helped organise a conference or user group meeting then you probably think there is (more...)

Quantum Data

That’s data that isn’t there until you look for it, sort of, from the optimizer’s perspective.

Here’s some code to create a sample data set:


create table t1
as
with generator as (
	select	--+ materialize
		rownum id
	from dual
	connect by
		level <= 1e4
)
select
	rownum					id,
	mod(rownum-1,200)			mod_200,
	mod(rownum-1,10000)			mod_10000,
	lpad(rownum,50)				padding
from
	generator	v1,
	generator	v2
where
	rownum <= 1e6
;

begin
	dbms_stats.gather_table_stats(
		ownname		 => user,
		tabname		 =>'T1',
		method_opt 	 =>  (more...)

Rittman Mead Founder Member of the Red Expert Alliance

At Rittman Mead we’re always keen to collaborate with our peers and partners in the Oracle industry, running events such as the BI Forum in Brighton and Atlanta each year and speaking at user groups in the UK, Europe, USA and around the world. We were pleased therefore to be contacted by our friends over at Amis in the Netherlands just before this year’s Openworld with an idea they had about forming an expert-services Oracle (more...)

ANSI Join Syntax und Prädikatanordnung

Die ANSI-Syntax zur Formulierung von Joins finde ich grundsätzlich deutlich lesbarer als Oracles traditionelle Schreibweise und würde sie vermutlich regelmäßig einsetzen, wenn sie nicht so viele Bugs hervorrufen würde. Einer davon ist gestern in einem OTN-Thread aufgetaucht. Dort hatte sich der Fragesteller darüber gewundert, dass zwei Varianten eines Outer-Joins unterschiedliche Ergebnisse lieferten, je nachdem, ob die ON-Prädikate direkt bei den zugehörigen FROM-Klauseln erschienen, oder getrennt von diesen in einem gemeinsamen abschließenden Block. Mein erster Gedanke (more...)

Progress update on my AWR repository

I received an email from a team member yesterday

Have you seen this? https://docs.oracle.com/database/121/TDPPT/tdppt_awr_warehouse.htm

Interesting idea – ever thought of implementing it?

Well of course I have implemented a AWR data repository and I thought I would catch-up on where I am with it and how it is being used.

The database started out on HPUX on 11.2.0.1 about 2 years ago and is now on Linux on 11. (more...)

OTN APAC 2014 – Auckland – Day 1

So it was really day 2 of the conference, but it was day 1 for me, so that’s the way I’m naming it… :) There were seven tracks available, but I’ll be speaking about what I saw…

First up was the keynote by Tim Ebbeck called 10 Rules of Transformational Leadership. I’m not the biggest fan of keynotes, but this one was pretty cool. To summarise:

  1. Nothing beats being as good as you can be. Get (more...)

Oracle Runcoach Bay Area Challenge: I Won #justsaying

Table backward compatibility in ADF

Hi  All,

Recently i came cross a use case where i need to add  a new column into a table which being already used in production and we need to support this new changes on both version of table schema.
However gradually we will get ride of old version of table. but for now we need to support both schema.
In my case it's only related to fetch operation ,so here i am going to (more...)

Jobs To Be Done. Or #JTBD. We’ve been road testing this…



Jobs To Be Done. Or #JTBD. We’ve been road testing this framework lately.  I like it. Could it be a good fit for the busy cloud developer who wants to build a usable solution that solves a real problem and doesn’t want to deal with the generalizations of personas or overhead of user profiles (a debate in itself)?

Seems like a good fit for the agile world too. Pictured is Julian Orr (left) (more...)

Why You Should Create BPM Suite Business Object Using element (and not complexType)

In this article I describe why you always should base your business object based upon an element, instead of a complexType.

With the Oracle BPM Suite your process data consists of project or process variables. Whenever the variable is based on a component, that component is either defined by some external composite (like a service), or is defined by the BPM composite itself, in which case it will be a Business Object. That Business (more...)

Table TXK_TCC_RESULTS needs to be installed by running the EBS Technology Codelevel Checker (available as patch 17537119).

I got this error while trying to apply a patch in R12.2:

 [EVENT]     [START 2014/11/19 09:18:39] Performing database sanity checks
   [ERROR]     Table TXK_TCC_RESULTS needs to be installed by running the EBS Technology Codelevel Checker (available as patch 17537119).

This table TXK_TCC-RESULTS is created in APPLSYS schema, by the latest version of the checkDBpatch.sh script delivered by 17537119.

So go ahead, download patch 17537119.  

Login as oracle user (more...)

OTN APAC 2014 : Auckland Day Off

The first day of the Auckland conference was made up of hands-on labs and workshops. I wasn’t presenting, so I arranged to meet up with some friends and have a play day. :)

On my way out of the hotel I saw Osama Mustafa, who is still looking buff like a Teenage Mutant Ninja Turtle. On the way to the station I met Anton Els, which was a pleasant surprise. We chatted for a (more...)

JDeveloper Debugging Tips (Watchpoints & Beep)

In a previous blog post I talked about scoping breakpoints for debugging purposes, next to scoping breakpoints JDeveloper has more interesting debugging features to offer.

I created a simple example to show both the watchpoint as well as the beep functionality. To illustrate this, I created a page with an inputText and a button, both bound to a backingBean. 

This  is the jsf code:
 



The code from the bean is also pretty straight forward:
    (more...)