I arrived on evening before just in time for the life cooking event and later at the bar to meet lot of the people I already know and some new too.
The morning begins with (more...)
Over the many years Oracle has been leading the database world, I guess they are now taking something of a wrong turn.
Let me briefly fill you in on my thoughts.
Basically I see two “minor” shifts that are significantly indicative of this:
- Oracle Standard Edition 2
- Oracle ACE Program
Okay, so you might think I am crazy, but let me try to explain.
Oracle Standard Edition 2
Sometime last year, the long expected, (more...)
When inserting data into the database, it is occasionally forgotten (especially by English-speakers) that we need to take steps to ensure we are inserting data correctly and without unexpected character translation.
For example, in SQL*Plus we need to ensure we set the NLS_LANG environment variable to the correct setting for our database before we initiate SQL*Plus.
Here’s a quick example showing what can go wrong:
[oracle@ORA122 ~]$ echo $NLS_LANG [oracle@ORA122 ~]$ sqlplus neil/neil SQL*Plus: Release (more...)
I nipped out to the local supermarket this lunch time to get stuff. I use one of those self-use barcode scanners to log all the goods I put in my basket (apart from the bottle of whisky I was stealing). I then go to the payment machine, scan the “finish shopping” barcode and try to pay. I can’t pay.
I can’t pay as I bought some paracetamol (note to US readers, you know it as (more...)
This is a follow up to earlier Virtual Development Server: Provide Docker images in docker registry for Oracle XE Database and others.
We now try to automated build of all needed images as soon as Oracle GitHub Sources changed or we need to build our Vagrant VirtualBox again from scratch.
After we have already installed Jenkins we now install first some needed plugins.
After this we create our Jenkins pipeline via “New Item”.
Here is the script (more...)
For automation of all of my processes I need Jenkins in my development server.
First I had installed Jenkins as Docker container via Vagrant Docker provider. But with this architecture it was very complicated to create docker images and run Docker containers on the Docker host, in this case my Vagrant Virtualbox.
So for simplification I have decided to install Jenkins with the provisioning of the Vagrant Virtualbox via a shell provider in my Vagrantfile:
#DOAG2016, the largest Oracle Community gathering in Europe. Taking place in Nuremberg, at the Nuremberg Convention Center NCC, one of the more impressive places to hold such a conference, towering 4 stories high, with a big central atrium!!
It is a huge effort to get all of this together!
If you try the newest version 184.108.40.206 (or maybe earlier versions too) you see, that your managed server does not restart, when
- you have deployed your ADF application(s)
- you try to restart the managed server with ADF
- you use intentionally or not shared libraries in your weblogic-application.xml (see example below)
<?xml version = '1.0' encoding = 'UTF-8'?> <weblogic-application xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.bea.com/ns/weblogic/weblogic-application http://www.bea.com/ns/weblogic/weblogic-application/1.0/weblogic-application. (more...)
Another DOAG is over and here are my summary.
Unfortunately the early train from duesseldorf arrives not before 9:30, so I missed the first morning slot. But on the other hand I this was the slot where I had to decide between 8 presentations, which I’m interested in.
Let’s face it: education without interaction is about as effective as shouting origami instructions at a lumberjack who is cutting down trees. Sure, your informative lessons will come in handy when the product of their work finally becomes paper, but it will be long forgotten and ultimately worthless by then. The only way a student is going to learn is if they can put (more...)
The mission was not too hard: write about your favorite bit of Oracle Technology.
Not just because (more...)
Virtual Development Server: Provide Docker images in docker registry for Oracle XE Database and others
For later creation of containers as needed in the deployment process we have first to build docker images whenever we do not find suitable one in docker hub.
For most of my development I need a oracle database. On the internet you can find a lot of Dockerfile’s for this, but no ready image. This is because for running a database you have to accept a license and this happens when you download the installation (more...)
Virtual Development Server: Add swapfile to VirtualBox as requirement for installing Oracle or build Oracle docker images
As I want later build Oracle docker images, some of this need a swapfile.
Per default my used Vagrantbox, does not have one, so later steps will fail.
As in the last blog I use a Vagrant shell provider.
... # add swapfile to the box config.vm.provision :shell, :path => "add_swap.sh" ...
This calls the script add_swap.sh in the created VirtualBox machine.
Make sure, that you create your swapfile on a supported (more...)
Virtual Development Server: Add enough ram and disk space to VirtualBox for further server components
As I want later build docker images and run docker containers I have to provide enough disk space for this.
Per default the Vagrantboxes have vmdk disks, these have a static size and are to small for my purposes.
Therefore I convert the disk, which comes with the box, via Vagrant VirtualBox provider from vmdk to vdi, so that it allocate only the used disk space in the host system.
Additional I add a second (more...)
As I want to decouple my development server from my computer as much as possible I want to create first a virtual machine with linux.
Because I have used Oracle Virtualbox in the past successfully, I will use it here too.
In an ideal world with a well-balanced and high-performing team, theory says it should all be dandy. But what happens when the real world sticks it's nose in and you need to deal with varying degrees of disfunction?
Feature Lifecycle Analysis is a technique I've been experimenting with for a few years. The idea is to visualise how well we are (more...)
Sooner or later you'll hear someone suspect it must be a problem with CI. Which is ironically funny in a shoot-the-messenger kind of way!
Thankfully our "CI issue" turned into a for-real bug. In short, the code involved many classes with near 100% test coverage. It had been read (more...)
In a previous post I explained what Node.js is and how it works. Now, I’ll help you install it and create your first Node.js powered webpage.
I have been considering writing this article for quite some time now.
APEX Connect 2016 in Germany’s capital Berlin and the DOAG Database days have finally persuaded me to talk more about #DBADev, let me explain why…
Whenever in the stone age…
During my career as DBA, I was always working closely together with Oracle Forms & Reports developers. In retrospect, the cooperation in that time was remarkable.
These Forms & Reports developers had always (more...)