Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

Oracle Database 19c on Fedora 32 300w, 768w" sizes="(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px" />

Fedora 32 was released at the end of April (see here). Here comes the standard warning.

Here are the usual things I do when a new version of Fedora comes out.

I pushed a Vagrant build to GitHub.

So now you know how to do it, don’t. </p />

    	  	<div class=

Say Hello to the WordPress Block Editor

At the beginning of June we’ll be retiring our older editor and transitioning to the more recent (and more powerful) WordPress block editor. Want to know how this may affect your site and what you can expect? Read on.

If you’ve launched your site in the past year and a half you may have never seen our older editor and are likely already using the more recent WordPress editor. Those of you who have an older site, though, might recognize this editing experience:

We know it can be frustrating to get used to an online tool only to see it change or go away. Retiring an entire editor — the place where you publish posts and pages on — is not something we would ever do on a whim. What inspired us to take this decision is the positive experience site owners have had with the newer WordPress editor.

Why switch to the WordPress editor? Let us count the ways.

The WordPress block editor was released over a year and a half ago. Since then, it has improved in numerous ways thanks to thousands of enhancements and fixes  — to the point that we’re certain it offers a far superior experience compared to the older editor. Not sure? You can take the WordPress editor for a spin. In case you’ve never encountered it before, here are only some of the features you’ll find in the WordPress block editor that aren’t available in the older editor.

Over 100 content blocks for publishing virtually any type of page or post
Content blocks can be mixed and matched to customize the content of any page or post.

A growing collection of block patterns
Block patterns are simply collections of blocks pre-bundled together to form beautiful designs.

Dozens of beautiful, built-in page templates
Page templates simplify the creation of common pages within WordPress by giving you a beautiful predesigned template to get started.

Customizable styles directly within the editor
You can now customize the look and feel of your website by testing out different fonts directly within the WordPress editor.

What other options do I have?

We hope you give the WordPress editor a try — it’s been the editing experience of choice for millions since it arrived on the scene. That said, we know some of you might prefer to avoid this change. We’re offering two options for those who’d rather stick with an older way of editing your content.

1) Use the Classic block
Within the new WordPress editor you’ll find the Classic block, which replicates the functionality of the Classic editor — that’s the editor that used to be the default until several years ago, well before we introduced the editor. Here’s what it looks like:

2) Opt to use the Classic editor
You also have the choice to switch to the Classic editor. Here’s what it looks like, in case you haven’t seen this one in a while (or ever):

We hope you enjoy the new WordPress editor — give it a try today to get a taste ahead of everyone else!

Video : NTH_VALUE : Problem Solving using Analytic Functions

Today’s video is a demonstration of the NTH_VALUE analytic function.

This is based on this article.

You might find these useful also.

The star of today’s video is Connor McDonald. This is his second visit to the channel. I’m sure most of you must know Connor from his blog and AskTom. He also has a YouTube channel here.



Video : NTH_VALUE : Problem Solving using Analytic Functions was first posted on May 18, 2020 at 8:10 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

VirtualBox 6.1.8

I’m in the middle of doing loads of Vagrant builds and I got a message to say VirtualBox 6.1.8 has been released. </p />

    	  	<div class=

Social Distancing : My Experience 300w" sizes="(max-width: 232px) 85vw, 232px" />

The UK has started to relax *some* of the lock-down conditions, so I thought I would write down some of my thoughts related to social distancing…

The Good

First and foremost, social isolation and social distancing is predominantly a good thing for me. I live alone, and as I’ve said many times before I like it that way. There is a “work Tim”, a “conference Tim”, a “with friends/family Tim” and a “home Tim”, and it’s the “home Tim” I’m most comfortable with. I’m not talking about some schizophrenic thing. Just different aspects of my personality that I use to cope with different situations. The only authentic me is when I am home alone.

I keep saying to people I’m living my best life at the moment.

The Bad

Having said all that, it’s not been plain sailing. One thing I’m really struggling with is work-life balance. Before this I mostly worked from the office, and my computer at home was for doing my own thing, like the website and blog etc. Since I’ve been working from home the working day has stretched, which has been made worse by some weekend work. When I do eventually switch off, the thought of doing my own thing is really difficult. I feel like I want to walk away from the computer, so that’s what I’ve been doing a lot. I think the solution to this is to define some different phases of the day and try to stick to them. Things have improved since I’ve been actively trying to do this.

