Using Postman For REST API on Oracle Cloud Infrastructure

Just completed quick training for Oracle Cloud Infrastructure (OCI)

REST API can be used on OCI for automation and presentation.

I find presentation for JSON results from CLI on server is UGLY.

Finally, I found POSTMAN which does to very nice job of presentation.

POSTMAN has results history, command history, search function.

https://www.getpostman.com/apps

 

5 main building blocks of the new Visual Builder Cloud Service

In may 2018 Oracle introduced the new version of Visual Builder Cloud Service. This version is not just aimed at the Citizen Developer, in the end an experienced JavaScript can do nice things with it.

In this blog I will have a look at 5 of the 6 main building blocks you build a VBCS applications with:

  1. REST service connections
  2. Flows and Pages
  3. Variables
  4. Action Chains
  5. UI Components

Putting all of this in one blog (more...)

R13 – Get Username Displayed Again

One of the things that we lost when we moved from R12 to R13 is the username in the top right corner. For end-users in production it doesn’t really matter as they’ll only be logging in as themselves, however during the implementation in Test we frequently log-in as different personas so it’s useful to see who the user is for your current session.

username

The initials we have in R13 offer a clue, but in non-Production (more...)

Checking if the current user is logged into Application Builder

If you want conditional logic in your PL/SQL dependent on whether the current user is also logged into the APEX Application Builder, this can be achieved by reference to:

APP_BUILDER_SESSION

e.g. v(‘APP_BUILDER_SESSION’)

 

This will have a value if the user is logged into APEX Application Builder, otherwise it will be null.

Related documentation: https://docs.oracle.com/database/apex-18.1/HTMDB/understanding-substitution-strings.htm#GUID-62FE6E65-265A-4BE4-B04B-F90BDA317328

Database links and SCNs on June 23, 2019

A few days or weeks ago I saw a Twitter post about database links failing on Oracle databases next year. So, I have researched this issue. My company has a bunch of Oracle databases with a web of database links connecting them. After researching this for a while I have convinced myself that our company will not experience an issue. I want to share some of what I have found in this post.

First, I (more...)

Developing for the Oracle Database

1 Coding Standards
What this document does not claim to offer is a prescriptive guide on the minutiae of coding standards.

Coding standards and naming conventions, particularly in SQL and PL/SQL, are an emotive and divisive subject.

This is largely the fault of a historical absence of mature IDEs and a lack of any rigorous, generally accepted standards as seen with other languages.

Many developers still hand-craft scripts and routines and the various tools available (more...)

Customized help text in APEX

Yes, I’m finally back. The last post was written right before a complete period of offline before it was even scheduled to be published. That followed with slowly getting back. I have been fully recovered for a while but not gotten back enough to find time to blog. That changes now. So what causes almost a half years time to recover. Going out with the trash. Yes, it really is dangerous and should be avoided (more...)

Post Collaborate and on call week post

So, I was at the Collaborate 2018 Oracle user group conference last week and I am on call this week. I have not posted anything about the conference so I thought I would try to get something out there.

I did my Python and Toastmasters talks. I’m not sure how people received these. Both of these talks sort of loaded extra burden on the Oracle DBAs who attended. One talk said they should learn Python (more...)

Branding R13 (pre-Newsfeed UI)

The branding in Release 13 is a touch different from what we had in R12 as we’ve been given a few more options in the Appearance toolkit. Oracle have upgraded Cedar’s partner environment to 18A so we’ve refreshed the look’n’feel. The 18B update later this year brings in the new ‘newsfeed’ responsive UI, but until then let’s see what we can do with the current toolset:

Layout

The first choice is for the overall springboard (more...)

Oracle Recruiting Cloud Workshop

This week I was fortunate enough to attend a 3-day workshop on the new Oracle Recruiting Cloud module.

It was my first proper look at the module and I was curious to see what Oracle have done, as there has been a lot of negative publicity about Workday’s new recruitment module (here and here). My first impression is that Oracle have done a really good job. It doesn’t do everything that Taleo Enterprise (more...)

Modifications to hidden parameters between 12.1.0.2 and 12.2.0.1

