Oracle Database 19c on Fedora 32

Uncategorized
| May 20, 2020

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

Cheers

Tim…


Oracle Database (more...)

Rename Table During DataPump Import

Uncategorized
| May 19, 2020

At source perform export for tables=SCOTT.SALES, SCOTT.ORDERS

$ expdp \"/ as sysdba\" directory=DATA_PUMP_DIR tables=SCOTT.SALES,SCOTT.ORDERS  dumpfile=SCOTT.dmp logfile=SCOTT.log

Preference is to use parameter file vs having to take into consideration and dealing with slash.

Import will rename table SALES to SALES_BACKUP and ORDERS to ORDERS_BACKUP for SCOTT schema.

$ cat impdp_table.par
userid="/ as sysdba"
directory=DATA_PUMP_DIR
dumpfile=SCOTT.dmp
remap_table=SCOTT.SALES:SALES_BACKUP
remap_table=SCOTT.ORDERS:ORDERS_BACKUP
table_exists_action=SKIP
$ impdp parfile=impdp_table.par

Import: Release 18.0. (more...)

Slow Exadata Compute Node Upgrades to Oracle Linux 7

Uncategorized
| May 19, 2020

One of the cool things that Oracle has done with Exadata is give users the ability to upgrade from Oracle Linux 6 to Oracle Linux 7 with an in-place upgrade process.  This comes automatically when you upgrade the Exadata compute image from 18c to 19c.  Upgrading the compute nodes to 19c give you the ability to upgrade your grid infrastructure to 19c, followed by installing a 19c database home and beginning the database (more...)

Honey, I shrunk the database!

Uncategorized
| May 19, 2020
For my current assignment I need to get 3 SOA/B2B environments running. I'm going to try-out the multi-hop functionality, where the middle B2B environment should work as a dispatcher. The idea is that in Dev, Test and Pre Prod environments the dev environment can send messages to the remote trading partner's test environment, through the in-between-environment. To the remote trading partner, that in-between-environment should act as the local test environment, but then should be able (more...)

Solution: BI Issues after Account Rename

Uncategorized
| May 19, 2020

Occasionally, when a Fusion user account is renamed, there is a sync issue that prevents the end-user accessing BI. Sometimes the data gets back in-sync within an hour or so, however sometimes the issue persists.

People get married or divorced and change their surname, or may have a name change for several other perfectly legitimate reasons. So renaming user accounts is an occasional but necessary part of most customer’s business-as-usual function – the only reason (more...)

ACFS Mystery

Uncategorized
| May 18, 2020

From ACFS Support On OS Platforms (Certification Matrix). (Doc ID 1369107.1)

ACFS and AFD 12.2.0.1 Supported Platforms
Vendor          :  RedHat Linux 
Version         : 7 
Update / Kernel : Update 6 3.10.0-957 and later / 3.10.0 Red Hat kernels X86_64	
ACFS Bug or PSU	: 12.2.0.1.191015 (Base Bug 29963428)

Where: “Base” (at the “Bug or PSU” column) stands for the "12.2.0.1  (more...)

How to Improve Oracle Performance with NVM

Uncategorized
| May 18, 2020
Non-Volatile Memory hardware is a technology that every Oracle customer must know about. Attend the webinar by Yaron Dar and find out how you can improve the performance of yoru Oracle database with NVM.

Covered topics:
  • - Proof points, best practices, and guidelines for achieving peak performance for Oracle workloads with NVMe and Storage Class Memory.
  • - Maintaining high availability through disasters with Oracle Extended RAC (demo)
  • - Achieving amazing data reduction and storage efficiency (more...)

Oracle WebLogic 14.1.1 under Podman

Uncategorized
| May 18, 2020
Since a few weeks the latest release of the Oracle WebLogic Server 14.1.1.0.0 is available and I was testing it already on native Linux Servers and within Docker.
Now it's time to check Oracle WebLogic Server 14.1.1.0.0 under Podman https://podman.io 

At first you will need an Oracle Linux 8.2 Server with podman. A really good instruction you can find at oracle-base.com https://oracle-base.com/articles/linux/podman-install-on-oracle-linux-ol8

Building my own Recovery ROM for a Samsung J5 2017 (j5y17lte, TWRP)

Uncategorized
| May 18, 2020
After several hours of sideloading a custom ROM and flashing a TWRP recovery image i thought the next step is to build a TWRP recovery image on my own.


So how to do that?

My startpoint was
(just search github for your device with TWRP)

