When you create Multitenant databases with DBCA there are some Things to Know. And in Oracle Database 220.127.116.11’s Database Creation Assistant (DBCA) there is a common pitfall in the “Options” screen. It was grayed out in the previous release but when you choose to create a “custom” database you can select the options/components now.… [Read More]
Oracle 12.2 adaptive features are enabled in Oracle 18.104.22.168 Windows BPs already, This is quite a surprise to me. But thanks to Michael Pfautz. He alerted me today.as he was wondering why his database didn’t start up anymore after he applied the August 31 Bundle Patch on Windows. It complained about the parameter
optimizer_adaptive_features in the SPFILE.… [Read More]
I did blog in the past weeks about Fallback Strategies with Flashback Database. But two of my reference customers came across an interesting issue when they tried to fallback: Oracle 12.2 underscores appear in the SPFILE – magically – and prevent the fallback using the existing SPFILE.
Oracle 12.2 underscores appear in SPFILE – be aware when you flashback
In one case it happened during a test, in the other case it happened during a live fallback after the Data Guard Broker has interfered with the upgrade causing real trouble.… [Read More]
I visit customers on a regular basis. And when we sit together in front of the machine I sometimes spot tiny little things which may impose a security risk. This could be things such as
SEC_CASE_SENSITIVE_LOGON=FALSE or the use of
UTL_FILE_DIR or something else. To detect such sensitive spots you should download and use the Oracle Database Security Assessment Tool (DBSAT).… [Read More]
That’s an interesting question a customer raised the other day:
How to patch the Oracle Instant Client?
I silently assumed that there’s a new release of the Oracle Instant Client every quarter or at least when we deliver fixes which apply to the client as well. Hm …
What is the Oracle Instant Client?… [Read More]
In the newer releases of Oracle database you may see components with status
OPTION OFF in the database’s registry. But what happens to components with
OPTION OFF status during upgrade? Will those stay on the old release?
What happens to components with OPTION OFF
status during upgrade?
You may have a quick look into your
CDB_REGISTRY).… [Read More]
A customer of mine hit an issue recently when upgrading to Oracle Database 22.214.171.124. They did everything correctly but received a ton of issues from the Data Guard Broker. A rule says: When you upgrade, disable the Data Guard Broker. But I can’t blame the customer as this “rule” is well hidden in the documentation.… [Read More]