Gitpod Workspace for Oracle Database Free 23ai–click and run, free and in 7 minutes
I am an enthusiastic user of Gitpod – a platform for ephemeral cloudbased workspaces. Click on a URL and a workspace is started for you (and for me). From …
Category: Oracle
Persistent, cross database and cross region pipe in Oracle Database 23ai
We know pipes in Oracle Database to be an in memory mechanism, ephemeral with loss of data when the database instance is stopped. With limitations on size of messages …
Multi-read Large Message Singleton Oracle Database Pipe– cache for shared context
Database Pipes have been around in Oracle Database since release 7. In memory, light weight, non-persistent, fast and a little low level. Somewhat brittle: the contents of a pipe …
Live HTTP access to JSON document with Oracle Database 23ai data set using Pre Authenticated Request URL
A very nice, powerful and potentially somewhat dangerous new feature in Oracle Database 23ai: Pre-Authenticated Request URLs for Read Only Data Access on Autonomous Database. In summary: with a …
Getting started with Oracle Database 23ai – in five minutes and for free
Yesterday I noticed an announcement of the latest Oracle Database release: 23ai. A long term support release – so one we will be able to use for many years. …
Oracle Database 23c–some intriguing new features–dbms_pipe, Prometheus, pre-authenticated request URL, reset database session, Vector Search
This article is really just a quick draft to remind myself of some really interesting new Oracle Database features that I want to further investigate. Very succinctly: Pre Authenticated …
How to enable Oracle Database Azure AD authentication
As of Oracle database release update 19.18 a new authentication method was made available utilizing Azure AD (Entry ID as its named by Microsoft recently) Oauth tokens. Using this …
Graph Database style explorations of relational database with Formula One data– Oracle Database 23c Property Graph
The core Formula One data could be represented in a graph like this: Drivers compete in races that are hosted on circuits. A result is achieved by the driver …
Oracle Database 23c as Graph Database–SQL Property Graph for network style querying
I bet you are used to relational data structures that you query using SQL. And so do I. And there is nothing in terms of data that a good …
Live Handson Environment for Modern Oracle Database Programming
My fellow Oracle ACE Directors and former AMIS-colleagues Patrick Barel and Alex Nuijten have co-authored an impressive book: The book discusses many of the wonders of SQL and PL/SQL …
Get Going with SQL Developer against Oracle Database 23c Free
In an earlier article, I showed how to quickly get going with an Oracle Database 23c Free instance in a Gitpod workspace – cloud based, ephemeral, quick start, zero …
Oracle Database 23c–Fine Grained Locking–Lock Free Reservations
This should surprise if not baffle you. Session 1 inserts a record and commits it. Session 1 performs an update on this record. And does not yet commit its …
Get going with Oracle Database 23c Free
A new major Oracle Database release is a special occasion. I joined Oracle in May 1994 just after the Oracle7 release (December 1993) although I worked with Oracle6 for …
Preparation for migrating data to Oracle Virtual Private Database
August 10, 2021
AMIS, Database, Databases, DBA Oracle, Oracle, Oracle 12, SQL, sqlplus, Technology
No Comments
preparation for migrating data to Oracle Virtual Private Database Introduction Recently I was part of a team involved in the preparation of migration data belonging to multiple business …
How to use single sign on between multiple OCI environments
Since we provide support for several clients in OCI, we regularly need to login into different OCI-tenancies. How nice would it be to have Single Sign-On (SSO) functionality between …
Migrate Oracle VM to KVM easily and without reconfiguration
Oracle VM is end-of-life and is, since March 2021, in extended support1. In looking for a replacement hypervisor AMIS has turned to KVM. Oracle itself also uses KVM, albeit …
What if companies say: “help me move away from Oracle”?
I hear this aspiration from a growing number of organizations. Sometimes as a quite literal question. This however is merely half of a wish. Apparently, organizations want to quite …
Oracle SaaS – Business Applications in the Cloud – as of Oracle OpenWorld 2018
Oracle has two main pillars on which its (future) business rests – dixit Larry Ellison: Oracle Cloud Infrastructure (including the Autonomous Database) and SaaS. In this article, I will …
Another Taste of India– ODevCYatra 2018
July 2018 saw another edition of the Oracle Developers’ tour through India, called Yatra. In just over two weeks, seven cities participated in this tour – with each city …
Using Java Management Extensions within Oracle Enterprise Manager Cloud Control 13c
The answer to using Java Management Extensions(JMX) within Oracle Enterprise Manager Cloud Control is using Metric Extensions. Metric extensions provide you with the ability to extend Oracle’s monitoring capabilities. …
How to install the Oracle Integration Cloud on premises connectivity agent (18.1.3)
Recapitulation on how to install the Oracle Integration Cloud on premises connectivity agent Recently (april 2018) I gained access to the new Oracle Integration Cloud (OIC), version 18.1.3.180112.1616-762, and …
Dbvisit Standby upgrade
Upgrading to Dbvisit Standby 8.0.x Dbvisit provides upgrade documentation which is detailed and in principle correct but only describes the upgrade process from the viewpoint of an installation on …
The Tale of the Ardent SpringCleaning Maniac (ASM)
or If you want to get rid of stuff, you can always do a good spring-cleaning. Or you can do what I do. Move. – Ellen DeGeneres In order …
Watch Oracle OpenWorld 2017 Keynotes On Demand
Watch Keynotes on YouTube using these links: Larry Ellison (Sunday Oct 1st) – https://www.youtube.com/watch?v=HEupUSSSEBo Dave Donatelli (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=irvNYpCopA8 Thomas Kurian (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=cef7C2uiDTM Larry …
AWS – Build your own Oracle Linux 7 AMI in the Cloud
July 14, 2017
Cloud, Cyber Security, Database, IT, Oracle, Platform Technology, Virtualization and Oracle VM
3 Comments
I always like to know what is installed in the servers that I need to use for databases or Weblogic installs. Whether it is in the Oracle Cloud or …
ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server
June 12, 2017
Oracle, Databases, DBA Oracle, ODA, Oracle 12, Performance and tuning, PL/SQL
No Comments
While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the …
Configuring Oracle Traffic Director 12c with WebGate
At a recent customer install, I was faced with configuring Oracle Traffic Director (OTD) 12.2.1.2.0 Webgate with Oracle Access Manager. Deploying Webgate on OD 12c is very well described …
Golden Gate 12c and DIY Sequence Replication with PL/SQL
May 5, 2017
Database, Databases, DBA Oracle, Engineered Systems, ODA, Oracle, Oracle 12, PL/SQL
2 Comments
Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by Oracle Golden Gate appeared to be faulty. The target …
Better track the Usage of Database Options and Management Packs, or it will cost you
So here it is Oracle announces a license audit, some urgency kicks in and this familiar but also really serious question comes down from management: “Are we using any …
Change UUIDs in VirtualBox
If you are anything like me you will have multiple virtualboxes running on your system. Sometimes you might want to run a copy of a virtualbox for different purposes. …
Dump Oracle data into a delimited ascii file with PL/SQL
This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file: Next to the query and the generated filename the Dump_Delimited function …
DIY Parallelization with Oracle DBMS_DATAPUMP
February 23, 2017
Database, Databases, DBA Oracle, Engineered Systems, ODA, Oracle, Oracle 12, PL/SQL
5 Comments
![DIY Parallelization with Oracle DBMS_DATAPUMP]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "DIY Parallelization with Oracle DBMS_DATAPUMP")
Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In a migration project from AIX 11gR2 to ODA X5-2 …
How About Oracle Database 12c Threaded_Execution
February 5, 2017
AMIS, Database, Databases, DBA Oracle, Engineered Systems, ODA, Oracle, Oracle 12
No Comments
THREADED_EXECUTION Threaded_Execution is an Oracle Database 12c feature aiming to reduce the number of Oracle processes on LINUX. After setting parameter THREADED_EXECUTION on TRUE and a database bounce, most …
Oracle 12c STIG Password Generator in PL/SQL
January 24, 2017
AMIS, Cyber Security, Database, Databases, DBA Oracle, DevOps, Engineered Systems, ExaData, ODA, Oracle, Oracle 12, PL/SQL, SQL
1 Comment
Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a password to …
Oracle Compute Cloud – Uploading My Image – Part one
Recently (October 2016) I had the opportunity to attend an Oracle Compute Cloud workshop that was very interesting. As a side effect I got access to the Cloud for …
The Oracle Public Cloud – work in progress
Building up a public cloud is quite a challenge. Oracle has faced and overcome many challenges – and it has built up tremendous momentum to tackle the current challenge. …
Spark with a K – how Apache Spark is omnipresent at Oracle OpenWorld 2016
Apache Spark made numerous appearances in many different sessions during Oracle OpenWorld 2016. It is clear that Oracle is very much embracing and leveraging and endorsing Spark at various …
One of the many nice new features in 12c database: code based access control
September 5, 2016
Cyber Security, Databases, Deployment, Oracle, Oracle 12, PL/SQL, Software Development, SQL
1 Comment
Topic of this blog is a nice new feature in 12c, not the plsql package I built that’s using it. So here’s the story.. For one of our customers …
Virtual columns
Maarten wrote a post on Virtual Columns in the oracle database. I read a blogpost on preventing people issuing SELECT * on a table. This was done in a …
Virtual Private Database…
Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem. The application ran fine until the Virtual Private Database …