But this is not the way to begin.
First you have to follow this page:
and do
repo init -u  (more...)

Video : NTH_VALUE : Problem Solving using Analytic Functions

Uncategorized
| May 18, 2020

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.

(more...)

Create video recording in Microsoft Teams with green screen chromakey background without an actual green screen

Uncategorized
| May 17, 2020

If you record yourself in front of a green screen – or giant sheet or curtain – you can then manipulate the video and have any picture, movie, drawing or other visual replace the green in the video. A trick commonly used by reporters who do not actually want to stand in the cold. Here I am in the middle of Broadway. Yeah, right!

image

If you do not have a big green piece of cloth (more...)

Cross-account AWS Glue Data Catalog access with Glue ETL

Uncategorized
| May 16, 2020

To process data in AWS Glue ETL, DataFrame or DynamicFrame is required. A DataFrame is similar to a table and supports functional-style (map/reduce/filter/etc.) along with SQL operations. The AWS Glue DynamicFrame is similar to DataFrame, except that each record is self-describing, so no schema is required initially. It computes a schema on-the-fly when required, and explicitly encodes schema inconsistencies using a choice (or union) type.

DynamicFrame can be created using the below options –

Samsung J5 2017 (aka j5y17lte) installing STOCK ROM

Uncategorized
| May 16, 2020
After installing a custom ROM (s. here) i wanted to flash the STOCK  ROM onto my smartphone again.
So what to do?

First: Download a ROM (e.g. sammobile.com)

and you will get something like
J530FXXU6CSK9_J530FDBT6CSL1_DBT.zip
this zip cannot be sideloaded. So you have to unzip and the you have:
AP_J530FXXU6CSK9_CL16642474_QB27583084_REV00_user_low_ship_meta_OS9.tar.md5
BL_J530FXXU6CSK9_CL16642474_QB27583084_REV00_user_low_ship.tar.md5
CP_J530FXXU6CSK9_CP14486297_CL16642474_QB27583084_REV00_user_low_ship.tar.md5
CSC_DBT_J530FDBT6CSL1_CL17419960_QB27658856_REV00_user_low_ship.tar.md5
HOME_CSC_DBT_J530FDBT6CSL1_CL17419960_QB27658856_REV00_user_low_ship.tar.md5
Within this you have to do a:
 (more...)

VirtualBox 6.1.8

Uncategorized
| May 16, 2020

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

The downloads and changelog are in the usual places.

I’ve installed it on Windows 10, macOS Catalina and Oracle Linux 7 hosts without any problems.

I’ve resumed with the Vagrant builds now. So far so good. 🙂

Happy upgrading!

Cheers

Tim…


VirtualBox 6.1.8 was first posted on May 16, 2020 (more...)

Social Distancing : My Experience

Uncategorized
| May 16, 2020

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 (more...)

Export WooCommerce Orders with Payment Method – Paypal

Uncategorized
| May 15, 2020

How to export orders from WooCommerce by Payment method In our comprehensive WooCommerce Reporting Plugin, one of the most powerful dashboard report is the Export Order Details report. The most powerful filter of all is the meta data filter. Using this filter you can query and export every aspect of your woocommerce order information. For … Read more

Origin: InfoCaptor BI

Last Week in Stream Data Integration & Stream Analytics – 15.5.2020

Uncategorized
| May 15, 2020

This is the 191st edition of my blog series blog series around Stream Data Integration and Stream Analytics!

Took me a bit later to compile this weeks edition….. in fact it is almost 3 weeks together!

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 (more...)

Oracle database migration to cloud with Zero Downtime Migration (ZDM)

Uncategorized
| May 15, 2020

New FMW 12c Vagrant project

Uncategorized
| May 15, 2020

Introduction

Several years ago I blogged about automatic creation of Fusion Middleware environments.
See for instance this article on installation, this one on the domain creation and these notes.

In between I wrote several articles on issues I got, start/stop scripts, etc.

Later I found out about Vagrant and since then I worked with that. And this I enhanced through the years, for instance, nowadays I use different provisioners to setup my environment.

(more...)

Scripting the Oracle Wallet truststore

Uncategorized
| May 15, 2020

As you may recall, I do not like processes that requires a GUI for things that should be possible to do repeatedly and be part of automatic deployment of a full environment.

Th us I want the whole wallet creation to be done in scripts. No, the root certs don’t change often and no it would bot be a bad thing to just commit a complete wallet to git. But I still like to quickly (more...)