Exercise is another issue. The gym is closed, and I find it really hard to be motivated to do anything other than go to the gym. I’ve done very little exercise, which is really not good as I’m a fatty, and being a fatty is not good at the best of times, but it’s even more problematic at the moment. This week I’ve been going on some bike rides at lunch time. Nothing big. Just getting out of the house and moving a bit. Once again, it’s about trying to define phases of the day.

I started the social isolation/distancing thing about a week before most people in the UK. I go to the shop every few days, and go to pick up a prescription once a month. Apart from that I stay home. I think it’s going to remain this way for quite a long time for me, regardless of what the government suggest.

I feel sorry for people who live alone and don’t like it. I feel sorry for families with kids who are going stir crazy. I can’t relate, but I can sympathise.

The Ugly

What this whole thing has taught me is there are some selfish fuckers out there who should go fuck themselves. People who blatantly ignore the rules, without thinking what impact they are having on others. I kind-of expect this behaviour from young people, as they think they are indestructible and are too dumb to think about the bigger picture, so I give them a free pass. What really pisses me off are adults who don’t seem to give a shit.

You don’t know anything about the people around you. You don’t know what their risk factors are. You don’t know if they are worried about relatives they live with that are vulnerable. It is not your position to judge, and you have no right to put them and their families in danger.

Now I admit some people take it too far, like walking in the road when there is nobody on the path, but for the most part people are being sensible and considerate. For those that are not, see my first sentence in this section!

The Good… Again

Despite that there have also been some really positive things.

  • On the whole people seem friendlier and more considerate at the moment.
  • It’s quieter. Lawn mowers are working overtime, but most of the time things are quiet.
  • Life seems a little calmer.
  • I’m not using petrol.

The Future

Some random thoughts from me.

  • I can’t see myself working full time in an office again. I’m not saying I will never go in, but I don’t see myself doing a 5 day week again. My company used to have some issues with working from home, but now we’ve been forced to do it for a few months, I can see a lot of people never going back to the old ways. I’m not sure how they could justify not allowing working from home on a mass scale now.
  • I think it will be quite some time before I consider travelling again, if ever. I had already scaled back my conference stuff, but maybe it’s over for me now. I may change my mind. Time will tell.
  • I want to consume less. Both from a food perspective, and everything else. I’m not a very materialistic person, but I can still cut back. I want my life to be as minimalist as possible.
  • I understand there will be economic hardships as a result of this pandemic, but I hope it has taught people something about themselves. Life doesn’t need to be some dog-eat-dog race. You don’t need as much as you think you do.

OK. The random bullshit is over for now.



Social Distancing : My Experience was first posted on May 16, 2020 at 10:33 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

APEX 20 patch

I’ve been debugging an issue within an APEX application and wanted to make sure that my local installation was at the same version as So I logged on to my workspace and ran queries on APEX_RELEASE and APEX_PATCHES and discovered that there was a patch available for 20.1.

That patch is 30990551 and you can download it from the usual spot on My Oracle Support. None of the bugs listed in the “Fixed Bugs” helped me with my issue, because it turned out to be my own code Smile. But here is what is fixed in the patch:


Installation was quick and uneventful – just running a script and copying some fresh image directories. As always, read the installation instructions carefully to make sure you run the correct script for your environment.

SQL*Plus: Release - Production on Wed May 13 10:45:45 2020

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Last Successful login time: Tue May 12 2020 18:17:47 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release - Production

SQL> conn /@db19_pdb1 as sysdba

SQL> @catpatch

. Application Express (APEX)
. Patch Set Exception 30990551


PL/SQL procedure successfully completed.

Session altered.


Session altered.


Package body created.

No errors.

Package body created.

No errors.

Package body created.

No errors.

Package body created.

No errors.

PL/SQL procedure successfully completed.


Session altered.

Grant succeeded.

Session altered.


Package body created.

No errors.

Package body created.

No errors.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

Commit complete.

...Validating APEX
...(10:46:40) Starting validate_apex for APEX_200100
...(10:46:40) Checking missing sys privileges
...(10:46:40) Re-generating APEX_200100.wwv_flow_db_version
... wwv_flow_db_version is up to date
...(10:46:41) Checking invalid public synonyms
...(10:46:41) Key object existence check
...(10:46:41) Setting DBMS Registry for APEX to valid
...(10:46:41) Exiting validate_apex

