Welcome, Bienvenue, Servus!

About Me

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”

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create your website with WordPress.com
Get started