Oracle Database Views and Tables for Oracle GoldenGate

Uncategorized
| Nov 8, 2019

Oracle GoldenGate for Oracle over the last few releases have been moving towards an integrated architecture.  This means that there is more views and tables within the Oracle Database that support Oracle GoldenGate.  You can quickly find these views and tables by using a where clause with a filter for GoldenGate: select * from all_views […]

The post Oracle Database Views and Tables for Oracle GoldenGate appeared first on DBASolved.

PostgreSQL Invalid Page and Checksum Verification Failed

Uncategorized
| Nov 8, 2019

At the Seattle PostgreSQL User Group meetup this past Tuesday, we got onto the topic of invalid pages in PostgreSQL. It was a fun discussion and it made me realize that it’d be worth writing down a bunch of the stuff we talked about – it might be interesting to a few more people too!

Invalid Page In Block

You see an error message that looks like this:

ERROR: invalid page in block 1226710  (more...)

PASS Summit 2nd Day Keynote

Uncategorized
| Nov 7, 2019

Woohoo, we’ve made it to the second day of PASS Summit!  After an awesome first day running from the keynote, to my first session with Denise McInerney, late for my executive meeting with less than a dozen other attendees with Rohan Kumar and sessions/networking/parties, here we are for the second day of PASS Summit keynote!

Info and Awards

We started the day with Wendy Pastrick to tell us about the financial status of PASS (more...)

Oracle database and grid home patches to install

Uncategorized
| Nov 7, 2019

This blogpost is about Oracle database and grid infrastructure software homes, which patches should be applied to which homes, and what it then looks like. This is fully documented by MyOracleSupport notes, but you will see that with version 18 and up this is unclear.

I keep a script-set that automatically installs and patches the Oracle database software and creates a database. This script-set is called vagrant-builder, and it can install any version with (more...)

Docker Birmingham – November 2019

Uncategorized
| Nov 7, 2019

Yesterday evening I went to the Docker Birmingham meetup, sponsored by Black Cat Technology Solutions.

This event was a single longer session by Matt Todd called “Make Data Science Great Again (Part 2)” I didn’t see part 1, but he gave a summary, so that wasn’t too much of a problem.

Matt started off by introducing the scientific method and discussed reducing variables when testing, so you know the impact of a change. The suggestion (more...)

Table Space

Uncategorized
| Nov 6, 2019

There’s a request on the Oracle Developer Forum for assistance to write a report that shows the total space allocation for a table – including its indexes and LOB columns. There is no requirement to allow for partitioned tables, but it’s not entirely clear whether the code should allow for index-organized tables and clustered tables, and there’s no comment about nested tables.

The OP has made an attempt to write a suitable query, but the (more...)

Bacon, Bloggin’ and First Day Keynote at PASS Summit 2019!

Uncategorized
| Nov 6, 2019

After a flurry of release announcements at MSIgnite this week, it was time to talk about the technology at a deeper level at PASS Summit.  I love this event, which has my undying loyalty due to the sheer amount of technical focus on everything in the Microsoft data platform and of course, was not disappointed with the first day keynote on Wednesday!

We started out with a great treat of information before the keynote, (more...)

Oracle Datapatch – out of place patches simplified

Uncategorized
| Nov 6, 2019
datapatch was introduced with Oracle 12.1 to simplify management of post-patching steps when a patch (or patchset) is applied.
As most software, it was written with best intentions but little knowledge how customers would use it.
One of these unforseen used case was parallel patching of multiple DBs in the same ORACLE_HOME at the same time.
Another problem was missing rollback files due to out of place patching.

Oracle addressed this in Bug 23170620.
(more...)

Cloning a schema with one line

Uncategorized
| Nov 6, 2019

In the world of DevOps, continuous integration and repeatable test cases, the demand for being able to

  • quickly build a suite of database objects,
  • utilise it for a series of tests,
  • then throw the objects away

has become far more common. This is one of the many great use cases for pluggable databases with all of the powerful cloning facilities available. In particular, now that you can take advantage of pluggable databases without* incurring additional (more...)

APEX 19.2 : Vagrant and Docker Builds

Uncategorized
| Nov 6, 2019

I’m sure anyone who cares knows that APEX 19.2 was officially released on Friday. I did an upgrade of one of our development instances straight away and it worked fine. it’s subsequently gone to a bunch of other development instances. I’ll be pushing to get this out to production as quickly as possible.

