Oracle XE 12c becomes Oracle XE 18c

Oracle Database, Express Edition (XE) is a free version of the Oracle Database, currently available as version 11g (11.2) for Windows and Linux.
A planned new version of Oracle XE based on 12c (12.2) was first mentioned back in 2013. Now we are in 2017 and Oracle has changed its version numbering, aiming for yearly releases of the database, which means that after 12c comes 18c (in 2018) and 19c (in 2019) and (more...)

VirtualBox 5.1.30

VirtualBox 5.1.30 has been released.

Downloads and changelog in the usual places.

It installed fine on a Windows 7 host on my PC at work. I’ll probably do the macOSX Sierra and Oracle Linux 7 installations tonight and update here.

Happy upgrading!

Cheers

Tim…


VirtualBox 5.1.30 was first posted on October 17, 2017 at 2:42 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use (more...)

Oracle C functions annotations

Warning! This is a post about Oracle database internals for internals lovers and researchers. For normal, functional administration, this post serves no function. The post shows a little tool I created which consists of a small database I compiled with Oracle database C function names and a script to query it. The reason that keeping such a database makes sense in the first place, is because the Oracle C functions for the Oracle database are (more...)

Oracle SOA Suite developer IDE: Creating a BPEL process (101HelloWorld)

After downloading and installing jdeveloper SOA Suite edition here a short 101 for building a BPEL process. (Nearly 10 years ago i posted the lost collaxa tutorials: 101.HelloWorld. All of these tutorials can be found here.)

First you have to start your jdeveloper (Middleware/Oracle_Home/jdeveloper/jdev/bin/jdev) and choose "All Features":
Then create a new application:
and choose SOA application:
and walk through the application wizard:
application wizard 2/3
application wizard 3/3
application wizard 3. (more...)

UKOUG Partner of the Year Awards – contribution to bringing Glassware Home

Proud to have been part of the Capgemini team who picked up some Glassware last night at ther UK Oracle User Group Partner of the Year Awards …

UKOUG Awards evening

UKOUG Awards Won by Capgemini

 

Gold – Business Transformation

Silver – Middleware


Oracle SOA Suite developer IDE: Jdeveloper 12c (download & installation)

After installing an Oracle 12c database onto an Oracle Linux i want to run Oracle's SOA Suite. But before the installation of SOA Suite 12c including the application server, i decided to download Jdeveloper to get a first impression of BPEL processes in version 12c (several years ago i did some projects with Oracel Fusion and Oracle SOA Suite 11g).

