Search

Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

Oracle Database 19c on Fedora 32

https://oracle-base.com/blog/wp-content/uploads/2020/05/f32-final-816x34... 300w, https://oracle-base.com/blog/wp-content/uploads/2020/05/f32-final-816x34... 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 />
</p></div>

    	  	<div class=

Say Hello to the WordPress Block Editor

At the beginning of June we’ll be retiring our older WordPress.com 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 WordPress.com 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 WordPress.com — 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 WordPress.com 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 WordPress.com 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 WordPress.com 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.

Cheers

Tim…


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 />
</p></div>

    	  	<div class=

Social Distancing : My Experience

https://oracle-base.com/blog/wp-content/uploads/2020/05/social-distancin... 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.

Cheers

Tim…


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 apex.oracle.com. 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:



31232686 - WEBSHEET SAML AUTH: ERROR WHEN ALLOW PUBLIC ACCESS
31217638 - PAGE DESIGNER 'GROUP BY' RENDERING PREFERENCE REMOVAL FROM CODE
31243923 - REGRESSION: IG CSV EXPORTS DOES NOT ENQUOTE VALUES CONTAINING LF (CHR(10))
31237894 - INTERACTIVE REPORT AND INTERACTIVE GRID HIGHLIGHT DOESN'T SHOW HIGHLIGHT STYLING IN REPORT SETTINGS
31206093 - DARK MODE: SQL WORKSHOP QUERY BUILDER COLOUR CONSTRAST ISSUES
31174941 - UNREADABLE HOME SUB-MENUS WHEN CHANGING ZOOM ON CHROME
31253570 - MEGA MENUS HAVE INCORRECT RESPONSIVE BEHAVIOR
31256032 - INCORRECT COLORS RENDERED IN DARK MODE IN APEX BUILDER AND UT
31224836 - SESSION TIMEOUT WARNING INCORRECTLY DISPLAYS IN THE BUILDER
31286811 - SAML AUTH: ORA-01460 WHEN PARSING THE AUTHN REQUEST XML DOCUMENT
31281836 - INTERACTIVE GRID: DIALOG ERRORS WHEN PDF IS THE ONLY EXPORT FORMAT

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 19.0.0.0.0 - Production on Wed May 13 10:45:45 2020
Version 19.6.0.0.0

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 19.0.0.0.0 - Production
Version 19.6.0.0.0

SQL> conn /@db19_pdb1 as sysdba
Connected.

SQL> @catpatch

. ORACLE
.
. Application Express (APEX) 20.1.0.00.13
. Patch Set Exception 30990551
........................................

APEX_VERSION
------------------------------
APEX_SCHEMA
--------------------------------------------------------------------------------------------------------------------------------
20.1.0.00.13
APEX_200100



PL/SQL procedure successfully completed.


Session altered.


APEX_SCHEMA
--------------------------------------------------------------------------------------------------------------------------------
APEX_200100


Session altered.

...wwv_flow_escape

Package body created.

No errors.
...wwv_flow_session

Package body created.

No errors.
...wwv_flow_authentication

Package body created.

No errors.
...wwv_flow_authentication_saml.plb

Package body created.

No errors.

PL/SQL procedure successfully completed.

...devpatch.sql

Session altered.


Grant succeeded.


Session altered.

...wwv_flow_authentication_f4900.plb

Package body created.

No errors.
...wwv_flow_property_dev

Package body created.

No errors.
...patch_31232686.sql

PL/SQL procedure successfully completed.

...patch_31217638.sql

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 19.0.0.0.0 - Production
Version 19.6.0.0.0

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 WordPress.com, 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.

https://en-blog.files.wordpress.com/2020/05/coming-soon-logged-out.png?w... 2048w, https://en-blog.files.wordpress.com/2020/05/coming-soon-logged-out.png?w... 150w, https://en-blog.files.wordpress.com/2020/05/coming-soon-logged-out.png?w... 300w, https://en-blog.files.wordpress.com/2020/05/coming-soon-logged-out.png?w... 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 WordPress.com — 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.

https://en-blog.files.wordpress.com/2020/05/settings-coming-soon-1.png?w... 150w, https://en-blog.files.wordpress.com/2020/05/settings-coming-soon-1.png?w... 300w, https://en-blog.files.wordpress.com/2020/05/settings-coming-soon-1.png?w... 768w, https://en-blog.files.wordpress.com/2020/05/settings-coming-soon-1.png 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.

https://en-blog.files.wordpress.com/2020/05/invite-people.png?w=2048 2048w, https://en-blog.files.wordpress.com/2020/05/invite-people.png?w=150 150w, https://en-blog.files.wordpress.com/2020/05/invite-people.png?w=300 300w, https://en-blog.files.wordpress.com/2020/05/invite-people.png?w=768 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.

https://en-blog.files.wordpress.com/2020/05/settings-private-1.png?w=150 150w, https://en-blog.files.wordpress.com/2020/05/settings-private-1.png?w=300 300w, https://en-blog.files.wordpress.com/2020/05/settings-private-1.png?w=768 768w, https://en-blog.files.wordpress.com/2020/05/settings-private-1.png 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.

https://en-blog.files.wordpress.com/2020/05/private-logged-out.png?w=2048 2048w, https://en-blog.files.wordpress.com/2020/05/private-logged-out.png?w=150 150w, https://en-blog.files.wordpress.com/2020/05/private-logged-out.png?w=300 300w, https://en-blog.files.wordpress.com/2020/05/private-logged-out.png?w=768 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

https://oracle-base.com/blog/wp-content/uploads/2020/05/king-tut-161521_... 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 />
</p></div>

    	  	<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.

GCP

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.

AWS

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.

OCI

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

  PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
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.

tmux

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.

Ksplice

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
4.14.35-1902.6.6.el7uek.x86_64

But I’m actually running a newer kernel:


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

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:
https://blog.dbi-services.com/wp-insides/uploads/sites/2/2020/05/Annotat... 300w, https://blog.dbi-services.com/wp-insides/uploads/sites/2/2020/05/Annotat... 768w, https://blog.dbi-services.com/wp-insides/uploads/sites/2/2020/05/Annotat... 1536w, https://blog.dbi-services.com/wp-insides/uploads/sites/2/2020/05/Annotat... 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 (https://www.oracle.com/cloud/free/) 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.