Optimized Docker Image for Oracle XE 18c (18.4.0) including Archivelog

In my current project I am mainly working with Oracle XE 18c (18.4.0) under Docker.

One pain point is size of the Docker Image for Oracle XE 18c, in case you will use the Scripts from https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance for the build of Oracle XE 18c you will have an image size of 8.7 GB, which is not quite handy :-)

So I invested some time and have done some modifications on the (more...)

Everything As Code – Article for PTK

PTK 2019-04-30.pngPTK (Pass The Knowledge) is the new name for the Independent UK Oracle User Group‘s journal, previously known as Oracle Scene.  Yesterday saw the 1st release under its new name, and I’m proud to say that I have an article included called Everything as Code.

Not only that,  it is great to see the journal includes the appearance of one of my Oracle Team colleagues at CapgeminiAmy Simpson-Grange (more...)

Review at amazon: SAP Cloud Platform

Last week i read this book:
Before starting with the Oracle Cloud i wanted to read something other than AWS or Microsoft Azure. I was surprised at the completely different target of this cloud in respect to AWS and Azure. It is much more focused on business and business value - which is clearly one core domains of SAP.

This book contains a very well written introduction into cloud services - many other books could (more...)

Oracle Database 19c (19.3) released!

And after nearly 3 months of waiting - Oracle released 19c:


First special feature: The rpm is still there and the release is only done for Linux and Oracle Solaris.

To get to the Linux download page just click here.



But the Grid Infrastructure is still not delivered as RPM package. :-(


Wireguard: An easy way to build VPNs

Last week i came across the following tool:

If you want to build up a VPN you can choose one of the following strategies:
  • based on IPSec
  • using TLS
(These two are the options to choose - of course there are some others...)

The nice thing with wireguard (from the linux point of view) is, that the wireguard interfaces are handled like all other  network interfaces on your device.

If you (more...)

Oracle 19c for Linux x86-64 available

Since last night the lastest Oracle Database Release 19c (19.3) is for On-Prem  available.


Currently only the Linux x86-64 version is for download available in Oracle Technology Network, the other platforms should follow in the coming days.


For the download checkout following link: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle19c-linux-5462157.html




The documentation can be found under following link: https://docs.oracle.com/en/database/oracle/oracle-database/index.html


On top Gerald Venzl also updated in the Oracle GitHub Repository the Docker Images for Oracle 19c already :-) https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance/dockerfiles




Happy download and happy testing :-)

Last Week in Stream Data Integration & Stream Analytics – 23.4.2019

This is the 154th edition of my blog series blog series around Stream Data Integration and Stream Analytics!

As every week I was also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts

Apache Kafka / Kafka Streams / Confluent Platform

Follow up: Upgrading Enterprise Manager 13.2 to 13.3 – missing ‘Update’ Option in GUI

First of all, thanks a lot to Martin Decker for his comment and the description how he could solve that problem. Tried that, but unfortunately, these changes alone did not help. I opened a SR and got a recommendation how to solve the problem, exactly designed for my environment. Beside the tasks Martin described, I had to edit some libraries in the directory tree <OMS_HOME>/inventory/featuresets/. 

I asked Oracle Support if I'm allowed to publish the (more...)

Oracle Groundbreakers Podcast – Helidon

One of the things I am fortunate enough to get involved with on occasion is the Oracle Groundbreakers Podcast (previously known as the Oracle Developer Podcast) and something I have written about in the past, even as Oracle Developer Community (ODC) Appreciation Day post.

As a result of the recent Meetups on the subject of Helidon that have been occurring recently, we made the suggestion that Helidon be the subject of a Groundbreaker’s Podcast, net (more...)

Oracle VM Server: Working with ovm cli

After getting the ovmcli run, here some commands which are quite helpful, when you are working with Oracle VM server.
But first:
Starting the ovmcli is done via
ssh admin@localhost -p 10000
at the OVM Manager.

After that you can get some overviews:
OVM> list server
Command: list server
Status: Success
Time: 2019-01-25 06:56:55,065 EST
Data:
  id:18:e2:a6:9d:5c:b6:48:3a:9b:d2:b0:0f:56:7e:ab:e9  name:oraclevm
