Oracle Cloud API Gateway – Using an Authorizer Function for Client Secret Authorization on API Access

Uncategorized
| Jan 3, 2020

The objective in this article: create a simple Authorizer Function that checks the Client Secret passed in API calls and allows and denies requests based on whether the correct Client Secret is included. The Authorizer Function does a little more than simply accept or deny: in case of accept it also return a token object that becomes part of the request sent to the real backend.

image

Steps:

  1. Create a Function with Fn (in any runtime (more...)

push_having_to_gby() – 2

Uncategorized
| Jan 3, 2020

THe problem with finding something new and fiddling with it and checking to see how you can best use it to advantage is that you sometimes manage to “break” it very quickly. In yesterday’s blog note I introduced the /*+ push_having_to_gby(@qbname) */ hint and explained why it was a useful little enhancement. I also showed a funny little glitch with a missing predicate in the execution plan.

Today I thought I’d do something a little (more...)

Where does the log writer spend its time on?

Uncategorized
| Jan 2, 2020

The Oracle database log writer is the process that fundamentally influences database change performance. Under normal circumstances the log writer must persist the changes made to the blocks before the actual change is committed. Therefore, it’s vitally important to understand what the log writer is exactly doing. This is widely known by the Oracle database community.

The traditional method for looking at log writer performance is looking at the wait event ‘log file parallel write’ (more...)

push_having_to_gby()

Uncategorized
| Jan 2, 2020

I came across an interesting new hint recently when checking the Outline Data for an execution plan: /*+ push_having_to_gby() */  It’s an example of a “small” change designed to reduce CPU usage by reducing the volume of data that passes through the layers of calls that an execution plan represents. The hint appeared in 18.3 but I’ve run the following on 19.3 as a demonstration of what it does and why it’s (more...)

Applying a Machine Learning Model in OAC

Uncategorized
| Jan 2, 2020

There are a number of different tools and languages available for machine learning projects. One such tool is Oracle Analytics Cloud (OAC).  Check out my article for Oracle Magazine that takes you through the steps of using OAC to create a Machine Learning workflow/dataflow.

Screenshot 2019-12-19 14.31.24

Oracle Analytics Cloud provides a single unified solution for analyzing data and delivering analytics solutions to businesses. Additionally, it provides functionality for processing data, allowing for data transformations, data cleaning, (more...)

Oracle REST Data Services (ORDS) 19.4 : A quick life update…

Uncategorized
| Jan 2, 2020

Almost 2 weeks ago I wrote about the release of Oracle REST Data Services (ORDS), SQLcl, SQL Developer and SQL Developer Data Modeler 19.4.

I spent the holidays playing around with it quite a bit, so I came back to work today and pushed it out across all Dev and Test installations.

As I’ve mentioned before, at work we run ORDS on Tomcat inside Docker containers. The build we use is very similar to (more...)

pgAdmin in Docker: Provisioning connections and passwords

Uncategorized
| Jan 2, 2020

pgAdmin is a popular open source and feature rich administration and development platform for PostgreSQL. When provisioning Postgres database environments using containers, it is not unusual to also provision a pgAdmin container.

The pgAdmin image provided on Docker Hub does not contain any server connection details. When your pgAdmin container changes regularly (think about changes to database connection details and keeping pgAdmin up to date), you might not want to enter the connections and passwords (more...)

Oracle Cloud Infrastructure Functions and Project Fn – Retrieving Headers, Query Parameters and other HTTP Request elements

Uncategorized
| Jan 2, 2020

Functions on Oracle Cloud Infrastructure are implemented using Project Fn. A function runs in Docker container. This container has a runtime (for example for Java, Go, Python, Node) and a minimal handler to handle an HTTP request and turn it into a call to the function. When writing the code to implement the function, we do not need to be aware of this layout. The FDK wrapper hands our Node function or Java method one (more...)

Oracle Cloud Serverless Functions unleashed: exposing OCI Functions through API Gateway

Uncategorized
| Jan 1, 2020

Oracle Cloud Infrastructure API Gateway makes it possible to expose OCI Functions on public endpoints that do not require complex signed HTTP requests. Any function that should be easily publicly accessible can be given such easy access. By creating an API Deployment on an API Gateway and associating a route in that API Deployment with an Oracle Function Backend. If needed, parameter mapping can be added as well as custom authorization and CORS headers in (more...)

Last Week in Stream Data Integration & Stream Analytics – 31.12.2019

Uncategorized
| Jan 1, 2020

Happy New Year! This is the last blog post for 2019. Wish you all a successful 2020!

This is the 179th 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. (more...)

VirtualBox 6.1 : No compatible version of Vagrant yet!

Uncategorized
| Jan 1, 2020

VirtualBox 6.1 was released on the 11th of December and I totally missed it.

The downloads and changelog are in the usual places.

I spotted it this morning, downloaded it and installed in straight away. I had no installation dramas on Windows 10, macoS Catalina and Oracle Linux 7 hosts.

The problem *for me* was the current version of Vagrant (2.2.6) doesn’t support VirtualBox 6.1 yet. I can’t live without Vagrant (more...)

2019 : A Year in Review

Uncategorized
| Jan 1, 2020

Well, it seems 2019 was another slightly bizarre year for me.

I just looked back on last year’s review (here) and I’m guessing I had “resting bitch face” while I was reading it…

Conferences

One of the things I mentioned last year was I was taking a year off presenting. I had two events I had already committed to at the start of the year, then dropped off the face of the earth (more...)

Scheduling Oracle Cloud Function execution

Uncategorized
| Jan 1, 2020

imageFunctions on Oracle Cloud are an important element in any cloud native application architectures. Functions are typically small, well contained and fairly independent pieces of logic to carry out specific tasks. These tasks can be executed upon reception and handling of HTTP requests – a very common use case – or processing of other events. A function can also provide the implementation of a job that should be executed according to a time schedule – (more...)

Happy New Year 2020

Uncategorized
| Dec 31, 2019

Oracle Tidbits – December 2019 #OraTidbit

Uncategorized
| Dec 31, 2019
“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in December 2019. December Tidbits are a repeat of the popular tidbits from 2019. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit DBA_AUTO_STAT_EXECUTIONS view in #db19c displays information about automatic optimizer statistics collection tasks, which …

The 2019 Year in Review

Uncategorized
| Dec 31, 2019

It’s that time of year where everyone is doing a “Year in Review” post and why not?

It’s good to gain perspective, plan for 2020 and celebrate all that was wonderful about 2019, (outside of politics, that was an utter failure on all fronts, pretty much most countries… :))

