Oracle database and more …
PostgreSQL’s foreign data wrapper to Oracle: hide passwords using secure external password store
Hi there, customer is worried about the credentials that are stored in PostgreSQL dbwhen using foreign data wrappers. In that case to Oracle, using oracle_fdw.It is possible to query a stored password from data dictionary. Only privileged users can do it, but still kind of a concern. Example: We can hide the password, by usingContinue reading “PostgreSQL’s foreign data wrapper to Oracle: hide passwords using secure external password store”
FAN events and FCF for SEHA
With Oracle database version 19.7 we got Standard Edition High Availability as a kind of replacement for Standard Edition RACs which cannot be used as of 19c any more. See https://blogs.oracle.com/maa/standard-edition-high-availability-officially-released In a recent discussion I wondered whether FAN events and Fast Connection Failover might work with such a setup. See https://twitter.com/MathiasZarick/status/1365266901639843844 . This shortContinue reading “FAN events and FCF for SEHA”
Data Guard – Definition of Online Redo Logs is “broken” after duplicate for standby
Hi there, today is the 1st birthday of a service request with Oracle I opened for which I see no progress since quite a while. I raised it exactly one year ago, on Oct 2nd 2019. There were some activity in last October, November mostly logging about the issue. There was no update in theContinue reading “Data Guard – Definition of Online Redo Logs is “broken” after duplicate for standby”
TNS chaos
I like to have my Oracle Net config consistent and without surprises. So for me it is a best practice to have ONE central TNS_ADMIN directory on the database server, which is set in all my shells. But a lot of processes might ignore that in case instances, sessions etc. are started from different environments,Continue reading “TNS chaos”
Preplugin Backups and the Missing Piece
Subheading 1: Preplugin Backups for non-CDB to PDB Conversions and the RMAN-06054 Subheading 2: PrePlugin Backups and the need for “Trick 17” The following is coming from a customer project. Imagine you have a huge non-CDB database, assume some terabytes. And you want to bring it to the CDB architecture. It is obvious to useContinue reading “Preplugin Backups and the Missing Piece”
Getting the most out of Oracle Database Express Edition (XE) 18c
Express Edition is a nice starter database which comes for free and does not need a license. Well, you do not get support for it either. There where XE databases in 10g and in 11g, but in this blog post I look into current XE which is 18c. I will concentrate on how to getContinue reading “Getting the most out of Oracle Database Express Edition (XE) 18c”
Why this Blog?
I had a blog, so why a new one? … Cause the old one was maintained by Trivadis – my employer – and just disappeared. Some customers and friends just asked me about that content. Thank you, that you consider it valuable. As it seems that it is not fixable in a suitable manner IContinue reading “Why this Blog?”
My First Blog Post
Be yourself; Everyone else is already taken. — Oscar Wilde. This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Subscribe below to get notified when I post new updates.
Follow My Blog
Get new content delivered directly to your inbox.