PL/SQL procedure successfully completed.

...Recompiling invalid public synonyms

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

timing for: Complete Patch 30990551
Elapsed: 00:00:03.47

Disconnected from Oracle Database 19c Enterprise Edition Release - Production

So if you’re running APEX 20, be sure to patch your instance when you get a chance.

Coming Soon: Make Your Site Private Until You’re Ready to Launch

When you create a new site, you may want to personalize it before making it public. On, we give you a safe space where you can work on building and editing your site until you’re ready to share it with the world. 2048w, 150w, 300w, 768w" sizes="(max-width: 1024px) 100vw, 1024px" />

Until recently, this Coming Soon mode was limited to new sites without plugins or custom themes installed. We realize, however, that many users — regardless of how long they’ve had a website on — might want to make updates, change the design, or add new functionality without making these changes visible to the public until they’re complete. Now, all sites have this Coming Soon option, and you can toggle it on or off as you wish.

To set your site to Coming Soon, go to Manage in the sidebar, select Settings, scroll down to Privacy, and select the Coming Soon button. Be sure to click on Save settings for the change to take effect. 150w, 300w, 768w, 1440w" sizes="(max-width: 1024px) 100vw, 1024px" />

While in this mode, site visitors will see a landing page with your site’s title. You and other logged-in people that you invite will see the full website.

To invite people to view your site while in Coming Soon mode, add them as new users from the ManagePeopleInvite button. Users will need to at least be a Contributor to view the site in this mode. 2048w, 150w, 300w, 768w" sizes="(max-width: 1024px) 100vw, 1024px" />

To make your site public again, go to Manage in the sidebar, select Settings, scroll down to Privacy, and select the Public button. Again, be sure to click on Save settings.

Private sites for all

If instead of sharing your site with everyone, you want to keep it private, and only available to invited members of the site — for instance, a private blog for your family, made up of photos and videos of your children or pets — you can use the Private option under ManageSettingsPrivacy. 150w, 300w, 768w, 1440w" sizes="(max-width: 1024px) 100vw, 1024px" />

In this mode, instead of the Coming Soon landing page, logged-out visitors will see a more discreet prompt to log in. 2048w, 150w, 300w, 768w" sizes="(max-width: 1024px) 100vw, 1024px" />

No matter what you want to do on your site — whether making a few tweaks, refreshing your site design, or building a fully fledged online store — use the Coming Soon feature to keep it private until you’re ready to unveil it to the world.

We hope you enjoy this new feature!

Oracle Linux 8 (OL8) : Podman 272w" sizes="(max-width: 197px) 85vw, 197px" />

When Oracle Linux 8 (OL8) was released, one of the first things I did was check for the Oracle supplied Docker engine. Nothing.

Not to worry I thought. They are probably waiting for UEK6 to ship before they worry about the Docker engine. I pretty much left it at that. I wasn’t really in much of a rush. To be honest, a new version of Oracle Linux doesn’t really hit my radar until the Oracle database is certified on it. </p />

    	  	<div class=

Expert Advice: Business Fundamentals for Creative Professionals

Are you an artist, photographer, or freelance writer? How about a website designer, master metalsmith, or musician? If you’re in any creative profession and would like to learn more about how to market and sell your services and work online, we’ve created a free webinar just for you.

We’ve partnered with our friends at FreshBooks, the leading invoicing and accounting software for creative entrepreneurs, to offer tips on how to build your online store and automate your sales and accounting, leaving you with more time to focus on your craft.

Date: Wednesday, May 20, 2020
Time: 10:00 a.m. PDT | 11:00 a.m. MDT | 12:00 p.m. CDT | 1:00 p.m. EDT | 17:00 UTC
Cost: Free
Registration link
Who’s invited: Artists, writers, musicians, website and graphic designers, photographers, marketers, and anyone else interested in learning how to sell their creative services online.

Your hosts will be Jonathan Wold, Community Manager at WooCommerce, and Irene Elliott, Senior Community Manager at FreshBooks. Dustin Hartzler, a WooCommerce Happiness Engineer, will moderate questions. After the 45-minute presentation, we’ll open up the (virtual) floor for a 15-minute Q&A session.

Attendee slots are limited, so be sure to register early to save your seat! But if you can’t make it, we’ve got your back. A recording of the webinar will be uploaded to our YouTube channel a few days after the event.

See you then!

