I have struggled a lot with DBCA in silent mode. Its documentation lacks quite a bit, the error messages are not great, and the tool has quite a few issues.
Category: Features
Using Oracle Gold ImagesUsing Oracle Gold Images
After OOW19 I looked into using GI gold images to upgrade a few databases at a client’s site. The client has 11 data guard environments (and they both use ASM),
Did You Know #31 – OCR and Voting Disks in 18c and 19cDid You Know #31 – OCR and Voting Disks in 18c and 19c
In Oracle GI 18c, the OCR and Voting disks must be located on ASM. A certified NFS or 3rd party shared file system is not supported for these files (you
Oracle Data Guard Explained – Step By StepOracle Data Guard Explained – Step By Step
Oracle Data Guard consists of many components. In this post I’ll explain about an environment that helped me understand how all the components work. This is a 12.1.0.2 (with APR
ORA-7445 in 18cORA-7445 in 18c
I upgraded a test database not too long ago to 18.6 (to do proper testing before we start upgrading productions) and got a feedback from dev that one of the
More 19c New FeaturesMore 19c New Features
I’ve just noticed that Oracle 19c documentation is online here, so I’m writing this post after going over the “New Features” guide and finding some interesting stuff there.
Why I Don't Like ANSI JoinsWhy I Don't Like ANSI Joins
Since Oracle started supporting ANSI joins in 9i, the Oracle community was divided into two groups: one loved it and tried to convince everyone to use it, and the other
Top-N QueriesTop-N Queries
This is an old story. It started in 2015 when I found a problem with TOP-N query performance. I wrote a blog post about it and later an update. Here
DB Console vs. EM ExpressDB Console vs. EM Express
I usually don’t work with the local version of EM. I haven’t used DB Console in 11g and below so much, and I used EM Express in 12c even less.
Did You Know #28 – Standby + RACDid You Know #28 – Standby + RAC
In an Oracle Data Guard configuration, the primary and standby databases can have different configurations. It’s very common to have a smaller server for the standby database (less CPUs, less