I recently troubleshooted an issue with RMAN catalog database using seperate schemas for each target database and more than 300 schemas present. Catalog Database was on 12.2.0.1 and suffering from severe mutex contention because of huge version counts for RMAN catalog SQL statements. I then realized that the default number of max child cursors was increased from 1024 to 8192 in 12.2.0.1. This made me check what other parameters (more...)

Oracle MBX 2018 recap

Last week I attended Oracle’s MBX (Modern Business Experience) conference held near the O2 in London. Here’s what I learnt:

General

It was busy. Really busy. I’ve also been to the MBX in each of the last 3 or 4 years and this was – by far – the biggest event. I think it even took the organisers by surprise how many people were there as the registration was super-lengthy and there weren’t many lunches (more...)

Where should my new tech path lead?

I’m a BTOODBA (Bitter Twisted Old Oracle DBA)…and a pretty darn good one if I say so myself. I’ve loved working with Oracle since version 7.0 Parallel Server (what a mess that was!) on OpenVMS (loved VMS). I’ve been responsible for small databases, large databases, very large databases. Oracle Apps (now known as e-Biz…I think), Agile (not the methodology, an actual Oracle product), RAC, Golden Gate (near zero downtime server migration!), Exadata…too (more...)

Getting geared up for Collaborate 2018 #C18LV

I’m leaving for Las Vegas a week from this Sunday for the Collaborate 2018 conference #C18LV.

I’m doing the same two talks that I did in Denver at RMOUG Training Days.

Here are the times and locations for the talks if you will be there at C0llaborate:

Session: 1415: Python for the Oracle DBA
Date/time: Tue, Apr 24, 2018 (09:45 AM – 10:45 AM)
Location: Jasmine H

Session: 1416: Toastmasters for the Oracle DBA
Date/time: Wed, (more...)

Had to set parallel_max_servers to 2 for Delphix clone

This is a quick note about a problem I had creating a Delphix virtual database clone of a production database.

This is an older 11.1.0.7 HP-UX Itanium database. I tried to make a new virtual database copy of the production database and it failed due to the following error:

ORA-07445: exception encountered: core dump [krd_flush_influx_buffers()+96] [SIGSEGV] [ADDR:0x10000000005D8] [PC
:0x400000000B415880] [Address not mapped to object] []

I only found one thing on Oracle’s (more...)

Upgrade to Oracle 12.1.0.2 problems

I was recently tasked with upgrading  an Oracle RDBMS 11.2.0.4 to 12.1.0.2. The platform is Windows 2012 R2. I know about not being able to move the listener to the new 12c home, which prevents me from using the upgrade utility DBUA.  However, this time there was a nasty surprise in store for me. I ran all the pre-upgrade steps and done all the pre-upgrade fixes and it was (more...)

Inconceivable!

“The Princess Bride” is a cult classic with many quotable lines…including Vizzini’s frequent and incorrect exclamation “Inconceivable!” Eventually, Inigo counters “You keep using that word. I do not think it means what you think it means.”

Often we are faces with websites and applications that present us with ‘data’…that is little more than bits & bytes, characters & numbers. If the data presented is not accurate, relevant or timely, it is not useful (more...)

Getting traction through action!

Weird title, right! Very slick and marketing talk…
It is also a deviation of the usual topics I discuss here, but at least (!)as important.

But it is true. And this is what we truly aim to do at JK-Consult. Not just professionally, but in everything we stand for.
Of course, as long as this is just words, what does it really mean? Not so much…

Therefor, starting in 2018, we are a (more...)

Why you should sponsor an event

I love to go to Oracle meetings, conferences, trainings, and all that. Why? I actually like my job and I want to get better at it. Also I’m very lazy and always look for shortcuts and easier ways to do things.

Going to an Oracle (APEX) event is always very valuable for me (you can substitute Oracle or APEX for whatever field you are working in, but mine is #orclapex and I’m grateful I ended (more...)

Does an automated cloud data warehouse need partitioning and indexes?

This is a late post inspired by my time at RMOUG Training Days 2018. I attended two RMOUG Training Days presentations about automated cloud data warehouse database systems. The first was about Snowflake. The second was about Oracle’s coming Autonomous Data Warehouse Cloud offering. Both products seem to have the goal of automating as much as possible in a data warehouse database and neither seem to allow users to create indexes or to partition their (more...)