Always free / always up tmux in the Oracle Cloud with KSplice updates

By Franck Pachot

I used to have many VirtualBox VMs on my laptop. But now, most of my labs are in the Cloud. Easy access from everywhere.


There’s the Google Cloud free VM which is not limited in time (I still have the 11g XE I’ve created 2 years ago running there) being able to use 40% of CPU with 2GB of RAM:

top - 21:53:10 up 16 min,  4 users,  load average: 9.39, 4.93, 2.09
Tasks:  58 total,   2 running,  56 sleeping,   0 stopped,   0 zombie
%Cpu(s): 12.9 us,  8.2 sy,  0.0 ni, 12.6 id,  0.0 wa,  0.0 hi,  0.3 si, 66.0 st
GiB Mem :    1.949 total,    0.072 free,    0.797 used,    1.080 buff/cache
GiB Swap:    0.750 total,    0.660 free,    0.090 used.    0.855 avail Mem

This is cool, always free but I cannot ssh to it: only accessible with Cloud Shell and it may take a few minutes to start.


I also use an AWS free tier but this one is limited in time 1 year.

top - 19:56:11 up 2 days, 13:09,  2 users,  load average: 1.00, 1.00, 1.00
Tasks: 110 total,   2 running,  72 sleeping,   0 stopped,   0 zombie
%Cpu(s): 12.4 us,  0.2 sy,  0.0 ni,  0.0 id,  0.0 wa,  0.0 hi,  0.0 si, 87.4 st
GiB Mem :      1.0 total,      0.1 free,      0.7 used,      0.2 buff/cache
GiB Swap:      0.0 total,      0.0 free,      0.0 used.      0.2 avail Mem

A bit more CPU throtteled by the hypervisor and only 1GB of RAM. However, I can create it with a public IP and access it though SSH. This is interesting especially to run other AWS services as the AWS CLI is installed here in this Amazon Linux. But limited in time and in credits.


Not limited in time, the Oracle Cloud OCI free tier allows 2 VMs with 1GB RAM and 2 vCPUs throttled to 1/8:

top - 20:01:37 up 54 days,  6:47,  1 user,  load average: 0.91, 0.64, 0.43
Tasks: 113 total,   4 running,  58 sleeping,   0 stopped,   0 zombie
%Cpu(s): 24.8 us,  0.2 sy,  0.0 ni,  0.0 id,  0.0 wa,  0.0 hi,  0.2 si, 74.8 st
KiB Mem :   994500 total,   253108 free,   363664 used,   377728 buff/cache
KiB Swap:  8388604 total,  8336892 free,    51712 used.   396424 avail Mem

18666 opc       20   0  112124    748    660 R  25.2  0.1   6:20.18 yes
18927 opc       20   0  112124    700    612 R  24.8  0.1   0:06.53 yes

This is what I definitlely choose as a bastion host for my labs.


I run mainly one thing here: TMUX. I have windows and panes for all my work and it stays there in this always free VM that never stops. I just ssh to it and ‘tmux attach’ and I’m back to all my terminals opened.


This, always up, with ssh opened to the internet, must be secured. And as I have all my TMUX windows opened, I don’t want to reboot. No problem: I can update the kernel with the latest security patches without reboot. This is Oracle Linux and it includes Ksplice.
My VM is up since February:

[opc@b ~]$ uptime
 20:15:09 up 84 days, 15:29,  1 user,  load average: 0.16, 0.10, 0.03

The kernel is from October:

[opc@b ~]$ uname -r

But I’m actually running a newer kernel:

[opc@b ~]$ sudo uptrack-show --available
Available updates:

Effective kernel version is 4.14.35-1902.301.1.el7uek
[opc@b ~]$

This kernel is from April. Yes, 2 months more recent than the last reboot. I have simply updated it with uptrack, which downloads and installs the latest Ksplice rebootless kernel updates: 300w, 768w, 1536w, 1974w" sizes="(max-width: 1024px) 100vw, 1024px" />

Because there’s no time limit, no credit limit, always up, ready to ssh to it and running the latest security patches without reboot or even quiting my tmux sessions, the Oracle Autonomous Linux is the free tier compute instance I use everyday. You need to open a free trial to get it ( but it is easy to create a compute instance which is flagged ‘always free’.

Cet article Always free / always up tmux in the Oracle Cloud with KSplice updates est apparu en premier sur Blog dbi services.