OraNA :: Oracle News Aggregator

Fedora 32 was released at the end of April (see here). Here comes the standard warning. Do not install Oracle on Fedora before reading this! Here are the usual things I do when a new version of F...

http://orana.info/2020/05/20/oracle-database-19c-on-fedora-32/

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

http://orana.info/2020/05/19/rename-table-during-datapump-import/

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

http://orana.info/2020/05/19/slow-exadata-compute-node-upgrades-to-oracle-linux-7/

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

http://orana.info/2020/05/19/honey-i-shrunk-the-database/

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

http://orana.info/2020/05/19/solution-bi-issues-after-account-rename/

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

http://orana.info/2020/05/18/acfs-mystery/

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

http://orana.info/2020/05/18/how-to-improve-oracle-performance-with-nvm/

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

http://orana.info/2020/05/18/oracle-weblogic-14-1-1-under-podman/

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.What is a TWRP recovery image?So how to do t...

http://orana.info/2020/05/18/building-my-own-recovery-rom-for-a-samsung-j5-2017-j5y17lte-twrp/

Today’s video is a demonstration of the NTH_VALUE analytic function. This is based on this article. NTH_VALUE Analytic Function You might find these useful also. Analytic Functions : Introducti...

http://orana.info/2020/05/18/video-nth_value-problem-solving-using-analytic-functions/

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

http://orana.info/2020/05/17/create-video-recording-in-microsoft-teams-with-green-screen-chromakey-background-without-an-actual-green-screen/

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

http://orana.info/2020/05/16/cross-account-aws-glue-data-catalog-access-with-glue-etl/

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

http://orana.info/2020/05/16/samsung-j5-2017-aka-j5y17lte-installing-stock-rom/

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

http://orana.info/2020/05/16/virtualbox-6-1-8/

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

http://orana.info/2020/05/16/social-distancing-my-experience/

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

http://orana.info/2020/05/15/export-woocommerce-orders-with-payment-method-paypal/

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

http://orana.info/2020/05/15/last-week-in-stream-data-integration-stream-analytics-15-5-2020/

I wrote this article on my LN page, visit the link below to read it.https://www.linkedin.com/pulse/on-premise-oracle-db-migration-cloud-zero-downtime-zdm-hussain/?published=t

http://orana.info/2020/05/15/oracle-database-migration-to-cloud-with-zero-downtime-migration-zdm/

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

http://orana.info/2020/05/15/new-fmw-12c-vagrant-project/

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

http://orana.info/2020/05/15/scripting-the-oracle-wallet-truststore/

Nur damit der Blog nicht völlig einschläft: Franck Pachot weist in seinem Blog darauf hin, dass Oracle 20 nun endlich die "predicate information" in AWR abspeichert, wie das seit Generationen g...

http://orana.info/2020/05/15/plan-pradikate-in-awr-mit-oracle-20/

I’ve been debugging an issue within an APEX application and wanted to make sure that my local installation was at the same version as apex.oracle.com. So I logged on to my workspace and ran que...

http://orana.info/2020/05/15/apex-20-patch/

When Oracle Linux 8 (OL8) was released, one of the first things I did was check for the Oracle supplied Docker engine. Nothing. Not to worry I thought. They are probably waiting for UEK6 to ship ...

http://orana.info/2020/05/15/oracle-linux-8-ol8-podman/

In this part of Migration methods to Autonomous Database (ADB) article series, we will see how to load data into ADB database using the DBMS_CLOUD package.Assuming you have an ADB database up & r...

http://orana.info/2020/05/14/migration-methods-to-autonomous-database-adb-part-iv-dbms_cloud-copy_data/

In my previous post, Testing RMAN Restore Validate From Tape , now I will perform actual restore. There is requirement to test backup to the new tape library before implementing in production by ...

http://orana.info/2020/05/13/rman-restore-from-tape/

In part III article series of Migration methods to Autonomous Database we will see how to migrate or load data into ADB using SQL Developer.Below slide from Oracle presentation depicts SQL Develo...

http://orana.info/2020/05/13/migration-methods-to-autonomous-database-adb-part-iii-sql-developer/

Yesterday I updated my Linkedin profile with my new role and the amount of comments and likes just amazed me. Perhaps everyone has more time to read Linkedin during COVID19 but I was very touched...

