ADHD and Certification Tests- A Tale of Disaster

Uncategorized
| Dec 30, 2019

I don’t talk too much about my Attention Deficit Hyperactivity Disorder, (ADHD) brain outside of the occasional squirrel joke and more often view it as a super power, but when it is a challenge, I think it’s important to share what we go through.  You can’t solve a problem if you don’t know it is one.

ADHD and Autism

For those that aren’t aware, I was diagnosed with ADHD/on the spectrum for autism back (more...)

Override Date.now() based on OS time when Node returns incorrect current date

Uncategorized
| Dec 30, 2019

I was facing a weird issue. In my Node application – version 10.6.3 – running on Ubuntu – 18.04 – I got the wrong value for the current date and time. A call to new Date() and to Date.now() resulted in a wrong value, off by over two months:

image

The top two values are the formatted date and value for now:

console.log(new Date())
console.log( Date.now())

The other values (more...)

Scalar Subq Bug

Uncategorized
| Dec 30, 2019

This is an observation that came up on the Oracle Developer Forum a couple of days ago, starting life as the fairly common problem:

I have a “select” that runs quickly  but when I use in a “create as select” it runs very slowly.

In many cases this simply means that the query was a distributed query and the plan changed because the driving site changed from the remote to the local server. There are (more...)

File export not saved oracle apps r12

Uncategorized
| Dec 29, 2019

Suddenly We couldn’t able to save the file after we did export.

 

Solution :

 

Check your database any one of tablespace space issue in alert log file and add datafile.

Installing Nginx

Uncategorized
| Dec 28, 2019

With Oracle GoldenGate Microservices, you have the option of using a reverse proxy or not.  In reality, it is a best practice to install the recommended reverse proxy for the architecture.  The main benefit here is the security aspect of using it.  In Oracle GoldenGate Microservices, depending on the number of deployments you have per […]

The post Installing Nginx appeared first on DBASolved.

The Shepherd’s Crown

Uncategorized
| Dec 28, 2019

The Shepherd’s Crown is the last book in the Discworld series by Terry Pratchett. I really don’t like the finality of how that sounds, which is probably why I’ve waited a long time to read this book.

Having complained about how the female lead character was used in The Unicorn Project, I figured it was time to read this book and see it done properly again.

I’m not going to include any full-on spoilers, (more...)

Friday Philosophy – Community Means So Much

Uncategorized
| Dec 27, 2019

There have been a few things in the last month that have really brought home to me how much I personally receive from the Community. In my case, my Community is primarily the Oracle User Community – The end users who come together to share knowledge, the Oracle employees who support this, and the companies that support the end users. For most of you reading this, you are part of the Oracle User Community, but (more...)

Use Conda to Generate Requirements.txt for Docker Containers

Uncategorized
| Dec 26, 2019
pip is a standard package manager. Requirements.txt can be generated in one environment and installed by pip in a new environment. Conda replicates own installation. Pip produces a list of packages that were installed on top of standard library to make the package you wrote work.

Following are the steps to generate requirements.txt file to be used insdie Dockerfile for docker containers:



Go to your project environment conda activate

conda list gives you (more...)

Tools To Monitor and Work with Oracle on Azure

Uncategorized
| Dec 26, 2019

I’ve been studying for over a week for my certs.  It really is a challenge for my ADHD brain, as I learn by interacting and using a product, not be reading about it and guess what?  Most of what the certs are on are not in my technical area.  Yeah, this is not fun for me.  I find that my brain hits a limit on what it can absorb before the (more...)

Important update of ORDS… release 19.4

Uncategorized
| Dec 26, 2019
A few days ago Oracle released Oracle REST Data Services (ORDS) 19.4.

In my opinion, it's a major release and most likely worth investigating to upgrade for everybody. For me, the following 3 improvements are worth the upgrade:

Performance of REST APIs

The performance of ORDS based REST APIs was significantly improved in ORDS 19.4.0 by changing how ORDS handles proxied database connections. You can read more about this in the readme.

(more...)

APP-FND-00706: Routine FDFADF: Detected a data error

Uncategorized
| Dec 25, 2019

During Payment voucher creation, users getting the below issue.

After click Ok, users getting below error

 

Solution:

 

Increase open_cursor parameter in database and start a new session to do the payment voucher, it’s working now.