The DBAKevlar blog:

  • 46 published posts for 2019
  • Over 800 posts on the site
  • Over 600K in visitors for 2019
  • Daily views have increased steadily, with (more...)

Oracle wait event ‘log file parallel write’ change

Uncategorized
| Dec 31, 2019

This post is about a change in how the time is measured for the event ‘log file parallel write’. This is important for the performance tuning of any change activity in an Oracle database, because with the default commit settings, a foreground session that commits changes waits in the wait event ‘log file sync’, which is a wait on logwriter activity, for which the wait event ‘log file parallel write’ always has been the indicator (more...)

java.lang.SecurityException: User: ASADMIN authentication failed

Uncategorized
| Dec 30, 2019

When i trying to undeploy the REST service in UAT and deploy again, i am getting the below error.

 

java.lang.SecurityException: User: ASADMIN authentication failed

Solution :

verify the asadmin given credential correct and roles also.

Run the txkISGConfigurator.xml utility with “ebsSetup” argument.

refer :  Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

Section 2: Configuring Oracle E-Business Suite Integrated SOA Gateway for REST Services

 

sysadmin user not logging in r12

Uncategorized
| Dec 30, 2019

I am trying to logging in sysadmin user of one of our UAT system, It’s simply loading but not logging in.

I checked the sysadmin user credentials valid. Yes it’s Valid.

 

select fnd_web_sec.validate_login(‘SYSADMIN’,’password’) from dual;

Y

Solution :

I checked any blocking session in database, Yes it’s there . So I kill those sessions afterwards  I can able to login.

select l1.sid, ‘ IS BLOCKING ‘, l2.sid
from v$lock l1, v$lock l2 (more...)

Configure Distribution Service between two Secure GoldenGate Microservices Architectures

Uncategorized
| Dec 30, 2019

Once you configure an Oracle GoldenGate Microservices environment to be secure behind the Nginx reverse proxy, the next thing you have to do is tackle how to connect one environment to the other using the Distribution Server.  In using the Distribution Server, you will be creating what is called a Distribution Path. Distribution Paths are […]

The post Configure Distribution Service between two Secure GoldenGate Microservices Architectures appeared first on DBASolved.