http://orana.info/2020/05/13/exciting-new-role-how-did-i-end-up-here/

When granting roles to users we need to remember two things: Any child role of the granted role is granted to the user as well (and this is hierarchical) You can turn on and off roles in your ses...

http://orana.info/2020/05/13/did-you-know-36-list-all-active-roles/

Last year and earlier this year I have been struggling to create a new Vagrant box based on an installation of the Oracle Base box. I had some extra requirements, for instance having a GUI in my ...

http://orana.info/2020/05/13/vagrant-oracle-linux-and-the-vagrant-user-use-a-password/

This is a quick how-to article on setting up RMAN to backup to Object Storage on OCI. This is applicable when you build your on Oracle database on an OCI instance, or when you have a database on-...

http://orana.info/2020/05/13/a-quick-how-to-rman-backup-to-oci-object-storage/

Introduction Last time, I talked about the API Gateway . The URL that we used last time has randomness in it: it looks like https://54dwcigu3a.execute-api.eu-west-1.amazonaws.com/prod/shop. When ...

http://orana.info/2020/05/13/aws-shop-example-api-gateway-2/

A couple of days ago I mentioned the certification of Oracle database 19c on Oracle Linux 8 (OL8) with UEK6. I’ve had a bunch of OL8 articles and builds for a while, but up until now they’ve ...

http://orana.info/2020/05/13/oracle-linux-8-ol8-vagrant-and-docker-builds-for-19c-database/

