A pre-Christmas blog

Only 3 weeks left until Christmas. Hope all the preparations are well underway. In the meantime, have a break from the decorating, shopping and wrapping and read the latest blogs and articles.

And of course, enjoy a little Christmas joke:

Who hides in the bakery at Christmas?

A Mince Spy!

Blogs of the week

  1. Multiple Node.js Applications on Oracle Always Free Cloud

Andrej Baranovskij asks, “What if you want to host multiple Oracle JET applications?”

He gives the solution in a diagram then refers us to a previous post.

2. Create a Vagrant Box with Oracle Linux 7 Update 7 Server with GUI

Darwin IT begin by saying, “Yesterday and today I have been attending the UKOUG TechFest ’19 in Brighton. And it got me eager to try things out. For instance with new Oracle DB 19c features. And therefore I should update my vagrant boxes to be able to install one. But I realized my basebox is still on Oracle Linux 7U5, and so I wanted to have a neatly fresh, latest OL 7U7 box.”

He points us to a previous post, in which he writes about creating your own Vagrant box. Then he found out that Oracle supplies those base boxes.

3. FCCS – calculating rolling x number of periods

Erik Erikson starts by saying, ” A common type of financial calculation involves a rolling x number of month calculation, like a rolling 12 month net income. In HFM, there were functions and keywords we could use. There are different ways of writing the calculation.”

He goes on to explore these.

In conclusion, “In closing, Essbase has been around since the early 1990s, so there has been plenty of time to figure out the functions that are needed – us HFM converts just need to learn!”

4. Exadata/RDBMS — Database Release Schedule + Support Dates – 19C + Exadata Image Upgrade (to the latest version // 19.3.1)

Erman Arslan says, “In order to get a long-term support, customers started to upgrade their Oracle databases to 19C.”

He points us to this document: Release Schedule of Current Database Releases.

He also links to two other previous blogs, here and here.

Erman goes into say, “So, in this blog post, I will try to give you some additional information about these kinds of operations.”

5. Data Profiling in Python

Brendan Tierney says, “With every data analytics and data science project, one of the first tasks to that everyone needs to do is to profile the data sets. Data profiling allows you to get an initial picture of the data set, see data distributions and relationships. Additionally it allows us to see what kind of data cleaning and data transformations are necessary. Most data analytics tools and languages have some functionality available to help you. Particular the various data science/machine learning products have this functionality built-in them and can do a lot of the data profiling automatically for you. But if you don’t use these tools/products, then you are probably using R and/or Python to profile your data.”

6. Include new APEX templates in an older APEX instance

Scott Wesley begins with, “Have you seen that super awesome theme in the new APEX version, then wondered how long it will it be before your site upgrades so you can actually use it? What if I told you that your current version could be retrofitted to use that template?”

7. Human readable JSON, stored in BLOB

Alex Nuijten writes a short blog, “Currently Oracle (we’re using Oracle 18c at the moment) is still recommending to store your JSON document in a BLOB column. More efficient, no character conversions and probably some more advantages.”

An easy way to make the JSON Blob readable is to use the query in the blog!

8. Oracle DB Patching with EM 13.3

Alfredo Krieg says, “I got several interesting questions last week during my presentation about Oracle Enterprise Manager (EM) 13.3 and Exadata at the East Coast Oracle Conference 2019. One of them was related on how to patch a DB home using EM 13.3 and I’ll try to show it on this post.”

9. Checking usage of HugePages by Oracle databases in Linux environments

Ludovico writes about the use of HugePages by Oracle databases in Linux environments.

He also links to this redhat page.

10. How to use IAM Authentication for RDS PostgreSQL with Glue ETL Jobs

Gokhan Atil begins by saying, “Amazon RDS enables you to use AWS Identity and Access Management (IAM) to manage database access for Amazon RDS for PostgreSQL DB instances. It’s possible to use the IAM authentication with Glue connections but it is not documented well, so I will demonstrate how you can do it. In your Glue job, you can import boto3 library to call “generate_db_auth_token” method to generate a token and use it when connecting.”

This week on Twitter

Oracle Analytics shared The Rise of AI and Business Intelligence in the Cloud: Guest Forrester Analyst & Oracle Webcast

Mark Meignier posted What A Free Oracle Database Means To These 4 Developers

CloudChangelog tweeted some recent Cloud Related Posts

Paper.li

Stories from ermanarslan.blogspot.com,  dirknachbar.blogspot.com and andrejusb.blogspot.com

Videos such as:

Oracle Code One 2019 Keynote

Seventeen Things Developers Need to Know About MySQL