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]
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 18.104.22.168 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 22.214.171.124.… [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 126.96.36.199 – 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 188.8.131.52 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 184.108.40.206.
GIMR DB in its own Disk Group
During a fresh installation of Oracle Grid Infrastructure 220.127.116.11 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]
The init.ora/spfile parameter
PGA_AGGREGATE_LIMIT got introduced in Oracle Database 18.104.22.168.
As per documentation in Oracle Database 12.1 it got defined as:
PGA_AGGREGATE_LIMIT specifies a limit on the aggregate PGA memory consumed by the instance.“.
Furthermore the algorithm for its setting got described as:
PGA_AGGREGATE_LIMIT is set to the greater of 2 GB, 200% of
PGA_AGGREGATE_TARGET, and 3 MB times the
PROCESSES parameter.… [Read More]