First try, to get Jdeveloper with SOA Suite extensions (skip these 4 steps - (more...)

Oracle and the Autonomous Database (a personal perspective from afar)

Yeah, if you hadn’t seen that one coming, hmmm, what can I say… Lot’s of…

Dockerize your APEX development environment

Nowadays Docker is everywhere. It is one of the main components of Continuous Integration / Continuous Development environments. That alone indicates Docker has to be seen more as a Software Delivery Platform than as a replacement of a virtual machine.

However ...

If you are running an Oracle database using Docker on your local machine to develop some APEX application, you will probably not move that container is a whole to test and production environments. Because (more...)

Testing Amazon RDS for Oracle: Plotting Latency and IOPS for OLTP I/O Pattern

This is just a quick blog entry to direct readers to an article I recently posted on the AWS Database Blog. Please click through to give it a read: https://aws.amazon.com/blogs/database/testing-amazon-rds-for-oracle-plotting-latency-and-iops-for-oltp-io-pattern/.

Thanks for reading my blog!

 


Filed under: oracle

Thanks ODC, Oracle WIT Edition #ThanksODC

Just in case you wondered, if you do a search for #ThanksODC and leave the “C” off, you get a lot of stuff on the boy band, One Direction…. You can thank me later for that warning….

The sheer amount of thank you posts for Oracle Development Community Appreciation Day, (#ThanksODC) and the historical hashtag for reference, #ThanksOTN are impressive, but I waited a day on mine so I could continue the support for the (more...)

ODC Appreciation Day: Oracle GitHub Docker Images and Oracle Container Registry

It's time again for the ODC Appreciation Day (formerly known as OTN Appreciation Day) driven by Tim Hall.

My personal favorite this year are the Oracle GitHub Docker Images and the Oracle Container Registry.

The Oracle GitHub Docker Images (https://github.com/oracle/docker-images) are the "Community Version" provided by Oracle. So in order to use them you will need to download upfront the required Installation Software from OTN or Oracle Software Delivery Cloud.

Under the (more...)

ODC Appreciation Day: The PL/SQL Language

Like last year, Tim Hall of oracle-base.com fame suggested we should all do an "ODC Appreciation Day" in honor of the Oracle Developer Community (ODC), by blogging about our favorite Oracle product or feature.

My personal favorite, after the database itself, is the PL/SQL language that runs inside the database.



Here's what's great about it:
  • Simple (and therefore easy to understand and quick to learn)
  • Runs everywhere the Oracle database runs (any operating (more...)

ODC Appreciation Day : Apiary Editor

This post is my contribution to the Oracle Developer Community (ODC) Appreciation Day. The idea of the event is best explained by Oracle Base – go here.

The Apiary Editor has to count as a pretty new entry into the possible features that could be considered with Apiary only coming into the Oracle family in the last year. Apiary as a solution provides a platform by which modern REST based APIs can be designed, documented (more...)

ODC Appreciation Day : Oracle Exadata Database Machine

Those that know me well, will know about my “appreciation” of the “Oracle Exadata Database Machine“, more commonly known as “Exadata🙂

So this will be my contribution to ODC Appreciation Day formally known as OTN Appreciation Day, a great initiative by Tim Hall aka Oracle-Base.com.

You can see a summary of last year’s blog post here:
OTN Appreciation Day : Summary

The very first Exadata, was the (more...)

Oracle Linux: How to change from uek to Red Hat compatible kernel

After a standard installation of Oracle Linux the uek kernel is bootet by default (unbreakable enterprise kernel).
# uname -a
Linux localhost.localdomain 4.1.12-94.3.9.el7uek.x86_64 #2 SMP Fri Jul 14 20:09:40 PDT 2017 x86_64 x86_64 x86_64 GNU/Linux
This behaviour can be changed with these commands:
First you have to get the linenumber of your new target kernel:
# grep ^menuentry /etc/grub2.cfg  | xargs printf '%s\n' |grep Oracle
(more...)

12c Parse

Following on from a comment to a recent posting of mine about “bad” SQL ending up in the shared pool and the specific detail that too much bad SQL could cause contention problems while staying virtually invisible, there’s a related note today on the ODC (formerly OTN) forum of a little change in 12.2 that alerts you to the problem.

Try executing the following anonymous block (on a non-production system):


declare m1 number;
begin
         (more...)

Presentations from Oracle Open World

With Oracle Open World 2017 over the ICS presentation is available at – Oracle integration cloud service (ICS) best practices learned from the field (OOW17)

We saw a lot of exciting new features and capabilities coming from Oracle in the ICS space. So keep an eye on the site as we publish new articles.

The API Platform presentation that was co-presented with Luis Weir is here…


Where in the World is Goth Geek Girl, Week 41

So now that I’m finished just taking it easy, playing hooky from Oracle Open World and Oak Table World…uh, yeah….

I get to recover from emergency surgery for another week and while I’ve been busy writing slide content, building out new abstracts for the new year, along with content for a couple books, I’m finishing chapters on.  My ebook is about to come out for DevOps for (more...)

Driving for Change- Women of Oracle

Somehow I’ve made it a pastime of pointing out how many times women are passed up for recognition while men are promoted around them. Its not that the men were identified as better or worse than women, but just about how heavily we scrutinize and limit women while everyone else passes them by. Now I’m going to ask the Oracle folks to not take this personally, but hopefully (more...)

Parsing

Here’s a quick quiz.

According to the Oracle 12.1 Database SQL Tuning Guide the first stage of parsing a statement is the Syntax Check, which is followed by the Semantic Check, followed by the Shared Pool Check. So where you do think the statement text will be while the Syntax Check is going on ?