When you create Multitenant databases with DBCA there are some Things to Know. And in Oracle Database 184.108.40.206’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]
I will start a series of blog posts on how to remove and clean up components from Oracle Database 11.2 – 12.2.
This series of blog posts is not meant to recommend the removal of any options from an Oracle Database. It is not meant to create any sort of negativeness on any of the components or options.… [Read More]
Did you recognize that the login messages displayed when you start SQL*Plus in Oracle Database 220.127.116.11 looks different than in releases before?
SQL*Plus banner in Oracle Database 18.104.22.168:
$ sqlplus / as sysdba SQL*Plus: Release 22.214.171.124.0 Production on Tue May 2 11:23:10 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved.… [Read More]
Are you worried because of the title of this blog post? Don’t worry … it will be about the Oracle database and not about miraculous additives.
Months back I wrote about how to remove options from the Oracle database’s kernel by either using chopt or linking options off:
Recently a very interesting case was logged in relation to a bug:
A customer had linked off the JOX option from the database kernel.… [Read More]
Sometimes people have the desire to remove options from the database kernel (i.e. from the oracle executable).
It’s a matter of fact that by default you’ll get plenty of things linked into your kernel in Oracle Database 12c.
In case you’d like to remove things the chopt utility does still exist in Oracle Database 12c – but you may recognize a difference between Oracle 11.2 and Oracle 12.1.… [Read More]
I doubt that many people are using the Oracle features “Rules Manager” and “Expression Filter” as usually people handle these things (such as ensuring that a zip code or a car number plate has a certain format) within the application code and not inside the database. Oracle Beehive for instance uses that just on the side.… [Read More]
Recently I had to dig a bit into the component dependency topic as I was working with an Oracle Database 10.1.0.5 customer planning to upgrade to Oracle Database 126.96.36.199 with a limited downtime window. To achieve the given downtime window we planned to remove some unused components from the database.
Example: Component Dependencies in Oracle Database 11.1
As you know already the time it’ll take to upgrade an Oracle database is mainly dependent on the number of installed components.… [Read More]