Finally, sftp from an Oracle database using plain plsql

Uncategorized
| Dec 24, 2019

Just a quick blog to get me through the Christmas eve. More than 5 years ago I wrote a blog about FTPS from an Oracle databse. In that blog I already mentioned that SFTP using plsql is possible. Not loading some Java classes in the database and adding some plsql wrappers. No, just plain old plsql. At that time I had a “prove of concept”-script which was huge.

But, after moving almost all encrypting/decrypting code (more...)

Flashback Archive

Uncategorized
| Dec 24, 2019

A classic example of Oracle’s “mix and match” problem showed up on the Oracle Developer Forum a few days ago. Sometimes you see two features that are going to be really helpful in your application – and when you combine them something breaks. In this case it was the combination of Virtual Private Database (VPD/FGAC/RLS) and Flashback Data Archive (FDA/FBA) that resulted in the security predicate not being applied the way you would expect, hence (more...)

Identity wallets used by Oracle GoldenGate Microservices

Uncategorized
| Dec 24, 2019

Wallets, Wallets, and more wallets! … Wallets are used for a few different things within Oracle GoldenGate Microservices; identifying what wallet is being used by a service is simple if you know where to look.   The biggest usage of wallets within Oracle GoldenGate Microservices is to help secure the communication between the Distribution Service […]

The post Identity wallets used by Oracle GoldenGate Microservices appeared first on DBASolved.

Publishing Keras Model API with TensorFlow Serving

Uncategorized
| Dec 24, 2019
Building a ML model is a crucial task. Running ML model in production is not a less complex and important task. I had a post in the past about serving ML model through Flask REST API — Publishing Machine Learning API with Python Flask. While this approach works, it certainly lacks some important points:

  • Model versioning 
  • Request batching 
  • Multithreading 

TensorFlow comes with a set of tools to help you run ML model in production. One (more...)

Into The Stream

Uncategorized
| Dec 24, 2019

"Let me try once more," Milo said in an effort to explain. "In other words--"
"You mean you have other words?" cried the bird happily. "Well, by all means,
use them. You're certainly not doing very well with the ones you have now."
- Norton Juster, The Phantom Tollbooth

Sometimes conventional wisdom isn’t so conventional, or common. As a case in point DBAs may believe that the STREAMS pool is reserved strictly for (more...)

Philosophy – Treating Illness As A Performance Issue

Uncategorized
| Dec 24, 2019

Firstly, I’m on the mend. This is not a post about “oh woe is me, I am so ill”. But I have been rather ill.  I’ll just give you the highlights: The highs of UKOUG Techfest19 at the start of the month were followed very quickly by me developing full-blown influenza (Type A). After about 5 days of being ill in bed I realised I was fighting for breath just laying there. I analysed (more...)

My Quick Start with Oracle Functions in Fresh OCI Tenancy

Uncategorized
| Dec 24, 2019

This article is fairly rough log of the steps I went through to get going on Oracle Cloud Serverless Functions. It is mainly intended to provide a note to myself, for future reference. However, my description could prove useful to you – the reader.

My steps to get going are based on https://docs.cloud.oracle.com/iaas/Content/Functions/Tasks/functionscreatingfirst.htm. Another very useful resource with step by step descriptions: https://www.oracle.com/webfolder/technetwork/tutorials/infographics/oci_faas_gettingstarted_quickview/functions_quickview_top/functions_quickview/index.html.

Using a fresh OCI Cloud (more...)

The Unicorn Project : My Review

Uncategorized
| Dec 24, 2019

The Unicorn Project is a follow-up to The Phoenix Project. Actually, it’s more like the same book again, but written from different person’s perspective.

I loved The Phoenix Project, but absolutely hated The DevOps Handbook, so I was a little reluctant to start reading The Unicorn Project, as I was really worried I would hate it, and it would tarnish the memory of The Phoenix Project.

Overall it was fine, but IMHO it was (more...)

Merry Christmas and Happy New Year !! (“Heroes”)

Uncategorized
| Dec 23, 2019
I would like to take this opportunity to wish all my readers a very Merry Christmas and a most happy, peaceful and prosperous New Year. My gift this year is not David Bowie and Bing Crosby doing their famous Christmas duet but a performance by Bowie of his classic “Heroes” as featured on the same […]