I have received several questions from customers in the past weeks using Oracle Multitenant about the parameter exclude_seed_cdb_view.It magically disappeared and morphed into _exclude_seed_cdb_view since Oracle Database 220.127.116.11. To be fair, the exclude_seed_cdb_viewis listed in the list of obsolete parameters in Oracle Database 18.104.22.168.
What is EXCLUDE_SEED_CDB_VIEW?
This parameter hides everything belonging to the PDB$SEED from the usual queries.… [Read More]
Recently we got alerted by a customer and a colleague from Italy about an issue with the upgrade from Oracle 12.1.0.x to Oracle 22.214.171.124 if – and only if – your database got created with 2k or 4k db block size.
If your database got created with 2k or 4k db block size, and you attempt an upgrade from any upgrade-supported Oracle version to Oracle Database 126.96.36.199 the upgrade – regardless of DBUA or catctl.pl – will fail with an ORA-1450: maximum key length (1478) exceeded.… [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.
Sometimes there are tiny little changes in a new release – and sometimes they are not documented very well yet. One of these changes is the new behavior of login.sql for SQL*Plus in Oracle Database 184.108.40.206.
Behavior before Oracle Database 12.2
In all releases until Oracle Database 220.127.116.11 by default SQL*Plus searches for the user profile (login.sql) in your current directory first, and then in the directories you specify with the ORACLE_PATH environment variable.… [Read More]