From time to time I read a question (or, worse, an answer) on OTN and wonder how someone could have managed to misunderstand some fundamental feature of Oracle – and then, as I keep telling people everyone should do – I re-read the manuals and realise that that sometimes the manuals make it really easy to come to the wrong conclusion.
Having nothing exciting to do on the plane to Bucharest today, I decided it (more...)
Es tut sich ganz schön was in der APEX Community dieses Jahr. APEX 5.0 wurde veröffentlich
. APEX Connect
im Juni findet statt und sollte bisher der größte APEX-Treffen im deutschprachigen Raum werden. Nun, wurde auch eine Reihe an Webinaren organisiert - APEX 5.0 Summer School
- für alle, die keinen Urlaub machen oder für diejenigen, die den Urlaub langweilig finden. Meldet euch an. Die Anzahl der freien Plätze ist nicht unendlich.
Next up in the 2015 ‘How I work‘ series is Mark Heppell. Mark is one of Cedar’s longest serving employees having been with us for 16 years. As a consequence he’s been on almost all our client sites, so he’s one of our better known and most beloved consultants.
Mark is one of Cedar’s key PeopleSoft developers and is one of the first people that we all turn to when there’s something beyond our abilities. (more...)
Im Rahmen der APEX Summer School 2015 ( Twitter Handle: #apexsummer2015 ) werden wir 9 kostenlose Webinare
zum Thema APEX 5 mit den Experten aus dem deutschsprachigen Raum durchführen:
Vielen Dank an Carsten Czarski
für die Einladung und Organisation! Nicht zuletzt auch vielen Dank für die klasse Homepage des Webinars, alles 100% APEX 5 out-of-the-box! Ein einfaches und dennoch wirkungsvolles Beispiel dafür, was standardmäßig mit APEX 5 möglich ist:APEX 5
ist seit letzter Woche (more...)
Just under three years ago, I joined Enkitec when they acquired Sumneva. The next three years brought a whirlwind of change and excitement - new products, additional training, and expanding the APEX practice from an almost nonexistent state to one of the best in the world.
Like all good things, that run has come to an end. Last Friday was my final day at Accenture, and I am once again back in the arena of (more...)
There are some stickers are out there causing quite the sensation
in the Oracle APEX Twitter community. Check it out and join the conversation.
A couple of weeks ago I received my sticker from the master dealer, Juergen
, so I thought I'd share my pimped up laptop, complete with sticker friend.
|Pimp my laptop|
Fun fact: the photo was taken on the same grass that formed my blog's title image.
And now I also learn (more...)
There’s a somewhat sour discussion going on based attached to the video at https://www.youtube.com/watch?v=jZW-uLb52xk
Whether you agree or disagree with the video or the comments, or (sadly) the animosity in them, it does lead to an interesting bit of investigation when it comes to data types with arbitrary precision, which was stumbled upon by a friend at work.
Let’s start with a simple comparison between two dates. In this case, I’ve just (more...)
In general it is known that Function-Based Indexes (FBIs) can no longer be used by the optimizer if the expression contains literals and CURSOR_SHARING = FORCE / SIMILAR (deprecated) turns those literals into bind variables. Jonathan Lewis described the issue quite a while ago here
in detail.In a recent OTN thread
this issue was raised again, but to my surprise when I played around with a test case that mimicked the OP's problem query (more...)
Sorry for the long title!
I had a question during my session about “advanced RAC programming features” during the last Paris Oracle Meetup about the MAA connection string. I showed an example taken from the Appication Continuity White Paper (http://www.oracle.com/technetwork/database/options/clustering/application-continuity-wp-12c-1966213.pdf). Someone from the audience asked me if I had experienced any problems with it, such as very slow connection timeouts. I haven’t, but wanted to double-check anyway. This is a (more...)
The following simple example shows how to push the basic hello world Python application to IBM Bluemix. We use the buildpack below.
1. Create a file called requirements.txtpas@pass-mbp:~/bluemix-apps/python-demo$ cat requirements.txt
2. Create a file called runtime.txt
to detail the Python version to usepas@pass-mbp:~/bluemix-apps/python-demo$ cat runtime.txt
3. Push the application using the buildpack above.
pas@pass-mbp:~/bluemix-apps/python-demo$ cf push pas-phython-demo -m 128m -b (more...)
I was invited to join the vJUG
and give a talk about Large Enterprise Java Architecture
and as a follow-up I also had the chance to be among the first guests of the newly created Virtual JUG Podcast
|Recording the Podcast with Hangouts, Audacity, Skype and Google Docs.|
Featuring regulars Simon Maple, Trisha Gee and Martijn Verburg with guests Markus Eisele and, Daniel Fullarton. The team did a great job guiding the guests through the (more...)
I previously blogged about deploying a Meteor application to Bluemix as follows
The following Buildpack created by an Internal IBM employee streamlines the process of deployment and avoids the need for ENV variables with the pushed application, here;s how. It's also detailed in the GitHub buildpack URL below.https://github.com/bancha001/bluemix-buildpack-meteor
1. Create .cfignore
to exclude the path 'local' to be uploadedpas@pass-mbp:~/ibm/software/meteor/simple-todos$ cat .cfignore
2. Create a manifest.yml (more...)
EMCLI is not certified or supported on Mac OS X, but I wondered if it is possible to run on my new macbook. I searched metalink, googled and couldn’t found any useful information. I thought it should be easy because EMCLI is a java application certified to run almost all enterprise operating systems including HP-UX, AIX, Linux, Windows, Solaris, and we all remember “write once, run everywhere” slogan of Java. Unfortunately it wasn’t as easy (more...)
Back in January 2014, I wrote a script to cleanup an Oracle
student schema. It worked well until I started using APEX 4 in my
student schema. You create the following 75 objects when you create an APEX 4 schema.
OBJECT TYPE TOTAL
Here’s the modified script that ignores the objects created automatically by Oracle APEX when you create a
In this post, we’re going to perform a push button refresh of an Oracle Database, Application Express (APEX) installation, and Tomcat webserver.
“But Oracle Alchemist,” you’re probably thinking, “we know about that. You’ve told us about how Delphix can provision and refresh data.” And yes, you’d be right. But I wasn’t done yet.
We’re going to perform a refresh of an Oracle Database, APEX installation, and Tomcat running in Amazon Web Services, replicated from (more...)
Recently I came across “ORA-00353: log corruption near block change time” error.
Errors in file /oracle/app/diag/rdbms/test/test/trace/test_ms00_54284.trc (incident=1490189):
ORA-00353: log corruption near block change time
ORA-00353: log corruption near block 4631374 change 263470473806052 time 04/16/2015 06:53:16
ORA-00312: online log 43 thread 3: '+REDO02/test/onlinelog/group_43.258.875922665'
ORA-00312: online log 43 thread 3: '+REDO01/test/onlinelog/group_43.258.875922633'
Incident details in: /oracle/app/diag/rdbms/test/test/incident/incdir_1490189/test_ms00_54284_i1490189.trc
Thu Apr 16 08:14:42 2015
Sweep [inc]: completed
Thu Apr 16 08:14:55 2015
LOGMINER: WARNING: error (more...)
This book touches a myriad of new features of oracle database 12c relevant to DBA’s, developers and architects. It starts with new features as well as step by step detailed instructions of installation along with relevant screenshots followed by an introduction to EM Express. Next chapter covers new features related to upgrading to Oracle Database 12c and various methods to perform the upgrade. All the subsequent chapters explore a whole lot of new (more...)