Since Oracle Database 188.8.131.52 we change our patching model as well, switching from Patch Set Updates (PSU) and Proactive Bundle Patches (BP) to Release Updates (RU) and Release Update Revisions (RUR). But what are actually the differences between PSU / BP and RU / RUR patch bundles? Is there any or is it just a renaming of well known patch bundles?… [Read More]
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]
On a regular basis the Database Upgrade Team releases new and improved versions of the preupgrade tools via a MyOracle Support note. And it’s time again: the September 2017 releases of
preupgrd.sql are available for download.
September 2017 releases of preupgrade.jar and preupgrd.sql are available
Please ALWAYS download the most recent versions of
preupgrade.jar for upgrades to Oracle Database 12.2 and
utluppkg.sql) for Oracle Database 220.127.116.11 upgrade from MOS Note: 884522.1.… [Read More]
There’s a new and improved version of the preupgrade.jar (build 5 – May 2017) available for download from MyOracle Support:
The same note will get you access also to the most recent builds of preupgrd.sql for upgrades to Oracle Database 12.1 and utlu112i.sql for the unlikely event you’ll have to upgrade a database to Oracle 18.104.22.168.… [Read More]
Good question we receive quite often:
Is “imp” still supported in Oracle Database 12.2?
For clarification: I don’t talk about “
impdp” but about old “
imp” (import). And yes, it is still supported in Oracle 12.2.
The old “
exp” got desupported with Oracle Database 22.214.171.124 – but “
imp” is still supported, even in Oracle Database 12.2.0.x.… [Read More]
All credits go to Ricardo Maeda as I knew that we’ll release a Bundle Patch for Oracle 126.96.36.199 sometime this week – but I couldn’t find it linked from the usual MOS notes. And please don’t ask my why that is.
I did blog in the past already about the Grid Infrastructure Management Repository Database (GIMR DB):
SID and DBNAME are kept the same in Oracle Database 12.2. But there are a few changes and additions in Oracle Database 188.8.131.52.
GIMR DB in its own Disk Group
During a fresh installation of Oracle Grid Infrastructure 184.108.40.206 you’ll have the chance to create a disk group for GIMR DB:
But you can migrate GIMR DB into a separate disk group as well – just make sure the size is large enough (see below).… [Read More]