Over the weekend I worked through a bunch of my GitHub stuff.

Vagrant : I’ve updated all my Vagrant builds to (more...)

Midlands Microsoft 365 and Azure User Group – November 2019

Uncategorized
| Nov 6, 2019

Last night I went to the Midlands Microsoft 365 and Azure User Group. It was co-organised by Urfaan Azhar and Lee Thatcher from Pure Technology Group, and Adrian Newton from my company.

This event was focused on Microsoft Teams, which is the MS version of Slack. If you don’t know what Slack is, you probably need to come out from under that rock…

First up was Matt Fooks speaking about “Microsoft Teams, the death (more...)

My PASS Summit, Wednesday, Nov. 6th Recommendations from DBAKevlar!

Uncategorized
| Nov 5, 2019

I thought I would share the recommendations for the next day that I’m excited about this year at PASS Summit 2019!  There are some really great sessions and as most attendees, I’ve focused the list on topics that I’m interested in or can help me in my role.

Although Tuesday afternoon and evening may kill me with how many events are all planned, there’s still a lot going on for the rest of the (more...)

Video : Oracle REST Data Services (ORDS) : REST Enabled SQL

Uncategorized
| Nov 4, 2019

Today’s video is a run through the REST Enabled SQL functionality in Oracle REST Data Services (ORDS).

I wasn’t originally planning on doing this video yet, but the subject of REST Enabled SQL came up a couple of times in the last few days, so I thought I would alter my schedule.

This video is based on the following article, where you can find a lot more examples than are present in the video.

Bridge network missing Gateway – Docker Issue

Uncategorized
| Nov 3, 2019

Here is a little something for you.  I’m working on building a demo of Oracle GoldenGate Microservices between three (3) containers. In order to do this, I wanted to setup a dedicated network between the containers. In order to setup a dedicated network, I needed to configure a network for the containers to use.  Docker […]

The post Bridge network missing Gateway – Docker Issue appeared first on DBASolved.

Out Of Order

Uncategorized
| Nov 1, 2019

"If you want sense, you'll have to make it yourself."
- Norton Juster, The Phantom Tollbooth

An interesting issue reared its head back in version 9.2 that involves inserting data into multiple tables with a single statement when a foreign key is declared. Regardless of the table order in the insert statement the following error can be thrown:


ORA-02291: integrity constraint (SCOTT.FK1) violated - parent key not found 

The error is generated (more...)

APEX 19.2 Download Available

Uncategorized
| Nov 1, 2019

Yesterday evening Hildo Haenen tweeted that the APEX 19.2 download was available. You had to use the direct file URL and you had to have agreed to the license agreement on another download, as pointed out by Markus Hohloch, for the URL to work, but you could get the software. Of course, I wouldn’t dream of doing such a thing (I totally did…).

Today it seems the download page has been updated and (more...)

Oracle Tidbits October 2019 #OraTidbit

Uncategorized
| Oct 31, 2019
“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in October 2019. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #DB19c For Enterprise and Standard editions of Oracle database, if you are not licensed for Oracle Multitenant, then you may have up to 3 …

PASS Summit 2019 is NEXT WEEK!

Uncategorized
| Oct 31, 2019

I’m getting ready for SQL Saturday Oregon this weekend, (taking the train up from Eugene to Portland…) but its about time I talked about the exhilarating and exhausting event we call PASS Summit.

This year I was lucky enough to be chosen as a speaker and a blogger.  Bloggers at the conference get the opportunity to sit in special zones during keynotes and we write about the event.  We also get special access to Microsoft (more...)

Oracle internal data dictionary oddity

Uncategorized
| Oct 31, 2019

This blogpost is about an inconsistency I found in the X$ tables X$KQFTA and X$KQFCO. This is very specific. If you don’t care about that, you can skip this post.

The Oracle database’s “dynamic performance views” are views that are prefixed with “GV$” and “V$”. The “G” with “GV$” stands for “global” and gets you the results from its “V$” equivalent for all instances. In most cases, but that’s not the purpose of this blog. (more...)

Upgrading a GI on NFS to 18c

Uncategorized
| Oct 31, 2019

I wrote lately a couple of post about upgrading to 18c (why research is important and OCR and Voting disks on 18c and 19c). These posts were the result of an upgrade planning for a client where the database resides on NFS. After I finished the research and prepared a plan, it was time for testing.

Creating ASM

As this is Oracle 12.1.0.2 on NFS, the OCR and Voting disks (more...)