In preparation for me starting as an Oracle freelancer, my Mumbai blog is moving here (https://www.marcusmoennig.de/blog/). Please update your bookmarks. If you signed up for email notifications ...

http://orana.info/2020/05/12/mumbai-blog-moved/

I haven’t dug too deep into this one, so what follows may be just coincidental but I thought I would blog it out just in case it happens to anyone else. While testing AskTOM as part of our Appl...

http://orana.info/2020/05/12/apex-upgrade-dont-forget-your-cdn/

In part II of migration methods to ADB blog series, we will look into MV2ADB tool details and usage. If you haven't read the Part I, I would encourage you to read it to get basic knowledge on var...

http://orana.info/2020/05/12/migration-methods-to-autonomous-database-adb-part-ii-mv2adb/

Creating PDFs in APEX after ORDS 19.1 Until 19.1 ORDS provided a built-in printing engine based on Apache FOP which allowed you to download a PDF version of your reports and XLS-FO templates in a...

http://orana.info/2020/05/12/creating-pdfs-in-apex-after-ords-19-1/

This is a reference note for a question that came up as a comment on a lengthy note I wrote about reading execution plans. How do you interpret something like: from$_subquery$_001@SEL$1 in the Qu...

http://orana.info/2020/05/12/from_subquery_nnn/

Short and simple method to validate backup. oracle@hawk:/home/oracle$ rman checksyntax @ restore_validate_idpa_ddbea.rman Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 12 07:24:57 ...

http://orana.info/2020/05/12/testing-rman-restore-validate-from-tape/

This one just for fun today. An AskTOM question came in about arbitrary length arithmetic because “NUMBER(38) was not enough”. After some back-and-forth discussions it turned out that the bus...

http://orana.info/2020/05/11/arbitrary-length-addition-and-subtraction/

Julian Dontcheff recently wrote a nice article on the new Automatic Index Optimization feature available in the upcoming Oracle Database 20c release (I’ll of course blog about this new 20c feat...

http://orana.info/2020/05/11/oracle-19c-automatic-indexing-dropping-automatic-indexes-fall-dog-bombs-the-moon/

When configuring some Oracle REST web services through Oracle APEX, I got confused, so I thought to quickly write down, so I don't forget for the future.Although I use many ORDS web services in s...

http://orana.info/2020/05/11/ords-the-database-user-for-the-connection-pool-named-apexrt-is-not-authorized-to-proxy-to-the-schema/

Scene: INT. LATE NIGHT. NATALKA is typing on a MACBOOK AIR. Suddenly, the screen goes dark. Silence. The MACBOOK AIR has shut down with no warning. Once upon a time, my laptop was well-behaved. I...

http://orana.info/2020/05/11/service-battery-warning-on-macos/

There are two common scenarios when we may need this: An existing DB node has crashed and is unrecoverable (due to some failure and non-availability of any backups. Though some of the things may ...

http://orana.info/2020/05/11/exadata-virtualized-db-node-restore/

Last week I had a quick email exchange with Simon Coter from Oracle about a few things related to Oracle Linux 8. I’ve been a little out of the loop over the last few weeks because of some impo...

http://orana.info/2020/05/11/oracle-linux-8-ol8-updates-uek6-podman-database-19c-certification/

As promised in an earlier post here are my notes about installing Oracle Restart with ASM Filter Driver (ASMFD) 19c on Oracle Linux 7 using UEK 5. Since the approach you are about to read isn’t...

http://orana.info/2020/05/11/silent-installation-oracle-restart-19c-asm-filter-driver-uek-5-edition/

In today’s video we work through some examples of using the NTILE analytic function to solve some specific problems. The video is based on the following article. NTILE Analytic Function You mig...

http://orana.info/2020/05/10/video-ntile-problem-solving-using-analytic-functions/

In this part of on-premise Oracle database migration to ADB series, we will focus on set of tools to migrate your on-prime database to Autonomies database (ADB). We will briefly discuss about var...

http://orana.info/2020/05/10/migration-methods-to-autonomous-database-adb-part-i-data-pump/

A number of use-cases can be implemented cleanly using a recursive approach. This post is not to debate the pros and cons of recursion versus looping but provides a simple approach to achieve thi...

http://orana.info/2020/05/10/recursive-calls-in-oracle-integration-flows-scenario-paginated-api-calls-for-large-data-sets/

While I have played a little with screen , my preference is nohup since the output from screen is so ugly. With that being said, it would be nice for application designs to be resumable, e.g. Sh...

http://orana.info/2020/05/10/nohup-vs-screen/

Almost every APEX Developer knows that JavaScript and CSS belongs in separate files and (in 99% of the use cases) not somewhere in your Page properties. If you have this code in separate files it...

http://orana.info/2020/05/10/using-static-files-in-apex-has-never-been-easier/

Last Thursday we gave a new look to our products APEX Office Print (AOP) and APEX Media Extension (AME). Not only did they get a new logo, but the whole website and portal were also put in a more...

http://orana.info/2020/05/10/a-new-look-a-new-name/

After several weeks working in homeoffice and my children in homeschooling i had to increase my efficieny. And the best thing is to get a second monitor running which meets the following requirem...

http://orana.info/2020/05/09/corona-homeoffice-second-monitor-for-my-laptop-portable/

Are there to many abbrevations in a posts title possible? If you think so, you might see this post a good example. The setting I'm talking about is an Oracle Universal Directory (OUD) which work...

http://orana.info/2020/05/09/oracle-eus-authentication-with-lsa-activated-on-ad/

Introduction You might have noticed that we skipped the API Gateway up to now . I will write two blogs about the API Gateway. In this one, we follow the simplest route: from sending the message t...

http://orana.info/2020/05/09/aws-shop-example-the-api-gateway-1/

When I delivered a previous version of this class last, it was year 2013 and the latest Oracle version was 11.2. Since plenty of people have asked if I ever do this training again - and now that ...

http://orana.info/2020/05/08/advanced-oracle-sql-tuning-training/

Success! Thanks for signing up for my class! You will receive an email with the payment receipt from Paypal that confirms your attendance. If you don’t see this email, please check your spam fo...

http://orana.info/2020/05/08/confirmation/

Training overview The emphasis of this class is on practical application troubleshooting and Linux OS performance tuning techniques. We’ll be using scripts and tools that you can use on any Lin...

http://orana.info/2020/05/08/practical-linux-performance-and-application-troubleshooting-training/

I will run another hacking session that has been in my mind for a while. It will be a pretty narrow deep-dive into one of the SQL Monitoring report’s columns that is not well explained: Oracle ...

http://orana.info/2020/05/08/hacking-session-oracle-sql-monitoring-understanding-the-execution-timeline-column-and-cpu-usage/

My customer needed to migrate to a new set of datacenters, and while other services were able to “lift and shift”, the Oracle RAC database servers had to be rebuilt in the new datacenter beca...

http://orana.info/2020/05/08/migrating-databases-using-dataguard-some-pitfalls-and-observations/

As you probably know, Oracle 20c is available only as a preview on the cloud. If you’d like to create a new server on Oracle Cloud with 20c, here is a post with the instructions. However, I tho...

http://orana.info/2020/05/07/oracle-20c-dbca/

This is the first edition of this weekly collection about what is happening in the rapidly evolving cloud sphere. This will mainly focus on news, blogs, articles, tidbits, and views from AWS, Azu...

http://orana.info/2020/05/07/cloud-vanity-a-weekly-carnival-of-aws-gcp-and-azure-edition-1/

As part of the Oracle Exadata Deployment Assistant (“OEDA”), Oracle includes a command line utility to read and modify the XML files used for deployment of an Exadata cluster.  Typical use c...

http://orana.info/2020/05/07/oeda-virtualized-cluster-discovery-with-ssh-keys/

In recent years, the data integration/replication space has stared to become crowded.  Products like Oracle GoldenGate have become stables inside of organizations, but companies like HVR are chi...

http://orana.info/2020/05/07/build-an-hvr-hub-without-underlying-database/

Paketo Buildpacks are modular Buildpacks, written in Go. Paketo Buildpacks provide language runtime support for applications. They leverage the Cloud Native Buildpacks framework to make image bui...

http://orana.info/2020/05/07/paketo-buildpacks-cloud-native-buildpacks-providing-language-runtime-support-for-applications-on-kubernetes-or-cloud-foundry/

In my last post I summarised how to enable versioning for Vagrant box outside Vagrant’s cloud. In this part I’d like to share how to update a box. My environment The environment hasn’t chan...

http://orana.info/2020/05/07/versioning-for-your-local-vagrant-boxes-handling-updates/

AWS Glue is a fully managed ETL service to load large amounts of datasets from various sources for analytics and data processing with Apache Spark ETL jobs. In this post I will discuss the use of...

http://orana.info/2020/05/07/implementing-glue-etl-job-with-job-bookmarks/

In today’s video we demonstrate how to format query results in SQLcl using query comments and the SQLFORMAT setting. For those of you that prefer to read, the video is based on this article. SQ...

http://orana.info/2020/05/07/video-sqlcl-format-query-results/

Disaster recovery is one of the most critical aspects to look into when you are designing a system. It becomes even more prominent while architecting a cloud solution. Two key concepts that must ...

http://orana.info/2020/05/06/understanding-rto-rpo/

It’s possible to have both SQL Profiles and SQL Plan Baselines. SQL PROFILES    : Adjust Optimizer cardinality estimations SPM BASELINES : Direct SQL to follow specific execution plan Researh...

http://orana.info/2020/05/06/notes-on-sql-profiles-vs-sql-plan-baselines/

Last week we had a new version of the ADF Performance Monitor available – version 9.5. In this blog I will write on one of the new features; thread wait and thread blocked time of requests. Som...

http://orana.info/2020/05/06/adf-performance-monitor-thread-wait-and-blocked-time/

  In my previous post, I discussed how Automatic Indexing did not recognise there was already an existing logically equivalent manually created index and so created effectively a redundant Autom...

http://orana.info/2020/05/06/oracle-19c-automatic-indexing-mixing-manual-and-automatic-indexes-part-ii-stay/

Attend the webinar by Oracle ACE Simon Pane and learn how to integrate Microsoft Active Directory with the Oracle database.Click here to register.About the WebinarThis presentation details the ad...

http://orana.info/2020/05/05/centrally-managed-users-in-oracle-ms-active-directory/

I recently wrote an article to introduce Windows Sandbox. I explained how the Sandbox can have folders mapped from the host, have network interactions with the host (and the rest of the world) an...

http://orana.info/2020/05/05/windows-sandbox-with-chocolatey-scoop-git-visualstudio-code-and-more/

I wanted to demonstrate what I thought would be a simple task to a client today, however it turned out to be a little more complex than I first anticipated, so I thought I would publish here. All...

http://orana.info/2020/05/05/getting-smart-view-to-work-with-oac/

I have been using Vagrant for quite some time now can’t tell you how much of a productivity boost it has been. All the VMs I have on my laptop are either powered by Vagrant, or feed into the Va...

http://orana.info/2020/05/05/versioning-for-your-local-vagrant-boxes-adding-a-new-box/