OVM> list vm
Command: list vm
Status: Success
Time: 2019-01-25 06:56:57,357 EST
Data:
  id:0004fb0000060000fa3b1b883e717582  name:myAlpineLinux
(more...)

Oracle Database 19c download

In january 2019 Oracle released the documentation for Oracle Database 19c.

More than 7 weeks later there is still nothing at https://www.oracle.com/downloads/:


The gap between release date of the documentation and the on premises software was for 18c not so long...

Will 19c on premises software be released before may? Or later in summer?

Push Content from Oracle WebCenter Content to Oracle Content and Experience Cloud with Fishbowl’s Subscription Notifier

WebCenter Content is a great tool for keeping your company’s content organized, but it can be difficult to proactively manage new, updated, and expiring content. Users check out content and forget to check it back in. Plans and policies require reviews at varying intervals. Managers change, and metadata needs to be changed for several content items. In 2005, Fishbowl launched the initial release of Subscription Notifier to help solve these problems and many more. Sold (more...)

Upgrading Enterprise Manager 13.2 to 13.3 – missing ‘Update’ Option in GUI

Tried to upgrade an Enterprise Manager Cloud Control 13.2 to the next level of happiness - 13.3 - like I did that for several installations. Unfortunately, the 'Upgrading an existing Enterprise Manager System' option in the 'Installation Types' section of the installation GUI is not available. Usually, this behaviour points to an unavailable or corrupt Oracle Inventory. As additional possibility, it could be a bug as well:
Check MOS Note "EM 13c: (more...)

Copy MOS-Note URL’s

Perhaps You've had that problem, too ... Something has changed with My Oracle Support URLs. Simply copying the url of an already opened MOS document and sending it to a collegue or pasting it into a doc will not give the expected result, i.e., forwarding to the expected document. But how to get the URL? Can be simply as that: Right click on the document's link, 'Copy link address' and You're done ... *wacko*

Last Week in Stream Data Integration & Stream Analytics – 15.4.2019

This is the 153rd edition of my blog series blog series around Stream Data Integration and Stream Analytics!

As every week I was also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts

General

My User Group Thoughts



Collaborate has three user groups that come together to create the largest user group events of the year. This was a year of change, not only the venue but also the user groups themselves.

IOUG joined with Quest, which I believe is a great way to safeguard the legacy of IOUG and to grow the reach of Quest. However I spoke to several IOUG people who think of Quest as being the home of TOAD rather (more...)

2019 Collaborate


Collaborate for the first time in ages was not in Las Vegas which really pleases me although it is back there again next year.

This is the biggest user event in the calendar and I had 5 sessions, across the 3 uaergroups.

Monday

I was part of an OAUG Cloud Panel facilitated by Alyssa Johnson and it also included Mohan Iyer and Alfonso Pinan from City of Atlanta who had previously shared their story at (more...)

2019 – OUG Ireland


This was an in and out conference for me.

It’s a two day event and this year it was the 15th Irish User Event and I have attended everyone. I even remember the board meeting when regional events were first suggested and I offered to champion this, my local event. I led it for many years and am still a volunteer under the leadership of Simon Holt.


Unfortunately I could not stay for both (more...)

The Unreasonable Effectiveness of Mathematics

AWS: Accessing S3 buckets from the internet and from ec2 instances (2)

After accessing a S3 bucket from an ec2 instance by adding an IAM role to my EC2 instance, i tried to get the access from an ec2 instance by using a AWS endpoint.

First step: Launch an ec2 instance within your VPC and try to access your S3 bucket:

[ec2-user@ip-172-31-30-93 ~]$ wget https://s3-eu-west-1.amazonaws.com/my.webtest/website.json
--2019-02-02 18:29:28--  https://s3-eu-west-1.amazonaws.com/my.webtest/website.json
Auflösen des Hostnamen »s3-eu-west-1.amazonaws.com (s3-eu-west-1.amazonaws.com)«... 52.218. (more...)